Hi, I did similar modules in excel where excel calculates payroll cost (+OH) and allocations the costs by department or by cost centres. The module enables you to manage employee list (with their basic contracts and conditions), tax tables and holidays. Excel, also, calculates the cost based on real working days (365 - weekend - holidays).
During the process (I use a pivot table (reports/ graphs) which updated automatically by VBA.), Excel validates the data and produces reports/forms for each employee and convert them to PDF based on parameters and criteria. There is a report generator which enables you to develop templates independently. Username id and password can secure the master files and the reports/forms.
I am financial experts and guru in Microsoft Office Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (automation) including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation.