Autymate
Talk to Us

Import Checks into QuickBooks Online

Autymate Transactions lets you bulk import written checks from Excel, CSV, IIF and text files. Check numbers, payees, bank accounts and expense lines all come across, so your register matches the bank.

Get Started for FreeSee how it works
  • Free plan, no credit card needed
  • Check numbers kept
  • Preview before you post

Why Checks Are the Hard One in QuickBooks Online

Intuit says QuickBooks Online's built-in import takes checks only on the Advanced plan. On other plans, the routes are typing each check in, or uploading a bank file and matching line by line, which leaves out the check's expense split and memo.

Import my checks

Can You Import Checks into QuickBooks Online?

Yes: Autymate Transactions imports checks into QuickBooks Online from the Excel, CSV, delimited text or IIF register you already keep. Rows that share a check number and bank account become one check with every expense line, your check numbers are kept, and payees and accounts are matched by name. You preview every check, and nothing posts until you approve it.

Checks from Wherever You Track Them

Pick where your checks come from. Each lands in QuickBooks Online as a real check, against the right bank account.

Pick Up Check Registers Automatically

Connect Google Drive, an SFTP folder or Amazon S3, and new check registers are picked up and queued for your review. Or pull checks from any system with a custom API.

  • Google Drive
  • SFTP folder
  • Amazon S3
  • Custom API

Checks coming from a system we don't connect to yet? Talk to an expert about a custom integration

The Whole Check, Not Just a Bank Line

Everything you'd type on QuickBooks Online's check screen, for hundreds of checks at once.

CheckSampleAmount$1,284.60
Payee
Harbor Seafood
Check no.
10455
Bank account
Checking
Payment date
11/09/2026
Location
Downtown
Print status
Already printed

Category details

  1. 1Food Cost · Weekly seafood order1,104.60
  2. 2Delivery · Delivery fee42.00

Item details

  1. 1Oysters, 100 ct · 1 × 138.00Billable · Lee Catering138.00
Memo: Inv HS-2291Total $1,284.60
Import written checks: QuickBooks Online gets each one like this sample, with its number, payee, bank account and every line.

  • Check Numbers

    Your numbers kept, so the register matches your checkbook and the bank.

  • Payees

    Vendors, customers or employees, matched by name.

  • Bank Account

    Each check posted to the right checking account.

  • Expense & Item Lines

    One check split across categories or items.

  • Billable Costs

    Lines marked billable to a customer.

  • Classes & Locations

    Spend tracked by location, department or brand.

  • Memos

    Check memos and line descriptions carried over.

  • Print Status

    Already printed, or queued to print later.

Bulk Import Checks. QuickBooks Online Gets Every Line.

Free plan, no credit card needed.

Get Started for Free

QuickBooks Online's Options for Checks vs Autymate

Outside the Advanced plan, QuickBooks Online gives you two ways to get checks in. Here's how they compare.

QuickBooks Online's Options for Checks vs Autymate
Typing each check inBank file uploadAutymate Transactions
BulkNo, one at a timeYes, up to 1,000 lines a fileYes
Creates real checksYesNo, bank lines to match or categorizeYes
Check numbersYesOnly if the bank file has themYes
Split across categoriesYesLine by line, by handYes, from your file
Payee & memoYesBank description onlyYes
Duplicates on re-runn/aPossibleAlready-posted checks skipped

QuickBooks Online's options from Intuit, checked November 2026. Import data lists checks, an option Intuit's QuickBooks Team says is on the Advanced plan only; a bank upload takes a date, a description and an amount. They can change by plan and region. (Intuit: importing data (opens in a new tab) · Intuit: uploading bank transactions (opens in a new tab) · QuickBooks Team: importing checks (opens in a new tab))

How to Set Up Your Check File

Use the register you already keep: for a QuickBooks Online import, checks from Excel or CSV need no template. These habits make every check import cleaner:

  1. One row per check line. Repeat the check number, payee and date on each line of the same check.

  2. One number per check. Two checks with the same number from the same account are treated as one.

  3. Name the bank account. Say which account each check was written from, or set one default when you map.

  4. Payees as they appear in QuickBooks. Vendor, customer or employee. A close spelling is paired once and remembered.

  5. Leave voided checks out. A negative or zero row is held for review, never posted.

Import Check Register into QuickBooks Online

CSVnov-checks.csvSample
  1. CheckNo,Payee,Date,Bank,Account,Amount
  2. 10452,Metro Foods,11/05/2026,Checking,Food Cost,862.40
  3. 10452,Metro Foods,11/05/2026,Checking,Supplies,74.10
  4. 10453,Green Lawn Co,11/06/2026,Checking,Repairs,220.00

Becomes 2 checks

  • Check 10452Metro Foods2 expense lines$936.50
  • Check 10453Green Lawn Co1 expense line$220.00
Two checks, three rows. Check 10452 posts with two expense lines; 10453 with one. (Metro Foods and Green Lawn Co are made-up payees.)

How Check Columns Map to QuickBooks Online

Autymate suggests the mapping from your headers. Change any field, set defaults, and save it for next time.

How Check Columns Map to QuickBooks Online
Your columnQuickBooks Online check fieldNotes
CheckNoCheck no.With the bank account, groups lines into one check
PayeePayeeVendor, customer or employee; if two match, Autymate asks
DatePayment dateDate formats detected and converted
BankBank accountMust be a bank-type account in QuickBooks Online
AccountCategory (expense line)Matched to your chart of accounts
Item / Qty / RateProduct/Service (item line)Matched to your items list
AmountAmountTotals checked before posting
Customer / BillableCustomer, BillableFor costs you pass on to a customer
Location / ClassLocation / ClassKept when tracking is on in QuickBooks Online
MemoMemoPrinted memo and line descriptions

Four Ways to Fill a Field

  • Source

    Copy the value from a column.

  • Default value

    Fill it in when the cell is blank.

  • Override value

    Always use one fixed value.

  • Advanced Function

    Format a date, trim text, or combine columns.

How to Import Checks into QuickBooks Online

Five steps, a few minutes for the first file. After that, saved mappings make it one upload.

  1. Sign up for Autymate Transactions and connect your QuickBooks Online company with your Intuit sign-in.

    The To card in Autymate: the destination is QuickBooks Online with a green connected check, and the destination entity is Check.
    QuickBooks Online connected, with Check as the record type it will receive.

  2. Pick Checks as the record type, then upload your Excel, CSV, text or IIF file.

    The record-type picker in Autymate: QuickBooks Online is the destination and the list is open on Purchases, showing Check, Expense and Bill Payment, with Banking and Accounting below.
    Checks sit under Purchases, next to expenses and bill payments.

  3. Autymate matches your headers to QuickBooks check fields. Pick the bank account if your file doesn't name one.

    The Autymate mapping table for a check: Payment date, Payee, Category, Amount, Bank account, Location and Check no., each with its mapping type, the column or value it takes, and a sample result such as Metro Foods, Food Cost, $862.40 and Checking.
    Each check field, where its value comes from, and what it will be. The bank account takes a default.

  4. See each check as it will appear in QuickBooks Online: number, payee, lines and total. Problems are flagged before anything posts.

    The Autymate Preview import screen for checks: 156 checks will post to QuickBooks Online, 2 need review and 1 is already there, with each check's number, payee, total, line count, bank account and a Ready or Error status.
    One row per check, with its line count and bank account. Checks that can't post yet are held back.

  5. Post the checks, then match them to cleared lines in your bank feed. Fix any held checks and re-run; posted ones are skipped.

    An Autymate run started from nov-checks.xlsx: 159 checks in the run, 156 posted, 2 needing review and 1 skipped, with the note that none of the held checks reached your books.
    What posted, what is held and what was skipped. Held checks never reached the books.
Get Started for Free

Common Check Import Errors, Handled

The usual reasons a check import into QuickBooks Online stops, and what Autymate does about each.

Common Check Import Errors, Handled
ErrorWhat causes itHow Autymate handles it
Payee not foundThe payee isn't in QuickBooks yet, or is spelled differently.Holds the check and suggests the closest match. Pair it once and every later check uses it.
Not a bank accountThe account a check is written from isn't a bank-type account.Holds the check so you can pick the right checking account.
Duplicate check numberThe same checks run again, so they're already in QuickBooks.Remembers every check it has posted, so a re-run skips them.
“Account doesn't exist”The expense category isn't in your chart of accounts.Holds the check and flags the account, so you can map it to the right one.
Voided checksVoids in the register show up as negative or zero rows.Holds them with the reason, so you can skip them.
Line totals don't matchSplit lines don't add up to the check amount in your file.Holds the check and shows the difference.

A Held Check, in Plain Words

When a check can't post as it is, Autymate keeps it back with the reason and the fixes that apply. Pick one, tick the box, and the same fix applies to every check after it.

The Autymate No matching payee panel: the payee named on these checks does not exist in your accounting system yet, and nothing was posted for these 2 checks. The options are Map to an existing payee or Skip the affected rows, with Do this automatically from now on.
Two checks held for a payee QuickBooks doesn't have yet. Nothing was posted for them.

Who Imports Checks into QuickBooks Online

  • Businesses That Still Pay by Check

    Vendor and contractor checks logged in a register, posted in one run.

  • Property Managers

    Owner draws, repairs and deposit refunds by property.

  • Bookkeepers & Accounting Firms

    Client check registers in any format, with a saved mapping per client.

  • Multi-Location Businesses

    Checks from every location's account, tracked by class or location.

  • Switching to QuickBooks Online

    Import outstanding checks: QuickBooks Online starts with the uncleared checks from your old system, so your first reconciliation ties out.

  • Catch-Up Bookkeeping

    Months of checks from a register or spreadsheet, entered in one pass.

Import Checks for Less

The same check-import job for a lower monthly price, with a free plan to start.

  • Free

    Start here    $0no card required
    • 1 location
    • 200 rows a month
    • Preview, undo and saved mappings

  • Standard

    $19per location, per month
    • Unlimited locations
    • 30 runs a month
    • Everything in Free

Every new account starts on Free, so you can connect QuickBooks Online and post real checks in your first session. Get started for free

Autymate Transactions compared with SaaSAnt Transactions (Growth)
Autymate TransactionsSaaSAnt Transactions (Growth)
Monthly price$19/mo$25/mo
Bulk check import to QuickBooks OnlineYesYes
Excel, CSV, Google Sheets & IIFYesYes
POS & app connections (Toast, Square, Clover…)YesNo
Get startedStart for Free—

SaaSAnt price from SaaSAnt's published Growth plan, checked November 2026. Prices may change.

Importing Checks into QuickBooks Online

Yes. QuickBooks Online's own import offers checks only on the Advanced plan, according to Intuit; on other plans you type checks in or upload a bank file. Autymate Transactions bulk imports checks from Excel, CSV, delimited text and IIF files, with check numbers, payees, bank accounts and expense lines.

Connect QuickBooks Online to Autymate Transactions, choose Checks, upload your file, map the columns, preview, then import. After the first file, the saved mapping makes the next one a single upload.

You can, but a bank upload creates bank lines to match or categorize, not checks. Intuit's upload takes a date, a description and an amount, so the payee, the expense split and the memo have to be added by hand.

Yes. Autymate keeps the check number from your file, so your register matches your checkbook and the bank.

Yes. Put each line on its own row and repeat the check number. Rows with the same number and bank account become one check with all its lines.

Any vendor, customer or employee in QuickBooks Online. Autymate matches the name in your file to the payee in QuickBooks, and if two records match, it stops and asks. A payee that isn't there yet is held, so you can map it.

Import the checks, then match them to the cleared lines in your bank feed. Autymate remembers every check it posts, so re-running a file never doubles them.

Yes. Import the checks that hadn't cleared in your old system, so your first bank reconciliation in QuickBooks Online ties out.

Leave them out of the file. If a void comes through as a negative or zero amount, Autymate holds it with the reason so you can skip it. A check that has already posted can be voided in QuickBooks Online.

Autymate Transactions starts free, with no card, one location and 200 rows a month. The Standard plan is $19 per location per month.

Stop Writing Checks into QuickBooks Twice

Bulk import checks into QuickBooks Online today. Start free, no credit card needed.

  1. Create your free account
  2. Connect QuickBooks Online
  3. Upload your check register
Get Started for Free