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.