We "restarted" our Accounting because of various errors, but all of the contributions are still there. However, they're not showing up on the bank reconciliation. Any ideas how to get them to show up?
Thanks!
Deposits not showing up on Reconciliation
Moderators: Moderators, Tech Support
-
Living.Water
- Posts: 1
- Joined: Thu Dec 31, 2009 9:13 am
-
JohnDMeyers
- Posts: 1338
- Joined: Sun Oct 07, 2007 9:50 am
- Location: Potsdam, NY
- Contact:
Re: Deposits not showing up on Reconciliation
They won't show up in the bank reconciliation, which is in the Fund Accounting module. That information is gone (except in your backups).
You can enter your starting balances, and you have to manually enter your outstanding checks and deposits when you do a restart.
What is kept in the Contributions Module are the previous contributions per envelope number. The List of Contribution funds will no longer point to your checking account number nor your income account number. You will have to re-enter those. (The Contribution Fund number and name still exist, but don't point to any Fund Accounting accounts).
What is kept in the Accounts Payable section are the Vendor Record names. Again, the default accounts will be blank and you will have to re-enter them. The vendor history is still intact, I believe.
Anything that had a Fund Accounting account number will have to be re-entered.
You can enter your starting balances, and you have to manually enter your outstanding checks and deposits when you do a restart.
What is kept in the Contributions Module are the previous contributions per envelope number. The List of Contribution funds will no longer point to your checking account number nor your income account number. You will have to re-enter those. (The Contribution Fund number and name still exist, but don't point to any Fund Accounting accounts).
What is kept in the Accounts Payable section are the Vendor Record names. Again, the default accounts will be blank and you will have to re-enter them. The vendor history is still intact, I believe.
Anything that had a Fund Accounting account number will have to be re-entered.
You can watch my PowerChurch tutorials now on YouTube!
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch
Re: Deposits not showing up on Reconciliation
When you restart accounting, the Contributions database is NOT touched, otherwise you'd lose all that contributions history.jamiehardhat wrote:We "restarted" our Accounting because of various errors, but all of the contributions are still there. However, they're not showing up on the bank reconciliation. Any ideas how to get them to show up?
Thanks!
What you need to do is manually create the Funds Accounting transactions to reflect those deposits. We've just gone through an accounting restart at our church, and since we've reorganized the CoA, we made sure that the new transactions reflected the updated accounts.
We found the easiest way to make sure you're doing the proper 'debiting' and 'crediting' is to:
1. In Contributions run a Funds Report by Date to get the totals for each Contribution Fund, for each Sunday.
2. Again in the Contributions Module, enter the Maintain List of Contribution Funds and go through each fund writing down the proper FA bank account for the Debit, and the proper FA income account for the Credit.
3. Then in Funds Accounting create the Transaction showing the proper credit to each income account, and the debit to the proper checking account.
For instance, in our case we use one checking account, but we have three Funds Account funds, one for operating, one for mission and one for the building.
If on one Sunday we received $1000 for operating, $200 for mission, and $200 for building, we would have the following in the transaction:
01-1110-000 Operating Checking Debit $1000
01-4210-000 Operating Income Credit $1000
02-1110-000 Mission Checking Debit $200
02-4300-000 Mission Income Credit $200
03-1110-000 Building Checking Debit $200
03-4400-000 Building Income Credit $200
This would balance out to show the bank deposit of $1400, but allows us to show the balances in fund 02 and 03 as not being available for use as operating funds.
This is a new concept for the elders here ... it seems they're 'borrowed' from other areas to keep the operations going.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.