Yes sir, you can do it. on one sheet you can put inflow 2nd sheet you put outflow and 3rd sheet make as summary.
you can do very good budget with the help of Excel, I can help you if you need
Budget plan documents can be viewed and edited using one or more layouts. Each layout can have an associated budget plan document template to view and edit the budget plan data in an Excel worksheet. In this topic, a budget plan document template will be generated using an existing layout configuration.
Yes you can. You can develop rather sophisticated budgets in Excel. In Samoa we use integrated Excel spreadsheets to formulate the national budget. This system is for Performance based output budgeting and uses a single point of entry with the data cascading into other spreadsheets sheets which provide summaries on department and overall government levels (ie. you can look at and compare revenue and expenditure estimates by output / sub-output levels on a department level or compare the same on departmental level).
The system is designed to also allow comparison of actuals against estimates which means that the system can and is used also for budget review and monitoring.
It can also be used to run scenarios (increases/decreases to revenue/expenditures either on a percentage or individual items eg. running a scenario of the cost of a proposed salary increase across the public sector or for specific professions such as police or teachers, or of a major capital project or to assess the impact of a tax change. This means that you can make the changes and have see the over all impact on the budget at various levels right away. Often this is done live during some budget meetings.
When rolling forward estimates were introduced this was incorporated into the existing integrated spreadsheet system.
In short Excel is extremely adaptable and has enormous capability which is only limited by how well you know the functionalities and how you design your spreadsheets. It may take a lot of time to set it up (thinking about what data and functionalities you want included and careful meticulous formatting and testing). But once it is set up and running the time saved and errors eliminated is monumental and well worth it.
We also used Excel spreadsheets to collect data for cashflow forecasting and management. This system had to take into account multiple currency bank accounts some which required separate treatment and cash inflows and out flows in multiple currencies (including multi currency loan repayments). We used this integrated Excel spreadsheet system to forecast long, medium and short term cash-flow requirements (10 years, annual, monthly, weekly and daily) as well as run scenarios on the impact of policy changes to revenue and expenditure.
Again ... excel has great versatility, it just requires knowledge of the functionalities and thinking about what you want.
- Badges
- Science topic