Make sure to confirm whether or not you need to include a title like LLC or INC.
Want your own invoice numbers to be imported? Turn on "Custom transaction numbers" in Accounts and Settings, or your invoice numbers will be replaced by standard QuickBooks invoice numbers.Ĭustomer: The customer must always be spelled consistently across your spreadsheet, and QuickBooks to avoid duplication. This invoice number must be unique and not match any invoice already existing in QuickBooks. Invoice Number: Use the invoice number to assign a unique identifier to each invoice. Check each of them for consistency and accuracy.
To ensure our data maps correctly in QuickBooks, we must take a few steps to ensure we have the 5 following required fields. Required fields for your data to import successfully to QuickBooks Online
Here’s an example of the most basic possible import for 10 invoices: This will make it easier to accurately organize the rest of your data. Next, remove data from your spreadsheet that you don’t want to be imported to QuickBooks. QuickBooks will allow you to define a mapping for data in your spreadsheet to data in QuickBooks, so the exact naming of your columns is up to you. Using the template can help reduce errors during the import process. Click here to view the template in Google Sheets and make a copyĭon’t be confused by the sample file, which shows multiple rows for each invoice- this is intended to demonstrate invoices with line item level detail, which is optional.Įither adjust your spreadsheet file or fill in the template with the data you’ve extracted using Invoice to Sheet.
Click here to install Invoice to Sheet from the Google Workspace Marketplace. To use Invoice to Sheet we need to have it installed first. We’re then going to import the contents of that spreadsheet into QuickBooks. To do this, we’re using Invoice to Sheet to extract the valuable information from each invoice and compile it into a single spreadsheet. Our goal is to import the data from all of our invoices into QuickBooks in the most efficient way possible. ? Step 2: Use Invoice to Sheet to extract structured data from your invoices Oh, and if you actually have printed invoices, just say no to the scanner and take a picture with your phone. Check out this article with time saving tips to help you find invoices in Drive more quickly. Need to navigate a labyrinth of Drive folders to find them? A couple tips and tricks can speed up your search. Getting invoices into your email so they can be extracted with Invoice to Sheet is easy. Still, I’m sure you have invoices hanging around somewhere besides your Gmail inbox. What to do when your invoices are stored in multiple locationsĮmail is great, isn’t it? I can’t remember the last time I received a printed invoice.