Debugging Debtors and Creditors Reports: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
*** Creditors: The sum of balances on bill headers/lines including -ve balances for credit notes. | *** 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. | *** Debtors: The sum of balances on invoice headers/lines including -ve balances for credit notes. | ||
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. |
Revision as of 08:40, 16 March 2021
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.