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.

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

1. 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)