?
Solved

Quickbooks Bank Reconciliation

Posted on 2007-03-27
7
Medium Priority
?
4,774 Views
Last Modified: 2011-09-20
In Quickbooks, the bank reconciliation opening balance no longer agrees with the balance of the same account in Quickbooks. I am not saying it does not match the bank statement, but that one place in Quickbooks (the check register) does not match another (the reconcilation function.)

How can I get the reconcilaition function back in sync? It is way off.
0
Comment
Question by:jasimon9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 2

Expert Comment

by:acctech1
ID: 18812072
The balance will change in QuickBooks if any additional transactions are entered subsequent to the bank rec being done.
0
 
LVL 1

Expert Comment

by:md501
ID: 18851851
acctech1 is correct.  You may have changed or added a transaction that was dated before the ending date of the previous rec.  If you have audit trail turned on, you can run the audit trail report to see what has been changed after the rec.
0
 

Author Comment

by:jasimon9
ID: 18851964
Actually, that is the case, in that certain tranasctions were deleted and replaced. Yes, it would have been better to not do that, but rather the make adjusting entries.

The real question is not "why?" but as stated "How can I get the reconcilaition function back in sync?"
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 2

Expert Comment

by:acctech1
ID: 18852438
If a cleared transaction was removed and/or replaced you will have to re-clear the new transactions entered.

Go to the Rec screen enter the correct beginning balance as the ending balance. Enter the statement date as the same as the last rec.(If the QuickBooks says 2/28/07 as the last rec date. Enter that as the date again.) Now "clear" the transactions you have entered in place of the ones you deleted. In theory these should all add up to the same amounts (Old transaction $ = New transaction $) Your "difference" should be 0 and you will be able to reconcile. The balance you put as the ending will become the beginning and you should be good to go.
0
 
LVL 1

Expert Comment

by:md501
ID: 18853500
If you deleted or changed transactions you will probably have to enter a j/e (dated in the month they were changed) with the difference of the balances.  Then later (in the next month) create an adjusting j/e to clear it out.  

0
 

Author Comment

by:jasimon9
ID: 18853569
All accounts are already correct. The only issue is that the "make deposits" function has lots of stuff in it.

Please note: I say again -- all GL accounts have the correct balances, including Undeposited Funds.

The procedure I am contemplating seems like it will do the following:

1. Get rid of the non-existent deposits by depositing into the new dummy account, thus making a large debit in the dummy account.
3. put a larege credit offset into undeposited funds.
4. The final manual AJE will clear the dummy account against undeposited funds, putting them both back to zero.
0
 
LVL 1

Accepted Solution

by:
md501 earned 2000 total points
ID: 18853615
Yes, that is correct.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month14 days, 1 hour left to enroll

800 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