Variance in Trade Debtors

Back Top Prev Next Print

Generally, if there is a variance between the Trade Debtors in the Balance Sheet and the Debtors list, it indicates that a manual entry (ie. a general journal) may have been posted directly to the general ledger. Following explains how to check if this is the case.

 

1.Go to Accounts > Account Inquiry.

1.Select the Trade Debtors GL Account in the Account field.

2.In the Doc.Date fields, choose a broad date range up to the current date (eg. 15/01/1900 to today).

 

debvarianceThis will display all trade creditors transactions within the selected date range.

4.Group the list by the Type column. This is done by clicking on the Type heading and dragging up above.

debvariance1

Look for any transactions such as general journals of type GJS or GJP, as these indicate that a manual general journal was posted..

You can then review these and decide how to manage them.

 

You can also try sorting the Debit and Credit columns to identify any variances.

 

debvariance2

 
In some cases, you may be able to locate the exact amount of the variance, however, it is also possible that the variance could involve more than one transaction.

 

Further information

Understanding Debits and Credits

Accounts Security

Debtors

Creditors

Use Debtors and Creditors Adjustments

Advanced Creditors

General Ledger

Account Inquiry

Transaction Journal

General Journals

GST Sessions and the BAS

Credit Cards

End of Financial Year

Clear the Historical Balancing Account

Suggested End Of Month Procedures

Enter a Capital Asset

Enter Capital into the Business

Enter Child Support Payments

Enter Government Support Payments

Enter Prepaid Expenses and Amortising Costs

Purchase a Capital Asset Under Finance

Handle Paypal (and Similar)

Record Debtors/Creditors Contras

Remove Duplicate Payments in Closed Period

Rounding Issues

Sell a Company Asset

Set up a Loan Account

ATO Reportable Sub-Contractor Payments

Share Utility Expenses with other Businesses

Variance in Trade Creditors and Creditor List Total

Recover Bad Debts

Withhold Tax

Write off a Bad Debt

Write off Fixed Asset

Work with Tax Codes in Jim2