# Forecast P&L **URL:** \ **Category:** Uncategorized\ **Created:** [April 6, 2022, 2:53pm UTC](https://forum.manager.io/t/forecast-p-l/40455 "2022-04-06T14:53:24Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [April 6, 2022, 2:53pm UTC](https://forum.manager.io/t/forecast-p-l/40455/1 "2022-04-06T14:53:24Z")
Dear Team Members, With the Forecast P&L statement you can make a long term budget prediction for the next periode For each periode (year) your you have the result of that period (year) Is it possible to have also the Assit (Cash at Bank) in the same table so to see based on the prediction what would be the Assit (Cash at Bank) in the future Assit plus result is next periode Assit To not interfere with the rest of the program the start value could be entererd manualy for example Your guidance or idea for the future is appriciated thanks Huib ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [April 6, 2022, 3:28pm UTC](https://forum.manager.io/t/forecast-p-l/40455/2 "2022-04-06T15:28:05Z")
That is not currently possible. You will notice that some, but not all, balance sheet accounts are available for selection when defining a forecast. But if selected, they do not appear on the resulting report. That suggests the ability to forecast balance sheets may be under development. ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [April 6, 2022, 3:48pm UTC](https://forum.manager.io/t/forecast-p-l/40455/3 "2022-04-06T15:48:24Z")
Yes balance sheet forecasting would be helpful to work towards future financial positions and estimate assets, liabilities and equity. I would propose that it becomes an idea. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [April 6, 2022, 4:13pm UTC](https://forum.manager.io/t/forecast-p-l/40455/4 "2022-04-06T16:13:21Z")
Forecasting balance sheets is a magnitude more difficult than forecasting a P&L There are many, many more variables at play such as Capital Expenditure, level of customer receivables, changes in inventory levels, receipt and payments of loans to mention just a few ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [April 6, 2022, 4:36pm UTC](https://forum.manager.io/t/forecast-p-l/40455/5 "2022-04-06T16:36:45Z")
Yes, but it is good practice even for small businesses. ---
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [April 22, 2022, 6:37am UTC](https://forum.manager.io/t/forecast-p-l/40455/6 "2022-04-22T06:37:30Z")
Dear Team Members Would it be possibe to put my request in ideas for the future? Thanks and regards Huib ---
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [July 10, 2022, 7:44am UTC](https://forum.manager.io/t/forecast-p-l/40455/7 "2022-07-10T07:44:44Z")
Dear Team Members As requested before would it be possible to add at the bottom a row for the assit It can be a number not coneected to the bookings but to show the nett result assit at 1 jan proffit assit at 31 dec With this a long term prognose van be made with in the program manager and without copy and past in to excel Thanks Huib ![Knipsel prognose](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/c/ac0fd06f21fb094afa792ee2c24f667de0f0acca.png) ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 10, 2022, 8:12am UTC](https://forum.manager.io/t/forecast-p-l/40455/8 "2022-07-10T08:12:52Z")
If by “assit” you mean “Cash on hand and in the bank” then it would not make sense to add the profit to the opening balance to get the closing balance. There is no direct relation between cash balance and profit. Many companies can be profitable but run out of cash and some companies can lose millions and still amass cash ---
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [July 12, 2022, 3:18pm UTC](https://forum.manager.io/t/forecast-p-l/40455/9 "2022-07-12T15:18:31Z")
@Joe91: i do not know what additional information you want to add to my request I would like to have a funtion in the Forecast P&L which shows; Balance (free text) 1000,00 | 1203,22 | 9354,61 | 10020,95 |etc Net profit (loss) 203,27 | 8151,39 | 666,34 | etc Balance (free text) 1203,22 | 9354,61 | 10020,95 | etc With this you could see a trent in savings / cash at hand All based on the information entered in to the forecast P&L statement Thanks in advance Huib ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 12, 2022, 3:34pm UTC](https://forum.manager.io/t/forecast-p-l/40455/10 "2022-07-12T15:34:11Z")
You are confusing “profit” and “cash” They are not measuring the same thing. It would be like adding apples and onions ---
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [July 13, 2022, 7:37am UTC](https://forum.manager.io/t/forecast-p-l/40455/11 "2022-07-13T07:37:58Z")
as the restult (net profit) is also on the balance sheet and will go to some where in the balance sheet (working capital / provisions / reveneue at bank) Indeed as in our case the profit will go or to the to provisions (part of the balance sheet) it would be nice to be able to have some of the balance sheet in to the forcast or have a line with free text ( provisions / work capital / cash ) above and below the net profit outcome to show where the result (net profit) will go to and what will be the outcome in the prognose in due time it wil show the provisions (in my case) over the yaers based on the forecast sorry to be difficult but in my opinion it would be a surplus to the prognose option in the program rgds huib ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 13, 2022, 12:59pm UTC](https://forum.manager.io/t/forecast-p-l/40455/12 "2022-07-13T12:59:58Z")
> [@HuibK](#): > > as the restult (net profit) is also on the balance sheet Here you are mistaken, @HuibK. _Net profit_ is on the Profit and Loss Statement, not the balance sheet. ---
**Author:** ![HuibK](https://avatars.discourse-cdn.com/v4/letter/h/f19dbf/32.png) [@HuibK](https://forum.manager.io/u/HuibK)\ **Post date:** [July 13, 2022, 2:07pm UTC](https://forum.manager.io/t/forecast-p-l/40455/13 "2022-07-13T14:07:10Z")
@Tut in our case we do not make a profit but at 31 dec all (result) will be booked into provisions as in our case all revenue at the bank are provions all cash is in Assist all provisions are in Liabilities Equity will be “0” the regulair cost are being paid from the same account as cost and booked as cost the contribution of the members are booked as income the expenses are paid from the bank and are deducted from the provision all plus and minus payments (all income and cost) will result in a net result. resume: to make a long story short for me i would appriciate if a calculaton field at the botom of the forecast P&L can be made in acting as a forecast balance sheet showing the following free text ( provision at 1 Jan xx) xxx net result yyy free text (provision at 31 dec xx) zzz or be able to make a forcast balans sheet based on the forecast P&L as the manager is excelent for me i would like to stay far away of using excel sheets as part of the annual reporting for me as the administrator of our group of Owners (VVE) is is a perfect tool to present the information to other owners thanks and regards huib ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:12pm UTC](https://forum.manager.io/t/forecast-p-l/40455/14 "2026-07-05T20:12:48Z")
Uncategorized topics older than 3 years with no recent activity