Skip to main content
A
asid
December 5, 2023
Question

GL Entries Backup and Restore

  • December 5, 2023
  • 1 reply
  • 0 views

I have QuickBooks Desktop 2016 Pro

 

I have a backup (QBB file) from September where all the entries and reports are correct However, my accountant in the following months has posted some back dated entries in months prior to September, which has resulted in incorrect balances for prior months. Along with regular business GL entries in October and November, he has posted some entries which are incorrect in these 2 months as well.

 

If I recover the September backup, all my October & November entries will be gone. Even the correct ones.

 

I want to know, how can I recover the September backup, add the correct GL entries for October & November in that backup and restore that to a live file? I know the back dated entries done prior to September, can identify them, just don't know how to correct those?

 

Is there a possibility that I go to my current live file, export the GL entries to a spreadsheet. And remove the incorrect entries done in October and November and then go restore the September backup as a new company, export the GL entries to a spreadsheet and merge the 2 spreadsheets together and import as a new company? Would this work?

1 reply

4
4Gal
December 5, 2023

Use the migration tool as a workaround and it's a one time license.

https://get.transactionpro.com/qbd

 

Use the exporter tool on the file your accountant was working on. Export all transactions for October and November to Excel

Restore your last good backup file

Use the import tool to import (and filter) Oct and Nov into your restored company file.

 

A
AileneA
December 5, 2023

Hello, asid. 

 

Thank you for reaching out to the Community. I appreciate your inquiry and would be happy to provide you with more detailed information.  

 

Regarding your question, both suggestions provided are viable options for your situation. If you export the GL entries to a spreadsheet, you can do so by accessing the General Ledger and selecting the desired date range. From there, you can export the data to a spreadsheet format of your choice. 
 

Alternatively, the 4Gal suggestion is also a great option. Using a migration tool, you can export all the transactions for October and November to Excel. This will allow you to manipulate and analyze the data as needed quickly. 
 

Lastly, restoring your backup file is always a good idea to ensure your data is accurate and up-to-date. Also, I'm adding more tips and other resources. You may visit our page on managing your business in QuickBooks: QuickBooks Desktop Self-help articles.

 

If you have any further questions or concerns, please don't hesitate to reach out. I'll be right here to keep helping. Have a great day!

    A
    asidAuthor
    December 5, 2023

    .

    Terms & ConditionsAccessibility statement