Introduction
Our integration with Business Central allows you to easily transfer information from Ramp to Business Central, ensuring your spending data is current and accurate. We respect your Business Central settings, avoiding any changes or account creations.
When Ramp is connected to Business Central, it gathers all necessary data for classifying your transactions. Transactions and reimbursements are synced to general journals. Bills are synced to purchase invoices.
Additional features for a stronger integration include:
-
Vendor creation: For Bills, Ramp can identify and add new vendors not already in your Business Central instance. These vendors appear in Business Central's Vendor/Employee column as "New:..." and are created upon syncing.
-
Chart of accounts and dimensions: Ramp imports all fields, including dimensions, from Business Central to ensure comprehensive transaction coding.
-
Ramp reimbursement service: Ramp facilitates the ability for your company to pay back employees. We also allow you to code which employee a reimbursement is for.
Prerequisites
- Customers must have an active Ramp Plus account.
-
Customers need to have their Azure Admin for Microsoft Dynamics Business Central assist with setup. The Azure Admin will have the information needed to complete the below setup process.
- Note: on-premises deployments are NOT supported
Jump to:
What Ramp looks like
Here's how the Business Central Accounting page appears on Ramp. For detailed information about settings, rules, and additional automation provided by Ramp, please refer to the linked article.
Setup
Please follow these instructions to link Business Central to Ramp.
How will transactions appear in Business Central?
Ramp card transactions show up as unposted journal lines in general journals.
We will populate each credit card transaction as two journal lines:
- Credit Ramp card liability account
- Debit expense account
Additionally, if there is a receipt to attached to a transaction, then Ramp will sync this over as well. Receipt files will be synced as an "incoming document file" on the credit line of the transaction.
Finance > General journals > Select the journal you synced to. There will be two total lines and the credit line is denoted by the second line.
However, if a vendor or employee is selected on a credit card transaction, then we will populate four journal lines and the credit line is denoted by the fourth line:
- Debit expense account
- Credit vendor
- Debit vendor
- Credit Ramp card liability account
Finance > General journals > Select the journal you synced to
For customers using the BSSI Multi-Entity Management extension transactions will also include entity-specific general journal information. Specifically, each transaction will include an Entity header such as the example below where Department is included in the header to highlight these transactions are associated with the Prod entity.
How will reimbursements appear in Business Central?
Reimbursements from Ramp will show up as unposted journal lines in general journals.
We will populate each reimbursement as two journal lines:
- Credit Cash Account
- Debit Expense Account
Finance > General journals > Select the journal you synced to
However, if an employee is selected for a reimbursement, then we will populate four journal lines:
- Credit vendor
- Debit vendor
- Credit Ramp card liability account
- Debit expense account
Finance > General journals > Select the journal you synced to
Note: Any receipts attached to reimbursements will be synced as an "incoming document file" in Business Central.
How will bills appear in Business Central?
Bills from Ramp will show up as unposted purchase invoices. Additionally, we will include the invoice PDF attached to the bill as an "incoming document file" on the purchase invoice.
Purchasing > purchase invoices > select purchase invoice
Bill payments from Ramp will show up as an unposted vendor payment. The first time you push a bill payment from Ramp to Business Central a "Ramp" payment journal will be created. Additionally, in order to sync bill payments, you will need to select, in Ramp, a cash account for the bank account you will use to pay bills.
Note: Before a bill payment can successfully be synced, the initial unposted bill will need to be manually posted in Business Central.
Cash management > payment journals > "Ramp"
Additionally, to sync bill payments, you will need to select, in Ramp, a cash account from Business Central for the bank account you will use to pay bills.
Accounting > settings > default accounts > Bill Pay accounts
Note: If a user pays a bill "outside of Ramp", we do not sync a payment journal.
How will statement payments appear in Business Central?
Statement payments from Ramp will be synced to the Ramp statement payment journal. Furthermore, when a statement payment is synced it will populate as one journal line with the cash account being the balancing account.
This is what it will look like:
Frequently Asked Questions (FAQs)
Does Ramp support one Ramp account to multiple Business Central companies?
Ramp does not support one Ramp account to multiple Business Central companies. However, Ramp does support multiple Ramp accounts to one Business Central company.
Why doesn't Ramp auto-post the information that they sync into Business Central?
Users will still be required to click the "post" button in Business Central in order to push the journal lines to the general ledger. The reason behind this is that Business Central provides rich error messaging with posting that we are not able to replicate.
Does Ramp support Business Central dimensions?
Yes, Ramp supports dimensions when syncing transactions, reimbursements, and bill line items.
Does Ramp support Business Central Project General Ledger journals?
Yes, Ramp supports Project General Ledger Journals. Project General Ledger journals are a subtype of General journals. The only difference between Project G/L Journal and G/L Journal is that the Project G/L Journal will show the project details within the Business Central UI by default.
Ramp does not support Project Journals because these do not include accounting data.
Why am I getting an error when trying to sync my bill payment?
You will receive the below error when attempting to sync a bill payment from Ramp to Business Central before posting the purchase invoice from the initial bill you synced.
Example error:
How does Ramp handle Vendors?
Business Central vendors are not required to sync a transaction. In other words, if you don't code a Business Central vendor to your transaction, then Ramp will sync it over without any associated vendor account and will default to putting the vendor name in the memo. We do not use a fallback, default vendor account.
Why aren't my receipts for journal lines or invoices syncing?
Once a transaction is synced and posted Ramp is unable to attach receipts. In other words, receipts must be attached before the transaction is synced over.
Is Purchase Order functionality supported?
At this time, this functionality is not supported with the Business Central Integration.
Why is Ramp not pulling in my credit card liability, cash account, or cash back account in Sync Settings?
To ensure Ramp pulls your credit card liability and cash accounts from Microsoft Business Central, configure them as Posting accounts with Direct Posting enabled, or as Posting accounts associated with a single bank account via a Bank account posting group. For Ramp to pull your cash back accounts, configure them as Posting accounts with Direct Posting enabled in Microsoft Business Central.
Why Do Ramp Transactions Sometimes Credit a Bank Account Instead of the Liability GL Account?
When syncing transactions to Business Central (BC), the logic used by Ramp can be more complex than it seems. Here’s an explanation to help clarify:
Querying BC Environment: When recording a credit liability account line, Ramp queries your BC environment for bank accounts connected via a BC bank account posting group to the liability GL account selected in Ramp.
Single Bank Account: If there is exactly one bank account tied to the selected liability GL account, Ramp credits this bank account instead of the GL account.
Zero or Multiple Bank Accounts: If there are zero or multiple bank accounts tied to the selected liability GL account, Ramp credits the GL account directly.
Example of a Common Issue: