Reconcile your Dynamics 365 Finance main account against your bank statement offline. Pre-labeled fields for legal entity, main account, and financial dimensions. Download in Excel, Word, or PDF.
Fill in the D365-specific fields below and watch the live preview update. Download the completed statement when you are done.
Pick Excel, Word, or PDF. Each has D365-specific fields for legal entity, bank account, and main account pre-labeled.
Fill in your legal entity code, bank account ID, main account number, statement date, and preparer name.
Enter the bank statement ending balance and GL main account balance. Add deposits in transit, outstanding payments, bank fees, and interest.
If both adjusted balances match, save a copy for your records. Compare against D365's reconciliation worksheet for audit.
Grab a blank template in the format that fits your workflow. Every version follows the same two-sided layout with D365 fields pre-labeled.
Spreadsheet with formulas. Best for teams that reconcile alongside D365 reports.
Pre-formatted document with tables. Best for sign-off copies and controller review.
Print-ready layout. Best for physical sign-off and audit binders.
Stop matching bank transactions manually. Let Bluecopa auto-reconcile across all your D365 legal entities and flag exceptions in real time.
D365 Finance offers bank reconciliation through Cash and Bank Management. The standard workflow imports bank statements and matches them against GL entries using the Reconciliation Worksheet or Advanced Bank Reconciliation.
Upload a BAI2, MT940, or CAMT.053 file through Cash and Bank Management. D365 parses the statement and loads individual transactions for matching.
Advanced Bank Reconciliation compares imported transactions against D365 bank transactions using configurable matching rules for amount, date, and reference.
Open the Reconciliation Worksheet to investigate items that did not auto-match. These are usually timing differences, bank charges, or recording errors.
Create journal entries for bank fees, interest, and corrections. Each entry posts to the main account and updates the trial balance.
Mark the statement as reconciled in D365. The system locks matched transactions and records the reconciliation date for audit.
Common D365 bank reconciliation problems come from incorrect legal entity selection, stale bank imports, or misconfigured matching rules.
In D365 Finance & Operations, go to Cash and Bank Management > Bank Statement Reconciliation. Select the bank account, import the bank statement, and use the Reconciliation Worksheet to match bank transactions against GL entries. Enable Advanced Bank Reconciliation for automated matching rules.
Advanced Bank Reconciliation is a D365 feature that automates bank statement matching using configurable rules. It compares imported bank statement lines against bank transactions in D365 based on amount, date, reference number, and other criteria you define.
D365 supports bank statement import through BAI2, MT940, and CAMT.053 formats. Go to Cash and Bank Management > Bank Statement Import, select the bank account, choose the format, and upload the file. The system parses the statement and loads transactions for reconciliation.
Yes. No cost, no account, no watermark. The interactive tool runs in your browser and the downloadable files are yours to keep.
Yes. D365 supports multi-entity reconciliation. Each legal entity has its own chart of accounts and bank accounts. Download a separate copy of this template for each legal entity's bank account.
D365 Advanced Bank Reconciliation supports matching by amount, date, reference number, transaction type, and custom fields. You can create multi-step rules that match one-to-one, one-to-many, or many-to-one transactions.
Templates work for a handful of accounts. When you manage multiple legal entities, handle high transaction volumes, or spend more than a day per month reconciling in D365, automation tools like Bluecopa can auto-match and flag exceptions across all entities.