Preparing daily cash flow and bank reports

%3CLINGO-SUB%20id%3D%22lingo-sub-2191076%22%20slang%3D%22en-US%22%3EPreparing%20daily%20cash%20flow%20and%20bank%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2191076%22%20slang%3D%22en-US%22%3EHi!%20I%20am%20looking%20for%20your%20help%20to%20design%20easiest%20automated%20report%20which%20includes%20daily%20retails%20and%20at%20end%20of%20month%20there%20is%20a%20consolidated%20report%20underneath.%20End%20of%20every%20month%20i%20want%20a%20report%20to%20trigger%20details%20by%20selecting%20catevory%20as%20in%20the%20colomn%20header%20and%20month%20wise%20also.%3CBR%20%2F%3E%3CBR%20%2F%3Eplease%20note%20there%20are%202%20sheets%20i%20want%20help%20with..%201.%20P.T%20CASH%20(as%20in%20PETTY%20Cash)%3CBR%20%2F%3E2.%20bank%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2191076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Hi! I am looking for your help to design easiest automated report which includes daily retails and at end of month there is a consolidated report underneath. End of every month i want a report to trigger details by selecting catevory as in the colomn header and month wise also.

please note there are 2 sheets i want help with.. 1. P.T CASH (as in PETTY Cash)
2. bank
1 Reply

@zaki4u 

 

I think you'd help us help you if you:

  • added a fair amount of transactional data under the "data" tab (assuming that it is the source of data for filling in those reports you want filled)
  • disabling (or disconnecting for the time being) any reliance on external data sources...I certainly don't want to have to be directed elsewhere; I can't speak for others here in the techcommunity in that regard, but I suspect I'm not alone.
  • let us know what version of Excel you're working with. It would be very helpful if you have the most recent, and/or a subscription to Office 365, because it has some functions that could be very useful to you.

 

So far as your own design process is concerned: my advice would be to concentrate on the functional issues first; get to colors and font formatting later...at this stage, too much energy put into prettification can actually get in the way of functionality.