CMS - Budgets

Created by Mienette van Heerden, Modified on Thu, 13 Jun, 2024 at 2:06 PM by Glennise Pretorius

The budget can either be entered manually, line by line, or it can be uploaded with an Excel template. 




Note: the budget amount that is filled in for Levies will be used to calculate the monthly levy amount for each unit/section.




1. Admin Budget Setup


1.1 Manual Budget Entry

Navigation: Community Level > Setup > Budget




If this is the first time entering the budget, it will be unlocked, alternatively, scroll right to the bottom of the page and click on Re-Open Budget for Editing.




When entering the budget, there will be the option to fill in a fixed monthly/yearly amount, or the option to untick the Equal Monthly Amount box. When unticked, a message will appear that says Specify Monthly Budget




When clicked on, a pop-up screen appears, where the budget can be filled in per month should there be an increase during the financial year or the monthly amount differs from month to month. Once done, click on  Apply.




Once all the relevant budget amounts have been filled in, scroll down to the bottom of the page, and click on Finalize Budget





Important: if the budget is not Finalised the Billing Screen will not reflect any amounts.



1.2. Bulk Upload

Navigation: Community Level > Setup > Budget


1.2.1 Download Template


On the same Budget page, in the top right corner click on Download Budget Template.




The template will look similar to below, however, it is based on the community financial year period.




If the monthly budgeted amount is the same for every month, either fill in the month-to-month amount (column B - M) for each income and expense ledger or just fill in the per year amount (column N). If the budget amount was filled in per month it is not needed to fill in the per year amount, the system will calculate this upon upload.




Note: the system will not be able to read any formulas, please ensure the Excel amounts are in values format.




1.2.2 Import Budget


On the Budget page, in the top right corner click on Budget Excel Import.




1.3 Duplicating a Budget

Navigation: Community Level > Finance > Actual vs Budget


1.3.1 Download Template


When the budget stays the same as the previous year, there is a simple way to load this. In the relevant community, 




Tick the Add Monthly Budget, and select the dates to be an entire financial year ( 12 months). When the page has loaded, click on Download Excel.




Open the Excel file. Delete all the normal columns (not stating Budget).




Delete the YTD columns.




Delete the bottom row.




1.3.2 Import Budget

Navigation: Community Level > Finances > Budget


Select the financial year for the new budget.




Click on Budget Excel Import on the right-hand side of the page.




Select the Excel file, and when it is finished uploading, click on Close.




2. Reserve Budget Setup


The Reserve Fund Budget works in the same way as the normal budget. It also has a manual input and an Excel import option.



2.1. Manual Budget

Navigation: Community Level > Setup > Reserve Fund Budget




Here is where the option exists to manually type in the Reserve Fund Levy Amount (Per Month or Per Year).




Once done inputting the whole budget, scroll right down to the bottom of the page, and click on Finalize Budget





Important: if the budget is not Finalised the Billing Screen will not reflect any amounts.



2.2 Bulk Upload

Navigation: Community Level > Setup > Reserve Fund Budget


2.2.1 Download Template


On the same Budget page, in the top right corner click on Download Budget Template.




The template will look similar to this




If the monthly budgeted amount is the same for every month, either fill in the month-to-month amount (column B - M) for each income and expense ledger or just fill in the per year amount (column N). If the budget amount was filled in per month it is not needed to fill in the per year amount, the system will calculate this upon upload.



2.2.2 Import Budget


On the Budget page, in the top right corner click on Budget Excel Import.




Once done inputting the whole budget, scroll right down to the bottom of the page, and click on Finalize Budget





Important: if the budget is not Finalised the Billing Screen will not reflect any amounts.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article