You can choose to enable the Inventory module on your Revel and QuickBooks Online Integration. Once you enable this module Revel will send vendors, finalized purchase orders, cost of goods sold and inventory values to your QuickBooks online account daily.
- You must have QuickBooks Online Essentials or Plus subscription in order to be able to integrate inventory.
- To enable the inventory module,
- on your Management Console go to the Settings tab.
- Click Quickbooks, then click Quickbooks Online Integration
- Select Inventory under modules:
- Make sure your Inventory is correct in Revel before integrating to avoid manually editing your Quickbooks data once it is created.
- Your products and ingredients must have costs associated to them in Revel in order for a successful inventory integration.
- If you use Recipes in Revel then we recommend to uncheck Track in Inventory under each product with a recipe inventory settings. If this is not done then whenever you sell a product with a recipe it will sync the cost of the product as well as the ingredients causing duplication.
When you initially integrate your Revel and QBO accounts, the following information will be pushed to QuickBooks Online:
- An initial sync Journal entry containing a sum of your product and ingredient inventory:
- You can see the sum of your product inventory in Revels management console under Inventory tab, then Products/Ingredients:
The initial sync Journal Entry is sent to QBO to your account so you have an initial starting balance in your reports. This is important for when Revel sends inventory and purchase order data, it will deduct and add to those initial balances as required.
Purchase orders will be transferred to QuickBooks once they are finalized in Revel. When they sync to QuickBooks, they will show up as an unpaid bill. You can locate these bills under the Expenses tab in QuickBooks online.
Bills that Revel creates in QuickBooks will credit Accounts payable and debit the Inventory asset account:
Bills may sync differently depending on how it was filed in Revel. The following examples will show the different ways a PO can be filed vs how it is shown in QuickBooks.
Example 1: If you add miscellaneous costs in the Purchase order it will create a separate Bill for the miscellaneous costs and the purchase order.
PO in Revel:
Bill with items ordered from Vendor:
Bill with miscellaneous costs inputted on the PO:
Example 2: If you input the miscellaneous costs into the Invoice instead of the PO, it will be transferred as a single bill that includes both the PO and miscellaneous costs.
Invoice for a PO in Revel:
Bill created in QuickBooks online including misc. Cost and PO details:
Example 3: If you receive items via multiple invoices in Revel then each invoice will create a separate bill in Quickbooks.
PO with multiple invoices in Revel:
Bills created in Quickbooks:
Example 4: If you manually Receive items in Revel it will also create an unpaid bill which will be applied to the QBPOS Vendor by default.
Manually received bill in Quickbooks:
- Important: Purchase Orders with negative value will not sync to QBO. Having negative purchase orders in Revel will suspend your integration. Please use RMAs to return items instead of POs.
- See our RMAs in QBO article for more information about RMAs in QBO.
- Take a look at our other useful guides for more information about Vendors, Inventory and Cost of Goods Sold integrations between Revel and QuickBooks Online.