financial reports

Hi, all! I have a workbook with 12 spreadsheets, one for each year’s financial statements by month. They’re all formatted as financial statements. If I use Get/Transform to clean one sheet, can I use the PowerQuery “program” from the first sheet to clean the others? Or do I have to manually use...

Hi Friends, I need your help. I am learning excel and i have a excel file with few instructions. Can any one able to solve this, & understand me - how we will solve it. it will be a great help. Please find the attached excel(Math-Finance file). I tried to solve but I am not sure ,what i did...

I have a work book that shows financial data in columnar format and I'm trying to create a summary sheet that will pull through the sum of the correct amount of months when specified. I have a drop down box with the months in, and these feed a cell that gives the corresponding number (i.e. Jan...

Hi all. I am in a quandary about creating a bimonthly (every 2 mths) financial report. I am the treasurer of a small group of volunteers which organises events & promotions on behalf of member groups. We get voluntary donations from the groups which are very haphazard & sometimes not at all...

I have linked a file that is a balance sheet, Income statement, cash flow, equity, and all historical data (BS and IS). I currently add a new row into historical for the new month then update all the formulas on sheets 1-7 manually. I need a way to automatically update all the formulas for the...

Hi, I am asking foradvice on how to build a financialreporting programme and I am not sure if I need to use Excel, Access, VBA or VBand hope you can direct me? I have four datatable. The first is daily revenue in around 30 different codes, the second iswages across 10 department, thirdly, a...