Hi, I’ve read your proposal regarding Strategic Finance Model. I am highly qualified for this project and can show you a sample of a similar project in Microsoft Excel which enables you to record/upload financial transactions and to get financial statements, cash flow, ageing report, and forecasts financial reports as well.
The posts entered/imported into journals entries sheets with a possibility to choose accounts, entities and other information from tables (like a chart of accounts, customer list, etc.). By this, the application keeps on the validity of the posts. The results (for any period and any currency) are embedded automatically in a trial balance.
Features and Benefits
Management Brief Reports
Dashboard
Trial Balance (including consolidated trial balance for parent company and subsidiaries)
Consolidated financial statements (Income Statement, Balance Sheet, and Cash Flow)
Deviation analysis report: Standard revenue and cost VS actual by product, customer and bill of material
Operational cash flow (Schedule of money in/out) by day/week/month
Collection reports (ageing reports)
Forecasting
Reports for any period
Flexible built-in reports
Additional journals entries
About me:
I am a professional financial and a guru in Excel and Excel-VBA/Macro. I have an experience in accounting, consolidating, forecasting, budgeting and, costing including inventory, bill of materials, collections, payments, bank reconciliation and financial reports.