Can I run a report to show individual customers debt as at 31/7/24

[hsw.dotgmail.com]

I am having issues reconciling the sales ledger closing balance for last years accounts to the figure now showing on the trial balance.

How can I extract the customer balances that make up the figure now showing on the TB, so I can compare it to the list used when the accounts were filed, last year.

I have exported the data on the debtors balance sheet but the sales invoices only show the invoice number and the payments just refer to the customer name so I cannot easily group this data by customer.

I have now found the aged debtor and creditor reports but would like to ask that this report be given more prominence in QF. I think it should be on the first list of reports as it is so useful for managing the data.

[Bagpipe]

Once you find a useful report, you can add the link to this report by clicking “add link” at the bottom left of the screen. Give it a name and hey presto, this then shows up under quick search on the left of the screen, always available.