Debugging Debtors and Creditors Reports: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 16: | Line 16: | ||
Common Posting Problems | Common Posting Problems | ||
# Both sides of the posting are to the same account. This is often caused by: | # 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) |
Revision as of 08:44, 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.
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)