To start you off, we’ve created a quick tutorial demonstrating how to use Upmetrics. To continue reading the 7 simple steps, please scroll down the page.
Step 1: Setup Financial
Once you're logged into your account, begin by setting up your financial module.
You’ll immediately arrive on the setup page, where you can establish financial projection level details such as start date, forecast range(length) and fiscal year start date.
Click ‘Next’ once you’ve established all necessary settings.
Step 2: Forecast Revenue
After you’ve setting up all time series assumptions, proceed to the revenue page where you’ll specify how revenue is generated.
Click ‘Add Revenue Stream’ to create new revenue stream
Select from the three pre-built revenue models to insert a revenue stream.
Below you'll find a breakdown of each revenue model to help determine which is best for your business.
Revenue Model Breakdown
- Unit Sales - A Simple sales transactions, where customers are charges based on unit product they purchase.
- Service Charges - This is similar to Unit sales model but most suitable for service industry. This doesn’t include inventory tracking.
- Recurring Charges - A time-based model where customers are charged a monthly fee for products or services provided.
If you have more than one revenue stream, or charge customers using more than one method, it may be best to input a revenue model for each transaction type as it will allow for maximum flexibility in fine-tuning your assumptions.
For instance, if you charge an upfront fee once a customer is acquired, and then charge an ongoing monthly fee for services, it would be best to input one revenue model to record the upfront fee and input a separate model to account for the ongoing services. Checkout how the revenue appears in various financial statements.
Step 3: Insert Cost of Goods Sold
After we’ve included all of our revenue streams we can then move on to adding cost of goods sold. This is also called direct costs associated with unit selling.
There are different types of COGs associated with revenue stream, If you have multiple revenue streams, we are recommending to add only COGs those are associated with current revenue stream only. This would help you to find out Gross Profit for this particular revenue stream.
Here is the COGs model breakdown :
- Constant Amount: Simple fixed recurring amounts over time(Daily, Weekly, Monthly, Yearly etc)
- Per Unit Sales of Product/Service: Applies a cost based on the number of product or services sold
- % of Overall Revenue or Specific Revenue Stream: Applies a cost as a percentage of revenue
- % of Other Cost of Sales: Applies a cost if its directly associated with any other cost from the same revenue stream.
- Varying Amounts Over Time: If none of above models are applicable, or you already have a detailed forecast in Excel or elsewhere, Choose this option to just enter overall cost values without any detail.
Step 4: Insert Operating Expenses
As separate from COGs these are the indirect costs. This is also called operating expenses. Go to the expense page and click on to Add Expense Group.
After creating a group, You can add set of expenses into this group. As same as we have added COGs.
Step 5: Insert Employee Salaries and Contracts
After inserting operating expenses and non personnel COGs costs, Move on to the personnel tab to add salaries & wages, and other employee related expenses.
Create new Employee Group or Team to add set of employee related costs within. For ease of cost insertions you can group employees who have same amount of salaries and wages. It would ask you to whether you want to insert salary for single employee or set of employees.
Step 6: Insert Funding, Assets and Other Investments
Step 7: Review Financials and Reports
After you have planned all your above financial inputs, system will prepare three main reports for your review, Profit & Loss Statement, Balance Sheet and Cash-flow.
Go to the reports page and review all your financial summary reports within excel sheet.
This concludes the 7 simple steps for creating your first projections in Upmetrics.
For any remaining questions or requests, please feel free to reach out to the Upmetrics team through the Help & Support widget (“?”) in the bottom left-hand corner.
Have fun planning your new business!