Skip to main content
February 27, 2020
Question

How do I fix the multiple memos error when importing invoices?

  • February 27, 2020
  • 1 reply
  • 0 views
I'm importing invoices from QB Online Company to a new QB Online Company and our invoices have multiple lines with a different memo for each line - How do I fix this error when trying to import? Does the memo have to be the same for each line item?

1 reply

February 27, 2020

Hi there,

 

I can see how multiple errors can stop your progress. Don't worry, you've reached the right place for help.

 

QuickBooks Online lets you import multiple invoices at once so you can save time. I'll show you how.

 

What you can and can’t import

  • You can’t add discounts, credit memos, and negative amounts in general.
  • You can import a maximum of 100 invoices at a time and 1,000 row limit per spreadsheet.
  •  You can import invoices with single or multiple line items.
  • You can also import a large volume of customers and suppliers or products and services.

Step 1: Prep your spreadsheet

 

Before you import your invoices, make sure everything looks good in your spreadsheet.

  1. Fill in the required columns:
    • Invoice number
    • Customer
    • Invoice date
    • Due date
    • Item amount
    • Item tax code
  2. If you collect taxes, just add the tax rate in your invoices in the spreadsheet. When importing, you can map the tax codes you created into QuickBooks tax codes.
  3. You can map each of your column headings to the invoice fields during the import. Take a look at what's required to import invoices. Or you download this sample spreadsheet.

Note: If your spreadsheet has new products or services it can be edited after importing.

 

For more info on this, check out these helpful steps in this article: Import multiple invoices at once.

 

In case you have other questions, feel free to contact our support team using this link here.