(Enlarge video by clicking the icon in the video player above)
Navigate to: Admin > Settings > Quickbooks > Quickbooks/Quickbooks Settings
In this section, we will cover the Quickbooks integration setup. We can export to 20 different accounts ranging from; sales, Cost of Goods Sold, Inventory Adjustments, Undeposited Funds, POs(vender bills), Wholesale, etc.
Once in there, you can set up Your Quickbooks account names and types, plus determine how you want to handle sub-accounts. Make sure the accounts match if your Quickbooks account is already established. This will keep from new accounts being created upon import.
This is a one-time setup in which you will match account names and account types on this MJ Freeway mapping page to your Quickbooks chart of accounts. For any account on this mapping page that you currently do NOT have an account in Quickbooks, one will be created once the Quickbooks import takes place.
This section allows you to determine the level of details that will be sent to Quickbooks
1. Use no subaccounts: This will send dollar totals to your Quickbooks accounts with further level of detail.
2. Use only product Categories: This setting will send dollar totals broken down by product category(Flower, Edibles, Accessories, etc.)
3. Use product categories and item names: This setting will send dollar totals broken down by every product in every category.
Once this mapping is setup in MJ Freeway, Quickbooks exports can be generated from Reports > QB Export for single days or customized date ranges.
Simply select the date range that you wish to export and select what you would like to send to Quickbooks(Sales, COGS, Inventory Adjustments, etc.) After clicking ‘Export Now’ you can save the file.
In Quickbooks, you will navigate to File > Utilities > Import > iif.
QUICKBOOKS EXPORT - not in ADMIN
REPORTS > QB EXPORT
To export your records, you can access Reports -> QB Export. This will take you to your exports. Select the date range and the account types you are exporting. Once you do that, you can generate your data. This will bring you to an option to save or open a file. Please save this .iif file to your desktop or downloads folder (whichever is easily accessible for you). You may then import this to Quickbooks.
** Please Note: THIS IS VERY IMPORTANT
make a backup or copy of your Quickbooks file BEFORE performing this import. Quickbooks does not allow imports to be undone, so if you import files and don't like how they come over, it will be difficult to undo.
In Quickbooks, please visit File > Utilities > Import > IIF files to import.