Deposits not showing up on Reconciliation

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Living.Water
Posts: 1
Joined: Thu Dec 31, 2009 9:13 am

Deposits not showing up on Reconciliation

Post by Living.Water »

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!

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Deposits not showing up on Reconciliation

Post by JohnDMeyers »

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 watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

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

Re: Deposits not showing up on Reconciliation

Post by NeilZ »

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!
When you restart accounting, the Contributions database is NOT touched, otherwise you'd lose all that contributions history.

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.

Post Reply