Ramp Banking's Recommended Book Close Workflow

This article helps guide finance teams on Ramp Banking through month-end book close process.

Before you begin, make sure you have configured Ramp Banking sync settings. Head to Accounting > Banking >Settings> Sync settings to map your Ramp accounts to their corresponding ERP GL accounts. See detailed instructions here. Note that you may also need to configure GL account mappings for Bill Pay.

To ensure accurate and timely reconciliation at month-end, we recommend the following steps:

1. Sync Ramp Checking Account and Ramp Operating Account transactions into your ERP

• From Accounting > Banking, select transaction(s) and click “Sync”. Note: Employee repayments and negative balance refunds require manual entries within your ERP system.

2. Export and upload bank feed to your ERP for transaction matching

• If you’d like to match transaction data using bank-side records, go to Banking > Overview , select the desired Ramp Checking Account or Ramp Operating Account, scroll down to the transfer table
• Click the calendar icon to filter for last month (or a specific time period), then click the rightmost download icon to export bank feed.
  • There is a separate bank feed for each Ramp Checking Account and Ramp Operating Account.
• Upload the file(s) into your ERP (see detailed instructions here). The bank feed reflects all movements in and out of the selected Ramp Checking Account or Ramp Operating Account. Ramp Investment Accounts do not support bank feeds, so reinvested dividends do not appear in a bank feed. However, reinvested dividends are synced to your ERP in Step 1 and are represented in Ramp Investment Account monthly statements. Direct bank feed integration is available for QuickBooks Online, QuickBooks Desktop, NetSuite, Sage Intacct, Acumatica, Zoho Books, and Xero. See Ramp Checking Account Bank Feeds for setup details.

3. Use Ramp Banking Statements for reconciliation

• Download monthly statement(s) from Banking > Overview > Documents >Statements to ensure your ERP balances align with Ramp’s official records. This file is your official, immutable record of balance changes and can be used to tie out the GL at month-end.
  • There is a separate statement for each Ramp Checking Account, Ramp Operating Account, and Ramp Investment Account.

For UCSV, download a CSV from Banking > Overview, select the desired Ramp Checking Account or Ramp Operating Account, filter for a date range, customize the CSV columns in the table, and then click the download button. You can then upload this into your ERP.