Forum Discussion

fzn365's avatar
fzn365
Copper Contributor
Oct 07, 2021

Excel Reporting

Hello Experts,

Thanks in advance for helping and solving the problems on this platform.

I attached a working excel workbook, and there is only one sheet. dummy data is given over there.

What i need out of that sheet is:

 

1-Daily report of CASH IN & CASH OUT with description (each day separate report) based on the data entered in the data entry sheet.  in the head of each day report following has to be mentioned.

 

i also attached a sort of report which i want to be generated automatically (30 days) 

 

Today total cash in     :    Today total cash out    :     Balance

 

To date cash in (previous dates cash in balance has to be carried forward)

To date cash out (previous dates cash out balance has to be carried forward)

 

Please feel free to ask if my question is not clear to you.

 

Thanks in advance

BI & Data Analysis
excel
Formulas and Functions
Macros and VBA

3 Replies

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Oct 08, 2021

    fzn365 

     

    Your setup does not have a source document reference number such as a receipt number or an invoice number.  How would you know any of the entries is not fictitious?

    • fzn365's avatar
      fzn365
      Copper Contributor
      Oct 09, 2021

      Yea_So Hi,

       

      Please check the attached file named *dummy*

       

      I did some manual working. but i want this in a proper way with more automated formulas.

       

      Have a look at the attached file. you will understand.