Enabling vouchers from the supplier to be matched in the Automatic Reconciliation module

This topic explains how to enable vouchers from the supplier to be matched in the Automatic Reconciliation module.

• How

If you are in the process of creating a new supplier account, skip to step 3.

1. Search for the supplier account you want to edit.

2. Click the Edit icon in the row of the supplier you want to edit.

   The supplier account is displayed.

   

3. Open the Automatic Reconciliation expander.

   

4. Select Automatic Reconciliation.

5. In the table map the columns in the supplier's Excel file to Travel Booster fields.

1. Click Click here to add a new item.

2. In the TB Field column, select the field in Travel Booster. You can select Reservation, Travel File Number, Voucher Number, Ticket Number, Currency, Net to Remit, Commission, Tax, Amount, Supplier Invoice Number, Supplier Invoice Issue Date, Supplier Invoice Due Date, Supplier Invoice Vat Amount and Supplier Reference from the drop down.

3. In the Supplier Field column, enter the column in the supplier's Excel file to which the field should be mapped.

4. Repeat steps a-c for each column in the supplier's Excel file.

Click here for a detailed example. In the suppliers Excel files, the Travel File Number column is G. To map the column, in the table: Click Click here to add a new item. In the TB Field column, select [B] Travel File Number. In the Supplier Field, column enter G.

6. If there are header and footer rows that need to be excluded from the file that is being imported:

1. In the Start from line no. field, enter the row number where matching should begin.

2. In the End X lines before EOF field, enter the number of rows before the end of the file where matching should end.

7. Click Save and Exit.

Related links

• Setup - Business Environment - Supplier Accounts - New Item

• Creating a new supplier

• Setting up internet permits for a supplier