Page 1 of 1

bank reconciliation after transferring between funds

Posted: Tue Jul 06, 2010 7:28 pm
by victory4me
I opened a savings account and started fund 02 for it.
I transferred $100 from fund 01 to fund 02 using the procedures in the Power Church manual book, with transfer accounts.
When I went to do the bank reconciliation, it showed a 0.00 amount for the fund 01 acct. Now my reconciliation is off by the $100. The transaction itself seemed to post correctly.
How do I fix this?

Re: bank reconciliation after transferring between funds

Posted: Tue Jul 06, 2010 9:38 pm
by JohnDMeyers
We'll have to go step-by-step to get to the answer.

Your transfer transaction should have been (don't worry if your account numbers are exactly the same as my example):

CR 01-1110-000 $100 checking
DB 01-9010-000 $100 transfer

DB 02-1120-000 $100 savings
CR 02-9020-000 $100 transfer

Post in fund accounting (which you said you did)

You need to go into the reconciliation window for 1110 and highlight the $100 in the window and click the spacebar or mouseclick to put a "C" next to the $100.

The amount "to balance" should be zero at the bottom.

You need to go into the reconciliation window for 1120 and highlight the $100 in the window and click the spacebar or mouseclick to put a "C" next to the $100.

The amount "to balance" should be zero at the bottom.

Did you do all this?

Re: bank reconciliation after transferring between funds

Posted: Wed Jul 07, 2010 6:45 am
by victory4me
From you:
You need to go into the reconciliation window for 1110 and highlight the $100 in the window and click the spacebar or mouseclick to put a "C" next to the $100.

my reply:
I did exactly the top part as you listed, but when I got to the reconciliation window for 1110, there wasn't $100. It said $0.00 for this entry.
The balance in the very bottom shows I am $100 off.

Thanks,
Wanda

Re: bank reconciliation after transferring between funds

Posted: Wed Jul 07, 2010 7:35 am
by JohnDMeyers
In the reconciliation window, try selected ALL DATA instead of just UNRECONCILED and see if it appears.

You may find two entries, which would account for the $100 error.

Re: bank reconciliation after transferring between funds

Posted: Wed Jul 07, 2010 10:41 am
by victory4me
I did click "all data". On the reconcile bank account page under checks and other subtractions, I still have: reference: open savings acct amount: 0.00. And the "to balance" is 100.00.

Why is the $0.00 there and not $100.00?

Re: bank reconciliation after transferring between funds

Posted: Wed Jul 07, 2010 11:21 am
by JohnDMeyers
There is a check box in the reconciliation window that says "only show items before the date of the statement" or something to that effect.

Uncheck that box. It is always checked by default, and it messes me up sometimes.

If that doesn't do it, check your Modify Unposted Transactions to see if it didn't get posted, or look in some nearby account to see if it got posted to the wrong account number.

Re: bank reconciliation after transferring between funds

Posted: Fri Jul 09, 2010 6:31 am
by Jeff
When I went to do the bank reconciliation, it showed a 0.00 amount for the fund 01 acct. Now my reconciliation is off by the $100. The transaction itself seemed to post correctly.
How do I fix this?
Transfering money from one fund to another should not have an effect on the balance in the account, so it should not have an effect on the bank reconciliation. The transfer will show as a 0.00 in the bank reconciliation because you are debiting and crediting the same account in 2 different funds.

Can you post the entry you used to transfer the money from one fund to another. And have you checked the transaction the used the money after you transfered it? It should also be shown on the reconciliation. A common problem is recording the transfer from one fund to another, but not recording the actual check.

Re: bank reconciliation after transferring between funds

Posted: Mon Jul 12, 2010 10:00 am
by victory4me
JohnDMeyers wrote:A common problem is recording the transfer from one fund to another, but not recording the actual check.
o.k. this is probably the problem.
What I am trying to do is transfer $100 from the 01 checking account (01-1110) to an 02 savings acct. (02-1210).
I did the transfer transactions exactly like the sample in the v11 book, p.229. Please help me with recording the actual check part.
I did not actually write a check, but I am entering "check" information through fund acctg transactions.
Do I need to use any of the transfer acct numbers with this?
Thanks sooo much for your help.

Wanda

Re: bank reconciliation after transferring between funds

Posted: Mon Jul 12, 2010 11:17 am
by Eden Whitehead
victory4me wrote:I opened a savings account and started fund 02 for it.
I transferred $100 from fund 01 to fund 02 using the procedures in the Power Church manual book, with transfer accounts.
When I went to do the bank reconciliation, it showed a 0.00 amount for the fund 01 acct. Now my reconciliation is off by the $100. The transaction itself seemed to post correctly.
How do I fix this?
Wanda, Are you saying that you can reconcile the fund 02 account with no problem? You are having the problem ONLY with the fund 01 account reconciliation?

Also, have you checked any of the Fund Accounting reports, as John suggested? -- Modify Unposted Transactions; also, you might want to look at the Posted Transactions report as well as the Account Activity report for both accounts to see what shows up.

Good luck! (I feel your frustration -- :wall: )

Eden

Re: bank reconciliation after transferring between funds

Posted: Mon Jul 12, 2010 1:10 pm
by victory4me
I called today and got this problem solved. I needed to move the $100 from 02-1110 (checking) to 02-1210 (savings) to make it work.
Thanks for the help.

Re: bank reconciliation after transferring between funds

Posted: Mon Jul 12, 2010 1:55 pm
by Eden Whitehead
Glad it was resolved for you! Happy PC+-ing! 8) :D