Did you know that there are currently 19 options available on imports to QuickBooks Online using Transaction Pro Importer? Below we will discuss some reasons why you might want to consider implementing these options on your QuickBooks Online imports.
You can access all the options on the Preview and Import page. Look for the COG Wheel at the upper right of the Transactions to Import data grid.
When you select the options button you will see a screen displaying all the available options. Check the box next to those options that you wish to use and the select the save changes button at the bottom left. These options will be saved/retained for all your future imports.
So why would I need to select any of these options?
Enable Account Numbers on Transactions
By default Transaction Pro Importer assumes that you are using account names on any transactions that use general ledger accounts. If your import file contains account numbers include the lowest sub-account number only in your import file and be sure to select this option.
Below is an example of where to find the account number field in QuickBooks Online.
Let QuickBooks Auto-Assign Transaction Numbers
If you do not wish to use the transaction numbers that are in your import file but prefer to let QuickBooks Online use the next number in your QuickBooks Online company file you would select this option. This feature is available on the following transaction types:
- Credit Memos
- Estimates
- Invoices
- Journal Entries (Note: This is not supported in Intuit’s API read more here)
- Purchase Orders
- Sales Receipts
Do not automatically add new list items to QuickBooks Online
Transaction Pro Importer by default will create new list items like customer, vendors, products of services etc. when you are importing transactions if they do not already exist in QuickBooks Online. However, if you are importing data from another system that may have some issues with list data not being correct you might want to consider trying this option.
This option is available on the following lists:
- Accounts
- Classes
- Customers
- Items (Products and Services)
- Locations
- Sales Terms
- Payment Methods
- Vendors
Any questions on how this works take a look at this prior blog post.
Cross Reference for Customers and Vendors
In QuickBooks Online Customer and Vendors are organized by Name. Other databases or services that you may use may use an account number instead of a Name. Additionally, there might be formatting differences between the other system and QuickBooks Online as to how names are formatted so they are not an exact match.
By default Transaction Pro Importer will look for a matching name in the Display Name as field on the customer or vendor when importing sales or purchase transactions. However you can change this so that Transaction Pro Importer looks for a match in the following fields instead:
Customer – Exemption Details (field was previously called Resale Id) which can be found on the customer on the tab labeled Tax info
Vendor – Account no.
Any questions on how this works take a look at this prior blog post.
Express date format in dd/mm/yy
By default Transaction Pro Importer assumes your date is in Month/Day/Year format. However, if the dates in your import file are formatted in Day/Month/Year format you should select this option so your dates are properly created in QuickBooks Online.
We hope this post is helpful and that you will start exploring all the Transaction Pro Importer options. If you currently use any of these options please let us know how you are using them in the comments below.