You are previewing Quick Books® 2010 All-in-One For Dummies®.
O'Reilly logo
Quick Books® 2010 All-in-One For Dummies®

Book Description

Everything that small-business owners need to manage their financial affairs with QuickBooks

Intuit's QuickBooks, updated each year, is the leading financial management software for small businesses. With eight content-rich minibooks, QuickBooks "X" All-in-One For Dummies covers everything you need to know to get your business finances in order with QuickBooks.

QuickBooks "X" All-in-One For Dummies is the complete reference for every aspect of this useful software

  • QuickBooks, the leading small-business accounting software package, is updated annually; this guide covers the latest version

  • Minibooks include An Accounting Primer, Getting Ready to Use QuickBooks, Bookkeeping Chores, Accounting Chores, Financial Management, Business Plans, Care and Maintenance, and Additional Business Resources

  • Covers understanding double entry bookkeeping, planning and preparing a QuickBooks accounting system, and setting up a QuickBooks network

  • Shows how to invoice customers, pay vendors, track inventory, and set up project and job costing systems

  • Explains how to write a business plan, create a business plan forecast, and conduct a ratio analysis

  • QuickBooks "X" All-in-One For Dummies is an indispensible tool for small-business owners who want to manage their business finances more effectively."

    Table of Contents

    1. Copyright
    2. About the Author
    3. Acknowledgments
    4. Publisher's Acknowledgments
    5. Introduction
      1. About This Book
      2. How to Use This Book
      3. Foolish Assumptions
      4. How This Book Is Organized
        1. Book I: An Accounting Primer
        2. Book II: Getting Ready to Use QuickBooks
        3. Book III: Bookkeeping Chores
        4. Book IV: Accounting Chores
        5. Book V: Financial Management
        6. Book VI: Business Plans
        7. Book VII: Care and Maintenance
        8. Book VIII: Appendixes
        9. Stuff at My Web Site
      5. Conventions Used in This Book
      6. Special Icons
    6. I. An Accounting Primer
      1. 1. Principles of Accounting
        1. 1.1. The Purpose of Accounting
          1. 1.1.1. The big picture
          2. 1.1.2. Managers, investors, and entrepreneurs
          3. 1.1.3. External creditors
          4. 1.1.4. Government agencies
          5. 1.1.5. Business form generation
        2. 1.2. Reviewing the Common Financial Statements
          1. 1.2.1. The income statement
          2. 1.2.2. Balance sheet
          3. 1.2.3. Statement of cash flows
          4. 1.2.4. Other accounting statements
          5. 1.2.5. Putting it all together
        3. 1.3. The Philosophy of Accounting
          1. 1.3.1. Revenue principle
          2. 1.3.2. Expense principle
          3. 1.3.3. Matching principle
          4. 1.3.4. Cost principle
          5. 1.3.5. Objectivity principle
          6. 1.3.6. Continuity assumption
          7. 1.3.7. Unit-of-measure assumption
          8. 1.3.8. Separate entity assumption
        4. 1.4. A Few Words about Tax Accounting
      2. 2. Double-Entry Bookkeeping
        1. 2.1. The Fiddle-Faddle Method of Accounting
        2. 2.2. How Double-Entry Bookkeeping Works
          1. 2.2.1. The accounting model
          2. 2.2.2. Talking mechanics
        3. 2.3. Almost a Real-Life Example
          1. 2.3.1. Rent expense
          2. 2.3.2. Wages expense
          3. 2.3.3. Supplies expense
          4. 2.3.4. Recording sales revenue
          5. 2.3.5. Recording cost of goods sold
          6. 2.3.6. Recording the payoff of accounts payable
          7. 2.3.7. Recording the payoff of a loan
          8. 2.3.8. Calculating account balance
          9. 2.3.9. Using T-account analysis results
        4. 2.4. A Few Words about How QuickBooks Works
      3. 3. Special Accounting Problems
        1. 3.1. Working with Accounts Receivable
          1. 3.1.1. Recording a sale
          2. 3.1.2. Recording a payment
          3. 3.1.3. Estimating bad debt expense
          4. 3.1.4. Removing uncollectible accounts receivable
        2. 3.2. Recording Accounts Payable Transactions
          1. 3.2.1. Recording a bill
          2. 3.2.2. Paying a bill
          3. 3.2.3. Some other accounts payable pointers
        3. 3.3. Inventory Accounting
          1. 3.3.1. Dealing with obsolete inventory
          2. 3.3.2. Dealing with inventory shrinkage
        4. 3.4. Accounting for Fixed Assets
          1. 3.4.1. Purchasing a fixed asset
          2. 3.4.2. Dealing with depreciation
          3. 3.4.3. Disposing of a fixed asset
        5. 3.5. Recognizing Liabilities
          1. 3.5.1. Borrowing money
          2. 3.5.2. Making a loan payment
          3. 3.5.3. Accruing liabilities
        6. 3.6. Closing Out Revenue and Expense Accounts
          1. 3.6.1. The traditional close
          2. 3.6.2. The QuickBooks close
        7. 3.7. One More Thing...
    7. II. Getting Ready to Use QuickBooks
      1. 1. Setting Up QuickBooks
        1. 1.1. Planning Your New QuickBooks System
          1. 1.1.1. What accounting does
          2. 1.1.2. What accounting systems do
          3. 1.1.3. What QuickBooks does
          4. 1.1.4. And now for the bad news
        2. 1.2. Installing QuickBooks
        3. 1.3. Dealing with the Pre-Interview Jitters
          1. 1.3.1. Preparing for the interview
          2. 1.3.2. What happens during the interview
        4. 1.4. Running the EasyStep Interview
          1. 1.4.1. The big Welcome
          2. 1.4.2. Supplying company information
          3. 1.4.3. Customizing QuickBooks
          4. 1.4.4. Setting your start date
          5. 1.4.5. Adding bank accounts
          6. 1.4.6. Reviewing the suggested chart of accounts
          7. 1.4.7. Looking at the QuickBooks Learning Center window
        5. 1.5. Identifying the Starting Trial Balance
          1. 1.5.1. A simple example to start
          2. 1.5.2. A real-life example to finish
          3. 1.5.3. Supplying the missing account balances ...
            1. 1.5.3.1. Supplying missing inventory balances
            2. 1.5.3.2. Supplying missing accounts receivable and accounts payable balances
      2. 2. Loading the Master File Lists
        1. 2.1. Setting Up the Chart of Accounts List
        2. 2.2. Setting Up the Item List
        3. 2.3. Working with the Price Level List
        4. 2.4. Using Sales Tax Codes
        5. 2.5. Setting Up a Payroll Item List
        6. 2.6. Setting Up Classes
        7. 2.7. Setting Up a Customer List
        8. 2.8. Setting Up the Vendor List
        9. 2.9. Setting Up a Fixed Assets List
        10. 2.10. Setting Up Your Employees
        11. 2.11. Setting Up an Other Names List
        12. 2.12. Setting Up the Profile Lists
      3. 3. Fine-Tuning QuickBooks
        1. 3.1. Accessing the Preferences Settings
        2. 3.2. Setting the Accounting Preferences
          1. 3.2.1. Using account numbers
          2. 3.2.2. General accounting options
        3. 3.3. Setting the Bill Preferences
        4. 3.4. Setting the Checking Preferences
        5. 3.5. Changing the Desktop View
        6. 3.6. Setting Finance Charge Calculation Rules
        7. 3.7. Setting General Preferences
        8. 3.8. Controlling Integrated Applications
        9. 3.9. Controlling Inventory
        10. 3.10. Controlling How Jobs and Estimates Work
        11. 3.11. Dealing with Multiple Currencies
        12. 3.12. Starting Integrated Payment Processing
        13. 3.13. Controlling How Payroll Works
        14. 3.14. Telling QuickBooks How Reminders Should Work
        15. 3.15. Specifying Reports & Graphs Preferences
        16. 3.16. Setting Sales & Customers Preferences
        17. 3.17. Specifying How Sales Are Taxed
        18. 3.18. Setting the Send Forms Preferences
        19. 3.19. Fine-Tuning the Service Connection
        20. 3.20. Controlling Spell Checking
        21. 3.21. Controlling How 1099 Tax Reporting Works
        22. 3.22. Setting Time & Expenses Preferences
    8. III. Bookkeeping Chores
      1. 1. Invoicing Customers
        1. 1.1. Choosing an Invoice Form
        2. 1.2. Customizing an Invoice Form
          1. 1.2.1. Choosing a template to customize
          2. 1.2.2. Easy invoice customizations
            1. 1.2.2.1. Logo, please
            2. 1.2.2.2. Color you beautiful
            3. 1.2.2.3. Fiddling with invoice fonts
            4. 1.2.2.4. Specifying Company & Transaction information
          3. 1.2.3. Reviewing the Additional Customization options
            1. 1.2.3.1. Specifying Header information
            2. 1.2.3.2. Specifying Columns information
            3. 1.2.3.3. Specifying prog columns information
            4. 1.2.3.4. Specifying Footer information
            5. 1.2.3.5. Specifying Print information
          4. 1.2.4. Working with the Layout Designer tool
        3. 1.3. Invoicing a Customer
        4. 1.4. Billing for Time
          1. 1.4.1. Using a weekly timesheet
          2. 1.4.2. Timing single activities
          3. 1.4.3. Including billable time on an invoice
        5. 1.5. Printing Invoices
        6. 1.6. E-Mailing Invoices
        7. 1.7. Recording a Sales Receipt
        8. 1.8. Recording Credit Memos
        9. 1.9. Receiving Customer Payments
        10. 1.10. Assessing Finance Charges
          1. 1.10.1. Setting up finance charge rules
          2. 1.10.2. Calculating finance charges
        11. 1.11. Customer Odds and Ends
      2. 2. Paying Vendors
        1. 2.1. Creating a Purchase Order
          1. 2.1.1. A real purchase order
          2. 2.1.2. Purchase order tips and tricks
        2. 2.2. Recording the Receipt of Items
        3. 2.3. Simultaneously Recording the Receipt and the Bill
        4. 2.4. Entering a Bill
          1. 2.4.1. If you haven't previously recorded an item receipt
          2. 2.4.2. If you have previously recorded an item receipt
          3. 2.4.3. Recording a credit memo
        5. 2.5. Paying Bills
        6. 2.6. Reviewing the Other Vendor Menu Commands
          1. 2.6.1. Vendor Center
          2. 2.6.2. Sales Tax menu commands
          3. 2.6.3. Inventory Activities
          4. 2.6.4. Print 1099s/1096
          5. 2.6.5. Item List
      3. 3. Tracking Inventory and Items
        1. 3.1. Looking at Your Item List
          1. 3.1.1. Using the Item column
          2. 3.1.2. Using the Item List window
          3. 3.1.3. Using the inventory reports
        2. 3.2. Adding Items to the Item List
          1. 3.2.1. Basic steps for adding an item
          2. 3.2.2. Adding a service item
          3. 3.2.3. Adding an inventory part
          4. 3.2.4. Adding a non-inventory part
          5. 3.2.5. Adding an other charge item
          6. 3.2.6. Adding a subtotal item
          7. 3.2.7. Adding a group item
          8. 3.2.8. Adding a discount item
          9. 3.2.9. Adding a payment item
          10. 3.2.10. Adding a sales tax item
          11. 3.2.11. Setting up a sales tax group
          12. 3.2.12. Adding custom fields to items
        3. 3.3. Editing Items
        4. 3.4. Adjusting Physical Counts and Inventory Values
        5. 3.5. Adjusting Prices and Price Levels
          1. 3.5.1. Using the Change Item Prices command
          2. 3.5.2. Using price levels
            1. 3.5.2.1. Creating a price level
            2. 3.5.2.2. Using a price level
        6. 3.6. Inventory in a Manufacturing Firm
          1. 3.6.1. Manufactured inventory the simple way
          2. 3.6.2. Inventory accounting in QuickBooks Premier
            1. 3.6.2.1. Adding inventory assembly items
            2. 3.6.2.2. Recording manufacture or assembly of items
      4. 4. Managing Cash and Bank Accounts
        1. 4.1. Writing Checks
          1. 4.1.1. Recording and printing a check
          2. 4.1.2. Customizing the check form
        2. 4.2. Making Bank Deposits
        3. 4.3. Transferring Money between Bank Accounts
        4. 4.4. Working with the Register
          1. 4.4.1. Recording register transactions
          2. 4.4.2. Using Register window commands and buttons
            1. 4.4.2.1. The Go To button
            2. 4.4.2.2. The Print button
            3. 4.4.2.3. The Edit Transaction button
            4. 4.4.2.4. The QuickReport button
            5. 4.4.2.5. The Download Bank Statement button
            6. 4.4.2.6. The 1-Line check box
            7. 4.4.2.7. The Sort By box
        5. 4.5. Using Edit Menu Commands
        6. 4.6. Reconciling the Bank Account
        7. 4.7. Reviewing the Other Banking Commands
          1. 4.7.1. Order Checks & Envelopes command
          2. 4.7.2. Enter Credit Card Charges command
          3. 4.7.3. Online Banking command
          4. 4.7.4. Online Banking Center command
          5. 4.7.5. Loan Manager
          6. 4.7.6. Other Names list
      5. 5. Paying Employees
        1. 5.1. Setting Up Basic Payroll
          1. 5.1.1. Signing up for a payroll service
          2. 5.1.2. Setting up employees
            1. 5.1.2.1. Providing payroll and tax information
            2. 5.1.2.2. Providing other employment-related information
          3. 5.1.3. Setting up year-to-date amounts
          4. 5.1.4. Checking your payroll setup data
        2. 5.2. Scheduling Payroll Runs
        3. 5.3. Paying Employees
        4. 5.4. Editing and Voiding Paychecks
        5. 5.5. Paying Payroll Liabilities
    9. IV. Accounting Chores
      1. 1. For Accountants Only
        1. 1.1. Working with QuickBooks Journal Entries
          1. 1.1.1. Recording a journal entry
          2. 1.1.2. Reversing a journal entry
          3. 1.1.3. Editing journal entries
        2. 1.2. Updating Company Information
        3. 1.3. Working with the Memorized Transactions
        4. 1.4. Reviewing the Accountant & Taxes Reports
        5. 1.5. A Few Words about the Decision Tools
        6. 1.6. Creating an Accountant's Copy of the QuickBooks Data File
          1. 1.6.1. Creating an accountant's copy
          2. 1.6.2. Using an accountant's copy
          3. 1.6.3. Reusing an accountant's copy
          4. 1.6.4. Exporting client changes
          5. 1.6.5. Importing accountant's changes
          6. 1.6.6. Canceling accountant's changes
      2. 2. Preparing Financial Statements and Reports
        1. 2.1. Some Wise Words Up Front
        2. 2.2. Producing a Report
        3. 2.3. Working with the Report Window
          1. 2.3.1. Working with Report window buttons
            1. 2.3.1.1. Modify Report
            2. 2.3.1.2. Memorize
            3. 2.3.1.3. Print
            4. 2.3.1.4. Email
            5. 2.3.1.5. Export
            6. 2.3.1.6. Hide Header
            7. 2.3.1.7. Collapse
            8. 2.3.1.8. Refresh
          2. 2.3.2. Using the Report window boxes
            1. 2.3.2.1. Dates, From, and To boxes
            2. 2.3.2.2. Columns box
            3. 2.3.2.3. Sort By box
        4. 2.4. Modifying a Report
          1. 2.4.1. Using the Display tab
          2. 2.4.2. Using the Filters tab
          3. 2.4.3. Using the Header/Footer tab
          4. 2.4.4. Formatting fonts and numbers
        5. 2.5. Processing Multiple Reports
        6. 2.6. A Few Words about Document Retention
      3. 3. Preparing a Budget
        1. 3.1. Reviewing Common Budgeting Tactics
          1. 3.1.1. Top-line budgeting
          2. 3.1.2. Zero-based budgeting
          3. 3.1.3. Benchmarking
          4. 3.1.4. Putting it all together
        2. 3.2. Practical Approaches to Budgeting
        3. 3.3. Using the Set Up Budgets Window
          1. 3.3.1. Creating a new budget
          2. 3.3.2. Working with an existing budget
        4. 3.4. Managing with a Budget
        5. 3.5. Some Wrap-Up Comments on Budgeting
      4. 4. Using Activity-Based Costing
        1. 4.1. Revealing Traditional Overhead Allocation
        2. 4.2. How ABC Works
          1. 4.2.1. The ABC product line income statement
          2. 4.2.2. ABC in a small firm
        3. 4.3. Implementing a Simple ABC System
        4. 4.4. How QuickBooks Supports ABC
        5. 4.5. Turning On Class Tracking
        6. 4.6. Using Classes for ABC
          1. 4.6.1. Setting up your classes
          2. 4.6.2. Classifying revenue amounts
          3. 4.6.3. Classifying expense amounts
          4. 4.6.4. After-the-fact classifications
          5. 4.6.5. Producing ABC reports
      5. 5. Setting Up Project and Job Costing Systems
        1. 5.1. Setting Up a QuickBooks Job
        2. 5.2. Tracking Job or Project Costs
        3. 5.3. Job Cost Reporting
        4. 5.4. Using Job Estimates
        5. 5.5. Progress Billing
    10. V. Financial Management
      1. 1. Ratio Analysis
        1. 1.1. Some Caveats about Ratio Analysis
        2. 1.2. Liquidity Ratios
          1. 1.2.1. Current ratio
          2. 1.2.2. Acid test ratio
        3. 1.3. Leverage Ratios
          1. 1.3.1. Debt ratio
          2. 1.3.2. Debt equity ratio
          3. 1.3.3. Times interest earned ratio
          4. 1.3.4. Fixed-charges coverage ratio
        4. 1.4. Activity Ratios
          1. 1.4.1. Inventory turnover ratio
          2. 1.4.2. Days of inventory ratio
          3. 1.4.3. Average collection period ratio
          4. 1.4.4. Fixed asset turnover ratio
          5. 1.4.5. Total assets turnover ratio
        5. 1.5. Profitability Ratios
          1. 1.5.1. Gross margin percentage
          2. 1.5.2. Operating income/sales
          3. 1.5.3. Profit margin percentage
          4. 1.5.4. Return on assets
          5. 1.5.5. Return on equity
      2. 2. Economic Value Added Analysis
        1. 2.1. Introducing the Logic of EVA
        2. 2.2. EVA in Action
          1. 2.2.1. An example of EVA
          2. 2.2.2. Another example of EVA
        3. 2.3. Some Important Points about EVA
        4. 2.4. Using EVA When Your Business Has Debt
          1. 2.4.1. The first example of the modified EVA formula
          2. 2.4.2. Another EVA with debt example
        5. 2.5. Two Final Pointers
        6. 2.6. And Now a Word to My Critics
      3. 3. Capital Budgeting in a Nutshell
        1. 3.1. Introducing the Theory of Capital Budgeting
          1. 3.1.1. The big thing is the return
          2. 3.1.2. One little thing is maturity
          3. 3.1.3. Another little thing is risk
        2. 3.2. Putting It All Together
        3. 3.3. Calculating the Rate of Return on Capital
          1. 3.3.1. Calculate the investment amount
          2. 3.3.2. Estimate the net cash flows
          3. 3.3.3. Calculating the return
        4. 3.4. Measuring Liquidity
        5. 3.5. Thinking about Risk
        6. 3.6. What Does All This Have to Do with QuickBooks?
    11. VI. Business Plans
      1. 1. Profit-Volume-Cost Analysis
        1. 1.1. How Profit-Volume-Cost Analysis Works
        2. 1.2. Calculating Breakeven Points
        3. 1.3. Using Real QuickBooks Data for Profit-Volume-Cost Analysis
          1. 1.3.1. Sales revenue
          2. 1.3.2. Gross margin percentage
          3. 1.3.3. Fixed costs
        4. 1.4. The Downside of the Profit-Volume-Cost Model
        5. 1.5. Using the Profit-Volume-Cost Analysis Workbook
          1. 1.5.1. Collecting your inputs
          2. 1.5.2. Understanding the breakeven analysis
          3. 1.5.3. Understanding the profit-volume-cost forecast
          4. 1.5.4. Looking at the profit-volume-cost charts
      2. 2. Creating a Business Plan Forecast
        1. 2.1. Reviewing Financial Statements and Ratios
        2. 2.2. Using the Business Plan Workbook
        3. 2.3. Understanding the Workbook Calculations
          1. 2.3.1. Forecasting inputs
          2. 2.3.2. Balance Sheet
            1. 2.3.2.1. Cash & Equivalents
            2. 2.3.2.2. Accounts Receivable
            3. 2.3.2.3. Inventory
            4. 2.3.2.4. Other Current Assets
            5. 2.3.2.5. Total Current Assets
            6. 2.3.2.6. Plant, Property, & Equipment
            7. 2.3.2.7. Less: Accumulated Depreciation
            8. 2.3.2.8. Net Plant, Property, & Equipment
            9. 2.3.2.9. Other Noncurrent Assets
            10. 2.3.2.10. Total Assets
            11. 2.3.2.11. Accounts Payable
            12. 2.3.2.12. Accrued Expenses
            13. 2.3.2.13. Other Current Liabilities
            14. 2.3.2.14. Total Current Liabilities
            15. 2.3.2.15. Long-Term Liabilities
            16. 2.3.2.16. Other Noncurrent Liabilities
            17. 2.3.2.17. Total Noncurrent Liabilities
            18. 2.3.2.18. Owner Equity
            19. 2.3.2.19. Total Liabilities and Owner Equity
          3. 2.3.3. Common Size Balance Sheet
          4. 2.3.4. Income Statement
            1. 2.3.4.1. Sales Revenue
            2. 2.3.4.2. Less: Cost of Sales
            3. 2.3.4.3. Gross Margin
            4. 2.3.4.4. Operating Expenses — Cost Centers 1, 2, and 3
            5. 2.3.4.5. Total Operating Expenses
            6. 2.3.4.6. Operating Income
            7. 2.3.4.7. Interest Income
            8. 2.3.4.8. Interest Expense
            9. 2.3.4.9. Net Income (Loss) Before Taxes
            10. 2.3.4.10. Income Tax Expenses (Savings)
            11. 2.3.4.11. Net Income (Loss) After Taxes
          5. 2.3.5. Common Size Income Statement
          6. 2.3.6. Cash Flow Statement
            1. 2.3.6.1. Beginning Cash Balance
            2. 2.3.6.2. Net Income After Taxes
            3. 2.3.6.3. Addback of Depreciation
            4. 2.3.6.4. Accounts Payable Financing
            5. 2.3.6.5. Accrued Expenses Financing
            6. 2.3.6.6. Other Current Liabilities Financing
            7. 2.3.6.7. Long-Term Liabilities Financing
            8. 2.3.6.8. Other Noncurrent Liabilities Financing
            9. 2.3.6.9. Accounts Receivable Investments
          7. 2.3.7. Inventory Investments
            1. 2.3.7.1. Other Current Assets Investments
            2. 2.3.7.2. Plant, Property, & Equip Investments
            3. 2.3.7.3. Other Noncurrent Assets Investments
            4. 2.3.7.4. Other Owner Equity Changes
            5. 2.3.7.5. Net Cash Generated (Used)
            6. 2.3.7.6. Ending Cash Balance
          8. 2.3.8. Financial Ratios Table
            1. 2.3.8.1. Current Ratio
            2. 2.3.8.2. Quick Ratio
            3. 2.3.8.3. Working Capital to Total Assets
            4. 2.3.8.4. Receivables Turnover
            5. 2.3.8.5. Inventory Turnover
            6. 2.3.8.6. Times Interest Earned
            7. 2.3.8.7. Sales to Operational Assets
            8. 2.3.8.8. Return on Total Assets
            9. 2.3.8.9. Return on Equity
            10. 2.3.8.10. Investment Turnover
            11. 2.3.8.11. Financial Leverage
        4. 2.4. Customizing the Starter Workbook
          1. 2.4.1. Changing the number of periods
          2. 2.4.2. Ratio analysis on existing financial statements
          3. 2.4.3. Calculating taxes for a current net loss before taxes
          4. 2.4.4. Combining this workbook with other workbooks
      3. 3. Writing a Business Plan
        1. 3.1. What the Term Business Plan Means
        2. 3.2. A Few Words about Strategic Plans
          1. 3.2.1. Cost strategies
          2. 3.2.2. Differentiated products and services strategies
          3. 3.2.3. Focus strategies
        3. 3.3. Look, Ma: No Strategy
          1. 3.3.1. Two comments about tactics
          2. 3.3.2. Six final strategy pointers
        4. 3.4. Writing a White Paper Business Plan
        5. 3.5. Writing a New Venture Plan
          1. 3.5.1. Is the new venture's product or service feasible?
          2. 3.5.2. Does the market want the product or service?
          3. 3.5.3. Can the product or service be profitably sold?
          4. 3.5.4. Is the return on the venture adequate for prospective investors?
          5. 3.5.5. Can existing management run the business?
          6. 3.5.6. Some final thoughts
    12. VII. Care and Maintenance
      1. 1. Administering QuickBooks
        1. 1.1. Keeping Your Data Confidential
          1. 1.1.1. Using Windows security
          2. 1.1.2. Using QuickBooks security
        2. 1.2. QuickBooks in a Multi-User Environment
          1. 1.2.1. Setting up additional QuickBooks users
          2. 1.2.2. Changing user rights
        3. 1.3. A Few Words about Closing
        4. 1.4. Using Audit Trails
        5. 1.5. Turning on Audit Trail Tracking
        6. 1.6. Producing an Audit Trail Report
        7. 1.7. Simultaneous Multi-User Access
        8. 1.8. Maintaining Good Accounting Controls
      2. 2. Protecting Your Data
        1. 2.1. Backing Up the QuickBooks Data File
          1. 2.1.1. Backing up basics
          2. 2.1.2. What about online backup?
          3. 2.1.3. Some backup tactics
        2. 2.2. Restoring a QuickBooks Data File
        3. 2.3. Cleaning Up the QuickBooks Company Files
          1. 2.3.1. Cleanup basics
          2. 2.3.2. Some clean-up and archiving strategies
      3. 3. Troubleshooting
        1. 3.1. Using the QuickBooks Help File and This Book
        2. 3.2. Browsing Intuit's Product-Support Web Site
        3. 3.3. Checking Another Vendor's Product-Support Web Site
        4. 3.4. Tapping into Intuit's Product-Support System
        5. 3.5. Trying an Internet Newsgroup
        6. 3.6. When All Else Fails ...
    13. VIII. Appendixes
      1. A. A Crash Course in Excel
        1. A.1. Starting Excel
        2. A.2. Stopping Excel
        3. A.3. Explaining Excel's Workbooks
        4. A.4. Putting Text, Numbers, and Formulas into Cells
        5. A.5. Writing Formulas
        6. A.6. Scrolling through Big Workbooks
        7. A.7. Copying and Cutting Cell Contents
          1. A.7.1. Copying cell contents
          2. A.7.2. Moving cell contents
          3. A.7.3. Moving and copying formulas
        8. A.8. Formatting Cell Contents
        9. A.9. Functions Are Simply Formulas
        10. A.10. Saving and Opening Workbooks
          1. A.10.1. Saving a workbook
          2. A.10.2. Opening a workbook
        11. A.11. Printing Excel Workbooks
        12. A.12. One Other Thing to Know
      2. B. Government Web Resources for Businesses
        1. B.1. Bureau of Economic Analysis
          1. B.1.1. Information available at the BEA Web site
          2. B.1.2. Downloading a BEA publication
          3. B.1.3. Uncompressing a BEA publication
          4. B.1.4. Using the BEA publication
        2. B.2. Bureau of Labor Statistics
          1. B.2.1. Information available at the BLS Web site
          2. B.2.2. Using Bureau of Labor Statistics information
        3. B.3. Census Bureau
          1. B.3.1. Information available at the Census Bureau Web site
          2. B.3.2. Using the Census Bureau's publications
          3. B.3.3. Using the Census Bureau search engine
          4. B.3.4. Using the Census Bureau site index
        4. B.4. SEC EDGAR
          1. B.4.1. Information available through EDGAR
          2. B.4.2. Searching the EDGAR database
        5. B.5. The Federal Reserve Web Site
          1. B.5.1. Information available at the Federal Reserve Web site
          2. B.5.2. Using the Federal Reserve Web site's information
        6. B.6. Using the Government Printing Office Access Site
          1. B.6.1. Information available at the GPO Access site
          2. B.6.2. Searching the GPO Access database
        7. B.7. Using the Internal Revenue Web Site
      3. C. Glossary of Accounting and Financial Terms