Budgeting, Forecasting and Cash Planning

The purpose of this page is to help you learn the Budgeting and Forecasting tools in iDempiere.

Summary Explanation

A demonstration will come at a later time. You can create/import a GL Journal of Posting Type "Budget". Choosing a Posting Type of "Budget" exposes a new field called Budget. By creating multiple Budget records, you can easily extend this ability into forecasting. You can create and report against multiple budgets/forecasts simultaneously: operating budget, best case forecast, worst case forecast, etc.. When you create a budget, you will hopefully have more revenue than expenses. To make the budget's GL Journal balance, you will typically put the balance/profit to Retained Earnings. You can upload a budget per year (uploaded in Jan), per 6 months (in Jan and July), per quarter (in Jan, Apr, July, and Oct), or per period . The Financial Reports => Report Column Set gives you the ability to designate columns as either Posting Type "Actual" or "Budget". You can also use the columns to perform math (budget-actual). The GardenWorld => Income Statement => Financial Report includes an example of designating some columns as "Budget" and calculates "Remaining Budget". More information and a screen shots of Adaxa's Solution for Budget Uploading.

Cash Planning

The above section helps you build a budget into your existing financial reports and trial balance; however, it does not help you manage cash. Here are two tools to help you manage cash: