I have deposit that went to our account once. This transaction appears only once in Bank Rec, but appears three times in general ledger. Two of the three postings have the same post sequence and document number in the subledger information section.

It seems to me that I need to reverse two of the three transactions in the GL - there are no duplicate (cleared or outstanding) transactions to reverse in Bank Rec.

Can someone confirm how this would happen, or where I would look to see if there are additional subledger transactions? It seems more a software error than a user error. I have run data integrity checks in both General Ledger and Bank Rec.

Thanks,

Hi Lisa,

When BankRec - or any other Adagio program - posts a transaction, a retrieval file gets written to. Then from Adagio Ledger, a process to retrieve these files is performed and creates batches for processing and posting in Ledger. Each retrieved transaction should have a unique batch-entry number, with a collection of accounts and debits/credits that net to 0.00.

You said that integrity checks were run. Were they clean, or were errors found? Have you ever had to get data rebuilt or fixed due to any previous posting errors in GL?

Unless the retrieval file was accidentally restored from a backup and re-retrieved into Adagio Ledger, BankRec would not have any influence over posting batches in Adagio Ledger. If this happened, then the duplicate deposit number would be logged with different GL batch numbers.

Does BankRec allow duplicate document numbers? This is an option in the company profile. If it does allow, then it is possible to post 2 deposits with the same ID.

If you find that there are 2 posted transaction details to the same account and have the same posting sequence / batch # / entry #, it is possible that the entry happened to update the same account twice - though unlikely. Is it the same amount? You did confirm that the 'subledger information' had the same batch/entry number (ie the BankRec batch/entry).

If you load View Transactions in Ledger, highlight the problem transaction in question, and click the 'View GL Entry' button, what do you see? It should be all the transactions that made up the deposit. Maybe this will give some clues.

You said that integrity checks were run. Were they clean, or were errors found?
Yes, they were clean, no errors found.
Have you ever had to get data rebuilt or fixed due to any previous posting errors in GL?
We had a duplicate posting issue around the same time, but this occurred from GL to Bank Rec.

I will compare the difference in subledger to general ledger balance last month to this month. If the 'triple' posting of this matches the variance, the correcting entry is clear.

Thanks,

Lisa