HQ Wealth ↔ QuickBooks Online: The Complete Import & Export Guide

QuickBooks Online is where a huge share of small-business and client books actually live, and HQ Wealth is a full double-entry wealth accounting platform for crypto and traditional assets — real debits and credits, a chart of accounts, wallet and exchange reconciliation, and cost basis under FIFO, LIFO, HIFO, or AVCO. The two fit together naturally: many accountants keep the general ledger in QuickBooks but need crypto-grade lot tracking and reconciliation that QuickBooks was never built to do. So they run HQ Wealth for the digital-asset subledger and push clean journal entries into QuickBooks for the books of record.

Because HQ Wealth is itself a double-entry ledger, it maps onto QuickBooks journals with almost no translation loss — a debit in HQ Wealth is a debit in QuickBooks, against an account name you control. This guide covers both directions: how HQ Wealth exports in QuickBooks Online's exact import formats so files load on the first try, and how HQ Wealth imports a QuickBooks export so a client's existing books flow into your crypto ledger. Everything about QuickBooks formats below comes from Intuit's own documentation, linked inline, current as of July 2026.

Exporting HQ Wealth → QuickBooks Online

There are two supported ways into QuickBooks Online, and the right one depends on what you need. Use journal entries when you want full double-entry fidelity — every posting landing on the exact ledger account with matching debits and credits. Use the bank-feed CSV when you only need transactions to appear in a bank or credit-card register for categorisation. For an HQ Wealth user, the journal-entry path is almost always the right one, so we cover it first.

Path A: Journal entries (recommended)

QuickBooks Online imports journal entries from a CSV through Settings → Import Data → Journal Entries, with a field-mapping step where you match your columns to QuickBooks fields. Intuit documents the template fields in its import journal entries guide. HQ Wealth generates a file that matches those fields exactly, so you skip the manual template-building the guide otherwise walks through.

Here is what our exporter writes, column by column:

| Field | Required? | Format | Example | |---|---|---|---| | Journal No. | Yes | Text or number; repeated across the lines of one entry | 2026-0417 | | Journal Date | Yes | One consistent date format across the file | 17/04/2026 | | Account Name | Yes | Exact chart-of-accounts name; sub-accounts as Parent:Sub | Digital Assets:USDC | | Journal / Description | Optional | Free text memo for the line | Uniswap v3 swap, ETH to USDC | | Debits | Yes on debit lines | Positive number, blank on credit lines | 1520.25 | | Credits | Yes on credit lines | Positive number, blank on debit lines | 1520.25 |

Three things about this format matter more than they look, and HQ Wealth handles all three for you:

Debits and Credits are separate positive-number columns — not one signed amount. This is the single most common mistake when hand-building the file. Each line carries a value in either the Debits column or the Credits column, never both, and the numbers are always positive. HQ Wealth is double-entry internally, so it already knows which side each line sits on and writes it into the correct column.
Every entry must balance, grouped by Journal No. All the lines that share one Journal No. are one journal entry, and their debits must equal their credits. Because HQ Wealth only ever stores balanced entries, every exported journal balances by construction.
Sub-accounts use the Parent:Sub format. Intuit's guide requires sub-accounts written as Parent account:Sub Account (for example, Digital Assets:USDC). HQ Wealth maps its account tree into that colon notation automatically.

One preparation step lives on the QuickBooks side: Intuit's guide says to turn off account numbers before importing (Settings → Account and Settings → Advanced → Chart of accounts) so the import matches on account name. Do that once in the target company file and your HQ Wealth journals map cleanly. The first row of the file is used for field mapping, so leave the header row in place.

Path B: Bank-feed CSV

When you only need transactions in a bank or card register — not full journals — HQ Wealth exports the QuickBooks Online bank-transaction CSV instead. Intuit is strict here: per its CSV formatting guide, a bank CSV must be exactly one of two layouts — nothing wider. An upload wizard then maps your headers and asks "Is the amount in 1 column or 2 columns?", so what QuickBooks enforces is the column role and count, not verbatim header text.

The 3-column layout, one signed amount:

| Column | Format | Example | |---|---|---| | Date | One consistent format, dd/mm/yyyy recommended | 20/11/2026 | | Description | Free text, no numbers | Coinbase withdrawal to bank | | Amount | Signed: negative for money out, positive for money in | -500.00 |

The 4-column layout, split credit and debit:

| Column | Format | Example | |---|---|---| | Date | One consistent format, dd/mm/yyyy recommended | 20/11/2026 | | Description | Free text, no numbers | Coinbase deposit from bank | | Credit | Positive number, blank if not a credit | 500.00 | | Debit | Positive number, blank if not a debit | (blank) |

HQ Wealth writes a valid file directly, but the formatting rules Intuit lists are exactly the traps that get hand-made files rejected, so it is worth knowing what our exporter guards against:

One consistent date format per file. Never mix dd/mm/yyyy and mm/dd/yyyy. The wizard lets you declare the actual format, but the file itself must be internally consistent.
Split weekday text out of the Date column. A value like "20/11/2026 TUE" breaks the import; the day-of-week text must be removed so the cell holds only a date.
Credit and Debit headers read only "Credit" and "Debit". Drop the word "amount" — "Credit amount" is rejected where "Credit" is accepted.
Cells that would hold only a 0 must be blank. An empty Amount, Credit, or Debit cell must be genuinely empty, not a zero.
No numbers in the Description column, and Mac users must save as Windows CSV.

Finally, the size cap. Intuit's manual upload guide sets a hard 350 KB limit per manually uploaded file (which also must be in English; QBO, QFX, and CSV are accepted). A long trading history blows past 350 KB quickly, so HQ Wealth automatically splits the export into date-range batches under the cap, each with its own header row, so every file uploads independently.

Importing QuickBooks Online → HQ Wealth

Migration runs the other way too. When a client arrives with books already in QuickBooks, you can pull that history into HQ Wealth. QuickBooks Online exports its ledger data from Reports — the General Ledger, Journal, and Transaction List reports all export to CSV or Excel — and HQ Wealth's importer reads those exports.

The general structure is what you would expect from a double-entry system: each row carries a date, an account name, a debit amount, a credit amount, and a memo or description, grouped into balanced transactions. HQ Wealth's importer keys off that structure — it reads the debit and credit on each line and the account name, and rebuilds a balanced journal entry in HQ Wealth against the matching account in your chart of accounts. (The exact column headers vary by report and QuickBooks version, so we confirm them at build time against your actual export rather than assuming a fixed layout.)

Here is how our importer treats what it reads. This describes our mapping, not anything Intuit publishes:

| What the QuickBooks export shows | HQ Wealth treatment | |---|---| | A line with a value in the debit column | Debit posting to the mapped HQ Wealth account | | A line with a value in the credit column | Credit posting to the mapped HQ Wealth account | | Account name (including Parent:Sub) | Matched to your HQ Wealth chart of accounts; unmatched names surface for mapping | | Grouped lines that balance | One HQ Wealth journal entry preserving the original date and memo | | A cash or bank movement | Reconcilable against a wallet or exchange feed once mapped |

Because HQ Wealth is a proper ledger and not a tax calculator, every imported entry stays a real journal entry, and any crypto lines you subsequently reconcile against on-chain or exchange activity pick up cost basis under your chosen method rather than inheriting a fiat-only figure. The import preview shows the proposed account mapping before anything posts, and you can override any line.

Format quick reference

The two export targets at a glance:

| Target | Layout | Key constraint | |---|---|---| | Journal entries | Journal No., Journal Date, Account Name, Description, Debits, Credits | Separate positive Dr/Cr columns; entries balance per Journal No.; account numbers off | | Bank CSV (3-column) | Date, Description, Amount | Signed amount; no extra columns | | Bank CSV (4-column) | Date, Description, Credit, Debit | Positive Cr/Dr; zeros blank; headers read only "Credit"/"Debit" |

And the rejection errors we see most often, with fixes:

| Symptom | Cause | Fix | |---|---|---| | "The columns aren't mapped correctly" | Bank CSV has more than the allowed 3 or 4 columns | Trim to exactly the 3-column or 4-column layout | | Dates import wrong or the file fails | Mixed date formats in one file | Use one consistent format throughout; declare it in the wizard | | Upload rejected outright | Bank file over the 350 KB cap | Split into date-range batches, header row in each | | Header not accepted | The word "amount" in a Credit or Debit header | Rename to just "Credit" and "Debit" | | Zero rows misread | Cells holding 0 in Amount/Credit/Debit | Leave those cells genuinely blank | | Journal amounts double or invert | One signed amount instead of split columns | Use separate positive Debits and Credits columns |

FAQ

What is the correct QuickBooks Online journal entry import template? A CSV with the fields Journal No., Journal Date, Account Name, Journal/Description, Debits, and Credits, imported through Settings → Import Data → Journal Entries. Debits and Credits are two separate columns of positive numbers, and all lines sharing a Journal No. must balance. HQ Wealth exports exactly this shape.

Does the QuickBooks bank CSV use 3 columns or 4 columns? Either — but only those two layouts. Three columns is Date, Description, Amount (one signed number). Four columns is Date, Description, Credit, Debit (two positive columns). A file with more columns than that is rejected, because the upload wizard only maps these roles.

How do I get crypto transactions into QuickBooks Online? Track them in HQ Wealth, where wallets and exchanges reconcile and cost basis is calculated, then export to QuickBooks. Use the journal-entry export for full double-entry postings to your chart of accounts, or the bank CSV if you only need register lines to categorise.

Why does my QuickBooks CSV import keep failing? The usual causes are more than 3 or 4 columns in a bank file, mixed date formats, a file over the 350 KB cap, the word "amount" in a Credit or Debit header, or zero-value cells that should be blank. HQ Wealth's export avoids all five automatically.

---

Ready to run a crypto-grade ledger alongside your QuickBooks books? Try HQ Wealth and export clean journal entries in one click.