This feature is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

Modelling inventory orders and usage

In Fathom, you can model inventory or stock purchases and usage with journals and/or timing profiles. There are two main methods of modelling inventory in your forecast:

Bulk or batch ordering inventory in advance
Just in time ordering

Bulk or batch ordering in advance

To forecast large orders of inventory or stock, you can model the inventory purchases with journals and the inventory reductions with timing profiles.

To model the purchase of inventory with a journal:

Go to the impacted ‘Inventory’ account on the forecast Balance Sheet

❗Notice: The account should be classified as an Inventory account on the Balance Sheet. If it is not already classified as such, you can re-classify it in ‘Chart of Accounts’ in the company’s Settings.
Click on the cell date for when you want to purchase the inventory
In the menu that opens on the right, select the + Add custom journal option at the bottom
Name the journal
Increase the inventory account by the order amount
Select the + Add new line option
Decrease the cash account by the same amount

💡Smart Tip: If the purchase is not being made initially with cash, additional journals may need to be created to model the initial debt and then repayment.
Choose to make the journal a ‘One-off’ or ‘Repeating’ journal. Repeating journals can repeat every month or at a different monthly cadence. If repeating, you’ll need to choose an end date for the repeating journals.
Select Create

Now that you’ve modelled the purchase of inventory, you can model the usage or reduction of inventory through timing profiles with the correct account settings. To do this:

Go to the corresponding ‘Cost of Sales’ account on the forecast Profit & Loss
Click on the name of the account
In the menu that opens on the right, select Settings at the top
For the Cash / final posting account, select the inventory account that will be reduced
Select the cell date in the ‘Cost of Sales’ account for when the inventory will begin to be used
In the menu that opens to the right, scroll down to the timing profile and click on the Three dots icon
Select the option to create a + New profile, unless editing a profile for multiple Cost of Sales accounts
Choose a Monthly profile
Set the payment spread to be 100% in the ‘Same month’
Select the option to Create Profile

You’ve now modelled the reduction or usage of inventory.

To check the impact of the timing profile and journal you’ve created, you can click on the ‘Three dot’ icon next to the timing profile and choose the ‘Preview’ option to view how the timing profile impacts the Balance Sheet. You’re also able to view the Balance Sheet layer detail for the Inventory account to see the impacts of the Profit and Loss on that account.

💡Smart Tip: Because the Inventory account on the Balance Sheet is consistently being reduced by the Cost of Sales account posting to it, you're able to see when the Inventory account will eventually reduce to negative values. This will help you identify when your next large inventory purchase should be.

Just in time ordering

You may want to forecast purchases of inventory made just before the inventory is used or sold. This method of inventory purchasing is often preferred for perishable items. You can model just-in-time ordering with timing profiles and specific account settings. To do this:

Go to the impacted ‘Cost of Sales’ account on the forecast Profit & Loss
Click on the account’s name
In the menu that opens to the right, select Settings at the top
For Pre-payments, select the ‘Inventory’ account that will be reduced by the ‘Cost of Sales’ account

❗Notice: If you do not see the Inventory account as an option to select, then it may not be classified as an Inventory account on the Balance Sheet. If it is not already classified as such, you can re-classify it in ‘Chart of Accounts’ in the company’s Settings.
For the Cash / final posting account, make sure it is the Cash account the inventory is purchased from
Now, select the cell date in the ‘Cost of Sales’ account for when the inventory will begin to be used
In the menu that opens to the right, scroll down to the timing profile and select the Three dots icon.
Select the option to create a + New profile, unless editing a profile for multiple Cost of Sales accounts.
You’ll likely want to choose a Monthly profile
Set the payment spread according to when inventory purchases will be made. For example, if you’re purchasing all of the Inventory for that month in the month before it is used or reduced, then you can set the payment spread to be 100% in the month prior.

💡Smart Tip: If the purchase is not being made initially with cash, journals may need to be created to model the initial debt and then repayment.
Select Create Profile

You’ve now modelled the purchase and reduction or usage of inventory.

To check the impact of the timing profile you’ve created, you can click on the ‘Three dots’ icon next to the timing profile and choose the ‘Preview’ option to view how the timing profile impacts the Balance Sheet.

You’re also able to view the Balance Sheet layer detail for the Inventory account to see the impacts of the Profit and Loss on that account.

Learn more

Forecast Inventory in Fathom

Modelling inventory orders and usage

Bulk or batch ordering in advance

Just in time ordering