When you have a stack of transactions to enter, the answer is to batch-import transactions into QuickBooks Online rather than add them one by one. QuickBooks accepts a file of many transactions at once — but the format matters, and a plain import still leaves you with coding to do. Here’s how the batch import works and how to make it actually save time.
What a batch import is
To batch import transactions into QuickBooks Online, you upload a file containing many transactions and QuickBooks brings them in together. The usual route is a batch transaction CSV for QuickBooks with Date, Description, and Amount columns, uploaded under Transactions → Bank transactions → Upload from file.
Step 1 — Build the import file
Create your QuickBooks batch transactions import file as a CSV: one row per transaction, consistent dates, numeric amounts (negative for money out), one header row, no blank rows. If you’re starting from a PDF statement, convert it first — QuickBooks won’t read a PDF.
Step 2 — Upload and map
When you import a batch file into QuickBooks Online, QuickBooks asks you to map your columns to its fields and pick the account. Confirm the mapping, and it loads every row for review in one go.
Step 3 — The catch: it imports uncategorized
A batch upload gets the data in, but each transaction arrives uncategorized. So after the import you still code every line — which, on a big batch, is where the time really goes.
Make the batch import actually fast
The way to get the full benefit is to have the transactions already categorized in the file before you import. That’s what I built Bookmonstic for. (Disclosure: I’m a CPA and Bookmonstic is my own tool.) It reads a PDF/CSV/Excel statement, categorizes every transaction, and exports a QuickBooks batch transactions import file that’s coded and ready — so the batch import brings in data and coding at once. You review exceptions and import. For the conversion side, see how to convert a PDF bank statement to QuickBooks Online.
Frequently asked questions
What format does QuickBooks Online need for a batch import? A CSV with Date, Description, and Amount columns (or Date, Description, Credit, Debit), uploaded under Bank transactions → Upload from file.
How many transactions can I import at once? QuickBooks handles large batches in a single CSV; the practical limit is usually file cleanliness, not count.
Do batch-imported transactions get categorized? Not by a plain upload — they import uncoded. A tool that categorizes before import brings them in already classified.
Can I batch-import from a PDF statement? Not directly. Convert the PDF to a CSV (ideally a pre-coded one) first, then batch-import that.
Written by the founder of Bookmonstic, a practicing CPA. Bookmonstic turns PDF/CSV/Excel bank statements into AI-categorized, import-ready files for QuickBooks and Xero — no rules to build, no API. Try it free →
Leave a Reply