I can suggest to you an accounting module in Microsoft Excel, which enables to enter forecast (budget), actual entries (or upload from external systems from Intuit QuickBooks, SAGE SAP, ERP, etc. There is a flexible entries form or worksheet (including quantities), in one click you get full financial statements, Trial balance, and forecast cash flow by any period. Excel validates and manipulates the information (add formulas), and populates template reports and documents based on the needed parameters and criteria. There is a report generator which enables to develop templates independently. Also, there is a search engine with high search capability to find specific information and the file secured by username login and password.
Features and benefits:
- Consolidated Reports
- Dashboard
- 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
- Statements for any period
- Flexible fiscal years
- Flexible built-in reports
- Adjustable Cart of account
- VAT/GST reports
- Recurrence Jurnal entries
I am an expert and guru in Financial, Math and 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.