Transaction Pro Importer for QuickBooks Online on the Intuit App Center which allows you to import transactions and lists from excel or csv file into QuickBooks Online. You can sign up for a free trial and find out more here. I just wanted to write a short article to point out five advanced tips or features that you may not be aware of.
Power Tip #1: Customer and Vendor Cross Reference
It is not uncommon for the names in your QuickBooks Online company file to not match up to your other databases. Often times the other databases will use account numbers whereas for QuickBooks Online users will utilize a name. If this is the case just populate the account number in the resale number field on the customer information screen and the account number field on the vendor information screen. Read more here.
Power Tip #2: Update Existing Customers
What happens if you find that you need to update an existing field on a existing customer in QuickBooks? Lets say you want to add or update email addresses or the resale number on existing customers. Just create an import file that contains the customer name and the fields that you want to update. Read more here.
Power Tip #3: How to Import Deposits
Currently Intuit has not given developers access to import deposits into QuickBooks Online. What we suggest as a workaround is to create items on your products and services list in QuickBooks Online that match the account list and point these items to the correct account. Then select the import type of sales receipt and map the column that contains the account to the QuickBooks field, LineItem within the Transaction Pro Importer mapping. Read more here.
Power Tip #4: How to Import Fees on Paypal Transactions
When you download a file from Paypal the gross amount and the fees are listed on one line but within the Transaction Pro Importer you only have the ability to map one item per line. What you can do so that you can import both the gross amount and the fees is to utilize the shipitem and shipamount for the PayPal fees. This will work for any sales transaction where there are two items on the same line as well. Read more here.
Power Tip #5: How to Import Journal Entries from Payroll Providers
Most payroll providers provide an IIF file to be used for imports into QuickBooks. However, QuickBooks Online will not allow you to import IIF files as these files bypass all data validation. If your payroll provider cannot provide you with an excel or csv flat file you can easily just remove the header and footer row from the journal entry. Read more here.
If all else fails remember since you can import Excel files into QuickBooks Online you can easily use a host of formulas in Excel to manipulate the data.
What are you favorite options within Transaction Pro Importer? Do you utilize any Excel formulas? If so please share them in the comments below.