← All Guides

This guide is for the person who got handed a flash drive.

You're the newly-elected treasurer of a small association, and the previous treasurer dropped off a hard drive labeled "QuickBooks Desktop 2018 files." You're the executor of an estate, and the deceased's bookkeeper retired five years ago. You're a new bookkeeper inheriting a long-time client whose records you've never seen. You're a family member trying to figure out a parent's small business after a hospitalization. You're a business buyer who closed on an acquisition and now owns six years of accounting files in a format you can't open.

Whatever the path that brought you here, the situation is similar: real data, real records, no easy way to read them, and someone telling you it's complicated. Often someone telling you it's impossible.

It's not impossible. In most cases it's not even that hard. This guide walks through what you actually have, the three gates that stand between you and the data, what to do at each one, and what to do with the data once you can see it. It's organized so you can stop reading at the point where your particular situation is solved.

First, Figure Out What You Actually Have

Before you try to open anything, take ten minutes to look at what's on the drive. Plug it in. Open the file browser. Don't double-click anything yet — just look.

File extensions

QuickBooks Desktop creates several different file types, and knowing which one you have changes what you do next:

ExtensionWhat it isWhat to do
.QBW The working company file — the live database QuickBooks reads and writes when the program is open. This is the main file. Copy it to your hard drive and work from the copy.
.QBB A backup file — a compressed export of a QBW at a point in time. Equally usable. You'll restore it back into a working QBW when you open it.
.QBM A portable company file — a smaller version intended for emailing. Restores like a QBB. Slightly older format; less common.
.QBA An accountant's copy — used to send books to a CPA so they can make adjustments without freezing the client's live file. More limited. Can be opened but has restrictions on what can be changed. Fine for read-only data extraction.
.QBX An accountant's transfer file — the format an accountant's copy is delivered in. Has to be converted to QBA before opening. Most modern QuickBooks versions do this automatically.
.ND / .TLG Network data and transaction log files. Created automatically alongside a QBW. You don't open these. Leave them alongside the QBW; they sometimes need to exist next to it.
.IIF An Intuit Interchange Format file — a plain-text export of selected data. Already a text file. Open it in Excel or a text editor. No QuickBooks needed.

Version year

The file name or folder label often hints at the version year (e.g., "QuickBooks Desktop 2018"). If not, the file itself encodes the version it was last saved with. You don't need to know it exactly to proceed, but it helps to know roughly — a 2018 file behaves differently from a 2003 file. Anything from 2017 forward generally opens cleanly in current QuickBooks versions. Anything older may require an intermediate version to migrate it forward.

How big is the file?

QBW file sizes range from a few megabytes for tiny businesses to several gigabytes for long-running ones with lots of transactions. The size doesn't change what you do — but a 4 GB file is a hint that you're looking at substantial history, which is worth knowing before you start running reports.

Password protection — the silent gatekeeper

You can't tell from the outside whether the file is password-protected. You'll find out when you try to open it. But you can prepare: before you install any software, find out what you know about the original setup. Was there a bookkeeper? An IT person? A treasurer before the previous treasurer? Anyone who might know an admin password? More on this below; for now, just start asking.

The Three Gates Between You and the Data

Between an inherited QuickBooks file and the data inside it, there are three gates. You may have to clear all three; you may already have one or two cleared without knowing it. They are, in order:

  1. Software that can open the file. The file is in a proprietary format. You need either QuickBooks or a third-party tool that can read it.
  2. The admin password (if there is one). QuickBooks won't open a password-protected file without the admin credentials.
  3. License activation. If you're using QuickBooks itself, the software has to be activated. For old files and old licenses, this is sometimes the hardest gate.

The rest of the guide is the manual for each gate. If you're past one, skip to the next.

Gate 1 — Getting Software That Can Open It

You have three real options, in rough order of usefulness for most inheritance situations:

Option A: The free 30-day QuickBooks Desktop trial

Intuit still offers a free 30-day trial of QuickBooks Desktop. It's a full-featured copy of the software, and it'll open your inherited file the same way the original install did. Download it from Intuit's site (search "QuickBooks Desktop trial" — the URL changes from year to year).

What to expect: Download is large (1–2 GB). Install takes 15–30 minutes. When you open the file the first time, you'll get a one-way upgrade prompt — the file format will be updated to the trial version, and the upgraded file won't open in the original year anymore. For data extraction this doesn't matter; you're not putting it back. But this is why we said earlier: copy the file to your hard drive and work from the copy. Leave the flash drive untouched.

The 30 days is plenty. You don't need a month. You can usually pull every report you need in an afternoon. The time pressure isn't real unless you're working through something complicated.

Option B: A free third-party viewer

There are read-only tools that open QuickBooks files without installing QuickBooks itself. The best-known is 4n6 QuickBooks File Viewer (also called QuickBooks Data Viewer). The free version lets you browse the chart of accounts, view transactions, and inspect the data. The paid version adds Excel/CSV export.

What it's good for: Quick inspection. Checking what's in the file before you commit to installing QuickBooks. Cases where Excel export isn't needed (rare).

What it's not good for: Producing the reports you actually need (Balance Sheet, P&L, General Ledger). For that, the trial route is generally better.

Option C: The old PC the file came from

Surprisingly common: somewhere there's an old laptop or desktop that still has QuickBooks installed on it from when the file was originally maintained. If you can locate it, you may not need anything else.

Ask: did the previous treasurer / bookkeeper / business owner have a dedicated computer they used for QuickBooks? Is it still around? Even if it boots slowly, even if it's not connected to anything, if QuickBooks is on it and the file opens — you're in. The license is already activated. The software is already installed. The only gate left is the password.

Which to pick

For most inheritance situations: start with Option A (the trial). It's free, it produces the full range of reports, and 30 days is more than enough. Fall back to Option B if you want to look first without installing anything. Option C is the lottery ticket — if you have access to the original computer, it can save you everything else.

Gate 2 — The Admin Password

This is the gate that catches most people off guard. The file looks fine, you install QuickBooks, you open it — and you're staring at a password prompt.

QuickBooks Desktop has supported file-level password protection for years, and many bookkeepers set one as a matter of course. The problem is that the institutional knowledge of what the password is rarely transfers with the file.

Step 1: The people-and-paper route

Before paying for anything, ask. The password almost always exists somewhere; the question is whether it's recoverable from the human chain.

  • The previous holder. The most recent person who had the file. They may have set it; they may have inherited it from someone else who set it. Either way, they're the closest link.
  • The original bookkeeper. If a bookkeeper set up the file in the first place, they're likely the one who set the password. Their firm may still have credentials on file even if the original bookkeeper retired or moved on.
  • The flash drive itself. Look for a README.txt, a password.txt, or any text file labeled with anything credential-shaped. People often write the password down next to the file.
  • Transition documents. Board minutes, treasurer handoff notes, estate-planning binders, sale closing documents. Credentials sometimes get listed in these.
  • The original computer. If you have access to it (see Option C in Gate 1), the password may be stored in a browser's saved logins or written on a sticky note attached to the monitor.

This route resolves the majority of cases. Don't skip it just because it feels low-tech.

Step 2: Intuit's Automated Password Reset Tool

Intuit offers a free password reset tool for QuickBooks Desktop. It works only if you can answer security questions about the file that match what was recorded when the file was registered — typically the original purchaser's contact info, license number, and similar.

When this works: If you're the original purchaser, or you have the original registration documents. Long shot on inherited files; worth trying anyway because it's free and takes ten minutes.

When this doesn't work: The original purchaser is unreachable, the registration info doesn't match, or the file was registered under a defunct entity (a dissolved business, a deceased person). Most inheritance situations fall here.

Step 3: Third-party password recovery tools

Several commercial vendors sell tools that remove or recover QuickBooks Desktop passwords. They typically cost $50–$200, work on most QBD versions through 2020-ish, and have varying success rates on newer files. Search "QuickBooks Desktop password recovery" and read recent reviews before buying. Some specific tools to look up: Thegrideon QuickBooks Password, Passware Kit. Reputable vendors offer trial-and-confirm-before-pay options — use those.

What these tools do: Either brute-force the password (try every combination until something works) or exploit known weaknesses in how older QBD versions stored the credential hash. Both approaches are legal when applied to files you own or have legitimate access to as a fiduciary.

One thing to know: these tools generally need the admin user's password specifically. If the file has multiple users, recovering one user's password is not the same as recovering admin. You need admin.

Step 4: Forensic data-recovery services

When the cheaper paths don't pan out — usually because the file is old, badly damaged, or the password recovery tools fail on it — there are specialized services that extract data from inaccessible accounting files for legal and audit purposes. They cost more (four-figure starting points are realistic) but they often succeed where consumer tools don't.

This is the path for situations where the data has high enough value to justify the cost: contested estates, business sale due diligence, audit defense, dispute discovery. For an HOA with a few years of routine bookkeeping, this is overkill — better to give up on the file and reconstruct from bank statements.

Honest expectation-setting: Most inheritance situations resolve at Step 1 or Step 3. The people-and-paper route works more often than people expect. Third-party tools work on most older files. The "forensic services" option exists but rarely gets used.

Gate 3 — License Activation

This is the gate that gets the least attention and surprises the most people.

QuickBooks Desktop in recent years has been subscription-based — you pay annually, and the software phones home to verify your license. If the subscription lapses, the software reverts to a one-year read-only mode, then refuses to open the file at all without a renewal. Older single-user licenses (Pro 2018, Premier 2018, etc.) were one-time purchases, but those installations sometimes fail to activate on new machines because the activation servers no longer recognize the license, or because the machine signature has changed.

The trial route (Option A in Gate 1) sidesteps this entirely — a fresh trial install has its own activation, separate from whatever license was originally on the file. This is the main reason the trial is the recommended starting point.

If you have an old install and it's refusing to activate, your options are:

  • Call Intuit support. They can sometimes reactivate older licenses, especially if you have the original purchase records. Patience required.
  • Skip the old install, use a trial. Often faster.
  • If you found the original computer with QuickBooks already activated on it, don't touch its activation status. The old activation may still be working precisely because nothing has changed. Don't reinstall, don't update, don't move the install. Just open the file and run the reports.

Once You're In: What to Export

You opened the file. You can see transactions. Now the question becomes: what do you actually need?

The answer depends on why you needed the data in the first place. A two-question framework:

  1. Why do I need access to this data? Audit defense, IRS retention, due diligence for a sale, continuity of operations, settling an estate, ongoing recordkeeping?
  2. Given that reason, what should I have in hand?

Concrete recipes for the most common situations:

If you're an HOA, condo, or small-association treasurer

  • Year-end Balance Sheet for each year (assets, reserves, accounts payable, member equity)
  • Annual Profit & Loss for each year (assessments, dues, expenses by category)
  • General Ledger detail for any account that ever came up in a board discussion or dispute
  • Vendor list with year-over-year payment totals
  • Reserve fund detail (separately tracked, often critical for HOA reserve studies)
  • Audit trail report, if it's enabled — this shows what was edited and when, your defense if anyone questions the records' integrity

If you're an executor settling an estate that included a business

  • Balance Sheet as of the date of death and as of the most recent file activity
  • P&L for the three years prior to death (estate tax purposes; the IRS may ask)
  • General Ledger for the most recent two years
  • Asset detail — fixed assets, depreciation schedules, intangibles
  • A list of open AR (money owed to the business) and AP (money the business owed)
  • Payroll summaries for the past four years (employment tax retention)

If you're a new bookkeeper taking over a long-time client

  • Current Trial Balance — your starting point
  • Last three years of monthly P&L (look for patterns and anomalies)
  • Bank reconciliation reports for the last twelve months (verify what's been reconciled vs not)
  • A&P Aging and A&R Aging as of today
  • Chart of accounts (you'll likely want to clean this up over time)
  • Any custom reports the previous bookkeeper had saved — these show what the client has historically cared about

If you're a business buyer who just inherited the seller's books

  • Audited or reviewed financials for the past three years if available
  • The complete General Ledger for the past three years
  • Payroll detail for the past four years (W-2s, 941s, employment tax records)
  • Sales tax filings and supporting reports
  • Customer and vendor master lists with transaction history
  • Any reports the seller produced during due diligence — pull the originals from the file rather than relying on what they sent you

For each report: File → Export → Send Report to Excel (or the equivalent in your version). Save with a clear filename including the date range. Don't trust QuickBooks' default filenames — they're usually unhelpful.

Where to Store What You Exported

The single most common failure mode after a successful inheritance extraction is this: the new treasurer pulls all the reports, saves them to their personal laptop, and then a year later the laptop dies. Or the treasurer moves on. Or the documents get filed in someone's Documents folder and forgotten.

Don't be that. Spend the extra ten minutes now to put the exports somewhere durable:

  • For an HOA or association: A board-owned Google Drive or Microsoft 365 folder, accessible to the current and future board. Not your personal account.
  • For a business: The company's existing document management system, with a clear "Historical Accounting Records" folder. Backed up.
  • For an estate: The attorney handling the estate, who is required to maintain records anyway, plus a copy for the executor's own files.
  • For a new bookkeeper: Wherever your firm keeps client documentation, with a note in the client file that these are pre-existing historical exports, not work product.

The question to ask yourself: if I disappeared tomorrow, would the next person know where these are and be able to access them? If no, fix that before you celebrate being done.

The Limits of Excel Exports

For most inheritance situations, a folder full of Excel exports is exactly enough. The data is human-readable, durable, and openable by anyone with a spreadsheet program.

That said, Excel exports have real limits, and it's worth being honest about them:

  • They're flat. You've taken a relational database and turned it into a stack of disconnected spreadsheets. Linking a transaction back to its customer, then to the customer's full history, then to a specific invoice line item — all of that has to be reconstructed manually if you ever need it.
  • They're not verifiable. A Balance Sheet exported to Excel is just a Word document's cousin — anyone with Excel can edit it. There's no way for a future reviewer to prove the numbers are what was actually in QuickBooks on the day you exported them.
  • They're partial. Every export captures a specific view (this report, this date range, this filter). The full dataset — everything QuickBooks had — usually requires running dozens of reports, and even then there are corners that don't surface in standard reports.
  • They depend on whoever ran them. If the person doing the export misunderstood a setting (cash vs accrual, fiscal year alignment, filter inclusion), the export is silently wrong. There's no audit trail that surfaces the choice.

For an HOA wanting to verify last year's reserve balance, none of this matters. For a business preparing to sell, all of it does.

When This Becomes a Sealed-Archive Problem

The Excel-and-shared-drive approach is the right answer for most inheritance situations. It's worth saying explicitly: most readers of this guide should stop at the previous section. Pull the reports, save them somewhere durable, document where, move on.

But there are situations where Excel exports aren't enough, and where a cryptographically sealed copy of the full dataset is closer to what's needed. Specifically:

  • You're inheriting a file because you bought the business. The historical records are part of what you paid for, and you may need to defend their integrity in a future audit, dispute, or resale.
  • You're an executor for a business with open tax exposure — pending audit, unresolved IRS questions, recent partnership changes. The records need to survive in a form that's defensible if the IRS comes back later.
  • The business or association is at the center of a dispute — a lawsuit, a contested fee, a partnership disagreement. Excel exports won't satisfy opposing counsel's authenticity challenges; cryptographic seals can.
  • The data is the only copy of records that legally need to be retained for a long time — payroll detail (4-year minimum), employment tax records (4-year minimum), records relevant to ongoing claims of loss or worthless securities (7 years), records for transactions you may need to substantiate decades later (real estate basis, depreciation chains, capital improvements).
  • You're handing this to a successor and want it to actually survive the handoff this time. Excel exports rot. Sealed archives don't.

A sealed accounting archive takes the complete database — every transaction, every account, every linkage — and packages it in a portable, queryable format that doesn't depend on QuickBooks (or any vendor) to read. The archive is sealed with a SHA-256 cryptographic hash and time-stamped by an independent authority under RFC 3161, so anyone can verify decades later that nothing has been altered since capture. The archive is delivered to you and only you — no vendor retention, no subpoena exposure, no subscription needed to keep it accessible.

For the situations listed above, that's the difference between "we have copies of the reports" and "we have the records, demonstrably unchanged, queryable on demand."

A Note for Future Trustees

If you've worked through this guide and gotten the data out of an inherited QuickBooks file, congratulations — and one closing thought.

Whoever comes after you will probably end up in your shoes. The treasurer after you. The next executor in line. The bookkeeper who takes over from you in five or ten years. The pattern is structural: software ages out, institutional knowledge walks out the door, and the data sits trapped behind whatever access controls happened to be in place the day the prior holder stopped touching it.

The fix is structural too. Whatever path you chose — Excel exports on a shared drive, a sealed archive, an ongoing QuickBooks subscription you keep alive for read access — make a deliberate decision about what survives the next handoff, and tell the next person where it is.

The records belong to the organization, the estate, the family, the business. Not to whoever is currently holding them.

See also: What Happens to Your Accounting Records When QuickBooks Desktop Sunsets — the broader context for why inherited QBD files are getting harder to open, and what the May 31, 2026 and 2027 deadlines mean for anyone holding one.

Sources

QuickBooks Desktop trial and licensing

Password recovery

Third-party file viewers

IRS recordkeeping requirements

RFC 3161 trusted timestamping