Budgets
As a business, you are expected to set targets to forecast how your business is going to perform, either for increasing your revenue or for decreasing your expenses. These targets are called budgets.
However, businesses usually do not perform as forecasted. The performance of your business (otherwise known as actuals) is prone to unprecedented events, making it hard for businesses to meet the budget targets they had set initially. If you’ve been using Zoho Books diligently, you would have an idea of how your business is performing by tracking your receivables and payables.
Using Zoho Books, you can now reflect on how your business is performing by comparing your projected budget versus the actual performance of your business using very extensive and insightful reports. This process is also known as Budget Variance.
Create Budget
- Go to Accountant > Budgets.
- Click + New Budget in the top right corner.
Enter the following details:
| Field | Description |
|---|---|
| Name | Enter a name to identify your budget. |
| Fiscal Year | Select the financial year for which you would like to create a budget. |
| Budget Period | Select a time period for your budget. The budget period can either be monthly, quarterly, half-yearly or yearly. |
| Income Accounts | Select the income accounts you want to include in the budget. |
| Expense Accounts | Select the expense accounts you want to include in the budget. |
- If you want to include Assets, Liabilities, and Equity accounts in your budget, click the Include Assets, Liability, and Equity Accounts in Budget option.
| Fields | Description |
|---|---|
| Asset Accounts | Select the asset accounts which you want to include in the budget. |
| Liability Accounts | Select the liability accounts which you want to include in the budget. |
| Equity Accounts | Select the equity accounts which you want to include in the budget. |
You can associate reporting tags to your budgets as well. To do this:
- Click Create this budget for a specific reporting tag.
- Select the tag name and choose an option.
Next, you can record the budgets for your income and expenses. To record them, you can:
Enter Them Manually
If you would like to enter the budget manually, you can enter the amounts in the fields provided next to the respective accounts. Once you have recorded the budget for your income and expenses, the Net Profit and Loss will be automatically calculated by Zoho Books.
Pre-fill based on Previous Years’ Actuals
If you would like to create a budget based on one of your previous year’s business performance, you can do just that in Zoho Books.
- Click Pre-fill from Previous Years’ Actuals.
- Select a previous year.
- Click Pre-fill.
The Net Profit and Loss will be automatically calculated by Zoho Books.
Auto-fill accounts
Instead of entering the amount for each account and period individually, you can just enter the amount for the first period for an account and choose to auto-fill values for the subsequent periods (monthly, quarterly or half-yearly). The amounts in the subsequent periods will be auto-filled based on the first period amount and the following criteria:
- Apply fixed amount for each period
- Adjust by amount for each period
- Adjust by percentage for each period
Auto-Fill by Applying Fixed Amount for Each Period
If your business is projected to earn the same income or incur the same expense for each period in your budget, you can select this option. You will have to enter a fixed amount for the a period. The subsequent periods will be auto-filled with the initial amount you’ve entered.
Auto-Fill by Adjusting the Amount for Each Period
If your business is projected to earn income or incur expenses based on adjustments to amounts, you can select this option. You’ll be able to add the adjustment amount to the:
Add the adjustment amount to the first period’s amount
You can enter an amount for the first period and the subsequent periods will be auto-filled based on the adjustment amount.
Scenario: If you have set the first period’s amount as 1000 and the adjustment amount for each period as 100, then 1000 will be amount for the first period, 1100 for the second, 1200 for the third and so on.
Pro Tip: You can add the negative symbol (-) if you want the amounts in the subsequent periods to depreciate.
Add the adjustment amount for each period’s existing amount
You can select this option if you’ve already entered your budget and you wish to update them with an adjustment amount.
Scenario: Say, you want to create a budget such that you want to add 100 to the accounts of the previous years’ budgets. Let’s assume the previous years’ budgets for first three periods are 1000, 2000, and 1500. When you enter your adjustment amount as 100, the amounts for the newly created budget for the first three periods will be 1100, 2100 and 1600 respectively.
Pro Tip: You can add the negative symbol (-) if you want the amounts in the subsequent periods to depreciate.
Auto-Fill by Adjusting the Percentage for Each Period
If your business is projected to earn income or incur expenses based on a percentage, you can select this option. You’ll be able to add the percentage to the:
Add the adjustment percentage to the first period’s amount
You can enter an amount for the first period and the subsequent periods will be auto-filled based on the percentage of adjustment.
Scenario: If you have set the first period’s amount as 1000 and the adjustment for each period is 10%, then 1000 will be amount for the first period, 1100 for the second, 1210 for the third and so on.
Pro Tip: You can add the negative symbol (-) if you want the amounts in the subsequent periods to depreciate.
Add the adjustment amount for each period’s existing amount
You can select this option if you’ve already entered your budget and you wish to update them with a percentage of adjustment.
Scenario: Say, you want to create a budget such that you expect a 10% increase to the accounts of the previous year’s budget. Let’s assume the previous year’s budget for the first three periods as 1000, 2000, and 1500 respectively. When you enter the percentage of adjustment as 10, the amounts for the newly created budget for the first three periods will be 1100, 2200 and 1650 and so on.
Pro Tip: You can add the negative symbol (-) if you want the amounts in the subsequent periods to depreciate.
Budget Summary
Once you’ve created a budget, Zoho Books will use the budget to generate the following reports so that you can forecast your company’s finances:
Profit and Loss
The Profit and Loss report is generated based on the amount that you entered for the selected income and expense accounts when you created a budget. Your net profit and net loss will be calculated for the period that you have chosen based on the net income and net expense. Knowing the profit and loss for a budget that you have created will let you make better financial decisions and make the necessary changes to increase your profits.
Learn more about Profit and Loss Report.
Balance Sheet
A balance sheet in the budget is used to predict your assets, liabilities, and equities for the budget period. It will always be calculated for the period chosen (Monthly, Quarterly, Half-yearly, Yearly ). This report can be used to know the financial position of a business based on the values entered in the budget.
Zoho Books is a double-entry accounting system, this means that the budget values in the Balance Sheet will be maintained as follows:
Total Asset = Total Liability + Total Equity
In the budget, if the total asset account is not equal to the total liability and equity amount, Zoho Books will add a new equity account called Budget Mismatch Account to ensure that your accounts are equal.
Learn more about Balance Sheet Reports
Cash Flow Statement
The Cash Flow Statement report is a comprehensive report that will show you the total cash flow of your business based on the values entered in the budget. Using this report, you will get an idea about the cash coming in and going out of your business based on the values entered in the budget. Similar to the Balance Sheet report, this report will also include the Budget Mismatch Account if your total asset account is not equal to the total amount of liability and equity.
Learn more about Cash Flow Statement Report.
Compare Budgets Vs Actuals (Budget Summary)
OOnce you have created a budget, you can know how your business is actually performing against your forecasted budget. You will be able to compare your budget vs actuals with Profit and Loss, Balance Sheet and Cash Flow Statement reports. To compare them:
- Go to Accountant > Budgets.
- Click View Budget Vs Actuals next to a budget that you’ve created.
You will also be able to:
Export Budget Report
You can export your organization’s budget summary as a PDF, XLS, XLSX format.
Pro Tip: If you use Zoho Sheets, you can export your organization’s budget summary to Zoho Sheets as well.
- Go to Accountant > Budgets.
- Select the budget.
- Click View Budget Vs Actuals.
- Click Export As in the top right corner and choose your preferred format.
Customize Budget Report
You can run your budget summary report based on the name of the budget and account type (All Accounts, Budget Accounts, Accounts with Transactions, and Budget Accounts or Accounts with Transactions ). To customize your budget summary:
- Go to Accountant > Budgets.
- Select the budget.
- Click View Budget Vs Actuals.
- Click Customize Report in the top left corner.
- Select the budget, filter, report basis and the budget period.
| Field | Description |
|---|---|
| Filter | Run your report based on the account type. You can select all accounts, active accounts, budget accounts and budget or active accounts. |
| Report Basis | You can run your report based on the type of income and expenses, It can be Accrual or Cash. |
| Budget Period | Run your report based on monthly, quarterly, half-yearly or yearly budget periods. |
| From | Select the starting date from which you want to generate the report. |
| To | Select the date till which you want to generate the report. |
Note: The Budget column in the report will be generated from the beginning of the month of the date given in the From field to the end of the month of the date given in the To field. For example, If you have the From date set as 14/5/2021 and the To date set as 3/9/2021, the budget column in the report will be generated from 01/05/2021 to 30/09/2021 The Actuals column will be generated from the exact custom dates you have set.
The accounts that can be filtered have been mentioned below:
| Filter | Description |
|---|---|
| All Accounts | Select this option if you want to run the report for all accounts. |
| Accounts with Transactions | Select this option if you want to filter the accounts that have transactions recorded. |
| Budget Accounts | Select this option if you want to filter the accounts that are included in a budget. |
| Accounts with Transactions or Budget Accounts | Select this option if you want to filter the accounts that have transactions recorded or the accounts that are included in a budget. |
Insight: If you had set a certain budget period say, quarterly while creating your budget, you can run your reports based on other budget periods (monthly, half-yearly or yearly) as well.
- Click Run Report.
Print Budget Summary
To print a copy of your budget summary:
- Go to Accountant > Budgets.
- Select the budget.
- Click View Budget Vs Actuals.
- Click the Print icon in the top right corner.
- Click Print.
More Actions
You can also perform certain actions for your budgets. You will be able to:
Edit Budget
If you have any changes that are to be made to your budgets, you can edit them anytime. To edit a budget:
- Go to Accountant > Budgets.
- Click the dropdown next to a budget you’ve created.
- Click Edit.
Clone Budget
If want to replicate a budget you had made earlier, you can just clone them. To clone a budget:
- Go to Accountant > Budgets.
- Click the dropdown next to a budget you’ve created.
- Click Clone.
Download Budget
You can download your budgets to your system as a PDF. To download your budget:
- Go to Accountant > Budgets.
- Select the budget you would like to download.
- Click the PDF icon in the top right corner to start the download the budget as a PDF.
Print Budget
To print a copy of your budget:
- Go to Accountant > Budgets.
- Select the budget you would like to print.
- Click the print icon in the top right corner.
- Click Print.
Delete Budget
If you no longer wish to use a budget, you can delete them permanently. To delete a budget:
- Go to Accountant > Budgets.
- Click the dropdown next to a budget you’ve created.
- Click Delete.
Yes
No
Thank you for your feedback!
