Getting supplier bills into QuickBooks in bulk rather than typing them one at a time comes down to three routes, and which is available depends on your version.
Worth knowing the difference before you start, because the preparation is most of the work and it differs by route.
The three routes
File import. You prepare a spreadsheet or CSV in the layout QuickBooks expects and upload it. Available in both QuickBooks Online and Desktop, with different mechanics and different field names. Free, and the most common route.
A connected app. A capture or bookkeeping tool connected through the QuickBooks App Store writes bills directly through the API. No file handling, and usually the least friction once it's set up.
Manual entry. Still the right answer at low volume — under about twenty bills a month, the preparation overhead of a file import often exceeds the typing it saves.
A note on terminology that causes confusion: in QuickBooks, a supplier invoice is a bill. An invoice means something you've issued to a customer. Import guidance for "invoices" frequently means the sales kind, which is not what you want for purchase ledger, and the field layouts are different.
Preparing a file that imports cleanly
Most import failures come from the data rather than the mechanism. Worth getting these right before the first attempt.
Supplier names must match exactly. QuickBooks matches on the name string. "ABC Ltd", "ABC Limited" and "ABC Ltd." are three different suppliers, and an import will happily create all three — which is how a supplier list gets messy in the first place. Export your existing supplier list first and reconcile your file against it.
Account names must exist already. The import maps to your chart of accounts by name. Anything that doesn't match either fails or creates a new account, neither of which you want. Same rule: export the list, match against it.
One row per line, not per bill. Multi-line bills are expressed as multiple rows sharing a bill number and supplier. Getting this wrong is what produces fourteen separate bills from one fourteen-line invoice — and it assumes you have the line data at all.
Dates in the format your file expects. The classic failure is UK day-first dates read as US month-first. Anything from the 13th onward errors; anything before it imports silently wrong, which is worse. Check a January date lands where you expect before importing the batch.
Decide net or gross and be consistent. Mixing the two within a file produces totals that don't tie and tax figures that are wrong.
Tax codes must be valid for your QuickBooks region and settings. Tax handling differs enough between regions that a file built for one won't import into another.
The sequence worth following
- Export your supplier list and chart of accounts from QuickBooks first.
- Build the file against those exact strings.
- Import five rows as a test. Not the whole batch.
- Check the result properly — open two or three bills and confirm the supplier, account, tax and total are all right, not just that the import reported success.
- Import the rest once the test is clean.
- Reconcile the total. Sum your file, compare against the batch in QuickBooks. They should agree exactly.
Step 3 is the one people skip. A failed import of five rows takes a minute to unpick. A failed import of four hundred is an afternoon, and the undo options are limited.
Errors that cause most failures
Duplicate bill numbers. QuickBooks may reject or warn depending on settings. If it accepts them, you've imported duplicates.
Trailing spaces in supplier or account names. Invisible, and they break exact matching. Trim every text column before importing.
Currency mismatches on foreign suppliers, where the bill currency doesn't match the supplier record.
Special characters in supplier names — ampersands and accented characters cause trouble in some import paths.
Closed periods. Bills dated into a locked period will fail. Check your closing date before importing anything historical.
Undoing a bad import
Worth knowing before you need it, because the options are thinner than you'd like.
QuickBooks Online has no general bulk undo for imported bills. Small batches can be deleted individually; large ones are painful. Desktop users can restore from a backup, which is why taking one immediately before a large import is the cheap insurance.
Practical rule: back up or test small. Preferably both.
Where this fits with capture tools
If you're importing files that a capture tool produced, you've automated the extraction and kept a manual import step. That's a real improvement over typing, and it's not the same as a connected integration.
Worth being clear about the distinction when evaluating tools, because "works with QuickBooks" covers both. Ask specifically: does it write bills through the API, or does it give you a file to import? Both are legitimate. They're different amounts of ongoing work, and the answer usually isn't on the pricing page.
Cribble exports CSV for QuickBooks, Sage50, DATEV and generic formats — so the extraction and coding are done and what's left is the import. A direct QuickBooks integration is planned but not live today; the live integration is Xero, which Cribble posts into directly. Worth knowing which you're getting before you buy anything, including from us.