How to Export Financial Data into Quickbooks

Learn how to map account names and export Jazva financial data into Quickbooks.

Contents:

• Downloading the Export File
• Mapping Accounts Between Jazva and Quickbooks

Downloading the Export File

1. From the main menu, navigate to Financials > Export and click Quickbooks.
2. You can select one of two tabs, Sales or Amazon Settlement, depending on the export type you want to use:
• Sales Export - exports the financial information of your sales transactions.
• Amazon Settlement Export- exports the financial information of your Amazon Settlement transactions.
3. Enter a Date Range to export transactions for.
4. For Amazon Settlements, select an Amazon channel to export transactions for.
5. Click Export.

This will download an Intuit Interchange Format (.lif) file, supported by Quickbooks, which you can then upload to your Quickbooks Enterprise system.

Mapping Accounts Between Jazva and Quickbooks

Account names in your chart of accounts in Jazva may be different from your chart of accounts in Quickbooks. To ensure transactions are entered into the proper accounts, you may want to map them in Jazva.

1. From the main menu, navigate to Financials > Chart of Accounts and open the account you wish to map.
2. In the External Name field, enter the account name you use in Quickbooks.
   1. If the Quickbooks account is a sub-account of other account(s), type the full path from the root Quickbooks account to the account you want to map, separated by column, with no spaces. Please type capitalization and punctuation exactly as it appears in Quickbooks. For example: Sales:Online Sales:Books
3. Click Update.

Transactions for mapped accounts will now be linked accordingly in future exports.

Mapping Sales Tax Regions in Jazva and To Quickbooks Desktop Sales Tax Items

1. If you haven't done so, add your Jazva sales tax setup
   1. Go to Setup > Sales Tax,
   2. Choose (or create) the taxable country (USA)
   3. Add all the Tax Regions that your company has a physical presence in and therefore you collect sales tax on your orders (even if tax is calculated outside of Jazva).
      1. One location zip code per state is sufficient
2. Open your Jazva Quickbooks Desktop channel and open the Sales tax tab
3. Click Add Sales Tax Mapping on the right
   1. Map the applicable Jazva sales tax region to the respective Quickbooks Sales Tax Item
      1. as with account mapping, capitalization and punctuation must match your Quickbooks sales tax item. 
   2. Repeat this step for each applicable Jazva sales tax region so you cover all incoming orders that will have sales tax assessed.