bank reconcilation

[CCSBA]

I have Powerchurch +9. I am doing a bank reconcilation in which the amounts that are posted to a subaccount are not showing up to clear in the bank reconcilation. Can you help me?

[Jeff]

Kim,

I am assuming the sub-account is a sub-account of your main bank account. Was the amounts to the sub-accounts included in one transaction? ie did the transaction look something like this:

01-1110-000 (debit 100.00)
01-1110-100 (debit 50.00)
01-1110-200 (debit 25.00)
etc.

If so, the bank reconcilation consolidates all these down to one entry and shows it as a single amount. (ie $175) It does this because your bank would only show one deposit for $175, not 3 deposits.

If this is not the case, what did the original transaction look like?

[CCSBA]

Okay. This is a little confusing; I hope that I can explain it.
If the bank reconcilation would show a single amount, that would be good and I would match.
It takes two entries in the bank reconcilation to match a deposit, because of the way that I have to entry them. I enter some of the deposit in the contributions module and some of the deposit in Fund Accounting. The deposit through contributions was fine. The deposit that I entered through Fund Accounting looks like this:
45-1110-000 debit $371.10
45-1110-200 credit $255.00
45-4210-000 credit $116.10

Yet, in the bank reconcilation the entry is showing a $116.10 total.
On the same date in contributions I entered a deposit in which part of the deposit was debited to account #45-1110-200, and the total of that deposit was correct.
Does this make any sense to you?
You asked if the sub-account is a sub-account of the main bank account: yes, I only have one bank account, but many funds from that bank account.

[Jeff]

The deposit that I entered through Fund Accounting looks like this:
45-1110-000 debit $371.10
45-1110-200 credit $255.00
45-4210-000 credit $116.10

In this case the bank reconciliation is going to show $116. The reconciliation screen is going to combine the debit and credit lines to all 1110 accounts to show one total number. We are doing this so the amounts will match what the bank is showing. What amount did the bank show for this deposit?

[CCSBA]

I deposit the whole amount of $371.10. It is a sub-account only because I want to keep a running total of the amount set aside for this purpose, but all of the money is in the same 1110 account.

[Jeff]

The transaction you listed would only increase the total 1110 by $116.10.

45-1110-000 debit $371.10 (this increase what I assume is your unrestricted checking by 371.10)
45-1110-200 credit $255.00 (decreases the sub account by 255.00 net effect on the 1110 account is 116.10)
45-4210-000 credit $116.10 (increases the income account 116.10)

What specifically were you trying to do?

Should the transaction have looked something like:
45-1110-000 debit $116.10
45-1110-200 debit $255.00
45-4210-000 credit $116.10
45-4???-200 credit $255.00
In this transaction, the net effect on the 1110 is an increase of $371.10

[CCSBA]

Jeff,
Thank you.
It took me some time to get back to my problem, but I understood and everything is much better with my bank reconcilation.

Thank You! thank you! Thank you!