Hi, I have ready a Financial Application on Excel and VBA for small and medium companies that have subsidiaries and multi-currency activities. At the end of the implementation, you will have Excel files with a management tools package including consolidated trial balance, financial statements, cash flow, aging report, and forecasts financial reports.
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 consolidated trial balance, financial statements, cash flow report, and forecast statements, and VAT reports. All the balances displayed in two leading re-evaluated currencies (for example USD and EUR) based on FASB 52 and GAAP requirements
Features and Benefits
Management brief reports
Trail 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 report (aging report)
Forecast reports
Foreign currency exposure reports
Reports for any period and any currency
Flexible built-in reports
Additional journals entries