QUESTION

If exporting from QuickBooks Online using Rightworks Transaction Pro Exporter and then importing the data back into a QuickBooks Desktop (QBDT)company file, all of the column names do not match exactly. Are there pre-defined maps that can be used for the process?

RESOLUTION

When the data is exported from QuickBooks Online using TPro Exporter, some of the column names do not match the field names on the mapping window of TPro Importer, causing the user to have to manually map some fields. However, Transaction Pro has created these maps in order to save time and minimize the chance of missed fields. 

Please locate and download the zip file attached this file under ATTACHMENTS (below article). The file contains a map for every import type that can be completed with Transaction Pro Importer into QuickBooks Desktop.

Some notes about the pre-definded maps for QuickBooks Online to QBDT:

• Any custom fields are not not part of these maps and will need to be mapped manually in TPro, if needed.
• Currency fields are not part of these maps and will need to be mapped manually in TPro, if using multi-currency in QBDT.

Other items to keep in mind when importing data into QBDT from QuickBooks Online:

• QuickBooks Online only has the option for one AR Account and AP Account. If using multiples of these accounts in QBDT, import files will need to be updated accordingly.
• QBDT does not have the option for Locations as does QuickBooks Online. Therefore, Locations and Classes may be combined by using Sub-Classes. If so, then the import file wlll need to be updated with the new Class prior to importing.
• For List Imports (Accounts, Customers, Employees, Items, and Vendors), only items with an active status are exported from QuickBooks Online.
• QuickBooks Online does not have the option of unit of measures. Thefore, if multiple unit of measures are being used in QBDT, import files will need to be updated prior to importing.
• Any Sales transaction with Sales Tax, the Sales Tax Item will need to be verified that it matches the Sales Tax Rate field that is exported from QBDT.
• If importing Sales transactions as E-Commerce mapping:
  • Discount Amount is mapped to Discount field in pre-defined mapping. If using Discount Rate, map will need to be updated.
  • If import Shipping, Handling, Discount, or Sales Tax, the correct item will need to be entered into the fifth window of Transaction Pro.
  • QBDT does not have the option to mark Discount as taxable or not when importing. It is decided by the Sales Tax setup in QBDT.
• Account List Import:
  • QBDT does not have Sub Account Types as does QuickBooks Online.
  • QuickBooks Online does not export the bank account number on any Bank General Ledger Account types. The bank account number will need to be manually entered into QBDT for these accounts.
• Bill Payment Import:
  • QuickBooks Online exports the Bank or Credit Credit Account in the same column. However, QBDT requires these fields be imported as separate columns. Therefore, the import file will need to be updated prior to importing to separate this data. 
  • A Payment Method is not exported from QuickBooks Online. Therefore, it will need to be manually entered into the import file or in QBDT after import, if needed.
  • Discount fields do not export from QuickBooks Online and will need to be manually entered into the import file or in QBDT after import, if needed.
• Deposit Import:
  • No Cash Back fields export from QuickBooks Online and will need to be manually entered into the import file or in QBDT after import, if needed.
  • TPro Desktop cannot import Deposits posted to Undeposited Funds. These type of Deposits will need to be manually posted in QBDT.
• Item Import:
  • The Item Type is not exported from QuickBooks Online and is a mandatory field. The import file will need to be updated prior to importing to include this information.
  • For the Type Bundle in QuickBooks Online, the detail does not export. It is best if Bundles (Group Items) are handled manually.
  • For Quantity on Hand, the amounts should be imported as an Inventory Adjustment type, and a pre-defined map for this is included with the other maps.
• Journal Entry Import:
  • Journal Entries export from QuickBooks Online with the debits and credits in the same column. Select this option in TPro Desktop before importing into QBDT.
• Refund Receipt Import:
  • QBDT does not have a transaction type of Refund Receipts. Best option is to imported as Credit Memo and then manually post credits to correct Bank Account in QBDT.
  • If not detail is needed, Refund Receipts can also be imported as Deposits.
• Time Activities Import:
  • Time Activities are to be imported as Time Tracking transaction.
  • No Payroll Item is exported from QuickBooks Online. This field will need to be updated in the import file prior to importing or a default value specified in TPro mapping.
  • Time Tracking in QBDT does not have the option to import Start and End Times. If these fields are in the file exported from QuickBooks Online, the import file will need to be updated to convert these into total time prior to importing.
  • If Hourly Rate is needed to be imported into QBDT, the command line code /TIME_RATE will need to be used. Read more about adding a command line code HERE.
• Transfer
  • No class is exported from QuickBooks Online and will need to be manually entered into the import file or in QBDT after import, if needed.