Overview
- Most common questions about the Revel + QuickBooks Online integration.
How does the Revel + QuickBooks Online integration work?
Sales and payment totals from Revel are automatically synced to QBO as a sales invoice on a daily, weekly, or monthly basis. Split your sales by Revel product category and get valuable insight into your businesses performance.
- Automatically sync sales and payment totals to QBO
- Split sales into different GL accounts
- Group payments to easily reconcile
- Apply tracking by class for even more insight into your business
- Sync gift cards and other custom payments
- Automate financial reporting, save time and reduce your administrative costs
How are the sales items presented on the invoice?
The sales comes in various forms depending on the customer’s preference. Sales items can be presented on the following formats:
- Detailed – A detailed invoice will sync each and every product sold
- Summarised – A summarised invoice will have 2 line items for sales in the sales invoice. One for taxed items and one for GST free items
- Grouped According to Product Category / Product Department – This type of invoice will sync sales according to product category or department
- Per order sync – Each order and/or invoices will sync as individual invoice in the account software.
How do I set up the integration?
The Revel + QuickBooks Online integration is an assisted integration. Currently we do not permit users to setup their own integration due to the large number of configuration settings available. An Amaka integration consultant will work with you to determine your specific requirements and configure your integration accordingly. During this process the integrations team will also ensure that data is correctly synchronising with your QuickBooks Online accounting software. Book a setup session.
How does the Revel + Quickbooks Online integration handle discounts?
Like sales, taxable and non-taxable discounts are shown separately on the invoice, can be mapped to one account or two separate accounts. Discounts can also be grouped by product class/category and by product item.
What is a service fee?
This is a feature that allows either a percentage charge or flat fee to be added to the order or specific items. A service fee can be manually added by an employee or auto applied based on certain criteria.
Service fees are mapped to income accounts. Taxable and non-taxable service fees are separately shown in the invoice and can be mapped to the same or different accounts.
How does the integration handle tips?
Tips received in Revel will be synced into the ‘Tips Liability’ current liability account in the QBO accounting software. Tips can be omitted from the sales sync if the user chooses, however this will result in differences of actual amounts deposited into the bank account compared to payment amounts. This is because when a customer pays via credit card and leaves a tip, the business will receive the full amount including the tip. This can be contrasted with cash tips, where the business may disperse these to staff on the night (and deposit the corresponding cash net of the tips received).
How are refunds being represented?
Refunds sync as negative item on the invoice. Refunds are synced to the QuickBooks accounting software the same way sales are synced. If sales are pushed in a sales summary invoice, so are the refunds. At present, Revel allows users to include service fees in the refund. It also gives the user the option to include the tips or not in the refund.
How are payments pushed from Revel to QuickBooks Online and how do you reconcile them?
Payments are pushed to clearing accounts. Payments of the same type can be mapped to a single clearing account which will make reconciling easier. If the customer prefers, payments can be mapped directly to the bank accounts.
Negative payments are not applicable for the Revel + Quickbooks Online integration. Invoices in QBO should be higher than $0.
When cash/merchant settlements are deposited into the bank, these deposits would be applied against the corresponding clearing accounts to reduce their balances to zero.
For example, a $200 total sales is paid via $100 cash and $100 credit. If cash payments are mapped to Cash Clearing account and credit payments to Debit/Credit Clearing account. This transaction will:
- Increase total sales/revenue by $200
- Increase Cash Clearing account by $100
- Increase Debit/Credit Clearing account by $100
Once the cash and credit payments are deposited and applied against the corresponding clearing accounts. This transaction will:
- Decrease Cash Clearing account by $100 resulting to zero balance
- Decrease Debit/Credit Clearing account by $100 resulting to zero balance
How does grouping payment types by account look in the accounting software?
Payments that are mapped to the same account will be grouped together on the sales invoice under one payment. Example: If the toggle for group payment types by account is off, Master and EFTPOS payments will be pushed as separate payment on the invoice but if the the toggle is on, Master and EFTPOS payments will be pushed as a single payment on the invoice.
How does the integration handle gift cards?
Transactions involving membership cards are recorded in Gift Card Liability which is a current liability account.
- Purchase of gift card – Purchasing a new card or reloading an existing card should increase the Gift Card Liability account. Reason behind: The customer will pay you cash without receiving any goods thus, the liability account
- Using the card for paying orders – Orders paid through gift cards are pushed to the accounting in the liability account. So when an order is paid through gift card payment, the liability account will decrease
How much does the Revel + QuickBooks Online integration cost?
$0.99 AUD per day / establishment. Additionally you need to pay $500 AUD setup fee for each establishment. Please refer to the pricing page.