Inventory entries

To record inventory or stock movements within Spotlight Forecasting, you can use a non-cash rule. The journal we replicate is:

DR. Cost of Goods Sold
     CR. Inventory

  1. Within the forecast, open the Profit & Loss tab.
  2. Open the Cost of Sales section, then locate your 'Cost of Goods Sold' account.
  3. Ensure that values have been entered into this account.
  4. Click 'Add Rule', then enter a name for the rule.
  5. From the 'Rule Type' drop-down list, choose Non Cash.
  6. From the 'Select Account to Apply Rule To' drop-down list, choose your 'Cost of Goods Sold'.
  7. From the 'Journal To' drop-down list, choose the Stock Asset account on the Balance Sheet.
  8. Click 'Next', then click 'Save Rule'.

The inventory or stock values now appear in your Balance Sheet and Profit & Loss reports only - these values will be excluded from the Cashflow Forecast report. 

 

To process a cash payment on the inventory or stock account, you can use a Balance Sheet rule. The journal we replicate is:

DR. Inventory
     CR. Bank

  1. Within the forecast, open the Balance Sheet tab.
  2. Open the Current Assets section, then locate your 'Inventory' or 'Stock' account. 
  3. Click 'Add Rule', then enter a name for the rule. 
  4. From the 'Rule Type' drop-down list, choose Balance Sheet. 
  5. From the 'Select Account to Apply Rule To' drop-down list, choose your 'Inventory' or 'Stock' account.
  6. From the 'Journal To' drop-down list, choose the Bank account the payment will come from.
  7. Click 'Next', then enter the cash payments into the Journal column.
  8. Click 'Next', then 'Save Rule'.

The inventory or stock values are now updated for these payments on the Balance Sheet report and cash outflows will appear on the Cashflow Forecast report. 

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2021