Importing payments against expense reports

First, create a file to import with the following columns:

• External ID
• Internal ID of Expense Report
• Payee Internal ID
• Date
• Posting Date
• A/P Account
• Currency
• Exchange Rate
• Amount

Note: Payee Internal ID is the Internal ID of the employee in this example. You may add additional fields as columns if there are other mandatory fields that you need to populate in your Bill Payment transactions.

Then follow these steps:

1. Navigate to Setup > Import/export > Import CSV Records
2. Scan & Upload CSV File
3. Import Type: Transactions
4. Record Type: Vendor Payment
5. Select the file previously created
6. Click Next
7. Import Options
8. Data Handling: Add
9. Click Next
10. Field Mapping
11. A/P Account <-> Vendor Payment : A/P Account
12. Currency <-> Vendor Payment : Currency
13. Payee Internal ID <-> Vendor Payment : Payee (Req)
14. Exchange Rate <-> Vendor Payment : Exchange Rate
15. External ID <-> Vendor Payment : External ID
16. Posting Period <-> Vendor Payment : Posting Period
17. Date <-> Vendor Payment : Date (Req)
18. Amount <-> Vendor Payment – Bills : Payment
19. Internal ID of Expense Report <-> Vendor Payment – Bills : Bill (Req)
20. Click Next
21. Save mapping & Start Import
22. Import map name: Assign a name to the import performed
23. Click Save & Run

Field Mapping Screenshot:

Note: Make sure to choose Internal ID as the Reference type for Payee Internal ID and Internal ID of Expense Report.