際際滷

際際滷Share a Scribd company logo

Using Global Financial Bridge

Download as PPT, PDF
S
Steve Travis

This document provides an overview of how to use the Global Financial Bridge tool to import data from QuickBooks, perform "what if" analyses, create budgets, and view key performance metrics on the one page scorecard. It describes how to load company data from QuickBooks or enter standalone financial statements, map accounts, import the data, and access the scorecard. It also outlines different "what if" techniques for analyzing revenue, profitability, working capital, and cash flow impacts of potential changes.

1 of 27
Global Financial Bridge Users Guide
Getting Started Data Access Options Load a company from QuickBooks. Make sure QuickBooks is open in the company you want to import. Create a stand alone company if you want to input data from a set of financial statements. Open an exiting GFB data set.
Getting Data From QuickBooks Click the load button
Data Mapping Screen Classify button = change the default account location QuickBooks Account GFB account location
Import - the last step The year you want data to start being imported from
Its done
The Starting Point called the data capture sheet The data capture sheet after the completion of the import process
Data Loading Functionality Opening the + sign shows the account details The data loading screen allows the source data view.
Access the One Page Scorecard Choose the period you wish to view in the One Page Scorecard Press Scorecard
The One Page Scorecard Current period numbers Metrics that define business performance Click on any performance category to expand the details of the performance category
Performance Category Expanded Click the performance box to expand the details of the box or to do the required what if
Performance Category Expanded (cont.) Working Capital explained (Change any of the working capital days to see the impact)
Performance Category Expanded (cont.) Cash flow and structure
Doing what ifs You can road test any strategy or multiple strategies by changing any item in 1.The income statement or balance sheet 2. Any editable performance measure Example: Change revenue growth to 30%
After doing a what if The scorecard re- calculates based on the change. Showing the picture after the change. Press the net change button to see the difference
Net Change View Press scorecard and Undo to return to the original data
What if Techniques Revenue Quality what if To increase revenue growth go to the net change view to determine if additional volume is cash generating or absorbing. Profitability what if Identify the best performance over all review periods. Use these metrics to change the profitability measures. Use the net change to see the impact.
What if Techniques (cont.) Working Capital Optimization Identify the best performance over all review periods. Use these metrics to change the working capital measures. Use the net change to see the impact. Combination what if (Improvement Opportunity) Combine the best measures in the profitability and working capital. Do a net change to identify the financial opportunity that can be derived by inputing the best measures the company has already done.
What if Techniques (cont.) The challenge what if Improve measures that you believe the business could perform against. Do the net change to determine the stretch goal.
Graphing Click on the performance measure you want to graph then press the Graph It button
Explain It Click on the ratio you want further information on Click on the Explain It button
Cash Flow and what ifs The following performance variables were changed: 1.Revenue Growth from 23.33% to 30% net change 6.67% improvement 2.Variable COGS % from 62.16% to 61% 1.16% (improvement) 3.Days Inventory from 122 days to 100 days 22 day improvement 4. Press Reports to select cash flow statement
Resulting Cash Flow statement First column (data entry) is the actual data without any changes. The second column is the cash flow based on all the what if or changes made to the scorecard. The third column is the difference. This is most helpful in explaining why cash changes when different decisions are made in the business.
Save, Print and Exit Save is the big one, if you press Save this will CHANGE your ORIGINAL data in the loading screen. Use it only if you want to save a potential strategy for future reference. If you do so use the Save As feature and save as a new name, my fast growth strategy.gfb, for example.
Creating a Budget In Data loading screen Click Add a Period Enter the start date and the number of months you want to budget for Check the Budget box Click the Wizard button
Creating a Budget (cont.) 1.Enter the key variables that you believe will be performed during the budget year. 2. Press Save.
Selecting the Scorecard View Determine the period you want to view in the Scorecard. Click on the column underneath the period heading. Press the Scorecard button.

More Related Content

Using Global Financial Bridge

  • 2. Getting Started Data Access Options Load a company from QuickBooks. Make sure QuickBooks is open in the company you want to import. Create a stand alone company if you want to input data from a set of financial statements. Open an exiting GFB data set.
  • 3. Getting Data From QuickBooks Click the load button
  • 4. Data Mapping Screen Classify button = change the default account location QuickBooks Account GFB account location
  • 5. Import - the last step The year you want data to start being imported from
  • 7. The Starting Point called the data capture sheet The data capture sheet after the completion of the import process
  • 8. Data Loading Functionality Opening the + sign shows the account details The data loading screen allows the source data view.
  • 9. Access the One Page Scorecard Choose the period you wish to view in the One Page Scorecard Press Scorecard
  • 10. The One Page Scorecard Current period numbers Metrics that define business performance Click on any performance category to expand the details of the performance category
  • 11. Performance Category Expanded Click the performance box to expand the details of the box or to do the required what if
  • 12. Performance Category Expanded (cont.) Working Capital explained (Change any of the working capital days to see the impact)
  • 13. Performance Category Expanded (cont.) Cash flow and structure
  • 14. Doing what ifs You can road test any strategy or multiple strategies by changing any item in 1.The income statement or balance sheet 2. Any editable performance measure Example: Change revenue growth to 30%
  • 15. After doing a what if The scorecard re- calculates based on the change. Showing the picture after the change. Press the net change button to see the difference
  • 16. Net Change View Press scorecard and Undo to return to the original data
  • 17. What if Techniques Revenue Quality what if To increase revenue growth go to the net change view to determine if additional volume is cash generating or absorbing. Profitability what if Identify the best performance over all review periods. Use these metrics to change the profitability measures. Use the net change to see the impact.
  • 18. What if Techniques (cont.) Working Capital Optimization Identify the best performance over all review periods. Use these metrics to change the working capital measures. Use the net change to see the impact. Combination what if (Improvement Opportunity) Combine the best measures in the profitability and working capital. Do a net change to identify the financial opportunity that can be derived by inputing the best measures the company has already done.
  • 19. What if Techniques (cont.) The challenge what if Improve measures that you believe the business could perform against. Do the net change to determine the stretch goal.
  • 20. Graphing Click on the performance measure you want to graph then press the Graph It button
  • 21. Explain It Click on the ratio you want further information on Click on the Explain It button
  • 22. Cash Flow and what ifs The following performance variables were changed: 1.Revenue Growth from 23.33% to 30% net change 6.67% improvement 2.Variable COGS % from 62.16% to 61% 1.16% (improvement) 3.Days Inventory from 122 days to 100 days 22 day improvement 4. Press Reports to select cash flow statement
  • 23. Resulting Cash Flow statement First column (data entry) is the actual data without any changes. The second column is the cash flow based on all the what if or changes made to the scorecard. The third column is the difference. This is most helpful in explaining why cash changes when different decisions are made in the business.
  • 24. Save, Print and Exit Save is the big one, if you press Save this will CHANGE your ORIGINAL data in the loading screen. Use it only if you want to save a potential strategy for future reference. If you do so use the Save As feature and save as a new name, my fast growth strategy.gfb, for example.
  • 25. Creating a Budget In Data loading screen Click Add a Period Enter the start date and the number of months you want to budget for Check the Budget box Click the Wizard button
  • 26. Creating a Budget (cont.) 1.Enter the key variables that you believe will be performed during the budget year. 2. Press Save.
  • 27. Selecting the Scorecard View Determine the period you want to view in the Scorecard. Click on the column underneath the period heading. Press the Scorecard button.