Hi, I would like to suggest you a module which enables to type actual expenses/Income in one sheet. and to get Trial balance, Balance Sheets and cash flow by month/years.
Also, you can manage forecast cashflow by recurrence method.
About Me:
I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.