Contents
 What is iPlanner.NET
 How it works
 Creating  a Business Plan
    Open and Add Projects
    Team Building
    Start and Setup
    Opening Balances
    Worksheet Features
    Saving and Team Work
    Publishing and Sharing
    Plan-Builder
    Financial Inputs (Lite)
    Financial Statements
    Sales Forecasting
    Labor Cost
    Other Operating Expenses
    Fixed Assets
    Paid-in Capital
    Business Loans
    Grant Financing
    Other Operating Revenue
    Dividends


www.iplanner.net Print

Home > Creating a Business Plan > Worksheet Features

Worksheet Features

The functions and features of input tables used on iPlanner worksheets are rather similar.

Entering numbers by months, quarters and years

Financial forecasts can be entered by years, quarters or calendar months. The default entry period is a calendar year.
To enter numbers by quarters or months, click on the year link (column header).
To enter numbers by months, click on the quarter link.
To close periods, click again on a corresponding column header.


business plan financial worksheets

When entering financial forecasts by years, the values of quarters and months viewed "downwards" will be calculated automatically. And vice versa, if values are entered with the accuracy of calendar month, they will be automatically summarized "upwards" to get quarterly and yearly forecasts.

AutoForward - automatic transmission of forecasts

In most cases, this software feature will help you to save time and reduce the number of entries. Sometimes, however, forecasts have to be entered in more detail, for example, as in cases of seasonal income-expenditure patterns. In such cases, you can turn AutoForward off.


AutoForward

Delete rows

To delete one or several rows, select the required rows and click "Delete". When the confirmation form appears, click "OK".

Add rows

To add a row, enter the values (name, numbers) in the empty row. Click "OK".

Increase and decrease the number of rows in the table

To increase the number of rows shown on the input table page, click on the button with the downward arrow ↓
To decrease the number of rows, click on the button with an upward arrow (this could result in an increase of pages).


Worksheet size

See more

Saving and Team Work
Start and Setup
Publishing and Sharing