| Applications (all the following applications are currently used by a $300M company) All of these items were designed and developed from scratch with out consulting. |
| General Ledger Reporting and Inquiry - In addition to reporting and inquiry, it even calculates multi-currency and calculates and produces the consolidation package. This database contains over a thousand objects and has very rich functionality and is extremely stable. Here is just a small sampling of functionality included in this application: Inquiries and reporting by company, by account number, by product line, by division, by department, by period, etc. Rich transactional analysis tools. Ad hoc reporting and predefined reporting. Analysis by system,by......... |
| Standard Cost Accounting - The cost accounting system I developed consists of 4 databases: 1) Main which processes payments, calculates variances, contains the bill of materials, automated FIFO costing, produces journal entries 2) Cost accounting data mart that contains all inventory movements by g/l account number 3) A comprehensive reconciliation of payment and receipts of all inventory by bill of material component 4) A 16 month roll of the perpetual down to the lowest level. |
| Customer Profitability - This application summarizes profitability by customer, by g/l account, by product line, by business segment, by sku. It includes numerous inquires and a highly automated reporting functionality. |
| Retail Store Reporting - This system takes well over a hundred Retail stores and slices and dices the information in many views of the information. For example, by store types such as "New", "Comp", "Non-Comp", "Temporary" etc. Basically the data is by account number, by store, by region/district, by state, square footage groupings, current actuals, last year, budget. Profit and Loss statements available for all the different views. Even general ledger transactional analysis is available. Automated report processing creates report packages to be sent out by region/district via email if desired. |
| Budgeting - This system contains: 1) Budgeting Cost by style by bill of material components in which many users enter information. It compares marketing estimates with procurement estimates. Even contains functionality as rich as cost increases by quarter being applied to the lowest level 2) Budgeting variable contribution margin down to the style level 3) A database that makes it possible to budget well over a hundred retail stores by account by product line. 4) Budget repository pulls in information from all budget sources into a central database. |
| Essbase G/L Reporting/Inquiry Cube - This cube is by country, by currency type, amount type (actual, budget, last year), by g/l account, by product line, by month, etc. and is used to analyze monthly results. A custom toolbar was developed that let's the user drill through the balances into the transactions that are stored in the g/l reporting and inquiry database mentioned above. |
| Data Marts - These data marts are all summarized by general ledger account number, making it possible to see what makes up balance on the g/l down to the lowest component. For example, a by customer, by invoice data mart. |
| Automated Updates - Where it makes sense, like the data mart area, completely automated updates of data from AS400 into the application has been mastered also. These updates can occur at the users desired interval, for example, every night or on regular intervals throughout the day. |
| Accounting/Finance Expertise - Have developed hundred of rules for all transactions from inventory modules and invoicing modules to book to the general ledger. In addition the entire account number structure / mechanics were developed from scratch for the cost accounting system. AA understands how the lowest level transaction needs to be booked in the general ledger so the highest level statements will be in accordance with GAAP. AA understands both application development and accounting, a rare combination. |
| Reconciliation of Data between systems and applications is a crucial point in every accounting/finance application. This is another area where AA accounting/finance expertise is invaluable. AA will not skimp in this area. The above applications all include reconciliation to ensure the data is accurate and can be trusted. |
| Developed with End Users in Mind - These applications are developed with the end user in mind. Many times applications are developed that have many bells and whistles but are of little use to the end user. AA aims at developing highly useful tools that will actually be used by the end user. This is due to my more than two decade career being spent both from the end user side and the "automater" side. |
| Many other applications such as a check reconciliation database and a flexible spending by customer database that is used for calculating the discount accrual for month end. All the above descriptions are strictly summaries. There is a lot of rich functionality that was not even mentioned above. |