Syncing Reimbursements

Modified on Mon, Jun 9 at 2:19 PM

Overview

Transactions can be synced from Ramp to FENXT from the “Sync Transactions” section of the portal.
Once a transaction is synced, the status is updated in Ramp.
Transactions that are available to be synced are shown in Ramp under the Accounting section and related transaction areas.

NOTE: If you have multiple Ramp accounts mapped to different FENXT databases, it's recommended you re-authorize Ramp and FENXT connections from the API connection section or use the ‘authorize’ buttons shown on the page before initiating the syncing process.

NOTE: Please be sure to review the export settings (noted below) before syncing transactions.

Syncing Reimbursements

Reimbursement transactions will be available to be synced from Ramp to FENXT if they are in the “Read to Export” stage.

To sync reimbursement transactions, click on the “Get Latest data from Ramp” button. This will retrieve all transactions and update the grid with the results. Once completed, you can click on the “Sync Reimbursements to Financial Edge NXT” button to push the transactions to FENXT.

Syncing errors are displayed in the grid for individual transactions. A summary is also displayed at the top of the grid of results.

Once completed successfully, the transactions are removed from the grid.

Export Settings - Reimbursements

The sync process will use the accounts payable account specified in Ramp. The Account ID field should contain the full account number. If this field is empty, the syncing process will use the account specified in the settings area of the portal.

Key Mappings

Since reimbursements transactions are grouped by employee into a single invoice for the period (based on when the syncing is occurring), the system uses the following rules to set the invoice date, due date, and posting date in FENXT.

FENXT: Invoice Date = minimum date (Ramp: Accounting date if this null then use Ramp: Submitted Date) for all reimbursement lines for the employee vendor.

FENXT: Posting Date = minimum date (Ramp: Accounting date if this null then use Ramp: Submitted Date) for all reimbursement lines for the employee vendor.

FENXT: Due Date = maximum date (Ramp: Accounting Date if this null then use submitted date) for all reimbursement lines for the employee vendor.

NOTE

Minimum Date = oldest date

Maximum Date = newest date