The way you connect your items in Fulcrum to the sales and purchases in Quickbooks is via the Accounting Code field tied to the item in Fulcrum. In this Fulcrum field, you will map the appropriate Quickbooks item. That being said, there are a couple of ways you can do this.

In order to connect your purchases and sales in Fulcrum over to Quickbooks, consider the following:
How do I currently have my sales and expense accounts set up?
-
Some businesses have one bucket for all of their sales (finished goods) and one for all of their expenses (raw material, buy items, and outside processes). If this is the case, you may just want to create a single, non-inventory item in Quickbooks for your sales and another for your expenses. You can then map that single sales item in Quickbooks to all of your sellable items in Fulcrum. The same goes for your Quickbooks expense item.
-
If your business requires a more detailed breakdown of sales and expenses, you may want to create additional non-inventory items in Quickbooks to differentiate these accounts.
For Example:
- Sales by customer
- Sales by item category
- Purchases by material type
Once these items exist in Quickbooks, you can map them to their appropriate items in Fulcrum.
To import them, you can go to Lists > Item Lists > Excel > Paste from Excel.
All of my items already exist in Quickbooks. Can I use those?
- The answer is yes, but strongly discouraged. If your items already exist in Quickbooks and are already associated with the appropriate sales or expense account, it may seem easiest to use these, however, the amount of data management can exponentially increase if this is the method you choose to take. Remember, Fulcrum is now the source of all item information.
- One important factor here to consider is the volume of new items you are creating. Any time you create a new item in Fulcrum, you will need to create the same item in Quickbooks and then associate the two via the Accounting Code field tied to the Fulcrum item. This may be a reason to consider using bucket items (as explained in 1a and 1b) where one Quickbooks item covers multiple Fulcrum Items.
If I do not have all of my items in Quickbooks, how is it tracking my inventory?
- Fulcrum is now your source of inventory! All inventory transactions, cost association, WIP, and COGS are captured in Fulcrum. As needed, you can use the Fulcrum Work In Progress and Cost of Goods Sold report found within the Accounting - Reporting section of your site to make journal entries in Quickbooks for your COGS and WIP adjustments and reconciliations.
