Revel and Quickbooks Connector Documentation
When it comes to connecting Revel Point of Sale and Quickbooks DSYNC can provide ready made integrations for the following workflows:
- Revel > Quickbooks Customer
- Revel to Quickbooks Item
- Revel to Quickbooks Inventory
- Revel Order to Quickbooks Invoice
- Revel Sales Summary to Quickbooks Daily Summary Invoice (learn more about taxable split invoices)
Revel POS to Quickbooks integration
Mapping template for Sales Summary to QBO integration includes the ability for mapping fields from Revel straight across to the Quickbooks Invoice per below mix and match option below:
MAP this ..... to this .......
|Sales Summary in Revel||Quickbooks Invoice Create|
|service fee total||TxnId|
|nontaxable_service fee||LineItem1 (as many as needed)||Description|
|order discounts total||DetailType|
|service charge total||TaxCodeRef|
|total tax surcharge service||value|
|crv value as price part||lookup|
|crv value as tax||Item|
|american express total||DetailType|
|other credit card total||TaxCodeRef|
|applied deposit total||Name|
|applied deposit other credit card|
|applied deposit other credit card tips||LineItem3||Description|
|applied deposit american express||Amount|
|applied deposit american express tips||DetailType|
|applied deposit discover||SalesItemLineDetail|
|applied deposit discover tips||UnitPrice|
|applied deposit mastercard||Qty|
|applied deposit mastercard tips||TaxCodeRef|
|applied deposit visa||value|
|applied deposit visa tips||lookup|
|applied deposit maestro||Item|
|applied deposit maestro tips||Name|
|applied deposit eftpos||TxnTaxDetail|
|applied deposit eftpos tips||TxnTaxCodeRef|
|custom payment total||value|
|expected total cash to business||lookup|
|actual total cash to business||TotalTax|
|cash tips total||TaxLine|
|credit tips total||Amount|
|american express tips||TaxRateRef|
|other credit card tips||CustomerMemo|
|paypal tips total||value|
|custom payment tips total||BillAddr|
|payments accepted amount||Line1|
|payments captured amount||Line2|
|payments declined amount||Line3|
|payments failed amount||Line4|
|payments pending amount||Lat|
|payments unknown amount||Long|
|other tips total||ShipAddr|
|payouts ins total||Lat|
|payouts ins count||Long|
|payouts outs total||SalesTermRef|
|payouts outs count||value|
|total number of people||Customer|
|avg sale per person||Taxable|
|adj credit tips total||BillAddr|
|adj credit tips||Id|
|adj visa tips||Line1|
|adj visa tips total||City|
|adj maestro tips||CountrySubDivisionCodePostalCode|
|dj maestro tips total||Lat|
|adj mastercard tips||Long|
|dj mastercard tips total||Job|
|adj american express tips||BillWithParent|
|adj amex tips||Balance|
|adj american express tips total||BalanceWithJobs|
|adj amex tips total||PreferredDeliveryMethod|
|adj other credit card tips total||domain|
|adj other credit card tips||GivenName|
|adj paypal tips||FamilyName|
|adj paypal tips total||FullyQualifiedName|
|adj discover tips||CompanyName|
|adj discover tips total||DisplayName|
|adj non cash tips total minus cash||PrintOnCheckName|
|adj declined tips total||Active|
|non cash tips total minus cash||DepartmentRef|
|out of range|
|open orders count|
|open orders ids|
|unpaid orders ids|
|has any filters|
|total tax breakdowns|
Custom development / Custom scoping: If you are after custom endpoint integration or extra connectivity the team can provide a paid integration scoping service and paid integration service for custom Revel to Quickbooks requirements. DSYNC is an open integration platform where developers, business analysts and accountants can manage the data mapping and work flows. If you would like DSYNC to do custom scoping of your integration you will need to be on a monthly plan and complete the scoping form outlining your requirements.
DSYNC can integrate more endpoints however we need to be clear that those endpoints are our standard Real Time endpoints and users / developers are responsible for connecting those. If there’s anything outside of our standard offering listed we can scope and build for a fee.
Hello and welcome to another DSYNC integration product tutorial. Today we will be showcasing the Revel and Quickbooks data connector. Revel is a popular point of sale and CRM and Quickbooks is a popular financial and accounting package. DSYNC can help to integrate the data between the two systems. We encourage self installation however if you do get stuck please feel free to ask our friendly team.
Please help to see the documentation listed below for self installation. Our team also offer an installation service if you require additional help or support.
Can DSYNC build a connection to another application if the connector does not exist?
Yes we do offer professional services to build new connectors. Please help to talk to our sales guys.
How does payment work?
DSYNC is a SaaS application with plans offered monthly. Payment is to DSYNC and starts from $25 usd per month. Our sales team can also provide estimates to you based on your transactional data.
How much does the connector cost?
Our starter plan for Revel and Quickbooks start at $25 usd per month and allows up to 2.5 GBs of data. The next plan is $100 per month and allows up to 10 GBs of data. With our Junior plan, your monthly data allowance is 2.5GB (Gigabytes) which translates to roughly 2,621 files (JSON, CSV, Excel, etc). The junior plan is perfect for smaller cafes and breweries. Our sales team can also provide estimates to you based on your transactional data.
How do I know how much data I am using?
Within the DSYNC dashboard there is a data counter that shows your daily and monthly usage. This feature is available via your free trial.
What versions of Quickbooks is DSYNC compatible with?
Version(s): Quickbooks online
What are some of the entities that Quickbooks can integrate?
Account, Bill, Bill Payment, Credit Memo, Customer, Department, Deposit, Employee, Estimate, Invoice, Item, Payment, Payment Method, Purchase, Purchase Order, Refund Receipt, Sales Receipt, Term, Time Activity, Transfer, Vendor, Vendor Credit.
What are some of the entities that Revel can integrate?
Address, Attribute, Company, Customer, Employee, Inventory, Order, Payment, Product, Purchase Order, Tax, User, Vendor.
Self Installation - Getting started:
- Login to the DSYNC dashboard. To login to your DSYNC dashboard simply sign up for a free trial here
- Load Quickbooks template. Once you log into your DSYNC dashboard, the next step is to Select “Use System Templates” We have pre built the integration ready for synchronization.
A pop up box will appear and will ask you to search for the Quickbooks template. By typing the word Quickbooks the readymade template will appear. Select Quickbooks, then select “Add this system”
When you add Quickbooks to the DSYNC dashboard, the platform will automatically load common Quickbooks elements onto your DSYNC dashboard.
- Authorise Quickbooks data. The next step is to “Open the system settings” This will bring you into the authorisation section where we use O AUTH to provide a secure link of the data. Proceed to check the settings and then authorise the connection.
As part of the authorisation method you will now be directed to the Intuit / Quickbooks automated flow. The process will ask you to sign into your Quickbooks account and verify that you would like DSYNC to connect your data.
- Set up Revel.
Now that you have authorised Quickbooks it is time to set up your Revel account in the DSYNC dashboard. In the right-hand corner click on “Plus System”. A pop up box will appear asking you to “Add system from Template” select REVEL from the readymade drop down list. click on Revel and then select “Add this system”
- Add Revel Credentials
Add Revel Credentials To Add Revel to the DSYNC dashboard you will need the special API key. Your individual API secret and the first part of your Revel URL. These key ingredients can only be obtained by working with DSYNC and your Revel representative and providing the Revel Client Authorization letter. We can help you with this process. When you have entered your API key, secret and special URL please select save. This will Add Revel systems to your DSYNC dashboard.
- Create a link/Relation between the two data points
The next step in the process is to join the data you would like linked between Quickbooks and Revel systems. In this example, we will be creating a link also known as a relation between customers.
On the Quickbooks side simply click on the data element named “Customer”
Then create a relation
Then on the Revel side simply click on the data element also named “Customer”
A pop up box will appear asking you to name the link, this process will be helpful if you need to make changes at a later stage.
When naming your job you can name the connection anything you wish
By naming the job this will create a link or a line between the two customer data endpoints in Quickbooks and in Revel.
- Create a Map
The next step will be to create a map for the data to be moved. We create maps in case you would like the data from one system to another to be formatted in a specific way. A map is also used as there may be multiple data elements under the customer – for example a name, address, phone number, date of birth.
- Edit the map (Pair the data)
Once you create a map you can edit the map and the underlying data points. To edit the map simply click on the lines between the two data points and on the right-hand side select “Edit”
When editing a map the first thing to do is to make sure all of the “required fields” are paired with another matching element.
Required fields can be identified by the red asterisk (*) next to the data name
Here’s an Important Mapping Tip for integrating Quickbooks with Revel Systems…. “Created By” is a required field in Quickbooks. To match “Created by” with a Revel data point, you will need to enter a “Custom Field”. To match with a custom field, simply click next to the data point then select “Add Custom Field”. We will now enter in a “string constant”.
For this example, the Created and Update field needs to be a USER in Revel specified by their ID. For further help with mapping Revel and Quickbooks data, please feel free talk to our team.
- Map the reverse direction
Now that we have mapped from Quickbooks to Revel we will need to switch and map from Revel to Quickbooks. To switch directions of the data flow simply click on the two arrows to reverse the workflow.
Follow the same process by matching the data elements you would like to match from Revel to Quickbooks.
Sometimes data fields are easy to match, for example first name and last name. DSYNC also gives you the ability to join data elements together. For example, if you would like to join the first name and the last name together. An easy way to join the two together is to select the two fields, then select “Add a custom field” then in the top toolbar connect the string of data together in your required format.
- Schedule the job to synchronize
After mapping both directions of the data, the next step is to set the schedule for when you would like data to be synchronized.
Another great feature is that you can set the direction and the time of the job to run. Within the scheduler, you can set the job to run every minute, hour, day, month or year.
- Enable the job/synchronization to run (Turn it on)
After you have created your map and set the time for the data to be processed, please select the enable button in the right corner of your DSYNC dashboard.
And you’re done! If you have any questions or need any extra support, please feel free to reach out – we love to help.