This post is for those users that are importing bills or checks into QuickBooks using Transaction Pro Importer (“TPI”) that have multiple amounts all on the same line. By enabling either of the options below on the Advanced Tab you will see that additional 15 expense account related field are added to the TPI mapping screen.
To demonstrate how this works lets assume that a company pays vendors commissions but this company also gets a five percent referral bonus on each payment. Below is a sample of an import file that will be imported as checks.
You will notice that this import file does not contain the expense accounts so we provided them as static values on the TPI mapping screen.
After the import you will notice that a check is created with two expense lines in QuickBooks.
If you do not have a copy of TPI and would like to test this out you can request a free trial demo here. If you have any comments feel free to post them below.