Debugging Debtors and Creditors Reports
Follow these steps to validate and debug problems with debtors and creditors reports.
- Check that totals of bill/invoice header and line balances match each other.
- If they don't match, find specific transactions that do not match and review the data. The calculation of balance on either the header or the line may be incorrect.
- Run the reconcilation
- Check that the total "Outstanding" amount matches:
- Creditors: The sum of balances on bill headers/lines including -ve balances for credit notes.
- Debtors: The sum of balances on invoice headers/lines including -ve balances for credit notes.
- Check that the total "Outstanding" amount matches:
General Checks
- Ensure that no invoice/bill line is over-paid. Suspect duplicated allocations or migrated data from old systems.
- Ensure that the line status of invoices/bills matches the balance owing.
- Ensure that the header status of invoices/bills matches the associated line status values.
- Ensure that unposted transactions don't have any net ledger transactions.
Common Posting Problems
- Both sides of the posting are to the same account. This is often caused by:
- Setting the account of bill/invoice lines to the control account.
- Setting the account of bill/invoice lines to a different control account to the current transaction control account (impacts balancing of the other account)