Our system use two GL accounts for incoming payments: 120-Accounts Receivable and 260-Customer Deposits. When I run the AR Balance by GL Account report, some prepayments are reported under the 260 account even though they have posted to our ledger under 120. That means the report doesn’t match our trial balance. Has anyone else experienced this? Is there a cause and is there a correction? Thank you.
An example follows.
The AR Balance by GL Account report, showing the prepayment listed under GL 260:
The AR Register for the highlighted transaction, showing the transaction posted to GL 120: