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. Open Accounting > Banking, then select 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. Record Ramp Checking Account and Ramp Operating Account transactions in your ERP

• For direct accounting integrations, open Accounting > Banking, select the transactions, and click Sync. Note: Negative balance refunds require manual entries within your ERP system.
• For Universal CSV (UCSV), open Accounting > Banking, select the Ramp Checking Account or Ramp Operating Account transactions you want to export, and click Export. Review them in Review & export, then click Export CSV. You can then upload this into your ERP.

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
• Use Date to filter to Last month or Custom range. Select Export (download icon), then Export bank feed OFX.
  • 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. Reinvested dividends 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.