Our church has been using Power Church for years for the Contributions & Membership modules.
We began using the Fund Accounting & Accounts Payable modules as of October 1st of this year.
I have been unable to complete our first bank reconciliation for October 2013. Part of what has complicated our situation is the fact that, when we started using the Fund Accounting module in October, we were in the middle of working with our bank to combine 14 bank accounts that the church was previously using down to only one bank/checking account.
We also have our chart of accounts set up with the one checking account listed as a group account, and 15 detail or sub-accounts for this one checking account.
But something else I noticed was that, when I printed the Check Register report for October, that lists all transactions in these bank accounts in Power Church, it shows that 201 transactions occurred. But when I count how many transactions are listed in the Reconcilation screen, it is only showing 147 transactions.
Has anyone else had this problem ?
Also, we were wondering if it is possible to have a separate file from the file the church is using to learn in ?
First Bank Reconciliation
Moderators: Moderators, Tech Support
Re: First Bank Reconciliation
ReJoiCe wrote:Our church has been using Power Church for years for the Contributions & Membership modules.
We began using the Fund Accounting & Accounts Payable modules as of October 1st of this year.
I have been unable to complete our first bank reconciliation for October 2013. Part of what has complicated our situation is the fact that, when we started using the Fund Accounting module in October, we were in the middle of working with our bank to combine 14 bank accounts that the church was previously using down to only one bank/checking account.
We also have our chart of accounts set up with the one checking account listed as a group account, and 15 detail or sub-accounts for this one checking account.
But something else I noticed was that, when I printed the Check Register report for October, that lists all transactions in these bank accounts in Power Church, it shows that 201 transactions occurred. But when I count how many transactions are listed in the Reconcilation screen, it is only showing 147 transactions.
Has anyone else had this problem ?
OK .. even though you have subaccounts under the checking account, when you reconcile, they should all be reflected under the main checking account (default of 01-1110)
Now, as far as missing checks in the reconciliation ... make sure that when you see the initial "Reconcile" pop up screen, you select the ALL DATA radio button. That will pull up everything. Let us know what you then see.
Also, make sure that you have POSTED everything from all areas of the program (Payroll, Accounts Payable) and so on.
Sure .. the best way to do this is to install Powerchurch on a local machine using a different install directory. For PCPlus 11.5, this is usually \powerchurch\pcplus115. Change that in the setup screen to \testPCPlus\pcplus115. Let the system install, then restart. It will ask for church information, you should only need the actual registration number, all the rest you could dummy.Also, we were wondering if it is possible to have a separate file from the file the church is using to learn in ?
Then take a backup from the "LIVE" system, and restore it to the test system. Then play to your heart's content
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: First Bank Reconciliation
NeilZ,
I don't know if it matters, but we are not using the default main checking account. Our main checking account number is 01-1111. When I look closely at the October Check Register that I printed, I can see that it is including transactions from more than one of the checking sub-accounts.
However, I have already been selecting "Include: All data" in the Reconciliation screen, yet it has only been including 147 transactions for October (as compared to the 201 transactions listed on the October Check Register). And everything has been posted.
Thank you so much for taking time to suggest ways to try to resolve our problem.
I don't know if it matters, but we are not using the default main checking account. Our main checking account number is 01-1111. When I look closely at the October Check Register that I printed, I can see that it is including transactions from more than one of the checking sub-accounts.
However, I have already been selecting "Include: All data" in the Reconciliation screen, yet it has only been including 147 transactions for October (as compared to the 201 transactions listed on the October Check Register). And everything has been posted.
Thank you so much for taking time to suggest ways to try to resolve our problem.
Re: First Bank Reconciliation
Just a thought, what about the dates?
Are all of the transactions dated before the statement date you are entering? In the newer versions,11 and 11.5, they will not show you something dated after the statement date. An example would be you enter a date of 10/30/2013. Any transactions dated for 10/31 would not be showing. There is a check box at the top of the reconcile screen that says, 'Only show items dated before statement date.' Unchecking that box will show everything that has been put into the system for that checking account.
Are all of the transactions dated before the statement date you are entering? In the newer versions,11 and 11.5, they will not show you something dated after the statement date. An example would be you enter a date of 10/30/2013. Any transactions dated for 10/31 would not be showing. There is a check box at the top of the reconcile screen that says, 'Only show items dated before statement date.' Unchecking that box will show everything that has been put into the system for that checking account.