Solved

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

Posted on 2012-03-22
5
327 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:strugglingalong
  • 4
5 Comments
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
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
 

Author Comment

by:strugglingalong
Comment Utility
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
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
Comment Utility
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
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
Hi strugglingalong   - Any update?  Did you speak with your Accountant?
... Thinkpads_User
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now