Forum Discussion

Wm_Benson's avatar
Wm_Benson
Copper Contributor
Nov 05, 2020

Calendar Cash Flow Forecast Spreadsheet

Looking for the easiest way to accomplish the following: In a calendar format (to capture the monthly cash flow), schedule monthly credits and debits on their due dates without having to input every individual credit and debit entry for the entire year, while being able to entire unscheduled expenses and incomes. Help?

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Wm_Benson 

     

    From your text I cannot infer which version of Excel you are dealing with, knowing the operating system would also be a plus for a proposed solution.

    You can also download templates from your Excel Direct.

    When you open the Excel you will see at the top right (if you have Excel 2010-2016) Recommended search depth: select Budgets and the Micorsoft world is at your feet.

    If you want something special then you should put it in a contract work.

    'M sure some will be here to contact to you for that :).

    Personally, I don't do any commissioned work, I do this here, just for fun.

    Help to be helped ... if need be.

     

    Nevertheless, here ... some information about it.

     

    Budget planning with spreadsheets

    https://www.microsoft.com/en-us/microsoft-365/business-insights-ideas/resources/budget-planning-with-spreadsheets

    Excel TEMPLATES

    https://templates.office.com/en-us/templates-for-excel

     

    Thank you for your understanding and patience

     

    Hope I was able to help you.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here