Reconciliation Issue

[jurnie05@11]

I have never reconcile the bank statement for the church and we started using PCP in 2011. I was only using the contribution and membership module but later on decided to use the accounts payable module. I was only recording the contribution funds such as tithes/offering, Sunday school offering, and church anniversary offering, etc. I didn't put in if there were a loan taking out on the church behalf.
I want to bring PCP and the bank account in line so it matches. Any help would greatly be appreciated.
TP

[NeilZ]

I have never reconcile the bank statement for the church and we started using PCP in 2011. I was only using the contribution and membership module but later on decided to use the accounts payable module. I was only recording the contribution funds such as tithes/offering, Sunday school offering, and church anniversary offering, etc. I didn't put in if there were a loan taking out on the church behalf.
I want to bring PCP and the bank account in line so it matches. Any help would greatly be appreciated.
TP

You didn't say if you had setup any Chart of Accounts. From the sound of it, you may have, or maybe not. I can't tell from your description. You also did not say if you were using v11.1 or v11.55

I'm going to be upfront .. if you did not run the Accounting Setup wizard before you started Funds Accounting and setup a good chart of accounts, and if you didn't post transactions to Funds Accounting from Contributions, as well as those checks written in the Accounts Payable, I'm not sure you can recover.

Get back with some additional information about how your local system is setup, and then there'll be a baseline of info to work from.

[jurnie05@11]

I'm sorry for the lack of information but yes I have posted everything to Fund Accounting from contributions & account payable. I'm using the 11.1 version

[NeilZ]

I'm sorry for the lack of information but yes I have posted everything to Fund Accounting from contributions & account payable. I'm using the 11.1 version

OK .. do this:

1. Make a backup of the Accounting files. This way you can revert back to the start if necessary.
2. Go into Funds Accounting and select the Reconcile Bank/Credit Card Accounts menu item. The initial window will then appear. The system will revert to the standard default account of 1110. If that's not your bank account number in the Chart of Accounts, use the one you actually use and have setup.
3. Take your most current bank statement and use that to enter the date of the statement and the bank statement balance, leave everything else at the default.
4. This will mean that all those deposits prior to the beginning date of the bank statement period will be also show up, these should be cleared. I'm assuming that all the deposits are good. Then make sure that the deposits listed on the bank statement are also cleared.
5. Now for the checks. I'd clear everything prior to the beginning of the year automatically, unless you know of checks that have not yet cleared the bank, don't clear them. Then using the statements beginning from the end of January, clear those checks.

You should see a bottom To Balance line of zero when you're finished. If not, then there's some research you need to do to see if there are checks that were cleared locally, but actually did not clear the bank (Account 1110 Balance is lower than the bank's), or checks that cleared the bank, but you did not clear locally (Adjusted Balance is lower than Powerchurch's)

If it comes out to zero .. great, you're done so click the DONE button, and print off a copy of the reconciliation. If it doesn't show zero, click the POSTPONE button. This does not finalize the reconciliation, so you can go back and make adjustments (unclear something, clear something, etc).

Let us know what you find out.

[jurnie05@11]

ok thanks and will do