Overview
This article provides a detailed overview of how Ramp integrates with QuickBooks Desktop, covering the syncing of transactions, bills, reimbursements, and statement credits. It explains how Ramp handles various types of transactions in QuickBooks Desktop, including cashback redemptions, creating bills, and managing negative transactions. Additionally, it provides setup instructions and answers to common questions, ensuring effective financial management through seamless integration.
Jump to:
- Overview
- What Ramp Looks Like
- Transaction Syncing
- Vendor Management
- Setup
- How Transactions Appear in QuickBooks Desktop
- How Reimbursements Appear in QuickBooks Desktop
- How Bills Appear in QuickBooks Desktop
- How Statement Payments Appear in QuickBooks Desktop
- How Cashback Redemptions Appear in QuickBooks Desktop
- Handling Negative Transactions
- What fields does Ramp support for QuickBooks Desktop
- FAQs
What Ramp Looks Like
Here’s how the QuickBooks Desktop Accounting page appears on Ramp. For detailed information about settings, rules, and additional automations provided by Ramp, refer to the linked article.
Transaction Syncing
- Transactions: Transactions synced from Ramp appear in QuickBooks Desktop as credit card charges.
- Reimbursements: Reimbursements are synced as bills, with each reimbursement coded to a specific user. Ramp automatically creates a vendor for each user, syncs the bill to that vendor, and creates a bill payment to pay the bill automatically. This improves upon the IIF method, which required manual matching of payments to bills.
- Bills: created in Ramp are synced as bills in QuickBooks Desktop, with support for multi-line item bills. Ramp also supports coding inventory items on bills, improving upon the IIF method.
- Statement Payments: These are synced as a transfer of funds in QuickBooks Desktop.
- Cashback Redemptions: Synced as a direct journal entry which includes a debit and credit in QuickBooks Desktop. Cashback redemptions are categorized under an income account in QuickBooks Desktop.
Vendor Management
- Vendors: When creating a bill for a new vendor in Ramp, if the vendor doesn't already exist in QuickBooks Desktop, Ramp will automatically create the vendor in QuickBooks Desktop. For credit card transactions without a matching vendor, Ramp creates a vendor using the merchant's name.
Setup
Please follow these steps to link QuickBooks Desktop to Ramp.
Key terms to know:
-
QuickBooks Company File (.qbw): Stores all your customers, accounts, vendors, and transactions. It can reside on a single computer or a shared network folder.
-
QuickBooks Web Connector: A tool that facilitates communication between QuickBooks Desktop and web services like Ramp. If you don't have it, you can download it here.
-
QuickBooks Desktop Instance: The actual QuickBooks Desktop application running on your computer or a remote desktop.
-
Remote Desktop Hosting (e.g., RightWorks/Ace Cloud Hosting): A service that allows you to access QuickBooks Desktop via a remote server. Specific setup steps may be required if you're using one.
-
Integration Partner (Conductor): Ramp's trusted partner that assists with the integration process. You'll receive a link from them during setup.
To ensure a smooth setup, please prepare the following:
1. Check QuickBooks Versions Installed
-
Verify Installed Versions:
- Go to Control Panel > Programs and Features (or Uninstall a Program).
- Look for QuickBooks Desktop in the list.
- Important: Only one version of QuickBooks Desktop should be installed. If you have multiple, please uninstall the older versions.
2. Determine the Number of Company Files
-
How Many Company Files Do You Have?
- Each company file represents a separate business entity.
- Note: Ramp connects to one QuickBooks company file per Ramp account. If you have multiple company files, you'll need to set up separate Ramp accounts for each. In this case, our QuickBooks Desktop IIF integration will be more suitable for you.
3. Identify How You Access QuickBooks
-
Do You Use a Remote Desktop or Local Computers?
If You Use a Remote Desktop:
- Who Set It Up? Often managed by an external IT service.
- Is It Hosted by RightWorks? If yes, you'll need to follow these steps during setup.
- Access to Web Browser: Ensure you can use a web browser on the remote desktop.
- Availability: The remote desktop should be online as much as possible, ideally 24/7.
If You Use Local Computers:
- How Is the Company File Shared? Common methods include shared network drives or services like Dropbox.
-
Multiple Users Syncing Data: If more than one person will sync data, the file path (e.g.
Q:Users/Documents/QuickBooks/MyCompanyFile.qbw) to the company file must be identical on all computers.
How Transactions Appear in QuickBooks Desktop
Ramp card transactions are synced as credit card charge in QuickBooks Desktop. Ramp automatically fills all fields on the credit card charge form, linked to the credit card transaction coded within Ramp. To locate a synced transaction -> Navigate to Banking -> Click Use Register -> Select Ramp Card -> Identify the transaction that was synced.
How Reimbursements Appear in QuickBooks Desktop
Reimbursements are synced as bills for easy tracking. To locate a synced transaction in QuickBooks Desktop, navigate to Banking → click Use Register → select the A/P account used in Ramp → identify the synced transaction.
How Bills Appear in QuickBooks Desktop
Bills created in Ramp are synced as bills in QuickBooks Desktop, including support for multi-line item bills. All fields on the bill form linked to the transaction coded in Ramp are automatically populated. To locate a synced transaction in QuickBooks Desktop, navigate to Banking → click Use Register → select the A/P account used in Ramp → identify the synced transaction.
How Statement Payments Appear in QuickBooks Desktop
Statement payments are synced as a transfer of funds in QuickBooks Desktop. To locate a synced transaction -> Navigate to Banking -> Click Use Register -> Select Ramp Card -> Identify the transaction that was synced.
How Cashback Redemptions Appear in QuickBooks Desktop
Cashback redemptions are synced as a direct journal entry which includes a debit and credit in QuickBooks Desktop. These are typically categorized under an income account. To locate a synced transaction -> Navigate to Banking -> Click Use Register -> Select Ramp Card -> Identify the transaction that was synced.
Handling Negative Transactions
Ramp allows for the syncing of transactions with negative amounts in QuickBooks Desktop. These transactions can be split across different accounts.
FAQs
What fields does Ramp support for QuickBooks Desktop integration?
Ramp supports Accounting category, Class, Customer / Job, and Item (supported on Bills only).
What status will a transaction from Ramp have when it is synced to QuickBooks Desktop?
Transactions synced from Ramp appear as credit card charge in QuickBooks Desktop. They will be in a state ready for review or further processing.
What versions of QuickBooks Desktop does the integration support?
Ramp supports every version, variant, and edition of QuickBooks Desktop since 2018, including:
- QuickBooks Enterprise Solutions - any version or year Any edition: Accountant, Contractor, Manufacturing and Wholesale, Nonprofit, Professional Services, Retail.
- QuickBooks Premier (Plus) - 2018 or later
Any edition: Accountant, Contractor, Manufacturing and Wholesale, Nonprofit, Professional Services, Retail. - QuickBooks Desktop Pro (Plus) - 2018 or later
- QuickBooks Accountant Desktop (Plus) - 2018 or later
Why does Ramp sync transactions as credit card charges?
Ramp syncs transactions as credit card charges to align with QuickBooks Desktop's best practices for recording expenses.
How does Ramp sync receipts?
For transactions, reimbursements, & bills receipts we will sync over a url link to the receipt in Ramp in the memo field. We are not able to sync over a PDF directly due to a limitation in the QuickBooks Desktop API.
Does the Ramp & QuickBooks Desktop integration support Procurement?
Currently, there is no plan to support procurement. Please reach out to your Account Manager to provide feedback.
How does Ramp handle vendor names in QuickBooks Desktop?
QuickBooks Desktop has a character limit for vendor names (41 characters). If a vendor name exceeds this limit, Ramp will sync a shortened version of the name.
How does Ramp handle Multi-Entity QuickBooks Desktop companies?
Ramp does not support Multi-entity for QuickBooks Desktop companies through a single Ramp instance when using the API. For each QuickBooks Company File within your QuickBooks Desktop account, you will need a separate Ramp instance. You will be able to navigate across each Ramp instance by leveraging unified login. However, you can use a single Ramp instance with our QuickBooks Desktop IIF export integration.
Does Ramp support QuickBooks Desktop data hosted by Rightworks?
Yes, we do support Rightworks.
Does QuickBooks Desktop API support the match transactions to open bills feature?
Yes, it does, for more information on this feature please review Match transactions to open bills.
Does QuickBooks Desktop API support syncing an invoice PDF from Ramp to QuickBooks Desktop?
No, we do not currently support this functionality.
Does QuickBooks Desktop API support class tracking?
Yes, we do support classes.