Reconciling Investment account

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
ASmith11
Posts: 25
Joined: Sat Jun 13, 2009 5:25 pm

Reconciling Investment account

Post by ASmith11 »

We have one investment account (#1450) spread out over 14 funds. Our core/cash investment account (#1150) is reconciled separately. The checking/operating account is completely separate (#1110) and doesn't factor into this equation.

My core account balances perfectly.

my investment account, however, does not. It balanced perfectly as of 12/31/09, but something happened during January and I am now $7316.41 off- overstated in PC+. I have accounted for the dividend income and the overall loss, but how could it have gotten so far off in one month? I feel like this should be obvious, but there's nothing on the statement to this effect.

I entered the dividends and the total loss via journal entry, the same way I always do it. I'm really confused. Any thoughts? Should I just do another journal entry as a general "loss" across the funds so I can get it to balance with the statement? Could this be due to incomplete cost basis?

Thanks in advance for any ideas.
Angie

wms7328
Posts: 246
Joined: Tue Apr 26, 2005 8:45 am
Location: Unity Presbyterian Church
Contact:

Re: Reconciling Investment account

Post by wms7328 »

Double check your transactions. It may be that you entered one incorrectly and it added to your asset account rather than subtracting. You may have just gotten the debits and credits reversed.

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

Re: Reconciling Investment account

Post by JohnDMeyers »

Also, in your reconciliation window, check your deposits reconciled against the bank statement and then the checks reconciled.

Hopefully, one or the other will be accurate and you will know if you are off in the deposits or in the checks.
You can watch my PowerChurch tutorials now on YouTube!

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

Post Reply