Overview

We have a direct integration with QuickBooks Online that allows you to seamlessly integrate and push information from Ramp to QuickBooks to always keep an up to date and accurate account of spend on QuickBooks Online.  We also want you to have full control over what happens so we don’t change any settings on your QuickBooks Online instance.

 

When we sync over transactions, we sync them over as an expense.  Historically, other companies have synced credit card transactions through the banking tab, however this doesn’t allow us to send the valuable information that we gather on Ramp and in turn, doesn’t allow you to take full advantage of the automation tools that we’ve built for you.  For reimbursements, we send them as bills and settle them with bill payments.

 

We’ve also built some additional features to make the integration more robust.  

• Vendor creation: If we detect a vendor that isn’t on your QuickBooks Online instance, you will have the option to create that vendor within Ramp.  The vendor will show up in the QuickBooks Vendor column as “New:...” and by syncing it over, you will create the vendor.
• Receipt Attachment: the receipt within Ramp will sync over as an attachment to your QuickBooks instance.  If an employee uploads a receipt to a transaction after that transaction has been synced, we will automatically send that receipt over without you having to manually add it to your instance.

Jump to:

1. What it looks like
2. Setup
3. Transactions
4. Reimbursements
5. Bill Pay
6. Statement Payments
7. Cashback redemption

 

What it looks like

Below is what the QuickBooks Online integration looks like on Ramp after you set it up.  We will attempt to find the vendor for you by matching the vendor name on Ramp to the vendor names you have on QuickBooks so you don’t have to.  For more information on settings, rules, and other automations that Ramp offers, please reference this article.

Setup

To set up QuickBooks Online, please follow the below instructions:

1. Click on the Accounting tab on your Ramp Dashboard
2. Click on the QuickBooks Online option
3. Select Connect to QuickBooks
4. Enter your QuickBooks credentials
5. Select the QuickBooks company you wish to sync to
6. Back on the Ramp Dashboard, select the default accounts where Ramp will send your transactions and reimbursements. It's important to note that the default account to which you sync transactions MUST be a Liability and Credit Card type account in QuickBooks Online. If the default 'Ramp Card' account created is not a credit card liability account, you'll run into errors when you try to sync transactions (you can resolve this by changing the Ramp Card account to a credit card liability account within QuickBooks Online).

Note that we do not connect to QuickBooks Online through QuickBooks, which other companies do. Why?  If we connect through the banking tab, this doesn’t allow us to send the valuable information that we gather on Ramp and in turn, doesn’t allow you to take full advantage of the automation tools that we’ve built for you.

 

Transactions

We sync over transactions as an expense.  To find them on QuickBooks, go to Expenses > Expenses. 

Additionally, below is what a fully coded transaction will look like.  We can set Category, Vendor, Location, Customer, Class, Billable (Y/N) on Ramp and it will appear in the transaction as well as the memo and receipt, which comes through as an attachment (near the bottom of the screenshot).  The description is populated as the “first name + last name of the cardholder + memo”.

 

You also have the ability to split transactions across multiple fields.  The supported fields for splitting are the same as above excluding Location and Vendor.  The reason is that the location is at the transaction level while the other fields are at the category / expense line level.

Note: we do not yet support pulling in custom tags from Quickbooks Online. 

Reimbursements

For reimbursements, we sync across a bill and a bill payment (bill payment only if paid via ACH on Ramp).  You can also find these by going into Expenses > Expenses to look at individual Bills and Bill Payments or Expenses > Vendors to look at by Vendor.

Note: we create a vendor as the merchant for reimbursements.

 

In the image below, you can see a fully coded reimbursement paid via ACH and how it shows up on QuickBooks Online. On the top right, it is marked as paid.  The vendor, as seen below is “first name + last name of employee (email)”.  Other supported fields are Category, Location, Customer, Class, and Billable (Y/N).

 

Additionally, the date of the Bill is set to the Approval date (this is because we view the approval date as the day the company recognized the expense).

Below, you can find the corresponding bill payment with the date also equal to the approval date since it is when the ACH payment is initiated.

Bill Pay

With QuickBooks Online, you have access to our Bill Pay feature.  Please reference this article for more information.

 

Statement Payments

With QuickBooks Online, you can sync over statement payments.  This will appear in the Payments tab of the Accounting tab and only appears after it has cleared.

Cashback Redemption

The accounting for a cashback is a credit to the Ramp Card account, reducing the liability on the card, and a credit to a nominated expense or income account. This cashback entry does not appear on a bank feed so this entry is important to sync across to the Ramp Card account to bring the value of the liability back into balance with the statement.