AR Transactions do not match GL Postings

[nickburns19]

I am writing hoping that someone can help with a problem I tracked down in SBT 5.0i. My AR Aging totals are not balancing with the balance sheet (GL - AR account). After running an AR Journal (Limited to AR Account) and then comparing the transactions per period to the General Journal (Limited to AR Journal), I have found a number of transactions where amounts did not agree and they were usually tied to cash receipts. For instance, a transaction for 809.01 in AR posted to GL for 189.16. Maybe I am wrong but it looks like receipts were over applied (which I didn't think was allowed). Now if you look at the Cash/Credit Applications report, the bad transactions are highlighted by the fact that the exact amounts appear as the balance in the Receipt/Credit Balance column (extra points if anyone can explain to me how the heck the totals are derived as they appear to be arbitrary). Mind you, I am coming into this basically as an observer as I do not handle the cash receipts.

Now after a little digging, I went into ARDIST and looked through the table for anomalies. Upon tracking down the offending transactions I noticed that the values for PAIDAMT and BPAYAMT did not agree. Running a quick query limited this to 64 transactions out of roughly 150,000. Does this scenario signal user error or program error?

At this point, I am a little lost. My Aging appears to be correct but my GL is off. Also in the case of one account with a very recent error in cash receipts, I am showing a negative open credit (AR Customer) in the amount of the error.

Any insight or feedback to this is greatly appreciated.

As a side note, I also had a batch of finance charges randomly post with no links to customers. That one was fun.

 

[BrianoNur]

There are several reasons AR does not match GL:

1. Verify customer setting. Every single customer MUST be set to a GL account.

2. PAIDAMT and BPAYAMT MUST be show same numbers. If they don't, SBT did not make that mistake. Probably someone made changes to one of those fields but forgot the other one.

3. Of course AR aging is correct, that report is reflects Invoices and payments.

4. Check the ARDIST out on no blank accounts.

5. You got to make a reconciliation customer by customer, transaction by trasaction to determine where the differences are, not easy, but not imposible either.

6. Develop routines to find mistakes/differences before end of the month.

Good luck!