Ramp Treasury Accounting

Overview

Speed up your reconciliation process by configuring the accounting sync settings for your Ramp Business account(s) and Ramp Investment account. Cash transfers and earnings payouts sync as journal entries in your connected ERP. Follow the steps below to get started.

Ramp Treasury supports the following accounting platforms:

• QuickBooks Online
• Netsuite
• Universal CSV (including IIF support for QuickBooks Desktop)
• Xero
• Sage Intacct

Accounting sync settings

If you haven’t connected Ramp to your accounting provider yet, please refer to the Overview of Ramp Accounting for more details.

If you already have an ERP connected (either directly or via UCSV), follow these steps to link accounts in Ramp to the corresponding ERP account:

1. Navigate to Accounting > Settings > Sync Settings > Treasury.
2. Select the appropriate GL account mappings for:
   1. Business Account(s): This account handles closed-loop deposits and withdrawals. A GL account is automatically created for you, but you can update or create a new account if needed.
   2. Earnings account: This account records earnings revenue from Ramp Business accounts. Select an existing account in your ERP or create a new one.
   3. Investment Account: This account records all buy and sell orders. Select an existing account in your ERP or create a new one. Only applicable if you opened one.
   4. Dividend account:This account records cash dividend from Ramp Investment account. Select an existing account in your ERP or create a new one.
   5. Linked bank account(s): This account is used for any funding account(s) linked to your Ramp Business account. Again, choose an existing GL account or create a new one.
      
      1. Reminder to add all accounts you have moved funds from/to and assign a GL account by clicking "Add another account".
3. Choose the sync frequency:
   1. Manual sync: Transfers are synced when you initiate them.
   2. Automatic sync (daily): Transfers are synced automatically on a daily basis.

Note that adjusting accounting settings does not affect the operation of your Ramp cards but affects how Ramp syncs transactions to your ERP system.

Manual Sync / Un-synced Transfers 

If you choose to sync manually, any unsynced transfers (those not started or that have failed) will appear in the table located at Accounting > Treasury in the left navigation bar. From this table, you can manually trigger the sync.

If a provider account mapping is missing, you will see “Configure to sync.” In this case, update the setting under Sync Settings > Treasury before attempting to sync your transfers.

Sync History and Failures

Use the Sync History button at the top right to view and download a CSV file. This CSV shows which transfers have been successfully synced and includes error messages for any failed sync attempts.

UCSV

For businesses using UCSV, you have the option to download a CSV of transfers instead of exporting them directly to your ERP. Downloading the CSV will mark the transfers as synced.

If necessary, you can mark these transfers as unsynced in the Sync History view. This will cause them to reappear in the transfers table.

What activities are synced? 

Activities Synced as Journal Entries

The following Ramp Treasury activity is synced as a journal entry to the ERP:

Ramp Business Account

• Deposit into Ramp Business Account
• Withdrawal from Ramp Business Account
• Earnings payout from Ramp Business Account (monthly)
• External deposits (i.e., deposits from a non-linked account, via wire or Real Time Payment)
• External withdrawals (i.e., Payroll)

Ramp Investment Account

• Buy order: Deposits into Ramp Investment Account from a Ramp Business Account
• Sell order: Withdrawal from Ramp Investment Account to a Ramp Business Account
• Cash dividends from Ramp Investment Account (monthly)

Regarding External Deposits and Withdrawals

1. The GL account of these transactions will not be filled automatically.
2. Select the appropriate category for external deposits and withdrawals within the Accounting > Treasury table before syncing.
3. When syncing external deposits and withdrawals within QuickBooks Online, you may need to select some additional required fields. 
   1. AP account: Select category for Quickbooks Vendor
   2. AR account: Select category for Quickbooks Customer/Job  
4. External payment activities are not yet supported for Sage (coming at Ramp speed). Filter for these activities within Treasury > Accounts > History and record them in Sage manually.  

Note that if you selected Automatic daily sync, external deposits and withdrawals are not synced automatically as additional category needs to be selected first.  

Treasury-Related Activities Synced by Other Ramp Products

The following other activities are synced by other Ramp products and will not show up under Accounting > Treasury tab:

• Bills paid from a Business Account: Synced under Bill Pay with Business Account as the source bank account
• Reimbursements paid from a Business Account: Synced under Reimbursement with Business Account as the source bank account
• Card statements paid from a Business Account (30-day and 1-day): Synced under card statement payment with Business Account as the source bank account
• Billing statements paid from a Business Account: Synced under billing statement payment with Ramp Business account as the source bank account

Activities Not Yet Synced to Your ERP

The following activities currently do not automatically sync into your ERP system and require manual handling:

1. DRIP Dividends (Reinvested Dividends)

• Dividends earned through the Ramp Investment Account that are automatically reinvested (via DRIP) are not synced.

• You will need to manually create journal entries for these transactions.

  • How to locate them:
    Go to Treasury > Accounts > History to find the relevant dividend records.

  • What to do:
    Record these transactions manually in your ERP system.

• Optional Configuration:
  You can change where dividend earnings are deposited:

  • Navigate to:
    Treasury > Accounts > Ramp Investment Account > All Time Earnings

  • Use the "Deposit dividends in" setting to choose between:

    • Business Account (cash) – for cash deposits

    • Investment Account (DRIP) – for reinvestments

2. Negative Balance Refunds

• If your Ramp bank account has a negative balance that results in a refund, this is classified as a bank refund.

• These types of transactions are not currently supported for automatic accounting in Ramp.

• Recommended action:

  • Create manual journal entries using data from your accounting provider’s bank feed.

Exportable Bank Feed (OFX)

This feature helps you reconcile Ramp Treasury activity on the bank side of your accounting systems. You can now export a standard OFX or a CSV file of all transactions from your Ramp Business Account(s). 

For ERPs

Go to Accounting > Treasury, use the clock icon to select your date range, then click the download icon and choose “Export to [Your ERP]” (e.g., QuickBooks, NetSuite, or Xero—this label updates based on your ERP connection). Then manually upload the OFX file to your ERP for reconciliation.

See Upload Bank Feed (OFX) to ERP systems for detailed instructions on how to upload OFX file to ERP system(s).

For UCSV 

Go to Treasury > Accounts > History, use the calendar icon at the top right to select your date range, click the download icon, and choose “Export (CSV).” If you wish to customize your CSV, click the download icon and select “Export settings” before downloading.  

Note that pending transactions and dividend reinvestments (DRIP) in the Investment Account will not show up in your bank feed.

Frequently Asked Questions

Is bank feed available?

You can now export a bank feed in OFX format from Ramp and upload it in your ERP systems. However, we do not yet support syncing via bank feed directly through integration.