How to Import Invoices into QuickBooks from Excel
If you pay bills with QuickBooks, each bill must get into the app. Typing them in one by one is slow. The good news: you can import invoices into QuickBooks from Excel. The trick is to shape the sheet the way QuickBooks likes.
Most bills reach you as PDFs. So step one is to turn each PDF into a clean sheet. Our invoice to Excel converter has a QuickBooks Bill export that does this. Then the import takes just a few clicks.
This guide walks the whole path: the columns QuickBooks wants, the import steps, the plan limit to know in the US, and the three fixes that cure most failed imports. Set it up once, and a week of bills goes in as one calm job, not twenty small ones.
First, get the bill into the right columns
QuickBooks reads bills by column names. Each column must hold one kind of fact. The vendor name goes in one column. The bill number goes in its own. Dates, items, counts, and prices each need a home too. If two facts share a cell, the import will fail or land wrong.
| QuickBooks needs | What goes in the column |
|---|---|
| Vendor | The firm that sent the bill |
| Bill number | The number printed on the bill |
| Bill date and due date | The two dates, in date form |
| Item and description | What each row of the bill is |
| Qty and rate | How many, and the price of one |
| Amount | The sum for each row |
Our QuickBooks Bill preset builds the sheet with these columns for you. You do not have to set them up by hand.
Two details trip up more imports than any other. Dates must be real dates, not text that looks like a date. And each bill number must be its own: two bills with the same number from one vendor will merge or clash. New to turning a PDF into a sheet at all? Start with how to convert an invoice PDF to Excel, then come back here to send the sheet on into your books.
Set up once: vendors, accounts, and tax
Ten minutes of setup saves an hour of fixes. Before your first real import, walk these three lists in QuickBooks and clean them. First, vendors: merge any twin names, so each firm has one record. Second, accounts: the bill rows must land in expense accounts that exist. If a row names an account QuickBooks does not have, the import stalls or the row lands in a catch-all you will have to fix by hand.
Third, tax. Each row can carry a tax code, and the code in your sheet must match one QuickBooks knows. Write your short list of codes down — the half dozen your firm uses — and keep it with the sheet. When a new bill shows a code not on the list, that is a flag to check the bill, not to invent a code on the fly.
Do this setup once and imports turn dull, in the best way. The match screen stops throwing flags. The preview looks right at a glance. Dull is what you want from a weekly job: the same steps, the same result, no drama.
Bills you pay vs invoices you send
QuickBooks keeps two kinds of these papers, and they are not the same. A bill is money you owe a vendor — it sits in what you pay out. An invoice, in QuickBooks talk, is most often money a client owes you — it sits in what you take in. This guide is about the first kind: supplier bills you must pay.
The split counts. Put a supplier bill in as a sales invoice and your books show income you will never get, while the real debt hides. The columns look alike, which is why the slip is easy. Check the kind before you import: if your firm must pay it, it is a bill, and it goes in through the bill path.
One limit to know if you are in the US: on US plans, the batch bill import sits on the top plan. On lower plans, you add bills one by one, or upload the bill files and let QuickBooks draft them for review. The sheet still earns its keep on those plans: you check and fix the data in the sheet first, so each bill you add by hand is right the first time.
The sales side has its own shape. A sales invoice names a client, not a vendor, and its rows are what you sold, not what you bought. If you send many invoices built in a sheet — a trade firm with set rates, say — the import craft is the same, but pick the sales import in QuickBooks, not the bill import. Two doors, alike but not the same. The sign on the door is the kind of paper in your hand.
Then import the file into QuickBooks
Save the sheet as an Excel or CSV file. In QuickBooks, go to the import tool for bills or expenses, pick your file, and match each column to its field. The app shows a preview before it saves. Read the preview with care. If a column is matched wrong, fix the match, not the data.
On the match screen, go column by column. QuickBooks reads your first row as the names of the columns, not as data. If your sheet has no name row, the first bill will be lost to the match step. Our preset adds the name row for you. If you built the sheet by hand, add a name row at the top before you import.
Start with one bill the first time. Check it lands right in QuickBooks. Then do the rest in one go. This slow first step saves a big clean-up later.
When the import fails: three fixes
Imports fail in a few known ways. Most take a minute to fix once you know the cause.
| What you see | Likely cause | The fix |
|---|---|---|
| Vendor not found | The name differs from the one on file | Add the vendor first, or tick the box to add new ones |
| Dates land wrong or blank | Dates saved as text, not dates | Set the cells to date form and save again |
| Bills merge into one | Two bills share one bill number | Give each bill its own number, as printed |
| A row is skipped | A must-fill cell is blank | Fill the account and the row sum, then re-import |
Fix the sheet, not the books. It is far easier to fix a row in Excel and import again than to hunt a wrong bill inside QuickBooks. Keep each import lot small while you learn: a bad lot of five bills is a shrug, a bad lot of five hundred is a weekend.
Tips that keep imports clean
- Use the same vendor name each time. “Acme Ltd” and “Acme Limited” look like two firms to the app.
- Check totals before you import. A bill that fails its math check will fail in your books too.
- Import in small lots, like a week at a time. Small lots are easy to check and easy to undo.
- Keep the source PDF. If a sum is ever in doubt, the PDF is the proof.
- Watch for twin bills. If a vendor sends the same bill twice, the import will not warn you — your own check for the same number must.
Most import pain comes from messy source data, not from the app. Clean rows in means clean books out.
That last tip — keep the PDF — grows into a records habit that pays off at tax time. The sheet is your working copy; the PDF is the proof. For the full case on which to keep and how, read why Excel beats PDF for keeping invoice records.
Quick questions
Can I do this with bills I send, not bills I pay? Yes — the sales side has its own import, with much the same columns. Keep the two flows apart: bills you pay go in as bills, bills you send go in as sales invoices. The column craft in this guide — one fact per cell, real dates, own numbers — holds for both.
What if a vendor is brand new? QuickBooks can add new vendors as part of the import if you tick the box, or you can add the vendor first by hand. Adding first is the safer path for a big vendor: you set the name, terms, and tax facts once, the way you want them, and each bill then lands on the right record.
Do I lose the PDF when I import? No. The import reads your sheet; the PDF stays on your disk as the source. Keep the two side by side in one folder per month. If a sum is ever asked about, you open the PDF and the sheet and show both. That pair is the whole audit trail.
How many bills can one file hold? Intuit caps a sheet at under 1,000 rows and asks you to split big files. In real work you will not come close: a week or a month of bills for a small team is tens of rows per bill at most. Small lots are not a limit here — they are the method.
What if I import the same file twice by mistake? QuickBooks will bring the bills in again; it does not know they are twins. That is why the bill-number check is yours to run. Before each import, scan your sheet for a number you have sent in before. One sort by vendor and number shows twins at a glance. Catch them in the sheet, where the fix is a delete key, not in the books.
Can I undo an import that went wrong? There is no one-click undo for a set of bills. You can delete bills one by one, which is slow pain on a big lot — one more case for small lots and a one-bill test at the start. If the lot was small, the undo is small. Treat the first import of any new sheet shape as a test, no matter how sure you feel.
Your next step
Convert one real bill with the QuickBooks preset and import just that one. Once it lands right, the rest is fast. If your team also uses Xero, read how to upload supplier bills to Xero. For bigger teams and more pages, see the pricing plans.
Give the import a fixed slot — say, each Friday — and it stops being a chore that piles up. Bills go in while the facts are fresh, vendors get paid on time, and your books stay a true picture of what you owe.
One last word on pace: a calm ten-minute import each week beats a frantic three-hour fix each quarter, in cost and in truth. The books are a tool you steer by. Keep them fed with clean bills, a few at a time, and they will tell you the truth back.
Sources and further reading
- Common questions about importing data to QuickBooks Online — Intuit answers the import questions that come up most, like file types, row caps, and which plans can import bills in the US.
- Enter bills in QuickBooks Online — Intuit's step-by-step for adding bills by upload or by hand, so you can see where an imported bill lands and how to check it.