Excel & VBA Programming Services

Would you like an Excel spreadsheet developed specifically for your business?

MSA develops custom business reports and analysis models using Microsoft Excel™ including:

  1. Financial reports from Sage 300 ERP (formerly Sage Accpac) or any standard accounting package
  2. Slow moving inventory analyses
  3. Suggested reorder lists
  4. Executive dashboards
  5. Department profit and loss statements
  6. Business key performance indicator (KPI) reports
  7. Finding possible duplicate incoming invoices across vendors
  8. Monthly sales by customer with budget comparisons
  9. Sales forecast and orders received analysis
  10. Payroll analysis
  11. Macros (VBA) to automate repetitive tasks
  12. Sales calls analysis
  13. Automated daily flash reports emailing system
  14. Convert Electronic Data Interchange (EDI) incoming orders to Accpac Order Entry
  15. Convert outgoing invoices to Electronic Data Interchange (EDI) for external customers

If your requirements are simple or complex the specialist knowledge of Microsoft Excel™ at MSA can be applied to create a cost effective result with great cost-benefit for you.


Contact us today for a no obligation discussion on how we can help with your business.


MSA applies more than accounting systems knowledge to your business.  In addition to normal statutory accounting requirements MSA can develop digital dashboards, KPI reports and sophisticated performance tracking to provide incredibly useful and relevant management accounting models.


MSA can integrate complex budgeting and cash flow forecasting and provide very detailed management reports or high level KPI warning systems.

  1. Integrating Excel with databases including Microsoft SQL Server
  2. Linking multiple sheets and importing files with input from external users
  3. Integrating Excel with financial applications such as Accpac and MYOB
  4. Macros and Visual Basic for Applications (VBA) Programming
  5. User-defined functions (UDF)  to carry out complex tasks in a single cell
  6. Advanced formulas adapted to take advantage of new Excel 2010 functions
  7. Simple one-click buttons that accelerate complex tasks and avoid user error
  8. Configuring lists that can be filtered and sorted by the user
  9. Data validation and drop-down lists
  10. Protection to prevent unauthorised or accidental changes to specific cells
  11. Advanced graphical analyses
  12. Build in self auditing controls to ensure workbooks deliver correct results.