inhandPrepare an eligible bank CSV for QuickBooks
InHand editorial · Updated 2026-10-09
QuickBooks accepts bank-transaction CSVs with Date, Description and Amount columns. InHand can create a QuickBooks CSV from an eligible CSV that passes Studio checks or a PDF that completes explicit source review and exact reconciliation. This is a manual CSV import, not a native .QBO Web Connect file or a direct QuickBooks integration.
Intuit documents both three-column and four-column bank CSV formats. Follow the instructions for your QuickBooks product and region, because available import workflows can differ. Read Intuit’s official CSV format guidance.
The exported fields
| Field | InHand output | Review |
|---|---|---|
| Date | MM/DD/YYYY | Choose the same date format in import. |
| Description | Reviewed narration | Compare source text and any visible apostrophe prefixes. |
| Amount | Credit minus debit | Incoming money positive, outgoing money negative. |
Check CSV eligibility first
The imported CSV must state its period in the first three records, include mapped opening and closing balances, classify every populated row, use valid supported dates and currency, and reconcile exactly. Map its Date, Description, signed Amount or separate Debit/Credit columns, and Balance. If any issue remains, Studio keeps export locked.
Inspect the destination import preview
After Studio enables export, choose QuickBooks CSV and open QuickBooks’ own import workflow. Select the correct account, assign Date, Description and Amount, and check the first, last and sample middle rows. Verify date format and at least one debit and one credit. Importing is different from categorising or reconciling in your accounting system.
Avoid duplicates and format confusion
Statements can overlap with other statement periods or transactions already imported through a bank feed. InHand flags possible repeated transaction identities but does not remove them automatically; review the destination’s duplicate handling. Renaming a CSV to .qbo does not make a QBO file. CSV is not XLSX, and QIF is a separate legacy format whose support depends on the receiving application.
Keep the original statement and compare the QuickBooks preview before confirming. A successful upload does not prove that all amounts or categories are correct. Read the balance-check limitations.