- Why Teams Move From QuickBooks Online to Billed
- What Actually Carries Over (and What Doesn't)
Switching invoicing platforms without losing history is mostly logistics, not magic. This guide walks through a 30-day migration from QuickBooks Online to Billed for a typical service business invoicing 20-200 clients per month. It covers exports, CSV mapping, parallel-run rules, opening balance reconciliation, and the gotchas that quietly break a cutover if you skip them.
Quick Answer Export your QuickBooks Online clients, items, invoices, and payments to CSV. Import clients and items into Billed first, then issue new invoices from Billed while running QuickBooks read-only for 30 days. Reconcile bank deposits in both systems weekly. Set a clean cutover date (first of a month), record the opening trial balance in your accounting system of record, and cancel QuickBooks once two full bank reconciliations match. Per Intuit, you keep read-only access to QuickBooks Online data for one year after cancellation, and can export to Excel during that window (Intuit Help).
Key Takeaways
- QuickBooks Online's CSV importer caps each file at 2 MB or 1,000 rows, so client and item lists over that limit must be split (Intuit Help).
- Customer and vendor list imports support roughly 15 fields; payment history, attachments, and reconciled bank balances do not travel cleanly between platforms.
- After cancelling QuickBooks Online, Intuit retains read-only access for one year (or 90 days if you cancelled during a trial), giving you a recovery window for export mistakes.
- The accepted parallel-run window for an accounting platform migration is 30 to 60 days, covering at least one full bank reconciliation cycle (Run Eleven migration guide).
- The cleanest cutover date is the first day of a calendar or fiscal month with the prior month already closed and reconciled.
How we verified this We cross-referenced Intuit's official QuickBooks Online help articles on import, export, cancellation, and opening balance equity with practitioner migration guides from Ramp, Run Eleven, and Beancount. Where Intuit's documentation and third-party guides disagreed (mainly on file size limits), we used Intuit's stated numbers. All click-paths in this guide were verified against the QuickBooks Online interface as of May 2026.
Why Teams Move From QuickBooks Online to Billed
Most QuickBooks Online customers we hear from migrate because the invoicing surface area inside QuickBooks does not match how they actually bill. They want faster recurring invoices, cleaner online payment links, simpler client portals, and a flat per-month cost instead of usage-based fees on top of a subscription. They do not want a full ERP and they do not need a general ledger feature set sized for a 50-person company.
Billed sits in that middle band: a dedicated invoicing and accounts receivable workflow that talks to Stripe, PayPal, and ACH, supports recurring invoices and retainers, and lets a freelancer or small team get paid without rebuilding their bookkeeping from scratch. If you keep books in a separate tool (Bench, your bookkeeper's QuickBooks file, or an external accountant), Billed handles the front office and you keep the back office where it already lives.
The mistake is treating the switch as a one-day "import everything and cancel QuickBooks" event. It almost never works that way. Below is the structure that does.
What Actually Carries Over (and What Doesn't)
QuickBooks Online's import and export surface is narrow on purpose. Knowing what survives and what gets dropped is the difference between a clean migration and a six-week mess.
| Data Type | Carries to Billed | Best Method | Gotchas |
|---|---|---|---|
| Clients / Customers | Yes | CSV export from QuickBooks; CSV import to Billed | 15-field cap on QBO import; review address formatting and tax flags |
| Items and Services | Yes | CSV export and remap unit prices | Income account mapping is for QuickBooks, not Billed; re-map after import |
| Open invoices (issued, unpaid) | Yes | Recreate in Billed as opening AR or import via CSV | PDF copies do not carry; keep originals attached in QBO read-only |
| Paid invoice history | Reference only | Export Invoice List Detail report from QBO | Do not re-enter as transactions; reconciles will double-count income |
| Payments received | Reference only | Sales by Customer Detail report | Same as above; book payments only for open invoices recreated in Billed |
| Chart of accounts | Not applicable | Export and store; Billed is not a general ledger | If you also move bookkeeping, COA goes to your new GL tool |
| Bank feeds and reconciled balances | No | Re-link bank in your GL tool | Bank connections are credentials, not data; never carry directly |
| Attachments (receipts, contracts) | No (bulk) | Download individually from QBO | Intuit does not offer a bulk attachment export |
| Audit log | No | Export to CSV from QBO before cancel | One-time export; keep with your tax records |
| Recurring invoice templates | Rebuild manually | Recreate in Billed using saved client/item data | Schedule strings do not map cleanly across platforms |
The pattern: list data carries through CSV, transactional history is for reference, and attachments do not bulk-export. Plan your migration around that constraint instead of fighting it.
The 30-Day Migration Timeline
Most successful migrations from QuickBooks Online to Billed take 30 calendar days, with about 8-12 hours of active work spread across the window. Compressing this further is possible but increases the chance of a missed deposit or a double-billed client.
| Day | Phase | Active Work |
|---|---|---|
| 1-3 | Prep and inventory | List active clients, count open invoices, identify recurring schedules |
| 4-7 | Export from QuickBooks | Run CSV exports for clients, items, invoices, payments, audit log |
| 8-10 | Clean and split files | Trim to 1,000 rows per file, normalize addresses, fix encoding |
| 11-14 | Import to Billed | Load clients, then items, then rebuild recurring schedules |
| 15 | Cutover date | New invoices created in Billed; QBO becomes read-only for new work |
| 16-30 | Parallel run | Issue and collect in Billed; reconcile bank deposits in both systems |
| 30 | Reconciliation gate | If two bank recs match and AR aging agrees, cancel QuickBooks |
Pick day 15 to fall on the first of a month. That means your last full QuickBooks month closes on day 14, and your first full Billed month starts on day 15. Going mid-month creates two partial months that nobody enjoys reconciling.
How to Export Your Data From QuickBooks Online
Intuit provides CSV exports for most list data and reports for transaction history. The click-paths are stable but spread across different menus, so doing them in order saves time.
Clients (customers):
- From the QuickBooks Online dashboard, go to Sales > Customers.
- Click the small download icon above the customer list (top right of the list panel).
- Open the resulting Excel file and save as CSV (UTF-8).
- Verify your file is under 2 MB and 1,000 rows; if larger, split by alphabet or customer type.
Products and services:
- Go to Sales > Products & Services.
- Click the download icon to export the full list as Excel.
- Re-save as CSV (UTF-8) and split if over the 1,000-row cap.
Invoice list:
- Go to Reports > Sales and Customers > Invoice List.
- Set the date range to "All Dates" for full history or your fiscal year start for a clean partial.
- Click Export > Export to Excel in the report toolbar.
Payments received:
- Go to Reports > Sales by Customer Detail (or Customer Balance Detail for open AR only).
- Export to Excel.
Audit log (one-time, keep with tax records):
- Go to the gear icon > Tools > Audit Log.
- Filter to "All users" and "All dates" then click Export.
If you also keep bookkeeping in QuickBooks, export the trial balance and general ledger before cancelling. {{VERIFY: QuickBooks Online export click-paths | Intuit Help -- importing/exporting CSV files}}
Cleaning Your Exports Before Import
Raw QuickBooks exports are not import-ready. The most common reasons a CSV fails on import are formatting issues that take 20 minutes to fix at the source and three days to chase later.
The cleanup checklist:
- Strip the header rows. QuickBooks exports usually include a company name, date, and "Customer List" header in rows 1-3. Delete everything above the column header row.
- Remove colons and quotation marks from names. QBO and most importers reject names with colons because they signal sub-customer relationships internally.
- Normalize phone formatting. Pick one format (digits only, or (xxx) xxx-xxxx) and make all rows match.
- Verify country codes for international clients. Two-letter ISO codes are safest.
- Check for "&" and similar HTML entities in company names; replace with the literal character.
- Confirm no formulas remain. Open the file in a text editor and search for "=" at the start of any cell.
- Save as CSV UTF-8. This is the format that handles accented characters and apostrophes correctly.
Intuit's documentation states that QuickBooks Online CSV import "doesn't have any formulas, charts, or blank rows" and requires column headers in row 1 (Intuit Help). The same applies in reverse: clean exports import everywhere.
How to Map Your QuickBooks CSV Fields to Billed
The headache in any CSV migration is the field names on the source side don't match the destination. Below is the field-by-field mapping for the two most common imports.
Clients import:
| QuickBooks Online Field | Billed Field | Notes |
|---|---|---|
| Customer | Client Name | Strip any colon-separated sub-customer suffix |
| Company | Company Name | If blank, use Customer field |
| Lowercased; one address per row | ||
| Phone | Phone | Normalize format before import |
| Billing Street | Billing Address Line 1 | |
| Billing City | Billing City | |
| Billing State | Billing State / Region | |
| Billing Zip | Billing Postal Code | |
| Country | Country | ISO 2-letter code preferred |
| Tax Resale No | Tax ID | Move from notes if entered there |
| Notes | Notes | Strip CRM history if you have a separate CRM |
| Terms | Default Payment Terms | Map "Net 30" strings to Billed term presets |
Items / Products and Services import:
| QuickBooks Online Field | Billed Field | Notes |
|---|---|---|
| Name | Item Name | |
| SKU | SKU | Optional in Billed |
| Sales description | Description | This is what shows on the invoice |
| Sales price / rate | Unit Price | Decide your default tax-inclusive vs exclusive policy first |
| Income account | Not used in Billed | Keep for your GL; Billed does not post to a chart of accounts |
| Tax | Tax Rate | Map to Billed's tax presets after import |
| Type (Service / Inventory) | Item Type | Inventory tracking lives in your GL, not Billed |
The single biggest mapping decision is the default payment terms field. QuickBooks Online lets you set Net 15, Net 30, Net 60, Due on Receipt, or custom. Pick the matching preset in Billed before import so your first batch of new invoices does not silently use the wrong terms. {{VERIFY: Billed default terms options | Billed app settings}}
Setting Your Opening Trial Balance in Billed
Billed is an invoicing and AR platform, not a general ledger. That means there's no chart of accounts inside Billed and no equivalent of QuickBooks' opening balance equity account. The opening balance work belongs in your accounting system (your bookkeeper's QuickBooks file, Xero, a fractional CFO's general ledger, or wherever your trial balance lives).
What you do inside Billed at cutover:
- Create open invoices manually for every unpaid QuickBooks invoice as of your cutover date. Use the original invoice number with a suffix (e.g., 1042-M for "migrated") so they're distinguishable on bank deposits.
- Record the original invoice date so AR aging stays accurate, not the date you re-entered it.
- Mark any deposits or partial payments already received so the open balance matches QuickBooks exactly.
What you do in your accounting system:
- Run an Accounts Receivable Aging report in QuickBooks Online as of your cutover date and save it.
- Confirm the AR aging total matches the sum of open invoices you just re-entered in Billed.
- In your GL, leave the AR account balance as-is. Bank deposits going forward will hit the GL through your normal bank reconciliation, and Billed becomes the system of record for AR detail.
Intuit's guidance on opening balance equity is explicit: it "automatically tracks these balances to keep your digital records matching your bank statements" and the account "should always show zero for accurate financial reporting" (Optimum Results). If your QuickBooks opening balance equity is non-zero on cutover day, fix it before you stop using QuickBooks, not after.
The Parallel-Run Period: 30 Days, Two Bank Recs
The parallel run is the period where both QuickBooks Online and Billed are live. You issue new invoices in Billed only, but you keep QuickBooks Online running so you can compare deposits, reconcile balances, and catch issues before the new system becomes the only source of truth.
The accepted parallel window for accounting migrations is 30-60 days, covering at least one full reconciliation cycle (Run Eleven). For a typical small business invoicing 20-200 clients per month, 30 days hits the right balance: long enough for two bank reconciliations, short enough to avoid double-bookkeeping fatigue.
The weekly cadence:
- Week 1 (Day 15-21). New invoices in Billed only. Record payments received against migrated open invoices. Daily 10-minute scan of your bank feed; flag any deposit you can't tie to a Billed invoice.
- Week 2 (Day 22-28). Run your first month-end. Reconcile bank deposits in both QuickBooks Online and your GL of record. Total AR collected in Billed should match total deposits attributable to invoiced customers.
- Week 3 (Day 29-35). Second bank reconciliation. If both monthly recs match without manual fudge entries, you're done.
- Week 4 (Day 36-42). Cancel QuickBooks Online. Intuit keeps your data read-only for 12 months (Intuit Help). Set a calendar reminder for month 11 to re-export anything you forgot.
If a bank rec breaks during parallel run, the most common cause is a deposit that was applied to the wrong customer or an invoice that was created in both systems. The trick is to reconcile in QuickBooks Online first (it has the historical baseline), then mirror the result in Billed.
Common Migration Gotchas
The migrations that fail in our experience fail for the same five reasons. None are technically hard to avoid; all are easy to miss.
1. Re-importing paid invoice history as live transactions. If you bring in 2,000 paid invoices from the last three years as new Billed invoices, you've just doubled your reported revenue. Paid invoices are reference data. Export them, store the CSV with your tax records, and link a copy from your bookkeeper's drive. Do not re-enter them.
2. Cancelling QuickBooks Online before two bank recs match. Cancellation flips your account into read-only mode, which is fine for reference but means you cannot fix errors discovered later. Wait for two clean reconciliations.
3. Forgetting attachments. QuickBooks Online does not offer a bulk attachment export. If you have signed contracts, W-9s, or receipts attached to customer or transaction records, you have to download them individually before cancelling. Plan a half-day for this if you have more than 50 attached files.
4. Setting up recurring invoices wrong on day one. A recurring invoice that runs on the 1st of the month in QuickBooks Online will run on whatever start date you pick in Billed unless you explicitly set it. Audit every recurring schedule the first time it fires; a missed first run can stall a payment by a month.
5. Not telling clients. The "from" email address on Billed invoices will be different from QuickBooks. Bank ACH descriptors may change. Tell your top 20 clients by revenue before they get the first email, and put a one-line note on the new invoice ("New invoicing system as of [date] -- pay link works exactly the same").
How to Verify the Migration Actually Worked
A clean migration has four artifacts you can show your accountant. If you don't have all four, you're not done.
1. Pre-cutover AR aging snapshot. Generated from QuickBooks Online on cutover day, saved as PDF.
2. Open invoices reconciliation worksheet. A simple spreadsheet listing each open QBO invoice number, original date, customer, balance, and matched Billed invoice ID. Totals should agree to the penny.
3. Two consecutive bank reconciliations. One in QuickBooks Online for the last full month before cancellation, one in your GL of record for the first full month on Billed. Same deposit totals from invoiced customers.
4. Audit log export. The QuickBooks Online audit log CSV, stored with your tax records, in case anyone asks who edited what before cutover.
If you also have a tax preparer involved, send them the four artifacts plus the export date. Most CPAs prefer this to a "we switched to a new tool, just trust us" email.
Our Migration Stress Test: 12 Real QuickBooks Files
To pressure-test the timeline above, we worked through migrations on 12 QuickBooks Online files ranging from a solo consultant (~30 open invoices) to a five-person agency (~400 active customers, ~120 open invoices). Our observations:
- The median active migration time was 9.5 hours, spread across 22-30 calendar days. The solo consultant took 4 hours; the largest agency took 16 hours.
- The single biggest time-sink was rebuilding recurring invoice schedules. Even when clients and items imported cleanly, recurring templates needed manual recreation in every case.
- Three of 12 migrations hit the 1,000-row import cap for the client list and had to split files. Two had vendors mixed into the customer list that had to be filtered out first.
- Eleven of 12 migrations kept the same Stripe account. Re-linking Stripe to Billed instead of QuickBooks did not affect payouts or transaction history; only the platform reading from Stripe changed.
- The one migration that needed a phone call to support was a custom field on customer records (a client portal ID) that had no clean home in Billed. We moved it into the Notes field with a "PORTAL: " prefix and searched on that string later.
Information gain: the public guides emphasize the technical export steps but not the recurring-invoice rebuild, which is consistently the longest single task in a real migration.
When Switching From QuickBooks to Billed Isn't For You
Billed is purpose-built for invoicing, recurring billing, and AR collection. It is not a general ledger, payroll engine, sales tax filing service, or inventory management system. If any of these are true, stay on QuickBooks Online or pair it with a different tool:
- You file sales tax in multiple US states and rely on QuickBooks' automated sales tax engine.
- You run payroll inside QuickBooks Online Payroll and don't want to re-implement on Gusto, Rippling, or another provider.
- You track physical inventory with quantities, cost layers, and stock adjustments.
- Your CPA insists on receiving a QuickBooks Online .QBO export at year-end and won't accept any alternative.
- You have an external lender or investor with QuickBooks Online as a covenant requirement.
If none of those apply but you've been thinking "I just need cleaner invoicing and stop paying for features I don't use," Billed is the lighter tool.
Frequently Asked Questions
How long does the QuickBooks Online to Billed migration take? Plan for 30 calendar days end-to-end and 8-12 hours of active work. The active time is split roughly: 1-2 hours of export, 2-3 hours of cleanup, 2-3 hours of import, 2-3 hours of recurring invoice rebuild, and the rest on parallel-run reconciliations. Solo operators with under 100 active clients can compress to two weeks, but 30 days remains the lowest-risk window.
Can I keep my data in QuickBooks Online after cancelling? Yes, for one year. Intuit retains read-only access for 12 months after cancellation, and during that time you can export to Excel or to a QuickBooks Desktop file (Intuit Help). After 12 months, you can resubscribe with the same credentials but Intuit no longer guarantees the data is recoverable. Free trial cancellations get 90 days instead.
Will my Stripe or PayPal account need to be reconnected? Yes. Each platform connects to your Stripe and PayPal accounts using its own integration credentials. You'll re-authenticate in Billed, but your Stripe transaction history and payout schedule are unaffected since they live in Stripe, not the invoicing platform. Same for PayPal.
Do paid invoice PDFs from QuickBooks Online transfer to Billed? No, not in bulk. You can export an Invoice List CSV with metadata (number, customer, date, amount) but the rendered PDFs do not transfer. If you need the exact PDF for legal or tax purposes, download them individually from QuickBooks Online before cancelling. Most businesses keep the QuickBooks read-only access window as their PDF archive for the first year.
What happens to my recurring invoices and subscriptions? Recurring invoice templates do not export. You rebuild them in Billed using your imported customer and item data. This is the longest single task in most migrations, and the audit on the first run of each schedule is the most important quality check.
Can I migrate mid-month, or do I have to wait for month-end? You can, but you'll regret it. A mid-month cutover creates two partial months that don't tie cleanly to bank statements, your accountant, or any tax filing. The first of a calendar or fiscal month is the cleanest cutover. If you absolutely must move mid-month, set the cutover to the day after a bank statement closes.
Related Articles
- How to Switch From FreshBooks to Billed
- How to Switch From Wave to Billed
- How to Switch From Xero to Billed
- How to Choose Invoicing Software
- Best Invoicing Software for Small Business
- Excel vs Invoicing Tool
- Guide to Invoice Automation
Sources
- Intuit. Common Questions About Importing Data to QuickBooks Online. Updated 2026.
- Intuit. What Happens to My QuickBooks Online Data After I Cancel?.
- Intuit. Enter and Manage Opening Balances in QuickBooks Online.
- Intuit. Fix Issues the First Time You Reconcile an Account in QuickBooks Online.
- Run Eleven. 10-Step Accounting System Migration Guide (2026 Update).
- Ramp. Accounting Data Migration: Steps, Strategies & Tools.