Best way to correct unreconciled reconciliation?

[umc.manatee]

We opened a new bank account in March of 2022 and since then the Bank Reconciliation has NEVER been in balance. Now, almost 2 years later, we would like to undo all the old reconciliations and start from scratch before things get further out of hand. If we do a back up, can we then safely undo the first Fund Accounting Recon of that account and go forward from there? Is there a better way to do it?

TIA,
Adrienne

[NeilZ]

We opened a new bank account in March of 2022 and since then the Bank Reconciliation has NEVER been in balance. Now, almost 2 years later, we would like to undo all the old reconciliations and start from scratch before things get further out of hand. If we do a back up, can we then safely undo the first Fund Accounting Recon of that account and go forward from there? Is there a better way to do it?

TIA,
Adrienne

It has NEVER been in balance ??? Is that due to an issue with the first reconciliation? In any case, if you're using v14.x you can undo any reconciliation or all of them on that account. Just do a backup. You don't have to do a 'full' backup unless you want to, you only need to do Accounting.

[umc.manatee]

Ok... it *may* have been in balance at some point in time, but I'm not sure when ( ).
Thank you for your reply, we will back up, undo and start again

[umc.manatee]

Due to some "Nervous Nellies" we haven't pulled the trigger on this yet, lol.

But waiting did bring up a good question: If we undo all of the reconciliations for this checking account (starting from the first one in March 2022), when we print the Recon Report, will it show ALL of the unreconciled transactions from 2022 to present day? Will the Outstanding Deposits and Outstanding Checks amounts include March 2022 to present day amount also? Basically, can we get a true Recon Report for the end of the month or will it be "inflated"?

[NeilZ]

Due to some "Nervous Nellies" we haven't pulled the trigger on this yet, lol.

But waiting did bring up a good question: If we undo all of the reconciliations for this checking account (starting from the first one in March 2022), when we print the Recon Report, will it show ALL of the unreconciled transactions from 2022 to present day? Will the Outstanding Deposits and Outstanding Checks amounts include March 2022 to present day amount also? Basically, can we get a true Recon Report for the end of the month or will it be "inflated"?

If you use the date on the statement for that month in question, it will only show those dated on or before that date. Exactly what do you mean by inflated?

Do you mean will it show all outstanding checks? No, it will only show those outstanding checks dated before the date of the bank statement. Remember, do a Powerchurch Backup of the accounting files first. This way you can show the 'nervous nellies' that you can restore back to the way it is now if the corrections doesn't look right.

If you need a refresher:
1. Go to the Utilities menu and select Backup & Restore Files the initial window will appear.
2. The backup option should be selected on the window, so click on the NEXT button, the file groups selection window will appear.
3. Select the radio button for Accounting Files, this is all you need to backup, click the NEXT button
4 I would leave the default location for the backup the same as normal, click FINISH
5. The program will then proceed to do the backup.

The backup will be available in the default location, and will display a backup type of ACCOUNTING.