Bank Reconciliation Balances

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
GaboroneBaptist
Posts: 17
Joined: Fri Aug 25, 2017 9:38 am

Bank Reconciliation Balances

Post by GaboroneBaptist »

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

GaboroneBaptist
Posts: 17
Joined: Fri Aug 25, 2017 9:38 am

Re: Bank Reconciliation Balances

Post by GaboroneBaptist »

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.
  • Transaction key duplicated
    Transaction detail key duplicated
I am guessing that this may be the source of my problem.

How do I fix this?

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Bank Reconciliation Balances

Post by NeilZ »

GaboroneBaptist wrote:
Wed Oct 14, 2020 9:31 am
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.
  • Transaction key duplicated
    Transaction detail key duplicated
I am guessing that this may be the source of my problem.

How do I fix this?
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.
Neil Zampella

Using PC+ since 1999.

Post Reply