02Home & Garden · Updated
How to Back Up QuickBooks Online Data
Short answer
Export and store copies of your QuickBooks records
QuickBooks Online does not provide a simple, universal full-company restore file like desktop software. You can export reports and lists, use available data-export tools, and keep separate copies in secure storage.
Backing up QuickBooks Online means keeping usable copies of important accounting information outside your live company file. That can help with recordkeeping, reviewing past activity, or recovering information you can re-enter if something goes wrong. It is not necessarily a one-click snapshot that can restore your entire account exactly as it was.
Before starting, confirm you have permission to access and export the company’s data, and decide where the copies will be stored. QuickBooks menus and available export options can differ by subscription, permissions, and software version, so menu names may vary slightly. Check Intuit’s current instructions for your account if a described option is not visible.
What You’ll Need
- A QuickBooks Online account with access to the company file; some exports require an administrator or another authorized role.
- A computer and a current web browser. Some export and download workflows are easier to complete on a computer than on a phone.
- A secure destination for files, such as an access-controlled business drive or encrypted storage. Avoid personal or shared devices that are not approved for company records.
- A list of the records your business needs to retain, such as financial reports, customer and supplier lists, products and services, or attachments.
- Enough available storage space, plus a naming and retention approach that makes each export’s company and date clear.
Step-by-Step
- Confirm access and scope. Sign in to the correct QuickBooks Online company and verify its name before exporting. Ask the account administrator for access if needed. Decide which reports, lists, and supporting documents you need; a few spreadsheets may not preserve every detail of the original company file.
- Review current export options. Open the settings or export area available in your account and look for a company-data export or backup option. QuickBooks Online features and paths can change or vary by plan, so menus may differ slightly. Use Intuit’s official help instructions for the exact workflow shown for your account. Do not assume that a report export is a complete account backup.
- Export key financial reports. Open the Reports area and run essential reports for the period you need. Common examples include the Profit and Loss, Balance Sheet, Trial Balance, General Ledger, and cash flow reports. Set the date range and accounting method deliberately, then export or download each report in a suitable format, such as PDF for a fixed readable copy or Excel for analysis. Include the report name, company, and coverage dates in the filename.
- Export lists and transaction data. Use the available export tools for records such as customers, vendors, products and services, and chart of accounts. Where relevant, export transaction details or lists separately. Check which fields and date ranges are included: exporting a list of names is not the same as preserving invoices, payments, reconciliations, and their links to one another.
- Save attachments and supporting records. If your workflow uses receipts, bills, or other attachments, determine whether the export includes them. If it does not, download or retain those documents through the available document tools and your established records process. Keep files organized in folders by company and period, and avoid storing sensitive records in a broadly shared location.
- Verify each download. Open the files from the destination folder rather than relying on a download-complete message. Confirm they are not empty or corrupted, the company and period are correct, and the report totals look reasonable. For spreadsheets, check that columns and dates were exported as expected; for PDFs, make sure pages are readable.
- Keep copies separate and controlled. Store the export in an approved location separate from the QuickBooks sign-in, and limit access to people who need it. If business policy allows, keep another protected copy in a separate location. Do not email unprotected accounting files or leave them in a public or shared download folder.
- Repeat on a schedule and document it. Choose a cadence that fits your recordkeeping needs and repeat the same exports consistently. Record what was exported, the date, the period covered, and where it was saved. After major changes or at the end of a reporting period, verify that the latest copy is complete.
Common Mistakes
- Calling a report export a full backup. A PDF or spreadsheet preserves a view of information, not necessarily the relationships, settings, audit history, or complete transactions needed to recreate a company file.
- Exporting the wrong company or dates. A person with access to multiple companies can easily download the wrong file. Check the company name, date range, and accounting method before saving.
- Assuming attachments are included. Reports and list exports may not contain original receipts or other documents. Verify separately whether the files you rely on were included.
- Leaving files unprotected. QuickBooks exports can contain confidential financial and personal information. Use approved access controls and follow your organization’s retention and security rules.
- Never checking the files. A download can be incomplete, unreadable, or saved somewhere unexpected. Open copies and confirm them before treating the task as finished.
Tips
- Use a consistent filename, for example
CompanyName_GeneralLedger_2026-01-01_to_2026-03-31.xlsx; adapt the dates to the period actually exported. - Maintain a simple checklist of reports, lists, attachments, formats, and date ranges so recurring exports are comparable.
- Keep a read-only archive copy when practical, and retain working copies separately to reduce accidental changes.
- Ask your accountant or QuickBooks administrator which records must be retained and which export formats fit your reporting workflow. Retention requirements depend on the business and applicable rules.
- If you need true restoration, confirm the recovery process before relying on any export. Some third-party backup services may offer additional features, but review their security, scope, and ability to restore data before using one.
Troubleshooting
- The export option is missing: Check your user role and subscription, then ask the company administrator. The feature may not be available in every account or may have moved; consult Intuit’s help guidance for the current menu.
- A file will not download: Check the browser’s download permissions, available storage, and blocked pop-ups. Try a supported, updated browser or another approved computer, then repeat the export.
- The file is blank or incomplete: Recheck filters, date ranges, and report settings, then export again. For large datasets, split the period into smaller ranges if the available tool supports it.
- Numbers do not match: Confirm the company, reporting period, accounting method, and any filters. Compare the result with the corresponding report inside QuickBooks before assuming the export is wrong.
- You need to restore data: Do not assume that opening an exported spreadsheet will restore the company. Contact the QuickBooks administrator or Intuit support to learn what recovery options apply, and use a backup service only according to its documented restore procedure.
Frequently Asked Questions
Does QuickBooks Online automatically back up my data?
Intuit operates the online service and has its own systems for protecting service data, but that is not the same as giving you a personal, downloadable full-company backup or a guaranteed self-service restore. Keep exports of records you need to retain.
Can I download my entire QuickBooks Online company?
Available export tools can provide substantial company information, but they may not capture every setting, attachment, relationship, or historical detail in a form that recreates the file. Check the specific export’s scope before relying on it as a complete backup.
Which reports should I save?
Common choices include the Profit and Loss, Balance Sheet, Trial Balance, General Ledger, and cash flow reports. The right set depends on your reporting and recordkeeping needs, so confirm it with the person responsible for the books.
Can I use Excel files to restore transactions?
An exported spreadsheet is useful for viewing and analyzing information, but it generally does not restore the original QuickBooks transaction structure by itself. Use an import or restore workflow only when it is supported and appropriate, and verify the results carefully.
How often should I export data?
There is no single schedule for every business. Choose a repeatable cadence based on how often records change, your organization’s retention process, and advice from your accountant or administrator.
Are third-party backup apps necessary?
They are optional and may offer broader or automated coverage than manual exports, depending on the product. Review what data they capture, how they protect it, and how restoration works before granting access.
Related
- How to Care for a Hyacinth Indoors and Outdoors
- How to Read a Fan Curve: CFM, Static Pressure, and RPM
- How to Cook Nathan’s Hot Dogs: 4 Easy Methods
Further reading: Intuit QuickBooks Help. Details can change, so check the official page for anything that matters to you. Spotted a mistake? Tell us. How we write an answer.