When integrating QuickBooks with Revel, clients often do not see accounts they desire in the drop-down menu.
This is because our integration does not allow you to choose accounts that would conflict with the business logic of QuickBooks. Accounts available within the QBO Settings drop-down are accounts that fit the integration requirements.
Please Note: Beginning in our 2.25 release Customers will receive an e-mail if any accounts do not match the accepted configuration. Use the table below to find the correct values to restart the sync.
Accounts that map to line items under Products and Services:
Total Non Taxable Sales
Total Taxable Sales
Surcharge
Service Charge
Short
Item Discount
Order Discount
Coupon Discount
Rounding Delta
Customer Deposit
Applied Customer Deposit
Tips
Refund Substitute
Gift Sales
Gift Payment
CRV Charge
House Account Charge
House Account Payment
Employee Service
Accounts that map to items under All Lists/Payment Methods:
Cash Payment
Visa Payment
Master Card Payment
Amex Payment
Discover Payment
Debit Card Payment
Check Payment
PayPal Payment
Other Payment
Tax Rate maps to Tax Rates under Sales Tax Center.
Tax list under Taxes>Sales Tax>Add/edit tax rates and agencies
(Establishment is dictated by the Class Tracking module.)
Below is a list of account types and subtypes needed for accounts to appear in the mapping section for QBO:
| Account Name | Account Type | Account Subtype | Classification |
|---|---|---|---|
| Income Account | Income | Sales Of Product Income | Revenue |
| COGS Account | Cost of Goods Sold | Supplies Materials Cogs | Expense |
| Asset Account | Other Current Asset | Inventory | Asset |
| Liability Account | Other Current Liability | Other Current Liabilities | Liability |
| Discount Account | Income | Discounts Refunds Given | Revenue |
| Cash Drawer Pay-ins | Expense | Office General Administrative Expenses | Expense |
| Cash Drawer Pay-outs | Expense | Office General Administrative Expenses | Expense |
| Cash Account | Bank | CashOnHand | Asset |
| Customer Deposit Account | Other Current Liability | Other Current Liabilities | Liability |
| Gift Cards Outstanding Account | Other Current Liability | Other Current Liabilities | Liability |
| CRV Adjustment Account | Other Current Liability | Other Current Liabilities | Liability |
| House Account | Other Current Asset | Inventory | Asset |
| House Account Adjustment | Other Expense | OtherMiscellaneousExpense | Expense |