Investigating and Resolving Discrepancies in the 'Other Transactions Affecting' Section of the Aged Accounts Receivables Report
The 'Other transactions affecting the Account Receivables account' number on the Aged A/R report often reflects entries that were posted directly to the accounts receivables asset account outside the standard workflow. This may include non-standard items such as journal entries, manually-posted expenses, or other adjustments that typically indicate incorrect postings. Resolving these discrepancies ensures accurate reporting and accounting integrity.
Understanding 'Other Transactions Affecting'
The 'Other transactions affecting' line item captures non-standard entries that influence the Accounts Receivables account outside the intended flow. Common causes include:
Journal entries
Expenses mistakenly posted to the A/R account
Manual adjustments or ad-hoc postings
These entries often result in inaccuracies and should not be used in determining the true balance of the A/R account. The accurate balance comes from the standard A/R activities displayed in the report.
Steps to Investigate Discrepancies
To pinpoint and address any discrepancies in the 'Other transactions affecting' section:
Run the Aged A/R Report: Start the report from an earlier period to identify when the balance first deviated unexpectedly. IE: run this report for each fiscal month to see when this figure had changed and the dollar amount of the change.
Note Unexpected Changes: Identify each fiscal period where the 'Other transactions affecting' or total balance shows unexpected changes.
Use Account Inquiry for Analysis: For each period with anomalies, run an Account Inquiry for the Accounts Receivables account to view the detailed entries made during that period.
Identify Non-Standard Transactions: Focus on spotting irregular entries, such as ad-hoc journal entries, expenses booked to the A/R account, or manual invoice adjustments using the A/R account as the offset account.
Corrective Actions
Once you identify the problematic transactions, take the following steps to correct them:
Reclassify incorrect postings to their appropriate accounts according to your company’s accounting policies.
Reverse any erroneous entries that should not have been made to the A/R account.
Validate corrections to ensure the account reflects only standard A/R activity.
Remember, journal entries should usually not be employed to adjust the A/R account unless under very specific circumstances.
Best Practices to Avoid Future Discrepancies
To ensure ongoing accuracy in managing the A/R account:
Limit direct postings to the A/R account to approved transactions only.
Regularly review and reconcile the A/R account to catch errors early.
Train staff on proper procedures for handling accounts receivables and associated accounts.
By following these steps and maintaining disciplined processes, you can ensure the accuracy of your A/R account and prevent future discrepancies.