Check Register doesn't match Activity Report or GL

[bethdtown]

We had this happen at the end of last year but it didn't effect our bank rec or GL we thought it was just a glitch when we had a brief power outage.
However, it has happened again while doing our latest bank rec and I don't understand why or how to fix it. When I look at the individual transaction the total matches the actual check amount that cleared our bank. The transactions are correct on our activity report and the GL account balances match the activity report totals but the amount on the check register is $136.00 less then what was posted. I can't finish my bank rec because it's off but I don't know how to fix it since the transaction amounts in GL are correct.

The transaction looks like this:
10-1130 Cash 3346.28
45-1130 Cash 2889.29
10-2810 Loan Payable 3346.28
45-5990 Interest 2889.29
Totals 6371.57 6371.57

Check cleared bank for 6371.57
Check Register has 6235.57

Any help is appreciated!

[NeilZ]

We had this happen at the end of last year but it didn't effect our bank rec or GL we thought it was just a glitch when we had a brief power outage.
However, it has happened again while doing our latest bank rec and I don't understand why or how to fix it. When I look at the individual transaction the total matches the actual check amount that cleared our bank. The transactions are correct on our activity report and the GL account balances match the activity report totals but the amount on the check register is $136.00 less then what was posted. I can't finish my bank rec because it's off but I don't know how to fix it since the transaction amounts in GL are correct.

The transaction looks like this:
10-1130 Cash 3346.28
45-1130 Cash 2889.29
10-2810 Loan Payable 3346.28
45-5990 Interest 2889.29
Totals 6371.57 6371.57

Check cleared bank for 6371.57
Check Register has 6235.57

Any help is appreciated!

When you're in the reconciliation, the check shows 6235.57, but the original transaction shows the correct amount? That is very unusual, let me see if I can get a tech here to look at this, as it sounds like the database is off somehow.

However, try doing a reindex of the database first, see if that may correct it. I doubt it will, but its worth a shot.

Finally, if you have power outages on that computer, I would get the church to buy a small UPS for that computer to keep that from happening in the future.

[Zorak]

We would need to look at the transaction in question to be able to diagnose the problem. As Neil suggested, reindexing is a good idea, since it will show a warning about database corruption found in the Fund Accounting data files. If you somehow have duplicate transaction IDs or something assigned in the database, that would explain why there is a $136 difference being reported on that particular transaction. Likely an unrelated $136 transaction being combined with this one in the calculation.

If you have the time to work through the problem with one of our technicians, please give us a call at (800) 486-1800 when you have access to the software. We are available from 9AM to 6PM Eastern, Monday through Friday. Otherwise, make an Accounting Files backup and send that to us using the form on our website at https://www.powerchurch.com/data and we will take a look for ourselves.