GL cash account balance and reconciliation off

Tyler Lester

Hello - running into an issue I can't resolve.

My GL cash account balance is off by an amount. This amount seems to be the aggregate sum of a series of payments. However - these payments had to be voided and re-drafted in order to be paid from the correct account - in this case, our operating account instead of our payroll account.

After voiding the initial payments, and re-recording them to correct the entries to reflect the draw from the correct account, the issue pops up.

The GL account balance is neatly off by this sum. I did look for additional amounts, or an additional sum somehow recorded somewhere in payables or the GL account, but have been unable to find any evidence of it. I entered database mode and checked the vendor as well, but the same information is recorded as what is in Web View. The amounts are cleared, match up during reconciliation, and provide no other problem except this one.

Anyone run into this issue or something similar? I'm pretty close to just recorded a cash balance only adjustment, but I'd rather just identify what seems to be a duplicate payment/s somewhere. That, or perhaps voiding them again, and re-recording the payments as “Do not Post,” though I'm not sure if that's a solution either.

Patrick Lunn

@Tyler Lester this could be an annoying tough one, but first of all I'd check the dates on the voids to make sure they line up in a logical way. In my experience with pretty much any accounting software, dates can often be the issue.

Tyler Lester

@Patrick Lunn
We did check the dates and amounts of transactions, and debits/credits going in and out. They reversals and drafts seem to line up.

We were thinking it was possible that the initial void/reversal which was related to the amount being paid from the wrong account, which may have created a transaction in a/p that is unaccounted for.

Kevin Brazell

@Tyler Lester
If the original post dates & the reversal dates are the same, then as long as the reversals themselves are posted, the GL should tie. So based on my experience, I'd confirm the reversals themselves are actually posted, particularly if the post date is in a previous fiscal period, that was soft closed, etc.