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

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.

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.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.