- 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
Conrad Carlberg has authored, coauthored, and contributed to more than 15 books about business analysis, quantitative forecasting, and database management. For several years, Carlberg has developed applications for use with QuickBooks in concert with Microsoft Excel, Word, and SQL Server.
He received a PhD from the University of Colorado, where he specialized in inferential statistics. Carlberg lives near San Diego, where he shares a home with two female cats, one of them well over five feet tall.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.