Hi, I already built some modules for accounting. The modules enable to type actual/forecast transactions in one sheet or to upload external files (like CSV files from banks). At the end of the process, the module produces TB GL BS P&L and cash flow by month/years. The module records the VAT directly to the VAT accounts and also record commissions/exchange rate to relevant accounts where the amount including commission. let me know if you have other types of transaction that you want to split and I will add it to the module. Also, The module manages the forecast 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.