If your Aged Creditors Report does not match your Trial Balance (TB), use the steps below to identify which supplier is out of balance.
Step 1: Run the Creditor Balance by Period report
To check whether the discrepancy is in the Aged Creditors Report or the TB itself, start by running the Creditor Balance by Period report.
Run the Creditor Balance by Period report.
Check whether the total on this report matches the total on your TB for your Purchase Ledger - Office and Nominals.
â ď¸Important: If the Creditor Balance by Period report does not match your TB totals, contact support.
If the totals do match, continue to Step 2.
â
Step 2: Export both reports to Excel
To compare the two reports side by side, export them both to Excel.
Export the Creditor Balance by Period report to Excel.
Run the Aged Creditors office/nominal report and export it to Excel.
In the Aged Creditors export, delete the info lines and keep only the totals.
Order the data by amount.
Copy the Aged Creditors data into the same spreadsheet as the Creditor Balance by Period data.
Subtract one total from the other to identify which supplier is out of balance.
Step 3: Investigate in Purchase Enquiry
Once you have identified the supplier, use Purchase Enquiry to locate the invoice with the issue.
Go to Purchase Enquiry.
Search for the supplier identified in Step 2.
Review the invoices to find the one causing the discrepancy.