How to Prepare a Quickbooks Online File for Advanced Restore


Before Rewind can restore a Quickbooks Online file (QBO), it must be properly prepared. Closed period books need to be opened before the file can be rolled back to the restoration date. This process includes un-automating bank feed rules and unmatched transactions.

Rewind cannot update or delete items that are matched from the bank feed. Rewind also cannot restore a file that is closed. However, opening closed period books and unmatching transactions is a straightforward process.

In this guide, learn how to:

  • Open closed period books for file restoration.
  • Un-automate bank feed rules and unmatch transactions.

Running Reports and Closing the Books

First, run through the reports that you need, and then you will have an open and closed period. It only makes sense that you cannot roll back a file to a point in time if the books are closed until today.

If you do not have a bookmark for “closing the books”, click the gear icon, go into “Accounts and Settings”, go to “Advance”, and now you can make a bookmark to save some time. In “Advance”, make sure that “close the books” is off, and save that.

Run the reports to the point in time that you are rolling back to. Be sure to run the reports for today and download the account list. If you are heavy with products and services, run a products and services report. Know what the report looked like at the point of time to today if you are rolling back a file.

You cannot get back a file that you have restored to a specific date because the data is gone. Make sure that you run a report or download some information on whatever product you believe will be the most problematic.

Un-automating Banking Rules

Next, go into “Banking” and then go into “Rules”. Due to the API of Quickbooks, you cannot restore a file that has matched transactions in it. Make sure that you unmatch those transactions and that they are excluded and then deleted. You need to go into “Rules” because you may have some automated rules.

If you have an automated rule, you need to unautomated it because you have told Quickbooks to add that transaction into the books. It automatically shows up in the “Reconciliation.” However, if you delete transactions first and you have not un-automated a rule, the transactions will pop back into the “Bank Feed.” If you are having problems with the bank feed and you have duplicated transactions, make sure you un-automate transactions in that case as well.

Unmatching Transactions

Now go into “Banking.” You can always delete transactions or unmatch transactions in the register or one-by-one. You can also do them in the reconciliation screen. There are multiple ways to find out what the match transactions are. One-by-one is a giant time waster, however.

For a quicker process, go into “Review Transactions” and pick the date range. Make sure you have it set to “all rules” because you want to delete all the transactions. Use the keyboard shortcut “m” to move back through the months. Apply the date range.

If you have a lot of transactions, use some cautions and do it month by month until the point in time that you need to unmatch the transactions. Work backwards from today until the date you are rolling back to. Click them all and click the “undo” button. This will pull all the transactions out of the “Reconciliation” screen and puts them into the “For Review” screen.

If you have transactions in the reconciliation screen that are mismatched and you do not want to delete them, use this process as well. Now all the transactions are unmatched. Input the previous date range on the “For Review” screen, and from there you can exclude or delete the transactions.

Now that you have pulled the transactions out of the reconciliation, they are no longer matched transactions. You are ready to go on your advanced restore.

This article originally appeared by our friends at Rewind.

Leave a Reply

Your email address will not be published. Required fields are marked *

From One-Time Buy to Brand Loyalist: 5 Ways to Build Lasting Customer Relationships

From One-Time Buy to Brand Loyalist: 5 Ways to Build Lasting Customer Relationships

How to keep your influencers motivated while growing your affiliate program

How to keep your influencers motivated while growing your affiliate program


Steve has entrepreneurship in his DNA. Starting in the early 2000s, Steve achieved eBay Power Seller status which propelled him to become a founding partner of, a contact lens and eyewear retailer. Four years later through a successful exit from that startup, he embarked on his next journey into digital strategy for direct-to-consumer brands.

Currently, Steve is a Senior Merchant Success Manager at Shopify, where he helps brands to identify, navigate and accelerate growth online and in-store.

To maintain his competitive edge, Steve also hosts the top-rated twice-weekly podcast eCommerce Fastlane. He interviews Shopify Partners and subject matter experts who share the latest marketing strategy, tactics, platforms, and must-have apps, that assist Shopify-powered brands to improve efficiencies, profitably grow revenue and to build lifetime customer loyalty.

You May Also Like
payday loans loans for bad credit
where can i buy clomid buy clomid