Accounting and business management information systems are typically made up of many sub systems. Ancillary systems often fulfill the business need where update to, or investment in, an integrated system from a single vendor is not justified; either economically or because of the length of time or disruption involved in implementation. An analytical tool such as a spreadsheet can be used to explore business processes in order to find a solution to a need or provide flexible early reporting.
Executive-E is expert in this field and regularly creates custom tables, templates, reports and other objects for clients, using spreadsheets and databases. We can also look at the bigger picture and extend the internal controls of the business, enabling reconciliation and reporting of key performance indicators. A key aspect of this area is understanding when and how best to use unique identifier and sequential numbering techniques to preserve the integrity of the system as a whole and avoid the issues that so often arise when disparate systems evolve organically. Over the years we have written and developed a number of articles, tutorials, spreadsheets & database files and documentation for a variety of business applications.
This downloadable sales ledger spreadsheet file demonstrates many techniques applied in a simple sales ledger to:
We continually develop new material and welcome requests and feedback to provide nourishment to this process. Please e-mail any constructive comments to firstname.lastname@example.org