Use the Stock template to predict the cost of sales and related stock movements.
Before you add data to this template to import, you must:
Once you've done this, we explain below how to add data to the Stock template in your Master Sheet.
⚠CAUTION:
Don't delete any rows or columns from the sheet
Don't add any additional rows or columns. If you require additional rows, use a separate template
If you accidentally do any of the above, you may corrupt the sheet. If this happens, you will need to open a new template, copy it to your Master Sheet again, and restart the process of adding data.
Click the Forecasting tab, then view the forecast you want to import predictions into.
Once in the forecast, click New prediction in the top right, then click Import templates on the dropdown.
Click Open Master Sheet.
Unlike some other templates, the Loan Amortization template requires no hidden settings to be opened and completed. You'll only need to add data to the white boxes.
There are three sections:
The predicted income
The cost of sale as a percentage of that income account
The purchase of stock.
Before you input this data, set the date you'd like to be predicting from. In the Income section, the first date has a drop-down option. Select the relevant month.
Once the date has been set, you'll need to add data for each of the three sections.
⚠CAUTION: Only paste values if you're pasting data from another source. This is because the sheet has underlying formulas.
For Income:
Choose the account in question.
Add a prediction name.
Add a VAT/GST/sales tax amount.
Add an invoice date (day of month) and payment days.
Add your predicted monthly income for this account.
📌TIP: If you have already predicted this income, either in-app or via another template, you can use the tick box to select to not import the prediction into Futrli. If you unselect it, it will still be used in this sheet for reference, but won't be pulled into Futrli.
For Cost of sales:
Pick an account for this to be mapped to
Use the dropdown to select which prediction you are referencing.
Set the cost percentage, then a stock account.
You will see the months will update automatically based on those settings and the figures you've set in the income section.
For Purchases:
Use the drop-down option to select if you would like to show the cash impact of purchases against the cost of sale account, or against the inventory account
Select an account to map this movement to, then in the same format as in the cost of sale section, use the drop-down to link to a cost of sale line.
Set the invoice date (day of month), VAT/GST/sales tax and payment days, followed by manually entering the figures for each month
When finished, you'll have a green tick at the top of the page. This means you can continue to sync the import template to Futrli.
If this isn't green, you'll be able to open the rows to see which information is missing.