How can I go back and adjust what by accounts balance really was at the beginning of the year?

I have a  quckbooks file that was started at the beginning of last year.

I just noticed that because some deposits were not recorded, the balance that quickbooks had in my checking account at the beginning of the year was not the accurate one.

How can I go back and state that as of 1/1/12, the balance was really XXXXX.


Thanks
strugglingalongAsked:
Who is Participating?
 
JohnConnect With a Mentor Business Consultant (Owner)Commented:
Thanks for the update.

So from a controllership point of view, your bank account (in the QB ledger) is a mess.

Since I have been here before with clients, the best thing for you to is to unreconcile back to a point where the bank account was reconciled (or the difference is inconsequential). This should be before the point where deposits and payments stop being recorded.

Take the earlier of the two points and reconcile the bank account.

Now enter the deposits from undeposited funds (enter by date, not all on one date). Then enter the electronic payments by date. Use your bank statements to help you here. Make sure any bank charges and other transactions have all been entered. You may have pre-authorized deductions for example (loans and like payments).

Then go back and reconcile month by month.

This is all a necessary step and I encourage you to review this with your accountant.

... Thinkpads_User
0
 
JohnBusiness Consultant (Owner)Commented:
Sorry, you cannot do that. Bank Accounts are critical to a business, so QuickBooks locks the beginning balance in order that the Bank Reconciliation work correctly. It has been like this for years (probably as much as a decade at least).

So how to move forward? Two ways:

1. If the error is small, put in the ending bank balance from your current bank statement (say February 29) and then make journal entry into the bank account and miscellaneous expense to reconcile. Now you are good going forward. Small = $100 maximum.

2. Open the reconciliation module and unreconcile backward until you reach a reconciling point. Then re-reconcile going forward. This can be time consuming if more than one or two periods and lots of transactions in each period. It is the best way, however.

... Thinkpads_User
0
 
strugglingalongAuthor Commented:
To tell yo the truth,

It appears that midway through last year, no deposits were recorded (it is all in undeposited funds) and a all the electronic payments were not recorded.

So now the difference is QB has it in the negetives, while in reality it is in the positive, About a $40K difference
0
 
JohnBusiness Consultant (Owner)Commented:
Hi strugglingalong   - Any update?  Did you speak with your Accountant?
... Thinkpads_User
0
 
JohnBusiness Consultant (Owner)Commented:
Thank you. I was pleased to assist and good luck getting your bank reconciliation sorted out (It is really important for you).  .... Thinkpads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.