My account 1110 account is not reconciling. I ran trial balance for January 01 2019 to September 30 2019 and everything balances correctly. I checked account activity and everything balances correctly. Yet when I run reconciliation, it shows that my 1110 account balance is -2647.59 whereas it should be 21.91. Difference of 2669.50. When I run reconciliation and tell it to include all data, I also get the same discrepancies. I also checked and made sure that there are no transactions later than 30 September 2019 that were marked as C or Y.
On the activity report, the difference between debits and credits is 21.91 (perfect!!).
Yet in reconciliation, the Cheques/Subtractions is 86000 lower than account activity. The Deposits/Additions is 85000 lower than account activity.
Since the trial balance, account activity, and balance sheet reports are showing correctly, I am thinking that there is something off in the reconciliation module.
Is there a "reset" or something to recalculate the balance for the reconciliation module? If not, how can I fix the error?
Thanks, James
Bank Reconciliation Balances
Moderators: Moderators, Tech Support
-
- Posts: 17
- Joined: Fri Aug 25, 2017 9:38 am
Re: Bank Reconciliation Balances
I ran a reindex a few times and kept receiving the following:
WARNING:
The following problems were found in your accounting files.
If you continue to get this warning, please contact technical support.
How do I fix this?
WARNING:
The following problems were found in your accounting files.
If you continue to get this warning, please contact technical support.
- Transaction key duplicated
Transaction detail key duplicated
How do I fix this?
Re: Bank Reconciliation Balances
This sounds like the database was corrupted in some way. I would call Powerchurch directly as this is something that probably cannot be correct by you alone.GaboroneBaptist wrote: ↑Wed Oct 14, 2020 9:31 amI ran a reindex a few times and kept receiving the following:
WARNING:
The following problems were found in your accounting files.
If you continue to get this warning, please contact technical support.I am guessing that this may be the source of my problem.
- Transaction key duplicated
Transaction detail key duplicated
How do I fix this?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.