How to Reconcile your ledgers within Sage 200

In Sage 200 by Sioned Roberts

Reading Time: 5 minutes

If you’re going through your Sage 200 Year End or preparing for auditors by balancing your ledgers you may find the following information useful!

How much time do you spend on average in reconciling ledgers and ensuring that the balances balance?

Are you confident that you are doing this correctly and you’re doing it the best way possible?

With our hints and tips on How to Reconcile in Sage 200, you will be well on your way.

3 Key Factors to reconciling in Sage 200:

  1. The Nominal Ledger is controlled by the status of the accounting periods
  2. Aged Creditors and Aged Debtors are based on Allocation Date instead of posting date when running retrospectively.
  3. Always best to start off with the question ‘does it balance to now?’ Before even looking into reconciling retrospectively.

To reconcile the Sales Ledger and Debtors Control follow these simple steps…

Step One: Get the Sales Ledger Balance

You need the total balance for all Sales Ledger accounts, and there is more than one way to do this…

OPTION 1. Using the ‘Aged Debtors (Summary)’ report (This can be accessed Sales Ledger- Reports- Credit Control- Aged Debtors (Summary)), and when the criteria appears, leave ‘as is’- i.e. do not add or filter by ANY criteria.

Then make a note of the Balance at the bottom of the report.

Sage 200 Reconciliation - Aged Debtors Default Criteria

OPTION 2. Using Ledger Summaries (This can be accessed via Accounting System Manager- System Utilities- Ledger Summaries) and selecting ‘Sales Ledger’ from the drop down. Use the field called “Current Ledger Balance”.

Sage 200 Reconciliation - Ledger Summaries

OPTION 3. Using the Transaction Listing Report (Accessed via Sales Ledger -Reports) and making a note of the ‘base outstanding total column’

*This only works if all your customers are ALL in base currency*

Highlight all customers in the customers list, and make a note of the Total Balance at the bottom of the screen

Step Two: Nominal Ledger Balance

You need the total balance for the Debtors Control Account, and, again, there is more than one way to do this…

OPTION 1. Using the ‘Trial Balance Report’ (Nominal Ledger- Reports- Financial Statements- Trial Balance Summary).

When the criteria appears, leave ‘as is’. Make a note of the Year to Date Balance on the Debtors Control Account

OPTION 2. Using the Nominal Accounts List- Find the Debtors Control account in the list and make a note of the balance on the account

Sage 200 Reconciliation - Nominal Ledger List view

OPTION 3. Using the Nominal Accounts Enquiry Workspace (Nominal Accounts – Nominal Enquiries – Nominal Accounts Enquiry Workspace) and filtering by the Debtors Control Account. Make a note of the balance year to date

Sage 200 Reconciliation - Nominal Ledger Account Enquiry Workspace

What to do if there are differences…


Report Pending Transactions (Sales Ledger- Period End Routines- Report Pending Transactions) – Does this account for the difference?

Q. How are transactions in pending transactions?

A. Transactions will be in here if you use Sales Order Processing and your SOP settings Order Processing is not set to ‘Add directly to the Sales Ledger’. You can update these by the menu item just below (Sales Ledger – Period End Routines – Update Pending Transactions) saying ‘update pending transactions’.

Sage 200 Reconciliation - SL update pending transactions


Perhaps you have waiting postings? Check the following reports:

Current Waiting Postings Report (Nominal Ledger- Reports- Account Analysis- View Waiting Postings Report)

Deferred Waiting Postings Report (Nominal Ledger- Reports- Account Analysis- View Waiting Postings Report Deferred)

When running these reports remember to specify the debtors’ control account number and make a note of the difference between the credit and debit values waiting to post to this account. Does this value relate to the difference in your figures?

Q. How do Waiting Postings happen?

A. There is definitely enough detail to write about this in another blog for another time, but just to give you the basics for your reconciliation queries. The Nominal Leger is an accounting Period controlled Ledger. Therefore using the transaction date the system checks what the status of the corresponding accounting period is and makes the following postings.

‘Closed’ – The transaction will be posted in the next open period.

‘Open’ – The transaction will be posted into the ledger.

‘Future’ – The transaction will go into ‘deferred waiting postings’ until the period is opened at which point it will move to ‘current waiting postings’ awaiting the user to run the ‘update waiting postings routine’.

Sage 200 Reconciliation - Accounting Periods

Still issues?

Have a look if any journals have been posted into the Debtors control account? If so, this amount will not have affected the Sales Ledger so will play a part in any differences. You can view journals easily by running the report in Nominal Ledger- Reports- Account Analysis- Manual Journal Listing. (remember again to only run this for the debtors’ control account)

Finally: This routine should only be run AFTER TAKING A SQL BACKUP and when all users are logged out of the system. Run the Balance Ledgers Routine from Accounting System Manager- System Utilities- Balance Ledgers- Financials.

Sage 200 Reconciliation - Balance Ledgers

Run this for both the Sales Ledger and Nominal Ledger.

If there are still issues, go on your holidays…

Next, would be to manually use the transaction listing reports for the Sales Ledger and the Debtors Control account, then export to CSV to go through and locate any transactions that are missed from either ledger.

It’s at this point you realise how important it is to balance your ledgers on a regular basis so that when you’re looking for an error, at least you have a better idea of which transaction dates you are looking for!

It’s going to be the same routine for Balancing the Purchase Ledger and the Creditors Control. Once you are confident in balancing your ledgers, you’ll be running through this routine in no time, and the more often you are checking, the quicker you’ll be in finding in corrections and correcting them!

Sage 200 Free Report Designer Online Course CTA