Fort Knox Model Introduction to SurvivalWare The Fort Knox Foundation Model Quick Tour of SurvivalWare Fire up SurvivalWare with some sample data Dashboard DataViewer Reports Report Packages To print any report package To add a report to a report package To add a graph to a report package To re-arrange the pages in a report package Budgeting To review the budget for this year To prepare a budget for next year To review performance against Budget Option 1: Print a report Option 2: View a graph of "Actual vs. Budget" Projections Term Loans ARC Loan Calculator Getting Started with SurvivalWare Step 1: Exporting data to a .CSV file The Ideal Data Format for Files Step 2: Creating a New Company in SurvivalWare 1. Company Name 2. Time Periods 3. Optional Logos Make Changes Step 3: Mapping the Line Items Loading the CSV files The Mechanics of Row Mapping Saving the Row Map File Step 4: Loading the data SurvivalWare Main Menu Menu Size The Sample Data file Overview of the Main Menu File Login The Getting Started Guide Load Data Module Data Format for Files Rollover Loading CSV files Creating a Row Map File What is Row Mapping? A Few Rules and Hints about Mapping The Mechanics of Row Mapping Saving the Row Map File Accessing an existing Row Map Printing the Row Map When you are done mapping The Import Data Trigger Eyeball the Results Errors Company Selector Company ID Data Viewer Module Viewing Time Periods DrillDown Trends Comparanator Company Selector Logic Navigating the Data Viewer Tabs Scroll bars Arrow keys Page Up / Page Down The ENTER key Copy / Paste Controlling the time periods Dashboard Module Selecting Dashboard Views Reports Module Reports and Column Sets Add to Report Packages Report Packages Budgeting Module View Current Year Budget Prepare Next Year Budget Forecast Tool Simple Trend Annual Growth Rate Seasonal Forecast Current year + X% YTD Average + X% Trends Logic Projections Module Part 1 - getting familiar with the Forecast Tool Individual line items The complete picture Forecasting a single line item 10% growth vs. last year Simple trend Looking at Years Making a total leap of faith Part 2 - Doing a complete Cash Flow Projection Sales Expenses Benefits Commissions Payroll taxes Royalties Part 3 - Debt Service and Investment Investments / Capital Expenditures Working Capital Other Cash Flow Summary of Cash Flow Changing the planning horizon Debt Service Investment / Capital Expenditures Part 4 - Working Capital History Projections Part 5 - Other Cash Flow Summary of Cash Flow Changing the Planning Horizon Company Setup Module User Settings Cash Planner Module Automator Module Overview - the Automator Theory of Operation Scope of the Automator The Tools Big Picture Rusty's Tool Box Time Periods Menu Structure File New Company Open Existing Company Save Company Save Company as… Define Import from QuickBooks Quickbooks Import from CSV or XLS file Look at a Row Map for a QuickBooks file Define Other Import Run Other Import (IDF) QuickBooks Direct Connect Create XLS Template Import from XLS Template Import Flex Names Properties Edit Copy Paste Customize Product Line Names Customize Product Line Names Find Rowname Find Number Find Next (F3) Analyze Compute Difference Run Allocation… Consolidate using CSF file Create CSF File… Edit CSF File… Company Stats - create comparison groups…. Create Group Averages based on Fields in Master Table Report Print or Preview Report Package Ranking Reports… ByColumn Reports Data Calculate Copy Projections into Budget Set Last Actual Month Migrate data from another model Data Disguise Module Replicate column in Benchmark data file Re-calc all files in a folder Rollover this file Rollover all files in a folder Zero out work area Tools Create/Edit an Automator applet Compile Logic Files Use Logic Files… Use INP File… Process a contact form file from web app Unzip all files in a folder Cash Planner Help Contents Help for Rusty's Toolbox About SurvivalWare Exit Appendix A: Rollover to a new year Appendix B: Chart of Accounts Chart of Accounts Income Statement Balance Sheet Other Data Items Appendix C: Importing Data Format for Data Importing Financial Data from QuickBooks Creating the Export Files - basic QuickBooks Profit & Loss (income statement) Balance Sheet Older versions of QuickBooks without the Export to CSV feature File naming conventions How much data to export each month Making sure you do the same export each month Memorized Reports Files created from QuickBooks running on the MacIntosh First Time Mapping and loading Mapping Hints When you are done mapping Accessing an existing Row Map Printing the Row Map Triggering the import of data Eyeball the Results Importing Financial Data from QuickBooks with Classes Creating the Export Files - QuickBooks with Classes Profit & Loss (income statement) Balance Sheet First time mapping and loading - QuickBooks with Classes Loading monthly "Class" data after the initial mapping has been done Loading monthly data after the initial mapping has been done QuickBooks Direct Connect Feature Install QBFC Open the QuickBooks File Run SurvivalWare and click on "Rusty's Toolbox" Select File / QuickBooks Direct Connect Map the QuickBooks accounts to SurvivalWare Loading Financial Data from Other Sources The Format of the Data Sample file formats Defining Other Import Data File Using a Template for the Data File Data File Format Account (Row) Map file Map Rows Map Columns Importing non-QuickBooks Data after the initial defining and mapping Appendix D: The CSF File Basic CSF Format Using a CSF File for benchmark comparisons Appendix E: The Allocation Control file (.ALC) Overall section Allocation sections