Don't get lost: IMan Guides » Concur Connector Guide » 2. Setup » b) Concur » v. File Export Configuration

File Export Configuration

Configure File Export function to ensure the correct data is available for IMan to correctly populate Sage.

IMan uses webservices to obtain the file, so there is no need to download the file from Concur.

Select Format

  1. Select “Use a custom GL file format.”

Account String

  1. It is recommended that only the account code field is selected.

General Settings

  1. Include descriptive column labels at the top of the file.
  2. Delimiter must be a comma “,”
  3. Date format must be “yyyy-MM-dd”
  4. File Extension must be “.csv”

Define Header

  1. No Grouping
  2. No Header

Fields Details Fields

The following fields are mandatory for correct importing of data.

  1. Account Code
  2. Alpha Code
  3. Amount Company Paid
  4. Amount Due Company
  5. Amount Due Employee
  6. Claim ID
  7. Claim Payment Reimbursement Type
  8. Employee First Name
  9. Employee ID
  10. Employee Last Name
  11. Payment Code
  12. Payment Confirmed Amount
  13. Reimbursement Method
  14. Tax Adjusted Posted Amount
  15. Tax Code
  1. Any other fields used to track costs should also be included in the file.

Warning: Some combination of fields (typically when too many fields are selected) will cause the accounting extract to fail. Where this is the case it is recommended to reset the configuration and begin again.

Summary/Copy

  1. If all expenses will be accounted for through Accounts Payable and/or Payroll modules, copy the configuration to each of the Payment Batch types.
  2. Please consult the following section if some (or all expenses) will be accounted through the G/L or Nominal ledgers.

General Ledger/Nominal Only Imports

  1. Create an offsetting GL entry for each group of expenses
  2. Enter an offsetting account.
  3. Enter Tax Details on separate line.
  4. When at the Copy/Summary step, copy the configuration to each of the Payment Batch types where G/L only imports will be used.