Syncing Reimbursements

Modified on Tue, Sep 23 at 3:36 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.

Getting Started

To begin, first ensure you have reimbursements in Ramp that are ready to sync.

These can be viewed under Accounting --> Reimbursements

Pull Transactions into Ramp for FE

To sync Reimbursements from Ramp, first access the Ramp for FE syncing console and navigate to Sync Transactions --> Reimbursements

Once there, click on Get Latest Data from Ramp. This will retrieve all reimbursement transactions and update the grid with the results.

NOTE: This will only pull reimbursements that are sitting in Accounting --> Reimbursements in Ramp.

Once you have clicked on Get Latest Data from Ramp, you can navigate away from the page or close the browser tab while you wait for the transactions to populate in the grid.

Review the Transactions

Once the transactions have been successfully pulled into the syncing console, the grid within Ramp for FE will be populated. From here you will be able to see the transactions that have been pulled in:

Selecting All or Some Transactions

By default, all transactions will be selected for syncing.

Optionally, you may uncheck this box and only sync a subset of transactions.

Syncing Errors

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

Errors may be:

Missing information
Date out of range for the open batch in FENXT

Completing the Sync

Once you are ready to sync the transactions to FENXT, click the Sync Reimbursements to Financial Edge NXT.

Ramp 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