Established MMXXIVAtlanta, GA · Serving All USIntuit ProAdvisor Gold
(877) 290-4522 · [email protected]
(877) 290-4522Begin an Enquiry
Bookkeeping Recovery

Our Accounting Software Company Shut Down: How to Rebuild Three Years of Books in QuickBooks Online From Bank Statements, IRS Transcripts and What Is Left

Need this handled instead of explained? Talk to a US-based, Intuit ProAdvisor Gold team — (877) 290-4522 or [email protected]. Books a mess? Start with the free QuickBooks File Analyzer — 60 seconds, no signup.

The short answer: you can rebuild a multi-year gap from four sources that do not disappear when a software vendor does: bank and card statements, the returns you filed and the IRS transcripts behind them, your payroll provider’s registers, and the invoices and bills sitting in email. Rebuild from the last filed return forward, one year at a time, and tie each year to its return before starting the next. What you will not get back is line-level detail nobody kept: item-by-item sales, job costing, and who paid which invoice when. This page sets out what survives, the order to work in, what to write off as lost, and how to make sure the new file cannot be taken away again.

Ram Singh · Published September 22, 2026
This is the recovery page. Catch-up bookkeeping is the service that does the rebuild, QuickBooks cleanup is for a file that exists but is wrong, and what a year of catch-up costs against waiting covers the penalty side.

What survives when the vendor does not

Start with an inventory, because the rebuild is only as good as its sources. Sort what you have into the four groups below and note the earliest date each one reaches.

SourceWhat it gives youWhere to get it
Bank and credit-card statementsEvery dollar in and out, dated, with a counterparty. The spine of the rebuild.Online banking downloads (PDF and CSV); older years by request from the bank, sometimes for a fee. Ask for CSV where offered.
Filed tax returnsYear-end revenue, expenses by category, and on 1120, 1120-S and 1065 returns a balance sheet (Schedule L) to open from.Your CPA’s copy first. If none, IRS transcripts (below) or Form 4506 for a copy of the return itself.
IRS transcriptsReturn transcript: most line items as filed. Account transcript: payments, penalties, filing dates. Employment tax transcript (2023 and later): 940/941/943/944/945 as filed.Business tax account online, Form 4506-T by mail, or the business tax line. Transcripts are free; allow 2–3 weeks after e-filing.
Payroll registers and filingsGross wages, withholding, employer taxes and net pay by pay date, plus the 941s and W-2s.Your payroll provider’s reports, if payroll was outside the dead software. If it was inside, the employment tax transcripts give the quarterly totals.
Invoices, bills, receiptsAccounts receivable and payable, customer and vendor lists, and the sales-by-customer detail that statements cannot show.Sent-mail folders, customer portals, vendor account pages, the merchant processor’s dashboard.
Sales tax filingsTaxable sales by period, which cross-checks revenue.The state portal keeps filed returns.
Loan, lease and merchant statementsBalances and interest for the balance sheet; processor fees and deposits for revenue.Lender portals; processor dashboards (Stripe, Square, PayPal) keep exportable history.

Transcript types and channels from IRS.gov, “Get a business tax transcript,” page reviewed 27 July 2026. A transcript is not a photocopy of the return; Form 4506 requests the copy, with the fee and processing time listed on the form.

The IRS already has a copy of the summary

This is the part most people searching for a rebuild do not know. For every year you filed, the IRS holds a return transcript with most line items as filed, an account transcript with every payment and penalty, and, for 2023 and later, an employment tax return transcript with the original 941 and 940 figures. All three are free and available online through a business tax account, by mail on Form 4506-T, or through the business and specialty tax line. If your CPA has moved on and the software is gone, the transcript is the fixed point the rebuild ties to: revenue, total deductions and net income for each year you filed, straight from the record the IRS will compare against.

What the transcript does not give you is the balance sheet detail on a Schedule C return, or any line detail behind the totals. That is why the order below starts from the return and fills in from the bank.

The rebuild order

1. Pick the opening date. The cleanest opening is the day after the last year you have a filed return and a balance sheet for. For an S corporation or partnership that filed Schedule L, the year-end balance sheet becomes the opening balances in QuickBooks Online: cash, receivables, fixed assets, loans, equity. For a Schedule C filer with no balance sheet, open with the bank and loan balances from the statements on that date and let equity absorb the difference; a CPA can true it up later.

2. Load one year of bank and card activity. Import each account’s statements for the year, by CSV upload where the bank offers it, then reconcile month by month to the statement ending balances before categorising anything. A year that does not reconcile to the penny at every month-end is not a year, it is a draft.

3. Categorise from the counterparties, then from the paper. Rules do most of the vendor side. Customer deposits are where statements fall short: a deposit is a number, not a customer. Use the merchant processor’s payout report and the sent invoices to split deposits by customer where it matters (job costing, 1099 reporting, sales tax), and post the rest as sales by month.

4. Rebuild payroll from the registers. Enter payroll by pay date from the provider’s register, or by quarter from the 941 if the register is gone: gross wages, withholding and employer taxes as liabilities, net pay to match the bank. The quarterly totals must equal the 941s on the employment tax transcript.

5. Tie the year to the return. Run the profit and loss and compare revenue, total expenses and net income to the return transcript. Differences are expected: depreciation, home-office or vehicle adjustments, and timing on receivables. List each difference with a reason. If a difference has no reason, the year is not finished. Then close the year and lock it.

6. Repeat for the next year. Opening balances roll forward automatically. Three years is three passes, not one long one; mixing years is how rebuilds fail.

7. Hand the tie-out to the CPA. Whether an amended return is warranted when the rebuilt year differs from the filed one is a tax decision, not a bookkeeping one. Give the CPA the year-by-year difference list and let them make it.

What to accept as lost

Be explicit about this early, because chasing it wastes the most time. Item-level sales history, unless the merchant processor or an e-commerce platform kept it. Job and project costing older than the invoices you can find. The exact application of customer payments to invoices, which matters only if a customer disputes a balance; for those customers, rebuild from statements you sent them. Inventory quantities at past year-ends, which are reconstructed from purchases and sales at the year-end count if one was taken and otherwise estimated. Fixed-asset detail older than the depreciation schedule on the return; the schedule itself survives on the return.

None of these change the tax position for a closed year. They change what the new file can report about the past, and the honest position is a note in the file: “Detail before [date] rebuilt from bank statements; customer and item detail not available.”

Making the new file vendor-proof

The lesson of a vendor shutdown is that a subscription is access, not ownership. Three habits fix that. Quarterly, export the general ledger, trial balance, customer and vendor lists and the aged receivables and payables to a folder you control; Intuit’s help article on cancellation, updated 5 August 2026, gives read-only access and export to Excel for one year after a paid QuickBooks Online subscription ends, which is generous, but a folder on your own drive does not depend on it. Keep PDFs of every filed return and every bank statement outside the accounting system. And keep records for the period the IRS can ask about them: generally three years from the filing date for income tax, and four years for employment tax records, longer where a return understated income or claimed a loss.

How long a three-year rebuild takes

It scales with transaction count, not years. A service business with two bank accounts and 150 transactions a month is roughly 5,500 transactions over three years; with clean statements and a reconcile-first approach, that is weeks, not months. A retailer with three card processors, inventory and payroll is a different job, and the payroll and sales-tax tie-outs are where the time goes. The one thing that shortens every rebuild is getting the transcripts and statements in hand before anyone starts categorising; the one thing that lengthens every rebuild is starting from the middle year.

Frequently asked questions

Can I get my old tax returns from the IRS if my accounting software is gone?

Yes. A return transcript shows most line items as filed, an account transcript shows payments and penalties, and for 2023 and later an employment tax return transcript shows the 941 and 940 figures. All are free through a business tax account online, by mail on Form 4506-T, or by phone. For a copy of the actual return, file Form 4506; the fee and processing time are listed on the form.

Can I rebuild books from bank statements alone?

Mostly. Statements give every cash transaction, dated and with a counterparty, which is enough for a cash-basis profit and loss and a reconciled balance sheet. What they cannot give is customer-level sales detail, invoice-to-payment matching, and non-cash items such as depreciation. Fill those from the merchant processor, sent invoices and the filed return.

Which year should I rebuild first?

The oldest year in the gap, opening from the last filed return with a balance sheet. Each year rolls its closing balances into the next, so starting in the middle means re-doing the opening balances later. Tie each year to its return transcript and lock it before starting the next.

Should I amend a return if the rebuilt year does not match what was filed?

That is a decision for your CPA, not the bookkeeper. Give them the year-by-year list of differences with reasons. Timing items, depreciation and owner adjustments usually explain the gap; an unexplained difference in revenue is the one that needs a professional opinion.

Need the rebuild done rather than described? Catch-up bookkeeping is the service, and monthly bookkeeping keeps it current afterwards. If the file exists but the numbers are wrong, start with QuickBooks cleanup. Deciding how many years to carry into the new file? How much history to migrate.

Need this handled instead of explained? Talk to a US-based, Intuit ProAdvisor Gold team — (877) 290-4522 or [email protected]. Books a mess? Start with the free QuickBooks File Analyzer — 60 seconds, no signup.
Begin

Get a free scoping call.

Tell us what you’re working on. We respond same business day.

Ram Singh, Founder of Numerawise Solutions
Of the Author

Ram Singh · Founder & Principal

Founder of Numerawise Solutions, established MMXXIV in Atlanta. Intuit ProAdvisor Gold tier. Former Intuit Technical Support engineer. Has personally led two hundred accounting software conversions for US small businesses since founding the practice. Reachable directly at [email protected].