Businesswoman providing feedback to her team.

QuickBooks partner profile: Fourlane guides Hotsy Pacific through a QuickBooks conversion and business process renovation

QuickBooks® Online Advanced has dramatically improved the invoicing process by adding a CSV import function. This new function is very powerful for companies that use a third-party point of sale or customer invoicing system. In Part 2 of our Accelerated Invoicing with QuickBooks Online Advanced user guide, we will focus on the best practices when importing invoice data into Advanced.

Part 2 of this two-part user guide will:

  • Compare recurring transactions and Advanced’s new accelerated invoicing.
  • Give an overview of the CSV Import function within accelerated invoicing.
  • Share important notes before importing your data.
  • Show how to access the CSV import option, including a step-by-step guide to complete the import.
  • Discuss third-party alternatives for invoice importing.

Recurring transactions

QuickBooks Online Advanced allows its users to transform a transaction into a memorized transaction for future use. These transactions can then be used whenever the need arises, or they can be scheduled to provide a reminder, or for automatic processing. This feature is extremely useful for businesses that have a recurring charge that does not change in price but may be different from customer to customer.

Companies that provide professional services, such as accountants, often use a recurring sales receipt to automate their monthly billing. Such a process requires the QuickBooks Online Advanced user to make a unique invoice per client for it to work correctly. Even if the accountant had numerous clients that had identical billing, recurring transactions require a specific customer name be assigned to each transaction. Depending on how often your client list changes it may be just as time consuming to maintain the recurring transactions each month compared to the time spent using Advanced’s new accelerated invoicing feature.

Accelerated invoicing

While recurring transactions make it possible to automate certain aspects of your invoicing it is limited by its need for a customer name before saving. Accelerated invoicing helps fill in this gap very nicely by making it possible to invoice multiple companies all at the same time.

QuickBooks Online Advanced provides two different methods to quickly create invoices:

  1. CSV import (download sample file here)
  2. Manually creating multiple invoices

Part 2 of our Accelerated Invoicing with QuickBooks Online Advanced user guide deals exclusively with importing multiple invoices via CSV files. Find more on manual multiple invoice creation, find Part 1 of this guide here.

How to access the CSV import feature:

Unlike the multiple invoicing feature, the only place to access the import function is directly from the Invoices tab after selecting Sales from the side menu. Once selected, a new window will be displayed where you can download a sample CSV file and an Import Guide.

Important notes before importing

Overall, the import process is very easy but there are a couple of important tips to follow to be more successful.

CSV File: The CSV file must include the following columns to be able to import:

  • Invoice Number
  • Customer
  • Invoice Date
  • Due Date
  • Item Amount

Products and services: Any products and services that are used within your CSV import must already be listed and active inside of your company file. If an item does not exist, you will receive an error notification.

Customers: If a customer does not already exist within your company file, QuickBooks Online Advanced can create a new customer for you by selecting the “Add New Customers to QuickBooks” checkbox. Be careful that all names listed in your import file are spelled correctly to avoid creating new customers by accident.

1000 Line Item Limit: QuickBooks Online Advanced allows CSV files that contain up to 1000 lines to import into their software. If your file has more than 1000 lines of data, it will be necessary to split the import into multiple parts.

Invoice Numbering: Custom transaction numbers can be used during the import process if the feature has been enabled within the company settings. Be careful not to accidentally create invoices with duplicate transaction numbers.

Get the latest to your inbox

Get the latest product updates and certification news to help you grow your practice.

By clicking “Submit,” you agree to permit Intuit to contact you regarding QuickBooks and have read and acknowledge our Privacy Statement.

Thanks for subscribing.

Relevant resources to help start, run, and grow your business.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Tax Pro Center

Expert advice and resources for today’s accounting professionals.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

How can we help?
Talk to sales 1-800-497-1712

Monday - Friday, 5 AM to 6 PM PT

Get product support