I built Cash flow Applications in MS Excel which manages the cash-in and the cash-out for various financial activities. This spreadsheet functions as daily management tools that enable to obtain precise information regarding the account balances for each day plotted against short-term periods and retrieved daily/weekly/monthly/yearly reports in the long term. It provides substantial insight to properly understand deficits/surplus and hence, proper management of the cash flow of the companies/subsidiaries.
The process runs in Microsoft Excel through visual basic applications, pivot tables and advanced formulas that show at the end the results along the template reports which provide by the user. Microsoft Excel captures the input data, creates forecast transactions for each activity (inclusive of opening balance, scheduled repayments, and interests), records them in one structured database and automatically update the built-in reports with the new results.
About me:
I am a financial expert and guru in Excel. I have knowledge and expertise in advanced formulas, Pivot Tables, VBA, dynamic dashboards, & charts (scripts).
Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, BOM, taxation and bank reconciliation.
With these skills, I come up with creative and sophisticated financial & statistical modules and form in a simplified & logical manner.