QuickBooks Mapping: Account Types

By Andrew

Follow

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.

Screen_Shot_2017-04-21_at_3.54.16_PM.pngTax 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


Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request
Still have questions? Contact our friendly Support team

Join us to learn and celebrate at Revelry, Oct. 12th - 13th. Take 50% off registration with promo code: SUPPORT50

Learn More