To import bills into QuickBooks Online, build a spreadsheet with one row per bill line holding the bill number, vendor, bill date, due date, expense account and line amount, then use Settings, Import data, Bills. Vendor names must match your vendor list. In the US, the bill import needs QuickBooks Online Advanced; other plans upload bill documents instead.
Which QuickBooks Online plans import bills from a spreadsheet?
In the United States, the spreadsheet bill import is limited to QuickBooks Online Advanced and higher tiers. Intuit's common questions about importing data says so directly and points other plans to the "Upload multiple bills" option on the Bills page.
Those two routes do different jobs. The spreadsheet import turns rows of data into bills. The upload option takes bill documents, such as the PDFs suppliers email you, and you review and save each one as a bill. If your bills already sit in a spreadsheet, perhaps exported from an old accounting system, the import is the faster route. If they arrive as paper and PDFs, the upload fits better.
Outside the US
Intuit's international help page on importing bills into QuickBooks Online describes the import for Essentials, Plus and Advanced, and calls vendors "suppliers." The columns and rules on that page are the same ones this post walks through. If your company is outside the US, check which plans in your region show Bills on the Import data screen.
Limits on a single file
The international page recommends no more than 100 bills in one import, and the US guidance caps a spreadsheet at fewer than 1,000 rows. A year of supplier bills will often need several files. Split by month so that a failed import only sends you back through one month of rows.
Bill import columns QuickBooks Online requires
A bill import file needs seven columns on every row: bill number, vendor, bill date, due date, account, line amount and line tax code. Intuit's international page marks all seven as mandatory. Every other column in the file is optional and can be left out.
What each column does:
- Bill no. groups lines into bills. Rows sharing a number become one bill.
- Vendor (shown as Supplier on international screens) names who you owe.
- Bill date is the date on the supplier's invoice.
- Due date is when payment is expected.
- Account is the expense or asset account the line posts to. It has to exist in your chart of accounts before the import.
- Line amount is the value of that line, zero or more.
- Line tax code applies a tax rate where tax is in use.
Keeping your own bill numbers
The supplier's invoice number is the most useful thing to put in the bill number column, because it is the reference the supplier will quote when chasing payment. Intuit notes that custom transaction numbers need to be switched on in your company settings for imported numbers to stick. Check that before the first file.
Items are not imported
The bill import works at account level. Intuit says product and service items are not imported, which means a bill import cannot raise inventory quantities. If you buy stock, record those bills through the normal bill form or an inventory-aware app so quantities update.
Splitting one bill across several expense accounts
A bill that covers more than one kind of cost takes one row per account. Each row repeats the bill number, vendor and bill date, then carries its own account and amount. QuickBooks combines the rows into one bill whose total is the sum of the lines. Even a one-line bill needs the account column filled.
Here is an example file with three bills. The values are made up for illustration.
| Bill no. | Vendor | Bill date | Due date | Account | Line amount |
|---|---|---|---|---|---|
| INV-5531 | Northside Property Mgmt | 05/01/2026 | 05/05/2026 | Rent | 2,400.00 |
| 88124 | Cobalt Utilities | 05/03/2026 | 05/24/2026 | Utilities: Electric | 312.45 |
| 88124 | Cobalt Utilities | 05/03/2026 | 05/24/2026 | Utilities: Water | 61.20 |
| A-2029 | Brightline IT Services | 05/04/2026 | 06/03/2026 | Software subscriptions | 189.00 |
Bill 88124 becomes one bill for 373.65 with two lines, one for electricity and one for water. The other two bills have one line each. Note that the account names match the chart of accounts exactly, including the colon that marks a sub-account.
Discounts and credits stay out
Intuit states that discounts and credit notes are not supported in the bill import, and a bill's total must be zero or more. If a supplier gave you an early-payment discount or a credit, import the bill at its full amount and record the vendor credit separately afterwards.
Vendor names in the bill file that match QuickBooks
Each vendor in a bill file must match a vendor already in QuickBooks Online, character for character. The import screen has a box to add vendors that don't exist yet. Ticking it in a company with an existing vendor list turns every typo into a new vendor, so leave it clear unless the company is new.
A two-minute check prevents most trouble. Export the vendor list, paste it into a second sheet of your bill file, and look up each vendor name against it. Names with no match need fixing, whether that's a missing "LLC," an ampersand that should be "and," or a stray space at the end.
If the vendor list itself is incomplete, load it before the bills. The guide to importing vendors into QuickBooks Online covers that list. A clean vendor list pays off twice: once here, and again when bank lines arrive and QuickBooks tries to recognize the payee.
Due dates on imported bills and what they drive
The due date on an imported bill decides when QuickBooks treats it as overdue. Unpaid bills are sorted and flagged by due date on the Bills page, and the accounts payable aging report groups them by how many days past due they are. A wrong due date hides an overdue bill or raises a false alarm.
Most suppliers print either a due date or payment terms such as "Net 30." If your source only has terms, calculate the due date in the spreadsheet before you import: bill date plus the number of days in the terms. A formula column does this for the whole file in one step, and you can paste its values into the due date column.
A due date trap
The commonest due date mistake is copying the bill date into the due date column because the real date was missing. Every bill then looks due on the day it arrived. Within a week the whole list shows as overdue, and the aging report stops telling you anything useful. Fill the real terms, even if that means a quick look at the original invoices.
Why would an imported bill be rejected?
Rejected bill rows usually have one of a few faults: an account that isn't in the chart of accounts, a vendor name with no match, a blank required cell on a second or third line, a negative amount, or a date in a format other than the one chosen during import. The summary screen lists the reason for each failure.
Run through this checklist on any failed rows:
- The account name exists in the chart of accounts, spelled the same way.
- The vendor name matches the vendor list exactly.
- Every line of a multi-line bill repeats the bill number, vendor and bill date.
- No line amount is negative and the bill total is zero or more.
- Dates use one format across the file, and it matches the format picked on the import screen.
- The file holds no more than 100 bills.
Retrying without doubling
After a partial failure, delete the rows that imported from your file before trying again. Uploading the full file a second time creates the successful bills twice. If duplicates slip through, delete the extra bills before any payment is recorded against them, because a paid duplicate is much harder to unwind.
Paying imported bills and matching the bank payment
An imported bill stays in accounts payable until you record a payment. When you pay a supplier, the money leaves your bank, and you match that bank line to the bill in QuickBooks Online. Matching marks the bill paid and records the cost once. Adding the bank line as a new expense would record it twice.
The sequence is the same however you pay. You can record the bill payment first and match the bank line to the payment later, or let QuickBooks suggest the bill when the bank line arrives. Either way, the cost appears once on the profit and loss, through the bill, and the bank line simply clears the payable.
For that matching to work, the bank lines have to reach QuickBooks. A bank feed brings them in automatically. If you only have PDF statements, SimpleBankConvert is being built to turn them into a file QuickBooks Online can upload, so each bill payment has a bank line waiting to match.
Estimates on the other side
Bills record what you owe suppliers. The customer-facing counterpart, before any sale is final, is the estimate. The guide to importing estimates into QuickBooks Online covers that file, and its layout will look familiar after this one.
Payroll and loan costs that don't belong in a bill import
A bill import suits supplier invoices with a due date. Payroll is not that. Wages, withheld taxes and employer taxes need their own accounts and, usually, their own records from the payroll provider. Loading a payroll run as a bill to the payroll company puts every cost on one line and loses the split between wages and tax.
Desktop users face the same question with different tools; the guide to importing payroll transactions into QuickBooks Desktop shows how that split is kept. For QuickBooks Desktop bills in general, see the guide to importing bills into QuickBooks Desktop.
Loan repayments are another poor fit. A single repayment mixes principal, which reduces the loan balance, with interest, which is an expense. A bill to the lender would post the whole amount to one account. Record repayments directly from the bank line with the two parts split, and keep the bill import for the supplier invoices it was built for.