Table of Contents
Step-by-Step Guide: How to Import Invoices into QuickBooks Online
Follow these steps to Import Invoices into QuickBooks Online safely. The exact screens may vary depending on your QuickBooks Online plan, region, and whether you use QuickBooks’ built-in import tool or a third-party importer.
Step 1: Open the import area
- Sign in to QuickBooks Online.
- Select the Gear icon.
- Look for Import data under the tools or settings area.
- Choose Invoices, if that option is available.
If you do not see an invoice import option, QuickBooks Online may not support native invoice importing in your version or region. In that case, use a trusted third-party app from the QuickBooks App Store or a migration service.
Step 2: Choose the invoice file
Upload your CSV or Excel file.
Before you continue, confirm that the file you choose is the final cleaned version. Do not upload a working draft with extra tabs, notes, filters, or formulas.
If you use a third-party app, select the transaction type as Invoice or Sales Invoice, depending on the app’s wording.
Step 3: Map your spreadsheet columns
Mapping tells QuickBooks where each spreadsheet column belongs.
For example:
| Spreadsheet Column | QuickBooks Field |
|---|---|
| Client Name | Customer |
| Invoice # | Invoice Number |
| Invoice Date | Invoice Date |
| Item | Product/Service |
| Unit Price | Rate |
| Line Total | Amount |
Take your time on this step. Mapping the wrong column can create incorrect invoices.
For example, if you map the invoice total to the rate field, QuickBooks may calculate the wrong amount when quantity is also included.
Step 4: Review customers and products/services
During import, QuickBooks may ask how to handle customers or products/services that do not already exist.
Be careful here.
If your file says ABC Co. but QuickBooks has the customer as ABC Company, QuickBooks may treat them as different customers. That can create duplicate customer records.
The same applies to products and services. If the item name in the spreadsheet does not match QuickBooks, the invoice may fail or the importer may create a new item, depending on the tool.
Step 5: Check the import preview
Most import workflows show a preview before the final import.
Review:
- Customer names
- Invoice numbers
- Invoice dates
- Due dates
- Products or services
- Quantities
- Rates
- Amounts
- Sales tax
- Classes or locations, if used
Do not rush through the preview screen. This is your best chance to catch mistakes before QuickBooks creates the invoices.
Step 6: Fix validation errors
If QuickBooks or your import app shows errors, stop and fix them before importing the full file.
Common validation errors include:
- Customer not found
- Product or service not found
- Invalid date format
- Missing invoice number
- Duplicate invoice number
- Blank amount
- Invalid tax code
- Unsupported special character
Fix the issue in your spreadsheet, save the file, and upload it again.
Step 7: Import a small test batch
Before importing hundreds of invoices, test with 2 to 5 invoices.
Choose a mix of examples, such as:
- One simple invoice with one line item
- One invoice with multiple line items
- One taxable invoice, if you charge sales tax
- One invoice with class or location, if used
After the test import, open each invoice in QuickBooks Online and compare it to the source file.
Step 8: Import the full file
Once the test looks correct, import the rest of the invoices.
For large files, use smaller batches. For example, import by month, customer group, location, or invoice number range.
This makes it easier to troubleshoot if something goes wrong.
Step 9: Save proof of the import
After the import finishes, save:
- The final spreadsheet file
- Any import confirmation screen
- Any error report
- The date and time of the import
- The user who completed the import
- The invoice number range imported
This documentation helps if you need to research an issue later.
Verify the Results
After you import invoices, do not assume everything is correct. Always verify the results inside QuickBooks Online.
1. Open a few imported invoices
Go to your sales transactions or customer records and open several imported invoices.
Check:
- Customer name
- Invoice number
- Invoice date
- Due date
- Line items
- Quantity and rate
- Total amount
- Sales tax
- Memo or message
- Class or location, if used
Compare each invoice to the original spreadsheet or source system.
2. Compare invoice totals
Run an invoice list or sales report for the imported date range.
Then compare the QuickBooks total to your source spreadsheet.
For example:
| Checkpoint | Source File | QuickBooks Online | Match? |
|---|---|---|---|
| Number of invoices | 150 | 150 | Yes |
| Total invoice amount | $48,250.00 | $48,250.00 | Yes |
| Taxable sales | $21,000.00 | $21,000.00 | Yes |
| Sales tax | $1,575.00 | $1,575.00 | Yes |
If the totals do not match, do not continue with payments or reconciliation until you find the difference.
3. Review customer balances
Open a few customer records and confirm the balances look correct.
This matters most if you imported open invoices. Each unpaid invoice should increase the customer’s balance.
If old paid invoices now show as unpaid, you may need to record payments, apply existing credits, or adjust your migration plan.
4. Check accounts receivable aging
Run an Accounts Receivable Aging report.
Look for:
- Old invoices that should not be open
- Customers with unexpected balances
- Invoices in the wrong aging period
- Duplicate invoice amounts
- Negative or unusual balances
Incorrect invoice dates or due dates can cause aging reports to look wrong.
5. Review income accounts
Imported invoice lines post to income accounts based on the product or service item.
If items were mapped incorrectly, revenue may appear in the wrong income account.
Spot-check sales by product/service or profit and loss reports to confirm revenue looks reasonable.
6. Check sales tax reports if applicable
If your business charges sales tax, review the imported invoices carefully.
Make sure:
- Taxable items are marked correctly
- Non-taxable items are not taxed
- Sales tax amounts look reasonable
- Tax agency reporting is accurate
Sales tax rules can be complex. If you are unsure, ask your accountant before filing a return.
Common Mistakes
Here are the most common mistakes people make when they import invoices to QuickBooks Online.
1. Importing paid invoices as unpaid
This is one of the biggest problems.
If you import old paid invoices but do not import or record the related payments, QuickBooks may show that customers still owe money.
Fix: Decide whether you need full historical invoice detail or only open unpaid invoices. If you import paid invoices, make sure you also handle the payments correctly.
2. Using inconsistent customer names
QuickBooks matches customers by name. Small differences can create problems.
For example:
- Smith Plumbing
- Smith Plumbing LLC
- Smith Plumbing, LLC
- Smith Plumbing Inc.
QuickBooks may treat those as separate customers.
Fix: Standardize customer names before importing.
3. Duplicating invoice numbers
Duplicate invoice numbers make it hard to track sales and payments.
They can also confuse customers if you send statements.
Fix: Check your file for duplicate invoice numbers before upload. Also review existing invoice numbers already in QuickBooks.
4. Mapping fields incorrectly
Mapping mistakes can cause major errors.
Common examples include:
- Mapping due date to invoice date
- Mapping amount to rate
- Mapping customer email to customer name
- Mapping product description to product/service item
Fix: Review the mapping screen slowly and test a small batch first.
5. Forgetting line-item structure
A multi-line invoice usually needs one row per line item. If the rows are not consistent, QuickBooks or the import app may create separate invoices.
Fix: Repeat the same invoice number, customer name, invoice date, and due date for each line that belongs to the same invoice.
6. Ignoring sales tax setup
Sales tax can fail or import incorrectly if QuickBooks is not set up before the import.
Fix: Confirm sales tax settings before importing taxable invoices. If tax treatment is complicated, speak with an accountant.
7. Importing products or services without checking accounts
Products and services control where income is reported.
If an item points to the wrong income account, your profit and loss report may be wrong.
Fix: Review product/service setup before importing.
8. Uploading too many invoices at once
A large import can be hard to fix if something goes wrong.
Fix: Start with a small test batch. Then import larger batches after you verify the results.
9. Assuming every detail will import
Not every import method supports every invoice detail.
Attachments, custom fields, discounts, shipping, classes, locations, multicurrency, and tax details may vary by tool.
Fix: Confirm what your import method supports before you start.
10. Not saving the final import file
If you need to troubleshoot later, the original upload file is important.
Fix: Save the final version of the file exactly as imported.
Best Practices
Use these best practices to keep your QuickBooks Online invoice import clean and reliable.
Start with clean data
Do not import messy data and plan to fix it later. It is usually faster to clean the spreadsheet first.
Remove:
- Blank rows
- Duplicate invoices
- Extra spaces
- Formulas
- Hidden rows
- Merged cells
- Unsupported symbols
- Unneeded columns
Use a test company or small batch when possible
If you have access to a test environment or sample company, practice there first.
If not, import a small batch into your live QuickBooks company and review it carefully before continuing.
Import by logical batches
Instead of one huge file, split invoices into groups.
Good batch options include:
- Month
- Quarter
- Customer type
- Location
- Department
- Invoice number range
- Open invoices only
Smaller batches are easier to review and correct.
Keep naming consistent
Use the exact names already in QuickBooks Online for:
- Customers
- Products/services
- Classes
- Locations
- Terms
- Tax codes, when applicable
Consistency prevents duplicate records and import errors.
Match totals before and after import
Always compare your source file totals to QuickBooks totals.
At minimum, compare:
- Invoice count
- Total sales amount
- Sales tax amount
- Customer balances
- Accounts receivable total
Keep an import log
Create a simple import log with:
- Import date
- File name
- Date range
- Invoice number range
- Number of invoices
- Total amount
- Person who imported the file
- Notes about errors or corrections
This is especially helpful for bookkeepers and accounting firms working with client files.
Do not import payments unthinkingly
Invoices and payments are different transactions.
If you import invoices first, payments may need to be entered or imported separately and applied to the correct invoices.
Always confirm how your import tool handles payments before you proceed.
Expert Tips
Tip 1: Import open invoices first
If you are migrating to QuickBooks Online, open invoices are usually the highest priority because they affect current customer balances.
Historical paid invoices can wait until you decide whether you truly need that level of detail.
Tip 2: Use invoice numbers from the old system when migrating
Keeping the original invoice numbers makes it easier to match payments, customer statements, and old records.
Before importing, check whether those invoice numbers already exist in QuickBooks.
Tip 3: Watch the invoice date and due date
The invoice date affects financial reports. The due date affects accounts receivable aging.
If either date is wrong, your reports may look inaccurate even if the invoice total is correct.
Tip 4: Review item income accounts before importing
The product/service item controls income categorization.
Do not wait until after the import to discover that all sales went to the wrong income account.
Tip 5: Be careful with discounts and negative lines
Some import tools handle discounts, credits, and negative amounts differently.
If your invoices include discounts, test those invoices separately before importing a full batch.
Tip 6: Do not assume QuickBooks Desktop import steps apply
QuickBooks Desktop and QuickBooks Online are different platforms.
QuickBooks Desktop may use migration tools, Excel imports, IIF files, or utilities. QuickBooks Online uses online import options or connected apps.
If you are moving from Desktop to Online, verify invoices after conversion instead of assuming every detail transferred perfectly.
Tip 7: Ask for accounting help before importing historical data
Historical invoices can affect income, sales tax, and accounts receivable.
If you are importing prior-year invoices, check with your accountant first. You do not want to accidentally change closed-period financial statements.
Frequently Asked Questions
1. Can I Import Invoices into QuickBooks Online from Excel?
Yes, you can import invoices from Excel to QuickBooks Online if your QuickBooks version or import method supports invoice importing. Many users prepare the file in Excel and then save it as CSV if required.
If QuickBooks Online does not show an invoice import option, use a reputable third-party import app that supports invoice transactions.
2. Can I import invoice CSV into QuickBooks Online?
Yes, a CSV file is commonly used for invoice imports. The CSV must be formatted correctly with columns such as customer name, invoice number, invoice date, product/service, quantity, rate, and amount.
Always test a small CSV file before importing a large batch.
3. Why did QuickBooks create duplicate customers after my invoice import?
QuickBooks may create duplicate customers if the names in your spreadsheet do not exactly match the names already in QuickBooks.
For example, Bright Star LLC and Bright Star, LLC may be treated as different records.
Clean and standardize customer names before importing.
4. Do imported invoices affect accounts receivable?
Yes. Imported unpaid invoices increase accounts receivable because they show money customers owe your business.
That is why you should be careful when importing old paid invoices. If payments are not also recorded or applied, customer balances may be overstated.
5. Can I bulk import invoices into QuickBooks Online?
Yes, you can bulk import invoices into QuickBooks Online using supported import tools or a third-party app. This is helpful when you have many invoices from Excel, CSV, a CRM, an eCommerce platform, or another accounting system.
For best results, import in smaller batches and verify each batch.
6. Will attachments import with my invoices?
Not always. Many invoice import methods focus on transaction data, not attachments.
If invoice PDFs, contracts, or supporting documents are important, confirm whether your import tool supports attachments before you start.
7. What should I do if the invoice import fails?
Read the error message carefully. Most failures happen because of missing customers, missing products/services, invalid dates, duplicate invoice numbers, blank amounts, or sales tax mismatches.
Fix the spreadsheet, save a clean copy, and upload again. If the error continues, try importing one invoice only to isolate the problem.
Key Takeaways
- Importing invoices saves time, but it must be done carefully.
- Customer names, product/service names, dates, invoice numbers, and amounts must be clean.
- Imported unpaid invoices affect accounts receivable and customer balances.
- Always test a small batch before importing a large file.
- Review the import preview before confirming the upload.
- Compare QuickBooks totals to your source file after the import.
- Use a third-party app if QuickBooks Online’s built-in tools do not support your invoice format.
- Be extra careful with sales tax, historical invoices, payments, classes, locations, and multicurrency.
Conclusion
Learning how to Import Invoices into QuickBooks Online can save hours of manual entry and help you move invoice data from Excel, CSV files, older accounting systems, CRMs, and eCommerce platforms.
The key is preparation. Clean your file, confirm customer and product/service names, review sales tax settings, map fields carefully, and test before importing a large batch.
After the import, verify invoice totals, customer balances, accounts receivable aging, and sales tax reports. A careful review now can prevent bigger cleanup work later.
Need Expert Help with QuickBooks?
Whether you’re importing data, fixing QuickBooks errors, migrating company files, or cleaning up your accounting records, our QuickBooks specialists are here to help.
- ✓ QuickBooks Data Import & Export
- ✓ Company File Migration
- ✓ QuickBooks Error Resolution
- ✓ File Cleanup & Repair
- ✓ Personalized QuickBooks Support
Save time, avoid costly mistakes, and get reliable QuickBooks assistance from experienced professionals.