On this page you will set up the default QBO accounts you would like Ollie Ops to sync information with. If you'd like to sync specific items within Ollie Ops to more specific accounts, you can do so.
Things to Know Before you Connect QBO Essentials:
Ensure you know the type of Quickbooks account you have:
There are specific differences between the QBO Essentials and Plus (or higher) integrations. The Essentials plan restricts certain features and therefore behaves slightly different than the Plus plan.
How often does QBO Essentials sync to Ollie Ops?
Syncing happens regularly every hour. Syncing can be triggered manually from the Raw Materials, Packaging Materials, Finished Goods, and Batches pages by clicking the “Sync to QBO” button.
What does the integration do?
- Purchase orders are synced as bills when marked as received. This will adjust the values of the inventory accounts upon creation of the bill.
-
Finished goods are synced via GL account values and not as items.
Steps to Connect QBO Essentials:
1. Select "Quickbooks Online Essentials"
2. Select an Accounts Payable Account
Select your default Accounts Payable Account for QBO.
When purchase orders are received, this will be the account that gets credited.
3. Select a Finished Goods Asset Account
Select your default Finished Goods Asset Account for QBO.
This is the account that will be updated with the current value of finished goods (cans/bottles/kegs) when the sync happens.
4. Select a Packaging Material Asset Account
Select your default Packaging Material Asset Account for QBO.
This will be the default account that gets updated with the current value of packaging materials when the sync happens.
Each packaging material can override the account that gets the current value of that item (and any others that use the same account) when the sync happens. Click here for instructions.
5. Select a Raw Material Asset Account
Select your default Raw Material Asset Account for QBO.
This will be the default account that gets updated with the current value of raw materials (grains/hops/yeast/miscellaneous) when the sync happens.
Each raw material can override the account that gets the current value of that item (and any others that use the same account) when the sync happens. Click here for instructions.
6. Select a WIP Asset Account
Select your default WIP Asset Account for QBO.
This is the account that gets updated with the current value of WIP beer (any beer that is in a tank or barrel) when the sync happens.
7. Select an Inventory Adjustment Account
Select your default Inventory Adjustment Account for QBO.
This is the account that is used to offset the adjustments made when syncing the above accounts (except for finished goods). Quickbooks requires that you have offsetting ledger items when adjusting GL account values.
8. Select a Cost of Goods Sold Account
Select your default Cost of Goods Sold Account for QBO.
This is the account that is used to offset the adjustments made when syncing the finished goods account. Your Cost of Goods Sold Account will be debited when you remove finished goods from Ollie Ops or transfer finished goods to Ollie Order via the Ollie Order integration.
9. Click on Update preferences
To complete your QBO Essentials Setup, click Update Preferences:
