In effect what I am saying is that companies which get the most value from spreadsheet automation(including using it to avoid expenditure on less adaptable commercial off the shelf applications) will be those which empower their users to routinely generate "in house" solutions. In such companies, you will find that only when the requirement becomes considerably specialised or complex, does the IT department get called upon to develop or purchase software solutions for user departments or functions with significant data recording and analysis needs.
For the purpose of creating custom financial and business management solutions that solve your identified problems, and give you control/ownership, without burning a hole in your pocket, Excel VB offers an amazing variety of possibilities, in the hands of an adequately skilled user.
Spreadsheet Tracking As A Crucial Element For Business Development. There are ways you can use spreadsheets to record and track materials usages/stocks, product sales, and other business data such that discrepancies will be easily detected when they do occur. The use of spreadsheets when properly done, can help to uncover the cause(s) of "losses" in virtually any aspect of a business operation.
In addition, visualise it having dynamic query/report drop menu interfaces, and a variety of custom buttons: for navigation(within and between worksheets), printing, data export (as PDF documents or spreadsheet files), saving, auto_data filtering, auto_charts plotting, auto_backup of files, user login authentication (for documents with sensitive or confidential content) etc.