Skip to content
logo Knowledgebase

Sage 200 - Aged Reconciliation Reports

Created on  | Last modified on  Highlight Matches

Summary

This guide identifies some additional reports to help with aged creditors/debtors reconciliation in the Sage 200 software.

Description

There may be times when your Aged Debtors/Creditor nominal code balance does not reconcile with and Aged Debtor/Creditor report. There are number of reasons why this may happen.

Please refer to the Sage 200 Standard Online or Sage 200 Professional help files for more details.

The problem is often linked to allocation dates on some transactions. The allocation date is the date used to tie two transactions together, so for example, if a sales invoice is dated after the report date, but has been allocated to a payment on or before the report date, this can cause discrepancies.

You can download reports to identify any of these transactions. These reports have been designed to help with reconciling the Debtor/Creditor control nominal code with an Aged Debtor/Creditor report.

Resolution

Download Reports

To download Aged Reconciliation Customer Report, click here.

To download Aged Reconciliation Supplier Report, click here.

For reference the below list shows different transaction types mentioned within the article/report:

  • SI - Sales Invoice
  • SC - Sales Credit
  • SR - Sales Receipt
  • SP - Sales Payment
  • PI - Purchase Invoice
  • PC - Purchase Credit
  • PP - Purchase Payment
  • PR - Purchase Receipt

Install Reports

To upload these reports to Sage 200, please refer to the help files below.

Sage 200 Standard Online, click here.

Sage 200 Professional, click here.


Customer Reports

Aged Reconciliation - Allocation Dates - Customer - Finds any transactions dated after the report date with an allocation date on or prior to the report date which are causing discrepancies. 

For example, SI dated 15/01/2021, allocated to SR dated 01/02/2021 with an allocated date of 31/01/2021. Aged Debtor report until 31/01/2021 will not show any balance as the invoice is no longer outstanding, however, Debtor Control nominal code on Trial balance for 31/01/2021 will only show SI balance as SR is dated 01/02/2021 causing these reports to imbalance. 

Report Description Date Range to use Action Required
Aged Reconciliation - Allocation Dates - Customer.report Finds transactions dated after the report date with an allocation date on or prior to the report date. Up to the reconciliation date

Add the report total allocated amount to the Debtor Control nominal code figure on Trial balance. 

Alternatively, amend the transactions/allocation date to the correct priod. See below for more details. 

 

  • Incorrect allocation date > Amend the relevant transaction allocate date to the same date or after the transaction date. In above example, 01/02/2021 or after. For more details on how to amend, Please refer to the help files for Sage 200 Standard Online or Sage 200 Professional.
  • Incorrect transaction date > Amend the relevant transaction date to the correct period. For more details on how to correct, Please refer to the help files for Sage 200 Standard Online or Sage 200 Professional

Supplier Reports

Aged Reconciliation - Allocation Dates - Supplier - Finds any transactions dated after the report date with an allocation date on or prior to the report date with are causing discrepancies. 

For example, PI dated 15/01/2021, allocated to PP dated 01/02/2021 with an allocated date of 31/01/2021. Aged Creditor report until 31/01/2021 will not show any balance as the invoice is no longer outstanding, however, Creditor Control nominal code on Trial balance for 31/01/2021 will only show PI balance as PP is dated 01/02/2021 causing these reports to imbalance. 

Report Description Date range to use Action Required
Aged Reconciliation - Allocation Dates - Supplier.report Finds transactions dated after the report date with an allocation date on or prior to the report date. Up to the reconciliation date

Add the report total allocated amount to the Creditor Control nominal code figure on Trial balance. 

Alternatively, amend the transaction/allocation date to the correct period. See below for more details. 

 

  • Incorrect allocation date > Amend the relevant transaction allocate date to the same date or after the transaction date. In above example, 01/02/2021 or after. For more details on how to amend, Please refer to the help files for Sage 200 Standard Online or Sage 200 Professional.
  • Incorrect transaction date > Amend the relevant transaction date to the correct period. For more details on how to correct, Please refer to the help files for Sage 200 Standard Online or Sage 200 Professional