1 / 22

Financial Flows The ‘Big Picture’

Financial Flows The ‘Big Picture’. ID#114. Presented by: Strategic Systems Group, Inc. “The Black Hole”. Baan is great at collecting data Okay at getting data out So-so on useable financial information. “The Data Map”. Where did the data come from?

dai
Download Presentation

Financial Flows The ‘Big Picture’

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Financial Flows The ‘Big Picture’ ID#114 Presented by: Strategic Systems Group, Inc.

  2. “The Black Hole” • Baan is great at collecting data • Okay at getting data out • So-so on useable financial information Strategic Systems Group, Inc.

  3. “The Data Map” • Where did the data come from? • How did it flow to the financials? • Who needs the information? • How do you get this information Strategic Systems Group, Inc.

  4. Types of Data Operations  General Ledger • Accounts Payable • Accounts Receivable • Commissions • Cycle Counts and Adjustments • Item Valuation and Re-valuation • Purchase Variances • Sales Margins . . . Sales and COGS • Warranty, RMA • WIP Strategic Systems Group, Inc.

  5. The Power of Your Data Receivables Collections Customer Responsiveness Product Quality Cycle Time Reduction Warranty Strategic Systems Group, Inc.

  6. Strategic Goals. . . go beyond Finance • Cut Costs • Reduce Cycle Time • Improve Customer Relations • Reduce Accounts Receivable DSO • Consolidate Purchasing Power Strategic Systems Group, Inc.

  7. "You cannot control what you cannot measure" Tom DeMarco Author, Consultant, Expert Witness Strategic Systems Group, Inc.

  8. MetricsWhat data are you measuring? • Financial data • Operational data • Third-party data Strategic Systems Group, Inc.

  9. Minimize the Black Hole syndrome Start at the END ! • What information do you need? • Monthly • Quarterly • On-demand • Where does the data come from? • What’s missing from current reporting? • How do you get the information? Strategic Systems Group, Inc.

  10. Financial Flows . . . The Big Picture Strategic Systems Group, Inc.

  11. Getting More out of your Data • Do you receive usable Information or just Data? • Is your data warehouse geared toward the business user? • How does Logistical reporting support Finance? • Do you run Baan reports and manually create new reports from this data? • Do you download data directly into Excel and then make changes? Strategic Systems Group, Inc.

  12. Dimension Reporting • How well are dimensions used? • What data do you capture? • Who uses this information? • Does Logistics reporting support Financial data? Strategic Systems Group, Inc.

  13. “Financial Flow” • Month-end Audits • Reconciliations • Transaction Validation • Data / Transaction Analysis • Beyond Financials • Strategic & Operational Goals Strategic Systems Group, Inc.

  14. What Audits Tell You • Validate transaction flows • Issues • Trends • Opportunities Strategic Systems Group, Inc.

  15. Issues and Trends • Can you identify opportunities? • How do you find problems or unfavorable trends? • When you find problems, how do you dig into the details? Strategic Systems Group, Inc.

  16. Transaction Analysis • Identify source of transaction • Identify related data • Do you have access to all data you need? • Do you understand the flow of data from Logistics to Finance? Strategic Systems Group, Inc.

  17. Troubleshooting Financial Transactions • Review the error log • Identify the transaction and its source • Look at the integration mapping elements • Update mapping • Post transaction(s) Strategic Systems Group, Inc.

  18. What Caused Problems? • Mistakes • Failure to follow established procedure • Business process changes • Training issues • Improper interpretation of the data Strategic Systems Group, Inc.

  19. End of Period Audits • Standard Audits • Received Not Invoiced • Shipped Not Invoiced • Posting Inventory Transactions • Timing is Everything • Other Audits • Bookings / Billings / Backlogs • Warranty • Margins Strategic Systems Group, Inc.

  20. Transactions Regular metrics reporting • On-time Deliveries • Production Material Variances • Margin Analysis Strategic Systems Group, Inc.

  21. Leverage Logistics and Financial data Look for opportunities in the data Recruit your SMEs (Subject Matter Experts - internal resources that know the business processes, the data, the company, the goals) Re-assess how well your organization is utilizing Baan ERP Define/re-assess key metrics to improve reporting Look for opportunities – utilize a SME with data analyst skills Identify where energies and resources should be focused – what will bring the greatest return to the organization. Let Baan ERP work for you! Black Hole Solutions Strategic Systems Group, Inc.

  22. Questions ?? Presented By Strategic Systems Group, Inc. (SSG) For details on the material presented today, please contact us at dcervelli@ssgnet.com (805) 493-0986 pdjohnson@ssgnet.com (949) 678-9672 Strategic Systems Group, Inc.

More Related