- Copyright
- Credits
- About the Author
- Acknowledgments
- Introduction
- I. Exploiting Your QuickBooks Data
- 1. Using QuickBooks to Analyze Business Data
- 1.1. Advantages and Drawbacks to QuickBooks Reports
- 1.2. Excel as an Adjunct to Report Analysis
- 2. Exporting Data from QuickBooks
- 2.1. Exporting Reports to Excel Workbooks
- 2.2. Formatting and Layout Problems
- 2.3. Exporting to Text Files
- 2.4. Analyzing QuickBooks Data with Pivot Tables
- 3. Digging Deeper with Pivot Tables
- 3.1. A Sample Pivot Table
- 3.2. Moving Data into a Pivot Table
- 3.3. Special Features of Pivot Tables
- 3.4. Sample Pivot Tables from QuickBooks Data
- 1. Using QuickBooks to Analyze Business Data
- II. Analyzing Financial Statements
- 4. Comparative Balance Sheets and Profit & Loss Statements
- 4.1. Reasons for Comparative Analysis
- 4.2. Using QuickBooks to Create Comparative Financial Statements
- 4.3. Combining Vertical and Horizontal Analyses
- 4.4. Making Comparisons to Other Companies
- 5. Working Capital and Cash Flow Analysis
- 6. Ratio Analysis
- 4. Comparative Balance Sheets and Profit & Loss Statements
- III. Controlling Costs and Planning Profits
- 7. Inventory Valuation and Gross Margins
- 7.1. Average Cost
- 7.2. COGS and Gross Margin
- 7.2.1. Selling negative
- 7.2.2. Going positive
- 7.2.2.1. Pending sales
- 7.2.2.2. Recovering after the fact
- 7.2.2.2.1. Correct your quantity on hand using an Adjustment
- 7.2.2.2.2. Correct your quantity on hand by editing an item receipt
- 7.2.2.2.3. Revise an existing sales record
- 8. Forecasting and Projections in QuickBooks
- 8.1. Using the Cash Flow Projector and the Cash Flow Forecast Report
- 8.1.1. A quick overview of the Cash Flow Projector
- 8.1.2. Working your way through the Cash Flow Projector
- 8.1.2.1. Verifying the Cash Flow Projector
- 8.1.2.2. Running the Cash Flow Projector
- 8.1.2.2.1. I Want to Project Cash Receipts Manually option
- 8.1.2.2.2. Use Last 6 Weeks option
- 8.1.2.2.3. Same 6 Week Period Last Year option
- 8.1.2.2.4. Use an Average of Last Six Weeks option
- 8.1.2.2.5. Average of Same 6 week Period Last Year option
- 8.1.2.2.6. Use a Weighted Average of Last 6 Weeks option
- 8.1.3. The trouble with transfers
- 8.1.4. Getting inflow estimates yourself
- 8.2. Going Outside QuickBooks to Project Receipts
- 8.1. Using the Cash Flow Projector and the Cash Flow Forecast Report
- 9. Monitoring Budget Variances
- 9.1. Understanding Process Control Charts
- 9.2. Getting Budget Variances
- 9.2.1. Laying out the data
- 9.2.2. Plotting budget variances
- 9.2.3. Understanding the moving range chart
- 9.2.4. Viewing the underlying data
- 9.2.5. Extending SPC techniques to other QuickBooks data
- 10. Contribution and Margin Analysis
- 10.1. Break-even Analysis
- 10.2. Looking into the Sales Mix
- 10.2.1. Adjusting the QuickBooks report
- 10.2.2. Calculating each product's break-even in units
- 10.2.3. Calculating each product's break-even in dollars
- 10.2.4. Evaluating product contributions
- 10.2.4.1. Lowering the sales price
- 10.2.4.2. Reducing fixed costs
- IV. Designing Your Own Analysis
- 11. Using the QuickBooks Software Development Kit
- 11.1. An Example QuickBooks SDK Application
- 11.2. Arranging for the Dynamic Link Library
- 11.2.1. Accessing QuickBooks objects
- 11.2.2. Getting the SDK
- 11.2.3. Using the Onscreen Reference
- 11.3. Exploring the CustomerQuery Request Code
- 11.4. Exploring the CustomerQuery Response Code
- 12. Managing Reports Using the QuickBooks Software Development Kit
- 12.1. Deciding to Run Reports through the SDK
- 12.2. An Overview of a Report Message
- 12.3. Examining a Report Message's Code
- 12.3.1. Acquiring the code
- 12.3.2. The summary report request message
- 12.3.3. Building the report request
- 12.3.4. The summary report response message
- 12.3.5. Finding data in the report
- 11. Using the QuickBooks Software Development Kit
- 7. Inventory Valuation and Gross Margins
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.