Reconcilation question

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Blessed_miracle67
Posts: 16
Joined: Sun Jan 19, 2014 4:38 pm

Reconcilation question

Post by Blessed_miracle67 »

When we went to reconcile our account, the adjusted bank balance for example says $25,200, but the 1110 balance says $24,300. The amount should actually be the adjusted bank balance. Is there a way to correct this error. I noticed that PC automatically added an entry of 100.00 in addition to the 100.00 initial deposit that we added when we first started PC

jwdick
Posts: 51
Joined: Wed Nov 06, 2013 8:16 pm
Contact:

Re: Reconcilation question

Post by jwdick »

PC shouldn't make any automatic entries. The only entries should be the ones made through "Contributions", through "Accounts Payable" or entered manual through "Fund Accounting".

When you started the Bank Reconciliation process, you entered:
1. the account to reconcile: 1110
2. Bank statement date:
3. Ending Bank Balance per the bank statement.

Assuming the beginning balances were correct and you ONLY cleared the actual Deposits and the actual Check and other Substractions your "To Balance" amount should be zero.

Double check to make sure you only marked as "Cleared" the items on the bank statement.
Last edited by jwdick on Fri Mar 14, 2014 3:50 pm, edited 1 time in total.
Jack D.
F.U.M.C. of Pace

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

Re: Reconcilation question

Post by NeilZ »

Blessed_miracle67 wrote:When we went to reconcile our account, the adjusted bank balance for example says $25,200, but the 1110 balance says $24,300. The amount should actually be the adjusted bank balance. Is there a way to correct this error. I noticed that PC automatically added an entry of 100.00 in addition to the 100.00 initial deposit that we added when we first started PC
OK .. you're $1,000 off? or $1,100 off? Did you enter a deposit during the initial setup, then add another one after you were all setup ??

I suspect that you added a deposit that you didn't need to, so you can probably reverse that, but then there's a $1,000 difference. That's a fairly round number that should be easy to find, a missing deposit? A deposit that should have been entered when you setup Accounting? A check that did not clear, but you marked as cleared ??

Verify everything you marked off in Powerchurch, with what you have from the Bank, then come back here with your findings.
Neil Zampella

Using PC+ since 1999.

Blessed_miracle67
Posts: 16
Joined: Sun Jan 19, 2014 4:38 pm

Re: Reconcilation question

Post by Blessed_miracle67 »

OOPS!! Sorry! I had a typo..$25,200, 1110 balance says $25,300 (100 diff). Yes I entered 100 during initial setup, then another 100.00 as my Oct deposit. On the trial balance it shows a beginning balance of 100 in Sept, and then my deposit in Oct. It then said that PC automatically generated 100.00. We started in Oct and I know I did not add 100 in Sept. And all of this was manually through Fund Accounting during the initial setup. Note: We are also still using 10 until 11.55 get installed on our new computer

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

Re: Reconcilation question

Post by NeilZ »

Blessed_miracle67 wrote:OOPS!! Sorry! I had a typo..$25,200, 1110 balance says $25,300 (100 diff). Yes I entered 100 during initial setup, then another 100.00 as my Oct deposit. On the trial balance it shows a beginning balance of 100 in Sept, and then my deposit in Oct. It then said that PC automatically generated 100.00. We started in Oct and I know I did not add 100 in Sept. And all of this was manually through Fund Accounting during the initial setup. Note: We are also still using 10 until 11.55 get installed on our new computer
OK ... let me go over this:

1. You are setting up Accounting in v11.55
2. You are also using the Accounting function in v10

I suspect that you're doing this because you're creating a new chart of accounts, as the one in v10 is not working? Right?

OK so then ..

1. The beginning balance entered into the v11.55 Accounting Setup Wizard was 100.00. This was the ending balance of the last bank statement for August, or was that the statement for September.
2. You did not enter any unreconciled deposits for September during setup.
3. You added a deposit in October by creating a Manual Transaction in the Funds Accounting module.

Is all that correct ? Then you could probably reverse the Powerchurch Entry. HOWEVER ...

If you added that October deposit during Setup when asked about unreconciled deposits, and then manually through Funds Accounting, I would reverse the one you entered manually as the one entered by Powerchurch covered that October deposit.
Neil Zampella

Using PC+ since 1999.

Blessed_miracle67
Posts: 16
Joined: Sun Jan 19, 2014 4:38 pm

Re: Reconcilation question

Post by Blessed_miracle67 »

We didn't start v11.55 at all yet. We were starting FA v10. This is our first time using FA V10.
We opened a new bank account on Oct 21st, and had no transactions in that month, only the 100 deposit from Oct when the account was opened. Did have to create a new chart of accounts because we started Accounting.
Beginning balance in acct setup was 100 in Oct. This was the ending balance for Oct. Did not have any unreconciled deposits
I added a deposit in Oct by creating a manual transaction in the FA module
**The transaction issued by PC says the deposit was in Sept

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

Re: Reconcilation question

Post by NeilZ »

Blessed_miracle67 wrote:We didn't start v11.55 at all yet. We were starting FA v10. This is our first time using FA V10.
We opened a new bank account on Oct 21st, and had no transactions in that month, only the 100 deposit from Oct when the account was opened. Did have to create a new chart of accounts because we started Accounting.
Beginning balance in acct setup was 100 in Oct. This was the ending balance for Oct. Did not have any unreconciled deposits
I added a deposit in Oct by creating a manual transaction in the FA module
**The transaction issued by PC says the deposit was in Sept
In that case, you should try reversing the created transaction. If PCPlus doesn't allow that, reverse the deposit that you added in October.
Neil Zampella

Using PC+ since 1999.

Blessed_miracle67
Posts: 16
Joined: Sun Jan 19, 2014 4:38 pm

Re: Reconcilation question

Post by Blessed_miracle67 »

thank you Neil. I'll try that. Hopefully it works

Post Reply