Import Invoices into QuickBooks Online
Bulk import invoices from Excel, CSV, text or IIF files. Multi-line items, discounts, sales tax, terms and due dates come across, with no 100-invoice cap and no duplicates.
- Free plan, no credit card needed
- Multi-line invoices
- Preview before you post
Intuit Gold Partner
SOC 2 Type II audited
1,000+ Five-Star Reviews
Whole file, one run
Invoice 1043✓ Posted- Shipping4 × $12.50$50.00
- Packing2 × $8.00$16.00
- Discount 10%
- −$6.60
- Sales tax 8.25%
- $4.90
- Total
- $64.30
Bulk Import Invoices: QuickBooks Online without the 100-Invoice Cap
QuickBooks' own invoice import takes 100 invoices at a time, skips discounts, and stops when a customer or product isn't set up yet. Anything bigger or messier gets split by hand, or typed in one invoice at a time.
Autymate Transactions742Can QuickBooks Online Import More Than 100 Invoices?
Yes, with Autymate Transactions. QuickBooks Online's own import takes up to 100 invoices per file and leaves discounts out. With Autymate you import invoices into QuickBooks Online as one file, in one run: rows that share an invoice number become one multi-line invoice, discounts and sales tax map to your QuickBooks Online settings, and you preview every invoice before anything posts. Re-runs skip invoices already posted.
Invoices from Wherever They Live Today
Pick where your invoices come from. Each lands in QuickBooks Online with its lines, tax and terms.
- XLS/XLSX → Invoice
Excel
Invoice registers and billing sheets, any layout.
Import invoices from Excel to QuickBooks Online - CSV → Invoice
CSV
Exports from billing, POS, ERP or e-commerce systems.
Import from CSV - Sheet → Invoice
Google Sheets
A shared billing sheet. Download it as Excel or CSV and import it as is.
Google Sheets to QuickBooks Online - IIF → Invoice
IIF
INVOICE blocks from Desktop-era systems.
Import from IIF - PDF → Invoice
PDF invoices
Invoice PDFs read and turned into line items.
Import from PDF - TXT → Invoice
TXT & other delimited files
Tab, pipe or semicolon files from older systems.
Get Started for Free
- Sale → Invoice
POS systems
House accounts and B2B orders from your POS.
Talk to Expert - Order → Invoice
E-commerce
Wholesale and net-terms orders from your store.
Talk to Expert - Charge → Invoice
Billing & subscription tools
Recurring charges and usage billing.
Talk to Expert - Job → Invoice
Field service & jobs
Completed jobs and work orders.
Talk to Expert - Closed deal → Invoice
CRM
Won deals and signed quotes.
Talk to Expert - Custom → Invoice
Your own system
An app we don't connect to yet? Our custom integration team builds the connection.
Talk to Expert
Pick Up Invoice Files Automatically
Connect Google Drive, an SFTP folder or Amazon S3, and new invoice files are picked up and queued for your review. Or pull invoices from any system with a custom API.
- Google Drive
- SFTP folder
- Amazon S3
- Custom API
The Whole Invoice, Not Just the Total
Every field your customer sees, and every field your books need.
- Subtotal
- 132.00
- Discount 5%
- −6.60
- Sales tax 8.25%
- 5.64
- Total
- $131.04
Memo Nov wholesale run
Multi-line items
Rows that share an invoice number become one invoice with all its lines.
Products & services
Item, description, quantity, rate and service date per line.
Discounts
Line or invoice discounts, which QuickBooks' own import skips.
Sales tax
Taxable lines and tax codes mapped to your QuickBooks Online tax settings.
Terms & due dates
Net 15, Net 30 or a fixed due date, as on the original.
Invoice numbers
Your own numbers kept, so invoices match what customers received.
Classes & locations
Revenue tracked by location, department or brand.
Memos & messages
Customer messages and internal memos carried over.
Start Importing
Free plan, no credit card needed.
QuickBooks Online's Invoice Import vs Autymate
QuickBooks' built-in invoice import works for a short, clean list. These are the limits people hit next.
| QuickBooks Online invoice import | Autymate Transactions | |
|---|---|---|
| Invoices per import | Up to 100 invoices (1,000 rows) | Larger files, no manual splitting |
| Discounts | Not supported | Line and invoice discounts |
| Missing customers or items | Import stops; add them first | Flagged, then mapped or created |
| Sources | CSV, Excel, Google Sheets | Plus IIF, PDF, Google Drive, SFTP, S3 and APIs |
| Duplicates on re-run | No protection | Already-posted invoices skipped |
| Saved mappings & scheduling | No | Yes |
| Credit memos & payments | Separate, or not available | Import them next to your invoices |
QuickBooks Online limits from Intuit's help articles, checked November 2026. They can change by plan and region. Source: Intuit: Common questions about importing data to QuickBooks Online (opens in a new tab).
How to Set Up Your Invoice File
Use the file you already have. These habits make every invoice import cleaner:
One row per invoice line. Repeat the invoice number, customer and date on each line. That is how you import multiple line invoices. QuickBooks Online gets one invoice per number, with every line.
Keep invoice numbers unique. Two different invoices with the same number are treated as one.
Customer names as they appear in QuickBooks, including sub-customers (Parent:Child).
Rate and quantity, or amount. Autymate checks that qty × rate matches the line amount.
Turn on custom transaction numbers in QuickBooks Online if you want to keep your own invoice numbers.
Import Invoices CSV: QuickBooks Online Sample File
InvoiceNo,Customer,InvoiceDate,DueDate,Terms,Item,Qty,Rate,Taxable1043,Main St Store,11/03/2026,12/03/2026,Net 30,Shipping,4,12.50,Y1043,Main St Store,11/03/2026,12/03/2026,Net 30,Packing,2,8.00,Y1044,Oak Ave Store,11/04/2026,11/19/2026,Net 15,Printing,1,45.00,N- Invoice 1043Net 30Main St StoreShipping4 × 12.5050.00Packing2 × 8.0016.00Taxable$66.00
- Invoice 1044Net 15Oak Ave StorePrinting1 × 45.0045.00Not taxable$45.00
How Invoice Columns Map to QuickBooks Online
Autymate suggests the mapping from your headers. Change any field, set defaults, and save it for next time.
| Your column | QuickBooks Online invoice field | Notes |
|---|---|---|
InvoiceNo | Invoice no. | Groups lines into one invoice and stops duplicates |
Customer | Customer | Matched by name, including sub-customers; created if you allow it |
InvoiceDate / DueDate | Invoice date / Due date | Date formats detected and converted |
Terms | Terms | Matched to your QuickBooks Online terms list |
Item / Description | Product/Service / Description | Matched to your products and services list |
Qty / Rate / Amount | Qty, Rate, Amount | Totals checked before posting |
Taxable / Tax code | Sales tax | Mapped to your QuickBooks Online tax settings |
Discount | Discount | Percent or amount |
Location / Class | Location / Class | Kept when tracking is on in QuickBooks Online |
Memo / Message | Memo / Message on invoice | Carried to the invoice header |
How to Import Invoices into QuickBooks Online
Five steps, a few minutes for the first file. After that, saved mappings make it one upload.
Sign up for Autymate Transactions and connect your QuickBooks Online company with your Intuit sign-in. Autymate never sees your QuickBooks password.
QuickBooks Online connected as the destination, receiving invoices. Pick Invoices as the record type, then upload your file: Excel, CSV, delimited text or IIF.
Pick Invoice as the QuickBooks Online record type, then add your invoice file. Autymate matches your headers to QuickBooks Online invoice fields. Fix anything unmatched, like a customer spelled differently in QuickBooks Online.
Each QuickBooks Online invoice field, the column it takes, and the value it will get. See each invoice as it will appear in QuickBooks Online: lines, tax, discount and total. Problems are flagged before anything posts.
Every invoice before it posts, by number. Invoices that cannot be built are skipped, and nothing partial is written. Post to QuickBooks Online and check results by invoice number. Fix any held invoices and re-run; posted ones are skipped.
What posted, and what is held for review. Sample run.
Common Invoice Import Errors, Handled
What goes wrong in an invoice import, why it happens, and what Autymate does about it.
| Error | What causes it | How Autymate handles it |
|---|---|---|
| Customer not found | The name in your file doesn't match QuickBooks Online, often a sub-customer. | Suggests the closest match, or creates the customer if you allow it. |
| Product or service not found | The item on a line isn't in your products and services list. | Flags it so you can map it to an existing item or create it. |
| Duplicate invoice number | The number already exists in QuickBooks Online, or two invoices share one. | Skips invoices already posted and flags clashing numbers. Reuse numbers on purpose? Switch on Allow duplicate invoice numbers. |
| Line totals don't match | Qty × rate doesn't equal the amount column. | Holds the invoice and shows the difference. |
| Sales tax doesn't line up | Tax codes in the file don't match your QuickBooks Online tax settings. | Maps each code once and reuses it. |
| Over 100 invoices | QuickBooks' own import stops at 100 invoices a file. | Imports the full file in one run. |
Who Imports Invoices into QuickBooks Online
Businesses that bill in batches, and the bookkeepers who post those batches for them.
Wholesale & B2B sellers
Net-terms orders from a sales system or spreadsheet, billed in bulk.
Multi-location businesses
House accounts and B2B invoices from every location, tracked by class or location.
Bookkeepers & accounting firms
Client invoice registers in any format, with a saved mapping per client.
Service businesses
Completed jobs and billable hours turned into invoices at month-end.
Switching to QuickBooks Online
Open invoices from your old system, so A/R starts out right.
Franchise networks
Franchisee fees and charges invoiced in one run.
Import Invoices for Less
The same invoice-import job for a lower monthly price. Start free, no card required.
Free
Start here$0no card required- 1 location
- 200 rows a month
- Preview, undo and saved mappings
Standard
$19per location, per month- Unlimited rows and locations
- 30 runs a month
- Everything in Free
Every new account starts on Free, so you can post real invoices in your first session. Get started for free
| Autymate Transactions | SaaSAnt Transactions (Growth) | |
|---|---|---|
| Monthly price | $19/mo | $25/mo |
| Bulk invoice import to QuickBooks Online | Yes | Yes |
| Excel, CSV, Google Sheets & IIF | Yes | Yes |
| POS & app connections (Toast, Square, Clover…) | Yes | No |
| Get started | Start for Free | — |
SaaSAnt price from SaaSAnt's published Growth plan, checked November 2026. Prices may change.
Importing Invoices into QuickBooks Online
Yes. Autymate Transactions imports invoices into QuickBooks Online from Excel, CSV, IIF and other files, with multi-line items, discounts and sales tax. QuickBooks Online's own import also works, for up to 100 invoices at a time and without discounts.
Connect QuickBooks Online to Autymate Transactions, choose Invoices as the record type, upload your file, check the column mapping, preview the invoices, then post them. Save the mapping, and next month's file is one upload.
QuickBooks Online's own import stops at 100 invoices per file. Autymate has no per-file invoice limit and imports the full file in one run. The Free plan covers 200 rows a month; on Standard, rows are unlimited.
Yes. Put each line on its own row and repeat the invoice number, customer and date. Rows that share a number become one invoice, and each line keeps its own product or service, quantity and rate.
Yes. With Autymate you can import invoices with discounts. QuickBooks Online receives each line or invoice discount as a discount, and every tax code in your file is matched once to your QuickBooks Online sales tax settings, then reused. QuickBooks' own import leaves discounts out.
Yes. Turn on custom transaction numbers in QuickBooks Online and Autymate keeps the numbers from your file. Or leave the number out and let QuickBooks number each invoice.
No. Autymate matches the names in your file to your QuickBooks Online customers and products. A name it can't match is flagged, so you can pair it with an existing record or let the run create it. If two records match, it asks instead of guessing.
Nothing is posted twice. Autymate remembers every invoice it has created, so a re-run skips the ones already in QuickBooks Online and posts only what's new.
Yes. Import the open invoices from your old system so accounts receivable starts out correct, then record customer payments against them as they come in. Customer payments can be imported too.
Autymate Transactions starts free, with no card, one location and 200 rows a month. The Standard plan is $19 per location per month, with unlimited rows and 30 runs a month.
Yes. Roll back a whole run, or only the invoices you choose. Autymate deletes the invoices it created in QuickBooks Online and keeps a record of what it did.
Stop Typing Invoices in One at a Time
Bulk import invoices into QuickBooks Online today. Start free, no credit card needed.
- Create your free account
- Connect QuickBooks Online
- Upload your invoice file
- Intuit Gold Partner
- SOC 2 Type II audited
- 1,000+ Five-Star Reviews
QuickBooks OnlineSample✓ 737 posted5 held for review