Click here to download a Sample of the Business Budgeting Software & see exactly what you get

Click here to view or download a PDF version of our USER GUIDE

Scroll down to to view a version modified for web viewing (for best results view the .PDF version)

INDEX

Section 1 Basic Information about the Business Budgeting Software Workbook

Sheets/Tabs (Input-, Print- & Report Sheets)
Print / Export Facility 
Compatibility with newer versions 4

Section 2 Capturing Budget Data (STEPS 1 – 6)

2.1 STEP 1:  START SCREEN (“SET-UP”)

                     Name of Company / Project 
                     Type of Budget Software
                     Financial Year End
                     Company Tax Rate
                     Using Branches / Divisions

2.2 STEP 2: CHART OF EXPENSE ACCOUNTS 

                     Renaming Expense Accounts
                     Selecting / Un-selecting Expense Accounts
                     Resetting the Chart of Expense Account s 
                     Salary & Wages Expense Accounts

2.3 STEP 3: CAPTURING OF SALES INFORMATION

                     Number of Input Lines
                     Customer Name and Branch / Division
                     Net Margin 12 Monthly Sales Amounts
                     Year-on-Year Increase in Sales

2.4 STEP 4: CAPTURING OF OPERATING EXPENSES

                     Entry Method (& starting periods)
                     Amounts – Entry Columns
                     Escalation + Esc/Incr %
                     Year-on-Year % Increase (YoY Incr%)

2.5 STEP 5: VRAIABLE EXPENSES + INTEREST/FINANCE CHARGES

                     Other Variable Expenses 
                     Interest Calculation

2.6 STEP 6: FIXED ASSETS / CAPITAL EXPENDITURE

                     Existing Fixed Asset Values
                     Entry of Capital Expenditure (Fixed Asset Purchases)

Section 3 Business Budgeting Software Reports 

                     Examples of final Business Budgeting Reports available for print/export

 

USER GUIDE (modified for web page viewing)

1 BASIC INFORMATION ABOUT THE BUDGET MODEL WORKBOOK

   1.1 Sheets / Tabs There are 20 sheets in this workbook

Input Sheets (1-6) (BLUE Tabs): These sheets are the only ones you need to capture information to. They are in order of the 6 step process needed to generate your financial budget. THESE SHEETS MUST NOT BE PRINTED.

Print/Export Sheet (7)(YELLOW Tab): This sheet will allow you to either print or export (in .xls format) selected budget reports (i.e. Income Statement (P & L), Operational Expenses, etc.).

Report Sheets (7-20) (RED Tabs): All these sheets are automatically generated from the information you capture to the blue sheets. They include all the reports necessary to print and present your budget and use for capturing to your accounting package. ONLY THESE SHEETS SHOULD BE PRINTED (You can use the Print/Export Sheet (Yellow Tab) to print or export the sheet.

 

1.2 Print / Export facility

Once you’ve completed STEPS 1 – 6 to generate your budget, you will be able to:

1.2.1 EXPORT a .XLS FILE which will only include the final printable budget reports. As the entire budget software model file is too large to eMail, this will allow you to generate a file of less than 1MB that you will be able to eMail or create a .pdf file from.

1.2.2 PRINT the final budget reports to your ‘default’ printer.

1.2.3 For both the Export & Print facility you will be provided with a further 3 options:
         1.2.3.1 Full Budget Report: This will include all the relative budget reports and should be used if you have selected to incorporate branches or divisions in your budget. The reports includes in this option are:

• Cover Page
• Index Page (with Budget Approval schedule)
• Income Statement
• Income Statement – Per Division
• Income Statement – 3 to 5 Years
• Sales Budget
• Fixed Expense Summary
• Fixed Expense Summaries - Per Division
• Fixed Expense Detail (Year 1 Only)
• CAPEX / Depreciation Schedule

 

1.2.3.2 Business Budgeting Software Report : This is the standard budget report pack. If you have selected NOT to incorporate branches or divisions into your report, then this option should be selected. It will include all the reports listed in 1.2.3.2 above, with exception to the ‘Fixed Expense Summaries – Per Division’ report (as this will not be required).

1.2.3.3 Additional Information Pages: This report incorporates additional information which will assist in the capturing of your budget data to the accounting software application used by you or your Company. This report is not included in Option 1 & 2 and is therefore printed separately.

 

1.3 Compatibility with newer Versions of Excel

The financial budget model is compatible with Microsoft Excel* 2003 and newer versions. If you are a user of any versions newer than Excel 2003, then you may want to save the file in the newer format (i.e. .xlsx). If you will be sharing the file with other users who have not yet installed the newer versions (and work in Excel 2003 or older versions) it is recommended that you always save the file in a format compatible with the older version.
When saving the file: select “Save As” (and not “Save”) and choose the “Excel 97-2003 Workbook” option. When saving in this format you will see the following ‘Compatibility Checker’ message (illustrated below) when you save the file for the first time. Simply click continue.

*Microsoft and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other Countries.

 

2 CAPTURING BUDGET DATA (STEPS 1 – 6)

STEP 1 - START SCREEN (“SET-UP”)

This input screen will require you to define basic information about your Company/Project as well as the format of the financial budget you wish to create. It will affect the headings (name, dates, etc.), selection criteria and the calculations within all the other input screens and report sheets. (see image below)

Name of Company/Project

Enter the name of your Company/Project. This name will automatically be inserted as a heading in all the budget reports which you will be printing and presenting.

Type of Budget Software Model

Select the type of budget you wish to create. Here you can select the number of years you wish to forecast and select whether or not you want the budget software reports to reflect the actual Year and actual Months in the headings of your budget reports.

If you select one of the “Dated” options: The model will automatically calculate the actual months and year numbers (i.e. “Aug-09”) to included as headings in your budget model – based on the fiscal information you capture to this screen.

If you select one of the “Using Period Numbers” options: The model will automatically change all the headings to include period numbers (i.e. “Period 1”-12) for the 1st twelve months of your budget. This is useful when you do not know exactly when a project or new Company will start.

2.1.3 Financial Year End   

Select the month in which your financial year ends or the month in which the first year of your project will end. This option is not required if you select one of the “Using Period Number” Options as per 2.1.2 above.

Enter the year in which your next financial year end will occur or when your project end period will be. 

2.1.4 Company Tax Rate

Enter the prevailing income tax rate applicable to your Company. This percentage will be used to automatically calculate the amount of income tax you need to pay and will reflect in the financial budgeting software reports.

2.1.5 Using Branches / Divisions

Note:

If you need to budget/forecast for different branches or divisions within your Company, the budget model will allow you to split your forecast into 4 or less branches/divisions.

At this point you would select whether or not you want the budget model to refer to them as “Branches” or “Divisions”. 

If you select either “Branches” or “Divisions”, the model will request you to enter the names of the different Branches/Divisions. You can enter the names for between 2 and 4 branches/division.

The budget model will automatically refer to the names of your branches/divisions in the other input screens and budget reports. [The budget reports will include an income statement (P & L) for each of the branches/divisions].
NOTE:
If you do not need to split your financial forecast between different branches/divisions, then all your budget info must be entered into the 1st column or the column indicating “All Units” in the areas where you can capture your information into different branches/divisions (in most areas allowance has been made to split the budget amounts between 4 branches/divisions).

 

STEP 2 – CHART OF ACCOUNTS

This input screen will allow you to select or define exactly which expense accounts you would like to use in your financial budget. The model includes a number of standard expense accounts which are automatically selected when you first open the budget model.

• If you are budgeting for an existing Company, it is recommended that you rename the expense accounts to reflect the name of the general ledger expense accounts as per the financial accounting package used by your Company.

 

• The accounts you select or define here must only include all the accounts you would like to be regarded as the “operational expenses” which will be deducted from the gross profit to determine your profit before interest and tax in the income statement report.
  
  • Any variable expenses which change relative to your level of sales, and which you would like to be included in the material cost of goods sold (or included in your calculation of gross profit), can be captured in the “Variable Expenses and Interest” sheet (STEP 5) as explained below. This may include items such as transport, packaging or any other expenses that change in relation to the revenue levels. These expenses must not be defined in this “Accounts” sheet.
  • Depreciation and Interest (or finance charges) must also not be defined in this section – as both of these items are allowed for in STEP 6 (Capital Expenditure) and STEP 5 (Variable Exp & Interest) respectively.

2.2.1 Renaming Expense Accounts

A standard chart of expense accounts will already be listed when you open the budget model for the first time. These will automatically be named and included in all the relative input screens and budget reports throughout the budget model.

You will be able to rename some or all of the expense accounts in order to reflect the names of the expense accounts used by your Company or to reflect the names of expense accounts more suited to your business, project or industry.

When you rename any of the expense accounts, the names of the expense accounts in other input screens as well as your budget reports will automatically change throughout the budget model.

2.2.2 Selecting and un-selecting Expense Accounts

All listed expense accounts will be selected when you open the budget model for the first time. If you do not want to include certain of the expense accounts listed, then simply ‘un-tick’ the box next to the name of the account (as illustrated above).

When you un-select an account, then the account will be listed as “IGNORE (Blank Item)” in all the other input screens and budget reports. Click and un-click the tick-boxes next to the account names and then see what effect it has on the “Operational Expense” input screen (STEP 4) as well as the Fixed Expenses report in the “Expense All” sheet (red stab). [as illustrated below]

2.2.3 Resetting the Chart of Expense Accounts

If you have made several changes to the list of expense accounts, and you would like to ‘reset’ the list to include the standard list of accounts as when you first opened the budget model, then simply click on the button illustrated above [grey button indicating “Click to Reset Account Descriptions to original names included in model”].

2.2.3 Salary & Wages Expense Accounts

It is important to understand the following with respect to the 8 Salary and Wages expense accounts with the darker blue background [as illustrated below].

The reason these are grouped and the reason why only salary related expense accounts should be included in the darker blue section, is because Salaries & Wages are grouped and reported separately to the other expense accounts in the Income Statement (P & L) report. As illustrated below the Income Statement reports on “Expenses” and “Salaries & Wages” separately under Operation Costs.

• The Salary – Co. Contribution... accounts relate to the contributions made by the Company, over and above the gross salaries paid to employees (‘Salaries – Main account’), to funds, institutions or government bodies. This could include the portion the company pays towards employees’ medical aid funds, pension funds, unemployment insurance funds, workmans compensation funds, etc.

 

• You may choose to only select one salary account which includes the total cost of employment.

• You and/or your Company may prefer to regard salaries or direct labour as variable expenses which directly relate to the level of revenue generated. You may further prefer to treat such expenses as an ‘above-the-line’ trading expense which must form part of your cost of goods sold (and is ultimately deducted from revenue when calculating Gross Profit (before fixed expenses).
  
  In this event it is recommended that you un-select these accounts and capture Salaries and/or Labour as a variable expense in STEP 5, where you can select an option to calculate the item as a % of sales.
  
  However, if you regard it as variable but still wish to include it ‘below-the-line’ with all the other operational expenses, then you can select the option to calculate this expense as a “% of sales” when capturing details to the “Oper Expenses” (STEP 4).

• Please take note of the “NB Please Note” notice to the right of the Salaries & Wages expense accounts listed.       

STEP 3  – CAPTURING OF SALES INFORMATION

The “3 Sales” sheet is used to capture all your sales and margin related data.

2.3.1 NUMBER OF INPUT LINES

The sheet allows for 100 line entries. You may choose to capture your sales information in one of the following formats:

1. Include each one of your customers [if you do not have more than 100 customers]

2. Include only the monthly total sales [if you have more than 100 customers or if your sales budgeting is normally done on a separate spreadsheet or in a different application used by the sales department]. If you are budgeting for 2 or more branches/divisions, then you can    do a separate line for each branch

3. Include only the monthly total sales per region [and per branch/division if necessary]

[in the example below we assume entry of sales info for each Customer]

Customer Name and Branch/Division

If you budget for more than one branch/division, then select the branch/division each customer belongs to - from the drop down list next the name of the customer.

2.3.3 Net Margin

Enter the net margin % you expect to achieve against each customer. Take note of the following:

• You do not need to enter the forecasted cost of the goods sold anywhere in the budget model. Instead you are able to only include the margin per customer. The budget model will automatically calculate and report the cost of goods sold.
• The margin % you enter, must be the gross profit (sales less ‘material’ cost of goods sold less rebates/discounts) captured as a percentage of the sales value against each customer. For example: You purchase a bicycle at a cost of $60 and you sell it for $100. The margin you enter will be 40%.
• If you include direct variable expenses (i.e. transport, head office fees, etc.) in the Variable Expense section (STEP 5), then the calculated margin must not include the cost of such goods.
  
  If you do however include all variable expenses in the calculation of your margin, then you do not need to capture any additional Variable Expenses in (STEP 5).
  For example: You may want to include the cost of transport ($3 per unit), franchise fees (5%) and direct sales expense ($8 per unit) when calculating the cost of goods sold for the bicycle you sold for $100. In this case your cost of goods sold amounts to $76 ($60+$3+$5+$8) and your margin is calculated at 24% ($24/$100).
• As the margin should reflect the ‘net’ margin against each customer, any known rebates or discounts should also be deducted from the margin. For example: If you award your customer a 3% rebate against the bicycle sold in the abovementioned example, and if you anticipate a 2% settlement discount, then the net margin reduces to 19%.

2.3.4 Monthly Sales Amounts

Capture the monthly total revenues you forecast against each customer. If necessary, provide for seasonal fluctuations, holiday periods or months with a large number of public holidays. 

2.3.5 YEAR-ON-YEAR INCREASE IN SALES

This option allows you to forecast the sales for years 2 and 3 or years 2-5, depending on the type of budget model you selected. This can be ignored if you selected a 12 month only budget.

If you selected to generate a 3 or 5 year budget, then the following can be captured in this section

• As illustrated above, you can select whether or not you want to increase or decrease the annual sales ‘per customer’ or if you want to capture a ‘global’ increase/decrease. [a pop up note will also appear when you select this option]
• If you anticipate the exact same volumes and revenue against certain or all customers, then the % should be kept a 0%. If you anticipate a 50% drop in revenue to a particular customer, then -50% must be entered in the period you expect the decrease.
• If you select to increase/decrease per customer, you will have a further 2 options for capturing the anticipated increase/decrease:
  
  • Option 1: Enter the % increase/decrease for each of the next number of years you are budgeting for. For  3 years budget, only enter your % into “Yr2” and “Yr2”; or
    
  • Option 1: Enter the % increase/decrease for each of the next number of years you are budgeting for. For  3 years budget, only enter your % into “Yr2” and “Yr2”; or
    
  • Option 2: If you anticipate the same year-on-year growth (or decline) in revenue to a particular customer, then you can enter the % increase/decrease into the “Every Yr” cell;
    

STEP 4  – CAPTURING OF OPERATING EXPENSES

This section is used to capture the details against each of the Expense Accounts a selected and/or defined in STEP 2 above. All the names of the Expense Accounts selected have automatically been updated on this sheet. There is a detail section for each one of the Expense Accounts selected.

You are able to enter up to 8 different line items against each expense account

2.4.1 Entry Method (& Starting periods)

This determines how each of the expense line items are (1) calculated and (2) distributed throughout the year. You can select your Entry Method from the drop down list illustrated below

The Entry Methods work as follows when selected:

ANNUAL:  Select this option when you want to enter the annual amount of the expense line item. The amount you enter will automatically be distributed over the 12 month period, in 12 equal monthly amounts. For example: If you enter $120,000 – then an amount of R10,000 will automatically be allocated to each of the 12 months of the 1st year of the budget.

MONTHLY:  Select this option when you want to enter the monthly amount of the expense line item. The amount you enter will be repeated in every month of the 12 month period. For example: If you enter $10,000, the amount will be allocated to each of the 12 months, amounting to $120,000 for the year.

% OF SALES: Select this option if you want the model to automatically calculate the expense line item as a % of sales (revenue/turnover). If, based on historical data, you are able to determine that an expense item (such as bank charges) normally amounts to a particular % of the revenue generated, then you will be able to select this option and then insert the % in the “% of Sales” column as illustrated below. When you select this option, and when you have entered a % in the appropriate column, then you need not enter any further amounts in the 4 columns to the right of the “% of Sales” column [used for entry of amounts for all other Entry Methods]. All amounts entered in these columns will not be used in calculations if the % of Sales option is selected.

ONCE OFF:  Select this option if you forecast that an entire line item will be expensed within one month of the financial year. For example: If you have a golf day once a year and all expenses relating to the day will be expensed in August, (1) select the ‘Once-off’ option, (2) select the month (August) in which you expect the item to be expensed and (3) enter the amount you expect to expense for this event [see illustration below]. The model will automatically allocate the amount to the appropriate period.

OVER 2-6 MONTHS:  Select this option if you forecast that an entire line item will be expensed over only a few months of the financial year. For example: If you have a golf day once a year and all expenses relating to the day will be expensed over a 3 month period starting in July, (1) select the ‘Over 3 months’ option, (2) select the month (July) in which you expenses to start (3) enter the amount you expect to expense for this event [see illustration below]. The model will automatically distribute the amount over the three months (July, August, and September) in equal proportions.


It is recommended that you test these selection items (including the capturing of amounts in the relative areas) and view the resultant allocations in the “Expense All” report sheet

2.4.2 Amounts - Entry Columns
For all ‘Entry Methods” (with exception to the ‘% of Sales’ option), you enter the amounts in these columns [as illustrated below]. If your budget does not need to cater for different branches/divisions, then you would ALWAYS enter your amounts in the far left column (‘New York’ column in illustration below). 

 

2.4.3 Escalation + Esc/Incr %

This option is used where you anticipate the amount of an expense line item to increase at a certain point during over the financial year. Examples of this would include:

• Escalation as per rental agreements: When your rental agreement stipulates that your rent would increase by a nominated % in the same month of every year;
• Annual contracted or anticipated increases in subscriptions or goods purchased;
• Increase in labour costs, subject to wage negotiations with unions, at a particular time in the year;
• Etc.

Select the month in which you expect the item to increase/escalate and enter the % with which you think the line item will increase.

 

2.4.4 Year-on-Year % Increase (YoY Incr%)

If you selected to generate a 3 year or 5 year budget, then it will be important for you to enter the anticipated Year-on-Year increase in this section [as illustrated below]. In most cases one would provide for a consistent increase % for the purposes of inflation or when a relative increase is generally experienced with respect to certain suppliers or industries.

 

2.5 STEP 5 – VARIABLE EXPENSES AND INTEREST/FINANCE CHARGES

This section is used to:

• Enter the variable direct expenses expressed as a % of sales. This will include only the direct variable expense items that have not been included in the calculation of the Net Margin as per STEP 3 above.
• Capture the amount of interest / finance charges forecasted or select an automated calculation method for interest / finance charges.

 

2.5.1 Other Variable Expenses

2.5.1.1 Selection of Br/Div If only a certain branch is subject to a particular variable expense, then you will be able to select the relevant branch here. Generally, the same variable will apply to all branches, in which case you select the “All Branches / Divisions” option.

 

2.5.1.2 Selection of entry method

You can select to either calculate the variable expense line item as (1) a % of sales (revenue/turnover) or (2) based on a fixed monthly amount you could enter to the columns to the right of the “% of Sales” column. The latter option might be applicable where a Company has secured a fixed monthly expense amount, against an expense item that is normally treated as an ‘above-the-line” expense item (such as transport). The latter option is also useful for Companies that choose to allocate their fixed monthly salaries/labour ‘above-the-line’ and calculate their gross profit after including the cost of salaries/labour.

 

2.5.1.3 Amount Entry Columns

Should you have selected the ‘Enter as equal Monthly Amounts’ option as illustrated above, then you would enter the applicable monthly amounts in the areas illustrated below.

 

2.5.1.4 Year on Year Increase %

If the latter option as per 2.5.1.2 has been selected and once you have entered the fixed monthly amounts, AND should you anticipate an increase (inflationary or otherwise) in the costs of these items, then you will be able to enter the Year-on-Year % increase in this section. [THIS WILL ONLY BE RELEVANT FOR 3 OR 5 YEAR BUDGETS]

2.5.2 Interest Calculation (also finance charges)

 

2.5.1.1 Entry Method

You can choose between a monthly or an annual interest amount. Once selected, the model will indicate where you need to enter the monthly or annual interest amounts.

 

2.5.1.2 Split Method

Where more than one branch/division is included in your budget, the interest expense needs to be split between the relevant branches/division. This selection will default to the option where the interest will be split according the % of sales each branch/division represents against total sales. For this option, the % split is automatically calculated [see illustration below].

Should you know the exact split for the interest charges (between the relevant branches), then you will be able to manually enter the % split once you select the second option (“Manual Entry of % per Division”).

Should you need to revert back to the 1st option (“According to % of Total Sales”) after having manually entered %’s for the split, then the automatic calculation of the % split between the branches/divisions will be lost. To fix this you click on the “Reset” button (below the branches) which will restore the original calculations.

 

2.5.1.3 Year-on-Year Increase Decrease

Should you anticipate an annual increase or decrease in the cost of financing (you may increase/decrease debt or anticipate an increase/decrease in interest rates), then you will be able to enter the % with which you expect this cost to increase or decrease year-on-year. This will only be relevant for 3 and 5 year budgets.

 

 

2.6 STEP 6 – FIXED ASSETS / CAPITAL EXPENDITURE (‘CAPEX’)

In order to accurately calculate the depreciation expense on (1) existing fixed assets and (2) forecasted capital expenditure for the relevant number of years in your financial budget, this input screen will allow you to define the current asset values, the deprecation rates as well as the anticipated capital expenditure. This section can be ignored if you do not wish to include depreciation in your operational expenses or if you do not want to detail fixed asset purchases over your budget periods. Some Companies also prefer to only report up to EBITDA (earnings before profit, tax, depreciation and amortization). In this instance the Income Statement reports need to be amended to cater for the reporting standard.

 

2.6.1 Existing Fixed Asset Values

The entry of this information is vital for:

• defining your Fixed Asset Categories (which will automatically update all the input screens as well as the relative budget reports);
• calculating the depreciation on existing fixed assets;
• calculating the depreciation on future capital expenditure (fixed assets to intend to purchase over the duration of this budget (1, 3 or 5 years).

This deprecation will form part of the total operational expenses (in the “Expenses”) and is reported on separately in the final budget reports.

Please note the following requirements when entering information in this section:

2.6.1.1 Depreciation %:
Enter the current % with which you depreciate your assets. If your current financial policy indicates that you ‘write-off’ (depreciate) assets over a nominal number of years (as opposed to defining a %), the divide 1 by the number of years. This will then determine the % you need to capture here. For example: If your policy stipulates that Plant & Machinery is written off over a 5 year period, then your depreciation % will be 20% (1 divided by 5). If you are starting a new Company/project we recommend that your accounting advisors determine the appropriate write-off periods or rather depreciation percentages which you can enter here.
2.6.1.2 Cost Value:
Enter the actual “COST” totals for each of the fixed assets categories as reflected in the general ledger (balance sheet) as it would be at the start date of your budget.
[DO NOT ENTER NET ASSET VALUES (Cost less accumulated depreciation) – as both the initial cost values as well as the accumulative depreciation values are required to accurately calculate the depreciation on existing fixed assets]
2.6.1.3 Accumulative Depreciation:
Enter the actual “ACCUMULATIVE DEPRECIATION” totals for each of the fixed assets categories as reflected in the general ledger (balance sheet) as it would be at the start date of your budget.
2.6.1.4 Utilisation per branch/division (Split):
Should you be generating a budget with more than one branch/division, then this section must be used to enter how the assets are currently split between the numbers of branches/division.

For example: If 60% of the motor vehicles (in terms of COST as per the balance sheet) are allocated to or used by the New York Branch, 30% by the Boston Branch and 10% by the Florida branch, then you need to enter 60%, 30% and 10% into the respective branch columns (as illustrated below).

If your % allocation does not add up to 100%, then the budget model will indicate that there is an error.

If your budget does not allow for branches/division, then you do not need to enter %’s in this section. The budget model will automatically assume 100% in the 1st column.

 

2.6.2 Entry of forecast Capital Expenditure (Fixed Asset Purchases)

This section is used to capture the cost of any fixed assets you will be purchasing over the duration of your financial budget. Not only will this generate a presentable Capex Requirement Report (which you can use to present to your board, shareholders, members or employees), the budget model will automatically calculate the deprecation that will form part of your operational expenses (based on the depreciation %’s you entered as per 2.6.1 above).

Provision has been made for entry of up to 15 line items (purchases) per fixed asset category.

Should your budget cater for more than one branch/division, then ensure that you enter the cost of the asset in the correct column. If one assets was purchased, and all branches/divisions would benefit from such a purchase (for example: server software that will benefit all branches), then split the cost of the asset in whichever proportion is suitable for such a purchase. [some Companies would split such costs based on the number of network users, or in proportion to branch turnover, etc.]

Should you select to generate either a 3 or a 5 year budget, then only the total annual purchases can be entered for years 2-5 [see illustration below].

 

3 FINAL BUDGET REPORTS

3.1 Examples of final Budget Reports available for print/export

• Income Statement (Profit & Loss Statement)

• Income Statement: (1) PER DIVISION/BRANCH + (2) Year-on-Year

• Income Statement (Profit & Loss Statement)

• Expense Schedule

Expense Schedules for each of the branches / divisions can be printed if Option 1 is selected (when branches / divisions are used).

• Expense Detail Schedule

This schedule will show all detailed line items captured – per expense account – as included when capturing operational expense items.

• Expense Detail Schedule

• Additional: Budget Entry Pages

This page provides you with the split of variable expenses – per division/branch – which will assist with the entry of budget data to your accounting package / application.

Business Budgeting SoftwareUser Guide PDF click here to download

Attachment	Size
Click_&_Plan_FBM_Sample_(zipped).zip	756.39 KB