Hi,

Sage have created a set of Aged Reconciliation reports to help with issues like this. You can find more details on the reports and how to install them here: gb-kb.sage.com/.../viewsolution.jsp

Hi, that's great I have installed those, however that one shows any payments made after the transaction date being allocated before the payment date, what I need is also a transaction allocated after the payment date, so payment made in July but allocated in August as this also effects the reconciliation, is that possible?

Hello Kate, 

I have looked into this for you and would suggest a couple of things. As you mentioned the Aged Reconciliation - Allocation Dates in your example would not pick up the allocation if it is posted after the payment date. For example a Purchase invoice and Payment both dates on the 01/01/2022 but allocated on the 01/02/2022 would not show.

This could be found by running Excel Reporting, Excel Reports then (once updated) the Supplier Transactions.xlsx. Once this Excel report is produced click on the Sage_SupplierTrans tab. Then this can be filtered to suit. So in my example I have a concern over period one January. I would select period one in the Accounting Period column. This then will show me all the transactions I have entered for January. If I then find the Date Settled column there are two transactions showing for the 01/02/2022 which is the allocation date I used.

You could do exactly the same on the Customer Ledger

The other option would be to see if Sage could create a customised report regarding the allocation. I have put in a link below to help.

https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112444124&page=1&position=5&q=report%20design

I hope this can be of use.

Kind regards,

Gordon