Open app

Home › Help › QuickBooks

Help · Pro

Import your checks into QuickBooks

Export the checks you printed with Quick Check Writer, then upload them to QuickBooks Online (CSV) or QuickBooks Desktop (IIF). No retyping.

QuickBooks Online (.CSV)

  1. In Quick Check Writer, open Register and tap “Export Checks to QuickBooks”.

    The Register screen with the Export Checks to QuickBooks button and its Pro badge

  2. Pick the bank account and the dates, keep “QuickBooks Online (.CSV)” and tap Download. The file saves to your device.

    The export window with bank account, date range and file type

  3. In QuickBooks Online, go to All apps → Accounting → Bank transactions.

    Illustration: the QuickBooks Online menu with Bank transactions highlighted
    Illustration — QuickBooks screens may look slightly different.

  4. Open the Link account ▾ menu and choose Upload from file. (Older menus: Banking → Upload transactions.)

    Illustration: the Link account menu open with Upload from file highlighted
    Illustration — QuickBooks screens may look slightly different.

  5. Select Drag and drop or select files, pick the QuickCheckWriter-Checks-for-QuickBooks file, then Continue.

    Illustration: the file upload box with the exported CSV file selected
    Illustration — QuickBooks screens may look slightly different.

  6. In QuickBooks account, pick the bank account the checks were written from, then Continue.

    Illustration: choosing the QuickBooks bank account
    Illustration — QuickBooks screens may look slightly different.

  7. Match the columns: Date → Date (format MM/dd/yyyy), Description → Description, Amount → Amount in one column (negative = money out). Then Continue.

    Illustration: mapping the Date, Description and Amount columns
    Illustration — QuickBooks screens may look slightly different.

  8. Tick the checks to import, tap Continue, then Yes and Done. Your checks wait under Bank transactions, ready to match or categorize.

    Illustration: the list of checks selected and the Yes button to import
    Illustration — QuickBooks screens may look slightly different.

QuickBooks Desktop (.IIF): pick “QuickBooks Desktop (.IIF)” in the export window. In QuickBooks Desktop, back up your company file, then go to File → Utilities → Import → IIF Files, pick the file and choose Import IIF / OK. New payees land in the Other Names list; payees already in QuickBooks are matched by name.

Illustration: the QuickBooks Desktop File, Utilities, Import, IIF Files menu
Illustration — QuickBooks screens may look slightly different.

What's in the file

The CSV has three columns, the format Intuit documents for bank uploads: Date (MM/DD/YYYY), Description (payee, check number and memo) and Amount (negative, because a check is money out). Void checks are left out. QuickBooks Online takes up to 1,000 lines per upload, so pick a shorter date range for more checks. The file name is QuickCheckWriter-Checks-for-QuickBooks-YYYY-MM-DD.csv.

Sources: Intuit, Format CSV files to get bank transactions into QuickBooks, Manually upload transactions into QuickBooks Online and IIF overview. QuickBooks is a trademark of Intuit Inc. Quick Check Writer is not affiliated with Intuit.

Export Checks to QuickBooks is part of Pro

Pro: up to 10 companies / bank accounts and QuickBooks export. $4.99/month, cancel anytime.

See plans

Stuck? Contact us and we'll reply by email.