TXNDATE: This is the Date that will be assigned to the Bill. Otherwise, a column will need to be added to the import file to combine the Employee's first and last name together, as it appears in the Vendor list. See this article for more information about the cross-reference option.
The Employee ID can be entered into the Vendor Account Number field and used to cross-reference the Vendor (Employee) Name. VENDOR: This is a required field and will be the Employee that is to be reimbursed. If the data is selected is more than 21 characters, an additional column may need to be added or the Expense ID shortened to 21 characters. Therefore, it will need to be decided which data to use for the Reference Number that is unique for each transaction. With TPro for QBO, there is no truncate option. The Reference Number can be up to 21 characters. It is also the field that allows Importer to know where a transaction begins and ends, which allows Importer to group detail lines together that belong on the same transaction. It is the number (can be alphanumeric) that is assigned to the imported Bill in QBO. The suggested fields to map at minimum to import the expense reimbursement information from Concur are: Your import file column headers will be available on the dropdown menu for each field under the IMPORT COLUMN column.Īny data that is not in your import file, needs to be included in the import, and has the same value for all imported transactions can be entered as a default value under the DEFAULT VALUE column.įor the mapping shown below, the following sample data file is being used: The first column is to map the info that is in the import file. You can enter information in either column but never both. MATCH COLUMNS: On this window, you will tell Importer what columns in your import file contains what data for available QBO fields.Īny field that has a blue asterisk (*) is a required field that must either be included in your import file or have a default value assigned to the field.Įach field has two options for mapping. Therefore, select the workbook and worksheet combination that contains the data that you wish to import by clicking the SELECT SHEET button next to the correct one. You can only work with one worksheet in one workbook at a time. SELECT FILE AND SHEET: If your workbook has multiple worksheets (tabs) and/or if you have attached multiple files, you will see a list of the all available options to import. NOTE: If any changes are made to the import file after it has been attached to Importer, the file will need to be re-attached for Importer to recognize the changes.Ĭlick SELECT FILE AND SHEET in the lower right-hand corner to proceed to the next window. Importer can import any flat file format into QBO such as.
UPLOAD FILES: On this window, either DRAG AND DROP into the gray box your file to import or click in the gray box to BROWSE AND ATTACH your import file.
QUICKBOOKS FOR MAC REIMBURSABLE EXPENSE PRO
The following are instructions for importing the Concur Employee Expense Reimbursement Report into QuickBooks Online (QBO) using Transaction Pro Importer.Īfter downloading an Employee Expense Reimbursement Report from Concur, log into Transaction Pro and select to IMPORT.ĬHOOSE IMPORT TYPE: Select BILLS as your import type by clicking on the box, which take you to the next window. Concur Employee Expense Reimbursement Import into QBO
0 kommentar(er)
