Concur Standard Imports to QuickBooks - Expense and Invoice

QuickBooks Desktop (Pro, Premier or Enterprise) > Transaction Pro Importer
Here are some tips and suggestions on how to get started:
 
In Concur:
Under the Accounting Setup be sure to select csv.
 
Most common import types:
 
 
Credit Card Statements (use if you have charges and credits make sure that the charges are expressed as negative amounts and credits as positive amounts - also note you do not need to use Aliases as the names and accounts are in your import file) http://blog.baystateconsulting.com/index.php/2012/04/04/import-credit-card-chargescredits-into-quickbooks-using-transaction-pro-importer/
 
Field and Record Selections on the First Screen of TPI:
Field:  Select Comma
Record:  Select CR/LF
 
 
Options to select:
As the Concur transaction id is much longer than what QuickBooks allows for the credit card transaction id be sure to select the option to "Truncate fields..."  under import options.
 
Mapping multiple fields to one QuickBooks field:
The Concur csv file has the employee name in two separate fields.  To combine these fields into one review this article:  http://blog.baystateconsulting.com/index.php/2010/11/01/how-to-use-the-static-valueformula-column-on-the-mapping-screen-in-transaction-pro-importer-for-quickbooks/

Add Feedback