To ensure your Quickbooks is properly set up, follow the directions below:
1. Go to app.ollieops.com
2. Click on the setting icon
3. Click on Brewery Settings
4. Click on Integrations
5. Click on Configure
Once fully configured, Ollie Ops will sync with QBO daily.
6. Follow the steps to add your inventory prior to configuration
Please ensure all of your inventory and WIP has been added to Ollie Ops prior to configuring QBO.
Enabling your QBO setup prior to taking these steps will result in inaccurate account values being synced to QBO.
Once a task is complete, you can click the X to mark to a check mark.
7. Select your Raw Materials Asset Account
This will be the default account that is updated with the current value of raw materials (grains/hops/yeast/miscellaneous) when the sync happens.
Each raw material can override the account that is updated with the current value of that item (and any others that use the same account) when the sync happens. Click here for instructions.
8. Select your Packaging Materials Asset Account
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 is updated with the current value of that item (and any others that use the same account) when the sync happens. Click here for instructions.
9. Select your WIP Asset Account
This is the account that will be updated with the current value of WIP beer (any beer that is in a tank or barrel) when the sync happens.
\10. Select your Finished Goods Asset Account
This is the account that will be updated with the current value of finished goods (cans/bottles/kegs) when the sync happens.
11. Select your Cost Of Goods Sold Account
This account will be adjusted any time finished goods is depleted via invoicing, manual removal, etc. Invoicing is not available to all customers and may have no consideration to your account.
For customers using Ollie Ops + Ollie Order: This account will not be adjusted during inventory transfers across platforms.
12. Select your Other Cost Of Goods Sold Account
This is the account that is for adding non-inventory related costs (i.e. labor or mobile canning). Note: it is perfectly fine if this account is the same as the other COGs account.
13. Select your Inventory Adjustment Account
This is the account that is used when inventory adjustments are made within Ollie Ops to Raw Materials, Packaging Materials, and Finished Goods.
14. Select your Accounts Payable Account
When purchase orders are received, this is the account that will be credited.
Must being using QBO Plus or higher and have enabled item based syncing (see step 17).
15. Select your Income Account
Once a Finished Good is invoiced and marked as paid in Ouickbooks, the Finished Goods Asset Account is debited and Revenue is added to your Income Account.
Note: this Invoicing is only available upon request an may not be shown on your account.
Must being using QBO Plus or higher and have enabled item based syncing (see step 17)
16. Select your Expense Account
Once a Finished Good is invoiced and marked as paid in Ouickbooks, the Finished Goods Asset Account is debited and Cost of Goods Sold is added to your Expense Account.
Note: this feature is only available upon request an may not be shown on your account.
Must being using QBO Plus or higher and have enabled item based syncing (see step 17)
17. Choose if you'd like to automatically sync packaged inventory
Check the box to enable an item-based integration for Packaged Inventory.
When we refer to an “item” below, it is referring to an individual inventory item in Quickbooks. This works as follows:
-
When a new product variant is created it is synced to Quickbooks as an “item”
-
When finished goods are packaged, added, or removed, we sync the inventory for that item to the Quickbooks “item”
-
Ensure that the "Finished Goods Asset Account" field from above is configured.
- When inventory is invoiced or otherwise sold in Quickbooks, we will automatically adjust your inventory in Ollie Ops
18. Mark all the steps as complete
In order to move on to the next step in your QBO configuration, you will need to ensure that you have completed and checked off all the steps.
19. Review your account values prior to completing setup
Prior to completing your QBO setup, you will need to:
-
Review the current values of each of your accounts for accuracy. If the accounts look incorrect, you may need to have one of the following issues.
-
Make a decision on removing any existing journal entries in QBO or not (not applicable to new users or first time configurations).
-
Checking this box will remove all journal entries previously synced to your QBO instance, impacting the existing value of your accounts in QBO. If you have already made additional journal entries to true-up any previous discrepancies, we recommend leaving this box unchecked.
-
20. Complete your setup
Once you've reviewed your account values and determined how to handle any prior journal entries, you can complete your QBO setup.
