Budget Management

Requirements

This tutorial requires the installation of the following applications/modules:

The Budgets app is where you make the necessary configurations, create and keep tracking of the budgets, and view the budgets analysis reports. The management can be done by using:

  • Budgetary Positions: through accounting accounts;

  • Analytic Accounts;

  • Combination of Budgetary Positions and Analytic Accounts.

Install Budget Management app

Navigate to Apps, find the Budgets, click on Install.

Install Budget Management Viindoo

After installing, the Budgets app will be available on the main menu.

Budgets app Viindoo

User access rights

With Budget App, Viindoo system supplies these user access rights:

User access rights
  • Leave it blank: User can’t see or access to Budget App.

  • User: User can create Budget, edit, delete or see the Budget Analysis reporting of budget that he/she created. User can’t create, edit or delete a Budgetary Positions.

  • Administrator: User can create, edit or delete a Budgetary Positions, Budget and see the Budget Analysis reporting.

Create the tools for managing budget

Analytic Account

Analytic Account is a tool to collect revenue/expenses related to a specific budget. You need to set an analytic account on the related revenue/expense accounting entries to create links to the budget.

Budgetary Positions

Budgetary Positions is built to help budget managers collect revenue/expenses based on the financial accounting accounts.

In Settings, on the view to enable the Budgets Management feature, you will see a shortcut for creating Budgetary Positions.

Create Budgetary Position in Viindoo

Click on Budgetary Positions to create a budgetary position. Or, you can also do it by navigating to Budgets ‣ Budgetary Positions ‣ Create.

Create Budgetary Position 2 Viindoo

For instance, when creating a budget to track the office expenses. We will create a budgetary position with the name Budgetary Position 1. The expenses will be registered to these accounts:

  • Account 6421: Staff expenses;

  • Account 6423: Office equipment expenses;

  • Account 6424: Fixed asset depreciation.

The information of the Budgetary Position 1 will be entered as follows:

Create budgetary position Viindoo

Budget Management

Create budget

For example, we create a budget for Office expenses in 2022 at 200.000.000 VND. Follow these steps to create a new budget:

Navigate to Budgets > Budgets > Create to create a budget

Create a budget in Viindoo

Fill in General information

Enter the following information:

Create a new budget Viindoo
  • Budget Name: Name of the budget - Office expenses - 2022;

  • Period: Planned start date and end date - From 01/01/2022 to 31/12/2022;

  • Posted Journal Items Only: This feature will affect the way the data is collected to the budget:

    1. Budget using only Budgetary Positions:
      • Checked: Only posted journal entries will be added to the Practical Amount for calculation.
      • Not checked: All draft and posted journal entries will be added to the Practical Amount for calculation.
    2. Budget using only Analytic Accounts:
      • Whether this field is checked or not, only posted analytic accounting entries will be added to the Practical Amount.
    3. Budget using the combination of Budgetary Positions and Analytic Accounts:
      • Whether this field is checked or not, only analytic accounting entries that contain posted journal entries will be added to the Practical Amount for calculation.

Fill in Budget Lines information

Click on Add a line then enter the following information:

Create a new budget Viindoo
  • Budgetary Positions: Select the Budgetary Positions if you want to manage your budget by budgetary positions. It can be empty if you manage budget by analytic account.

  • Analytic Account: Select the Analytic Account if you want to manage your budget by analytic account. It can be empty if you manage budget by budgetary positions.

    Note

    • You can manage a budget by using Budgetary Positions or Analytic Accounts or both of them.

    • The combination of Budgetary Positions and Analytic Accounts makes budget analysis more detailed and multi-dimensional.

    • Select both Analytic Account and Budgetary Positions, then fill in the other fields following the instruction above.

  • Started Date/End Date: Automatically field based on budget Period that you enterd in the above general information. You can edit them if you want.

  • Paid Date: Paid Date is used for Theoretical Amount computation.

    • If Paid Date is specified later than today, the Theoretical Amount will be zero.

    • If Paid Date is earlier than today,the Theoretical Amount will be equal to the Planned Amount.

    • In case no Paid Date is specified, the Theoretical Amount will be calculated based on the elapsed time counting from the Start Date.

  • Planned Amount: Enter negative numbers upon money out and positive numbers upon money in.

  • Practical Amount: Every Journal Item amount, whose accounting date is within the budget period, will be added to this value if satisfy one of the following conditions:

    • The Journal Item contains the corresponding Analytic Account (if the budget is managed by using Analytic Account).

    • The Journal Item contains the corresponding accounting account that has been selected in the Budget Position (if the budget is managed by using Budget Position).

    • Both of the two conditions above (if the budget is managemed by using Analytic Account and Budget Position).

  • Theoretical Amount: The planned value to be achieved at present. The system will automatically calculate by the following formula:

    • Theoretical Amount = Planned amount per day * The number of days counted from the start date to the present.

    • Planned amount per day = Planned Amount / The number of days in the budget period.

  • Achievement: The percentage of Practical Amount in comparison to Theoretical Amount.

After entering all the information, click on Save. Then, click on Confirm and Approve to enable the budget.

Budget Analysis

To see Budget Analysis Reporting, you go to Budget > Budget Analysis. Here, you can see a list of all the budget with Not Cancelled filter and Budgets group.

Click on the triangle icon to show detail lines and go to Budget view.

Review budget Viindoo Go to budget view

In the budget view, click on Entries to see all the Journal Items.

Click Journal Items Journal Items

Budgets in the Viindoo system give you an intuitive, instant view to evaluate the budget, to see if it sticking to the plan and on the right track. From there, you can make adjustments to accomplish your plan for the rest of the time. Based on the old data, you can review, compare and plan more effectively.