Download the Aged reconciliation reports

1. Click the download link:
• Sage Accounts v21 and above - Additional Reports Backup
2. Enter your My Sage Email address and Password then click Sign In.
3. If required, select your account.
4. The file downloads automatically to your Downloads folder.

   If you see a prompt to save the file, make a note of the file name then click Save and save the file to your desktop.

---

Restore the reports

As the backup only contains reports, your Sage 50 Accounts data isn't affected by the restore.

1. Back up your data.
2. Click File then click Restore.
3. Click Browse then browse to the location of the backup.
4. Select the reports backup, additional_reports_backup.001, then click Open.
5. Click OK then click Yes.

Run the aged reconciliation reports

1. Click Suppliers then click Reports.
2. Click AGED RECONCILIATION REPORTS.
3. Run each report to check for allocation discrepancies:

Report name	Description	Date range to use	Action required
Aged Reconciliation - Allocation Dates - PI	Locates purchase invoices dated after the report date with an allocation date on or prior to the report date.	Up to the reconciliation date.	Deduct the allocated amount from the aged balance. Alternatively, if using Standard VAT, delete the purchase payment, post a purchase payment on account then allocate the payment on account to the invoice using the invoice date. If the purchase payment is bank reconciled, to ensure the purchase payment on account is bank reconciled and avoid differences on the next bank reconciliation, select the Bank Reconciled check box in the Corrections option. Find out more in our Correct transactions guide.
Aged Reconciliation - Allocation Dates - PP-PC-PA-PD	Finds purchase payments, credits, discounts and payments on account dated after the report date with an allocation date on or prior to the report date.	Up to the reconciliation date.	Add the allocated amount to the aged balance. If both the invoice and the payment are dated after the report date, this does not result in a discrepancy and these transactions should be deducted from the allocated amount total.
Aged Reconciliation - Future Allocation Dates - PD-PP	Finds discount and payment transactions dated on or before the report date with an allocation date after the report date.	Up to the reconciliation date.	Change the allocation date to be the same as the posting date. To do this you can delete and repost the transaction. Alternatively, in Sage 50 Accounts v22 and above, you can unallocate the transaction then re-allocate. If you can't delete and repost or re-allocate the transaction, deduct the allocated amount from the aged balance. Find out more in our Correct transactions guide.
Aged Reconciliation - Link Removed - PI	Finds any PI transactions with Link Removed in the Allocation Details.	01/01/1980 - 31/12/2099	Follow the steps in our handy Link Removed transactions and Aged Balance differences guide.
Aged Reconciliation - Link Removed - PP-PC-PA-PD	Locates any PP/PC/PA/PD transactions with Link Removed in the Allocation Details.	01/01/1980 - 31/12/2099	Follow the steps in our handy Link Removed transactions and Aged Balance differences guide.
Aged Reconciliation - Outstanding PD	Finds any outstanding or part paid PD transactions.	01/01/1980 - 31/12/2099	Click File then click Maintenance. Click Check Data then click Recovery Tools. When prompted, take a backup. Click Reset Transaction Status. Click OK then click Close.
Aged Reconciliation - Upgraded - PI	Finds any purchase invoice transactions with Upgraded in the Allocation Details.	01/01/1980 - 31/12/2099	Cannot be corrected. This clears when the Clear Audit Trail routine is ran to a date after the upgrade date.
Aged Reconciliation - Upgraded - PP-PC-PA-PD	Finds any payment, credit, discount or payment on account transactions with Upgraded in the Allocation Details.	01/01/1980 - 31/12/2099	Cannot be corrected. This clears when the Clear Audit Trail routine is ran to a date after the upgrade date.