Forum Discussion

Soundra04's avatar
Soundra04
Copper Contributor
Dec 23, 2019

Personal Cash Flow

In the attached file I need to enter the month in the first tab where I have highlighted in cell B4 which should pick the month in second tab and post the total from the third tab to the second tab in the appropriate month.

 

Can anyone of you experts help me please? 

 

Kind Regards

Soundra

excel
Formulas and Functions

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 24, 2019

    Soundra04 

    Soundra, "Daily Expenses" sheet - it'll be one sheet per month or how you are going to keep the history of expenses for previous months?

    • Soundra04's avatar
      Soundra04
      Copper Contributor
      Dec 25, 2019

      SergeiBaklan 

      Thanks a lot for your message Sergie. Sind the expenses sheet has the total expense, I do not know whether there should be 12 sheets. I thought each month passes I can use the same daily one for every month after deleting the data for the previous month.

       

      I am sure you will be in a better position to advise me otherwise.

       

      Merry Christmas to you and your family

      Kind Regards

      Soundra

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Dec 25, 2019

        Soundra04 

        Hi Soundra,

         

        Excel doesn't remember results of previous calculations. As soon as you update any number in daily sheet Excel recalculates summary results. Actually you'll have the summary only for one abstract (current) month.

         

        You may organize 12 sheets for daily expenses (Jan, Feb,...) and summarize them on monthly/annual basis.

         

        Or you may denormalize your transaction tables and keep all transactions in one table with date/category/expense or income name/sum. This one table could be summarized into annual cash flow. That is something like here Free Money Management Template .

         

        Formulas shall not be a big deal, data structuring is the point. Think first about usability and maintainability. If it'll be the tool which is hard to use  you cancel it in few month. On the other hand will knew something new about Excel, that will be the only positive effect.

         

        If your goal is not to learn Excel google for templates, perhaps you'll find something suitable and ready to use. Or even spend few bucks on some tool. This is not my area of interest and I can't give concrete advice.

         

        Anyway, as soon as you select the data model will be glad to help with Excel formulas if needed.

         

        All the best for the coming year and happy holidays!

Resources