How to connect Revel POS and QuickBooks Accounting Software?
Discover the most common questions about the Revel QuickBooks integration. Please remember that if you don’t find the answer here, you can always contact our Integrations Specialist
How does the Revel QuickBooks 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. Features:
- 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 setup the Revel QuickBook integration?Revel QuickBooks 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 accounting software.
How does the Revel Quickbooks 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.
How much does the Revel QuickBooks 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.
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.
How should service fee appear in the invoice in the accounting software?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 Revel Quickbooks 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.
How do refunds relate to the invoices?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.
How does the Revel Quickbooks 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
Which variables are being ignored in a refund?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 QBO?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.
How to reconcile payments?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. 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
- Decrease Cash Clearing account by $100 resulting to zero balance
- Decrease Debit/Credit Clearing account by $100 resulting to zero balance