Microsoft Dynamics 365 Finance Setup and Config

We are seeking a Finance Data Migration Consultant with a strong understanding of core accounting principles and bookkeeping to set up our Microsoft Dynamics 365 Finance environment. The project involves migrating 18 months of historical data from Sage 50 and configuring specific workflows for Accounts Payable and Employee Expenses. All current historical data relates to our UK entity but we will in due course be operating accounts for UAE and Global as well which needs to be factored into the setup of Dynamics setup.

Key Responsibilities

1. Historical Data Migration

- Scope: Import approximately 18 months of historical records, primarily focusing on transactional data and payroll journal summaries.
- Source Data: We will provide the historical data in 3 Excel files (already exported from Sage 50). You will aid in loading this data into Dynamics 365 Finance, ensuring proper dating and categorization of all opening balances and transactions.
- Reconciliation: Perform comprehensive, auditable reconciliation checks between the final Sage 50 reports and the imported Dynamics 365 balances to guarantee zero data loss and absolute accuracy post-migration.

2. Functional Setup

Context:

We are a largely remote business and therefore require automation of entries into the ledgers in the first instance, and the ability to track invoices or expenses through an approval process – confirming the expense as a valid business expense for services received or goods received, from the correct counterparty and for the correct amount.  This needs to be done within the “system” with approvals “signatures” noted electronically within approval limits.

- Accounts Payable (Invoice Management): We require a simple, lightweight approach to handle invoices for services subscribed to or products purchased.
- Email Ingestion: Setup must include a workflow where invoices sent to a specific company email address are ingested/handled within Dynamics 365.
- Employee Approval & Audit: We need a way for employees to either enter items (for expected invoices) or approve invoices that have come in. This must include a simple audit process to track exactly who entered or approved the expense.
- Employee Expenses: Configure the Expense Management module (or appropriate workflow) to allow team members to easily upload and submit expense claims for approval

Each of these categories can be served by an add-in or configuration of the stand

Prerequisites

- Proven experience with Microsoft Dynamics 365 Finance implementation and data migration.
- Strong knowledge of Sage 50 structures to understand the source data.
- Ability to configure email-to-invoice workflows (via standard D365 features, OCR, or Power Automate).

Timeline

- We are able to have a call to go over the requirements/deliverables if required.
- Please provide an outline of your proposal to fulfil the requirements outlined above and an estimated timeline for the full process (Migration + AP/Expense Setup). e.g., 1-4 Days, 1 week.