Catch Up Months of Bookkeeping Backlog in MS Dynamics 365 Business Central

A bookkeeping backlog can develop for many reasons, from missing bank transactions and delayed invoice processing to limited internal resources. If several months of transactions remain unrecorded, posting current activity first can create reconciliation issues, inaccurate balances, and unreliable financial reports.  

Catch-up bookkeeping in Business Central becomes easier when you work through the backlog in the right order. Start by reconciling bank accounts, then clear uncategorized accounts, rebuild accounts receivable and payable, true up fixed assets and payroll liabilities, post reviewed correcting entries, and validate the financial statements. 

This blog lists the seven steps to clear your months of bookkeeping backlog in Business Central. 

Catch Up with Confidence

Let Experts Clear Your Months of Bookkeeping Backlog

Know More

7 Steps to Catch-Up Bookkeeping in MS Dynamics 365 Business Central

Catch-up bookkeeping is the process to clear overdue records by posting missing transactions, reconciling accounts, and reviewing financial reports. In Microsoft Dynamics Business Central, you need to reconcile bank accounts, clear uncategorized balances, rebuild AR and AP, true up fixed assets and payroll liabilities, post reviewed corrections, and validate the financial statements. 

Here are the seven steps to catch-up bookkeeping in Microsoft Dynamics 365 Business Central: 

Phase 1: Bank Reconciliation

Start by establishing an accurate cash position for the entire catch-up period.  

• Search “Bank Acc. Reconciliation” 
• Enter the Statement Ending Balance from the actual bank statement for that month 
• Use Import Bank Statement if you have an OFX/CSV feed or manually enter lines under “Bank Account Statement Lines” 
• Under Apply Entries, match statement lines to existing ledger entries where possible 
• For unmatched lines: create the missing G/L entry directly from the reconciliation screen (New Transaction action) rather than leaving it unreconciled 
• Post the reconciliation only when the Difference field reads 0. Do not force post with a variance. 
• Repeat sequentially for every month between cutoff and today. Do not jump straight to the current month 

Phase 2: Clear Uncategorized Accounts

Once bank activity is reconciled, review any transactions sitting in uncategorized accounts.  

• Identify the accounts: search “Chart of Accounts” 
• Search “General Ledger Entries,” filter by that account number, and pull the full list of unresolved lines 
• For each line, use Reclassify (or manually post a correcting journal to move it to the correct account 
• Anything you can’t identify, do not force-post. Flag it in a tracking sheet with date, amount, and source document for follow-up with whoever created it 
• Target: the suspense account balance should return to zero (or its expected recurring balance) by end of phase 

Phase 3: Rebuild AR and AP to match reality

The next step is to make sure customer and vendor balances reflect what is actually outstanding.  

Receivables: 

• Run Aged Accounts Receivable report (search by name) for the full catch-up period 
• Open Customer Ledger Entries for each customer with open items filter Open = Yes 
• Cross-check against actual bank deposits reconciled in Phase 2. For invoices already paid: Actions → Apply Entries, select the payment, and post the application. 
• For genuinely uncollectible balances: post via a journal to the appropriate bad debt/write-off account, not by deleting the entry 

Payables: 

• Run Aged Accounts Payable report 
• Open Vendor Ledger Entries, filter Open = Yes 
• Match payments against reconciled bank transactions using Apply Entries for anything that has already been paid. 
• For duplicate or erroneous bills: reverse via correcting journal, don’t delete posted entries 

Phase 4: True Up Fixed Assets & Depreciation

After rebuilding AR and AP, review other balance-sheet accounts that can affect the accuracy of the financial statements.  

• Open Fixed Assets list, check FA Ledger Entries for each asset to find the last posted depreciation date 
• Search “Calculate Depreciation” batch job → run for the range between last posted date and current period, per asset or asset class 
• Review the proposed depreciation journal lines. Before posting, check for assets that should have been fully depreciated or disposed but weren’t. 
• Post via the FA G/L Journal 
• If any assets were disposed/sold during the disarray period but never recorded, process via FA Disposal now, backdated to the actual disposal date (subject to your posting date lock in Phase 1, you’ll need to temporarily open that specific date) 

Phase 5: Reconcile Payroll Liabilities

Payroll liabilities should also be compared with the actual payroll records for each period to identify and correct differences. 

• Pull actual filed payroll reports from your payroll provider for each period in the catch-up window 
• Search “General Ledger Entries,” filter by your Payroll Clearing/Payroll Liability account(s) 
• Match each journaled payroll entry to the provider’s report for the same pay period, including gross wages, tax withholdings, and employer liabilities 
• Post correcting entries for variances via a dedicated journal batch (see Phase 7). Common issues include employer tax accruals not reversed, and benefits withheld but not remitted. 
• Confirm the clearing account returns to its expected balance (usually zero) after each pay period is trued up 

Phase 6: Post Correcting Entries as a Reviewed Batch

Instead of posting adjustments as you find them, consolidate the identified corrections into a reviewed batch with clear descriptions and consistent dimensions. 

• Post every correction identified in Phases 3–6 into this batch with a clear Description referencing the source issue (e.g., “Reclass misposted vendor payment, see suspense review 07/2026”) 
• Use Dimensions consistently if your chart uses them, so the corrections don’t create new reporting gaps 
• If workflow approvals are enabled, route the batch through a second reviewer before posting. Do not self-approve a bulk correction batch 
• Post only after the full batch is reviewed, not line by line as you find issues 

Phase 7: Trial Balance & Financial Statement Review

Once all corrections have been reviewed and posted, verify that the books now tie out across the catch-up period. 

• Search “Trial Balance” (or Account Schedules → Trial Balance) for the full catch-up period 
• Compare against the last known good trial balance (your Phase 1 cutoff). Check that the movement between the two makes sense, given what you corrected. 
• Generate the P&L and Balance Sheet via Financial Reports for the same range 
• Sanity-check: cash balance matches all reconciled bank statements exactly, AR/AP aging ties to Phase 4 output, and suspense/clearing accounts are at expected balances 
• Only once this ties out cleanly, move your Allow Posting From date (Phase 1) forward to close the catch-up period and reopen normal posting. 

Focus on Running Your Business While Experts Catch Up Your Books

Catching up on months of bookkeeping in Business Central takes more than entering overdue transactions. Start by reconciling bank accounts and clearing uncategorized balances, then rebuild AR and AP, true up fixed assets and payroll liabilities, and post reviewed correcting entries. Finish by reviewing the Trial Balance and financial statements to confirm the books tie out. Following this structured process helps restore accurate financial records while reducing the risk of historical errors affecting future reporting. 

At Whiz Consulting, our catch-up bookkeeping services help US businesses clear bookkeeping backlogs, reconcile transactions, and restore reliable financial records. While your team stays focused on running the business, our MS Dynamics 365 Business Central accounting services help keep your books accurate within the software.