Restore Quickbooks file

QB files - CurrentQB files from BackupHi,
 I have a situation where a Quickbooks  user downloaded transactions from the bank website and it altered multiple accounts this afternoon.
 Fortunately I perform file backup during night and also mid-day. So I see QB files as of this morning.
 How do I go about using QB files as of this morning?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
If you have the backup from the beginning of the day in question, copy it to a local QuickBooks machine, open QuickBooks and immediately CLOSE any open databases.  

Now, File, Restore Previous Local Back, browse for the file above, and open it.

Now determine what work you have to do to get current. About a day's work based on the above post by you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
Also if you backup by closing QuickBooks and backing up the QBW file, copy it to a local machine and as per above, close any open databases and open the file locally.

Either by Restoring the QBB file or opening the QBW file, you can determine the state of work required.
sgleeAuthor Commented:
I spoke to QB Tech support and they said that I could simply replace old/screwed up Checking.QBW file with older Checking.QBW file from the backup.
Then all I needed to do is to open Checking.QBW file. all other files .DSN, .ND, and .TL files were adjusted automatically.
All is good now.
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

JohnBusiness Consultant (Owner)Commented:
Yes that is what I suggested earlier about restoring your file
sgleeAuthor Commented:
For some reason, I did not understand what you tried to explain. It was confusing.
If what you were trying to say was to copy Checking.QBW file from the backup folder and replace current screwed-up  Checking.QBW file, it did not come across that way to me.
JohnBusiness Consultant (Owner)Commented:
That is certainly what I was trying to say as that is a normal backup restore process

I hope that clarifies for you
sgleeAuthor Commented:
I clearly misunderstood. Can you copy your sentence that is related to "copying checking.qbw file from the backup and replace current checking.qbw file and open that file"?
JohnBusiness Consultant (Owner)Commented:
From above:

if you <<regularly>> backup by closing QuickBooks and backing up the QBW file  (so that is one way to back up and I was making an assumption about this)

copy it <<the backup file>> to a local machine and as per above, close any open databases and open the file locally.

If I confused you and you wish to accept your own comment, that is fine with me.
sgleeAuthor Commented:
Thanks for your help.
JohnBusiness Consultant (Owner)Commented:
Thank you so much. I could have been a bit clearer here and I will keep this in mind and be clearer in my posts in future
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.