Import Invoice Template QuickBooks Online: Step-by-Step Guide

Katherine Jul 11, 2026

Streamlining your invoicing process is a breeze with QuickBooks Online, and importing invoice templates is a fantastic way to save time and maintain consistency. This step-by-step guide will walk you through the process, ensuring you're up and running in no time.

How to Create an Invoice in QuickBooks - Blog
How to Create an Invoice in QuickBooks - Blog

Before we dive in, make sure you have your invoice template ready. It should be in a compatible format, such as Excel or CSV. Now, let's get started!

How to Create an Invoice in QuickBooks Online
How to Create an Invoice in QuickBooks Online

Preparing Your Invoice Template

Before importing, ensure your template is well-structured and follows these guidelines:

How to import custom invoice templates in QuickBooks Online
How to import custom invoice templates in QuickBooks Online

1. Use the first row to label your columns with headers like 'Date', 'Customer', 'Item', 'Rate', 'Quantity', etc.
2. Each subsequent row should represent a separate line item on the invoice.
3. Save your file in either Excel (.xlsx) or CSV format.

Formatting Your Template for QuickBooks

How to create an invoice
How to create an invoice

QuickBooks Online uses specific columns to map your data. Here's how you should format your template:

1. 'Date': The date the service was performed or the product was delivered.
2. 'Customer': The name of the customer you're invoicing.
3. 'Item': The product or service you're billing for.
4. 'Rate': The price of the item or service.
5. 'Quantity': The number of items or hours worked.

Handling Taxes and Discounts

design quickbooks online custom invoice template by qbo_proadvisor  fiverr quickbooks online ...
design quickbooks online custom invoice template by qbo_proadvisor fiverr quickbooks online ...

If you need to include taxes or discounts in your invoices, you can add additional columns for 'Tax Code' and 'Discount'.

1. 'Tax Code': The tax rate applied to the line item.
2. 'Discount': The discount amount or percentage applied to the line item.

Importing Your Invoice Template into QuickBooks Online

How to Use Progress Invoicing in QuickBooks Online
How to Use Progress Invoicing in QuickBooks Online

Now that your template is perfectly formatted, let's import it into QuickBooks Online.

1. Log in to your QuickBooks Online account and navigate to the 'Sales' menu.
2. Select 'Invoices' and then click on the 'New' button.
3. Choose 'Import' from the dropdown menu.

QuickBooks Training - Customers and Accounts Receivable - Create an Invoice
QuickBooks Training - Customers and Accounts Receivable - Create an Invoice
7 Tips For Working Remotely For Freelancers
7 Tips For Working Remotely For Freelancers
how to copy an invoice in quickbooks online
how to copy an invoice in quickbooks online
Quickbooks How to Create an Invoice
Quickbooks How to Create an Invoice
Free Invoice Template  | Download for free
Free Invoice Template | Download for free
How to create an invoice with QuickBooks Online [Video Tutorial]
How to create an invoice with QuickBooks Online [Video Tutorial]
Invoice Template
Invoice Template
Invoice Templates Made Simple with Google Sheets
Invoice Templates Made Simple with Google Sheets
Never Late Payments Again: Ultimate Invoice Email Sample
Never Late Payments Again: Ultimate Invoice Email Sample
hands holding a clipboard with the title how to create an invoice in quickbooks desktop
hands holding a clipboard with the title how to create an invoice in quickbooks desktop
How to Customize Your Invoices in Dubsado
How to Customize Your Invoices in Dubsado
How to Create and Send an Invoice for Your Online Business
How to Create and Send an Invoice for Your Online Business
Free Invoice Generator for Small Businesses, Freelancers & Ecommerce Sellers
Free Invoice Generator for Small Businesses, Freelancers & Ecommerce Sellers
Free QuickBooks For Contractors Webinar
Free QuickBooks For Contractors Webinar
QuickBooks Tutorial: Unnaply Credit to Customer Invoice
QuickBooks Tutorial: Unnaply Credit to Customer Invoice
Modern Freelancer Workspace Canva Invoice Templates
Modern Freelancer Workspace Canva Invoice Templates
100 Free Invoice Templates | Print & Email Invoices
100 Free Invoice Templates | Print & Email Invoices
What is an Invoice? Definition + Free Templates | QuickBooks
What is an Invoice? Definition + Free Templates | QuickBooks
QuickBooks Tip:  How to Edit and Correct a Payment that is already Deposited
QuickBooks Tip: How to Edit and Correct a Payment that is already Deposited

Uploading Your File

1. Click on 'Browse' and select the invoice template you've prepared.
2. Ensure the 'File format' is set to 'Excel or CSV'.
3. Click 'Next' to proceed.

Mapping Your Data

QuickBooks will now prompt you to map your columns to the appropriate fields. Here's how:

1. Match the columns in your template with the corresponding fields in QuickBooks.
2. Click 'Next' once you've finished mapping.

QuickBooks will now import your invoices. Once complete, review them to ensure everything is correct. If you're satisfied, you can now send them to your customers. Happy invoicing!

Now that you've mastered importing invoice templates in QuickBooks Online, you can save time and maintain consistency in your invoicing process. Happy bookkeeping!