Search

Index

Revindex Storefront

QuickBooks

Last updated on 2021-04-12 3 mins. to read

QuickBooks is the world's most popular accounting and bookkeeping software for small and medium size businesses. You can easily export out your products, customers and invoices to load into QuickBooks.

The steps outlined below are for QuickBooks Online. You should be able to perform the same process for QuickBooks Desktop by following the instructions here.

Export Invoices

To export invoices, simply go to the Sales > Orders screen. QuickBooks limits the number of invoices you can import to 1000 invoices at a time. Therefore, it's a good practice to export out a subset of of your invoices regularly instead of accumulating for the entire year.

  1. Select the date range to export for the desired period.
  2. Choose the appropriate Order status. Typically, you want the "Ordered" or "Completed" orders.
  3. Once you have set your filter, click Search to list the qualified orders.


     
  4. Click Export view.
  5. In the Export dropdown, select "QuickBooks invoice".
  6. Click the Export button to download the CSV file.



     
  7. Login to your QuickBooks Online. Click on the gear icon to go to the Import data screen.


     
  8. Select Invoices.
  9. Select your file that you previously exported. Select the Add new contacts that don't already exist in QuickBooks and Add new product/services that don't already exist in QuickBooks.

    If you don't see the checkbox options, your QuickBooks account may not allow you to auto-create the customer and product records. You will need to import the customers and the products independently first (see instructions below on exporting customers and products).
  10. Click Next.


     
  11. Most if not all the column mappings should already match up by default. You only need to set the Invoice Date format to "YYYY-M-D" and the Item Amount to "Exclusive of tax" if prompted. If you don't see the "Exclusive of tax" dropdown, that means you can just go ahead and accept the default.
  12. Click Next.


     
  13. Match your tax classes with your QuickBooks tax codes. Hint: If your Storefront tax classes are configured with the same name, QuickBooks will match them automatically.
  14. Click Next.


     
  15. Make sure there are no errors and click Start Import to begin the import process.

Export Products

When you import invoices into QuickBooks, the products are automatically created for you. You are not required to import products separately into QuickBooks unless you want more granular accounting details.

To export products, go to your Catalog > Products screen.

  1. Click Export.
  2. In the Export dropdown select "QuickBooks product".
  3. Click the Export button to download the CSV file.
  4. Login to your QuickBooks Online. Click on the gear icon to go to the Import data screen.
  5. Select Products and Services.
  6. Select the file you previously exported.
  7. Click Next.
  8. Most if not all the column mappings should already match up by default. Click Next.
  9. Match up the Tax On Sales column with your tax codes. Hint: If your Storefront tax classes are configured with the same name, QuickBooks will match them automatically.
  10. Make sure the Price Incl Tax columns should all be set to "No".
  11. Click Import to begin the import process.

Export Customers

When you import invoices into QuickBooks, the customers are automatically created for you. You are not required to import customers separately into QuickBooks unless you want more granular accounting details.

To export customers, go to your People > Customers screen.

  1. Click Export.
  2. In the Export dropdown select "QuickBooks customer".
  3. Click the Export button to download the CSV file.
  4. Login to your QuickBooks Online. Click on the gear icon to go to the Import data screen.
  5. Select Customers.
  6. Select the file you previously exported.
  7. Click Next.
  8. Most if not all the column mappings should already match up by default. Click Next.
  9. Click Import to begin the import process.

 

Comments


Powered by Revindex Wiki