Excel Reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-2821886%22%20slang%3D%22en-US%22%3EExcel%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2821886%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Experts%2C%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20helping%20and%20solving%20the%20problems%20on%20this%20platform.%3C%2FP%3E%3CP%3EI%20attached%20a%20working%20excel%20workbook%2C%20and%20there%20is%20only%20one%20sheet.%20dummy%20data%20is%20given%20over%20there.%3C%2FP%3E%3CP%3EWhat%20i%20need%20out%20of%20that%20sheet%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1-Daily%20report%20of%20%3CSTRONG%3ECASH%3C%2FSTRONG%3E%20I%3CSTRONG%3EN%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3ECASH%20OUT%3C%2FSTRONG%3E%20with%20%3CSTRONG%3Edescription%3C%2FSTRONG%3E%20(each%20day%20separate%20%3CSTRONG%3Ereport%3C%2FSTRONG%3E)%20based%20on%20the%20data%20entered%20in%20the%20data%20entry%20sheet.%26nbsp%3B%20in%20the%20head%20of%20each%20day%20report%20following%20has%20to%20be%20mentioned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20also%20attached%20a%20sort%20of%20report%20which%20i%20want%20to%20be%20generated%20automatically%20(30%20days)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3EToday%20%3C%2FFONT%3Etotal%20cash%20in%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3A%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3CFONT%20color%3D%22%230000FF%22%3EToday%3C%2FFONT%3E%20total%20cash%20out%26nbsp%3B%20%26nbsp%3B%20%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BBalance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3ETo%20date%3C%2FSTRONG%3E%3C%2FFONT%3E%20cash%20in%20(previous%20dates%20%3CSTRONG%3Ecash%20in%3C%2FSTRONG%3E%20balance%20has%20to%20be%20%3CSTRONG%3Ecarried%20forward%3C%2FSTRONG%3E)%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3ETo%20date%3C%2FSTRONG%3E%3C%2FFONT%3E%20cash%20out%26nbsp%3B(previous%20dates%20%3CSTRONG%3Ecash%20out%3C%2FSTRONG%3E%20balance%20has%20to%20be%20%3CSTRONG%3Ecarried%20forward%3C%2FSTRONG%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20feel%20free%20to%20ask%20if%20my%20question%20is%20not%20clear%20to%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2821886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2828883%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1105933%22%20target%3D%22_blank%22%3E%40fzn365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20setup%20does%20not%20have%20a%20source%20document%20reference%20number%20such%20as%20a%20receipt%20number%20or%20an%20invoice%20number.%26nbsp%3B%20How%20would%20you%20know%20any%20of%20the%20entries%20is%20not%20fictitious%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2829644%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2829644%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3BHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20the%20attached%20file%20named%20*dummy*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20some%20manual%20working.%20but%20i%20want%20this%20in%20a%20proper%20way%20with%20more%20automated%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20look%20at%20the%20attached%20file.%20you%20will%20understand.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

3 Replies

@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?

@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.

In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Que...