- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
Do more in less time!Whether you're an entrepreneur, accountant, or bookkeeper, this comprehensive guide will help you get the most out of QuickBooks 2012: more productivity, more business knowledge, and more value! Drawing on her unsurpassed QuickBooks consulting experience, Laura Madeira delivers step-by-step guides and practical checklists for taking total control over business finances, and improving everything from planning to reporting, payroll to invoicing!* Create new files; convert from other software; and set up users, permissions, and preferences* Master all the essentials of financial reporting* Understand QuickBooks lists: from the chart of accounts, items, classes and more* Set up and manage inventory, vendors, customers, and payroll* Track customer leads* Work with bank and credit card accounts* Create repeatable reports* Review the accuracy of your data, step by step* Share QuickBooks data with accountants* Reliably back up data* Troubleshoot database errors and monitor QuickBooks databases* Use QuickBooks 2012's tools for managing loans, planning, preparing for year-end, and syncing with Outlook* Efficiently review and correct client data errors, from misclassified transactions to incorrect beginning balances* Prepare customized financials using MS Excel and Word integration* Master powerful shortcuts for working more efficiently and saving precious timeAll In Depth books offer* Comprehensive coverage with detailed solutions* Troubleshooting help for tough problems you can't fix on your own* Outstanding authors recognized worldwide for their expertise and teaching styleLearning, reference, problem-solving...the only QuickBooks 2012 book you need!
Contents
Introduction 1How This Book Is Organized 1Conventions Used in This Book 3Menu Commands 3Web Pages and Manufacturer Information 3Special Elements 4Text Conventions 4Introducing QuickBooks 2012: What's New 5Get New Insights 5Calendar View 5Excel Integration Refresh 5User-Contributed Reports 7Get More Organized 7Lead Center 7Document Center 7Inventory Center 9Edit No Company Open 9QuickBooks 1099/1096 Wizard 9Get Time Back and Save Steps 11Express Start 11Batch Timesheets 11Integrated Help/Search 12Transaction Tab 12QuickBooks Enterprise Solutions 13Enhanced Inventory Receiving 13First In First Out (FIFO) Inventory Costing 14Inventory Auto Cost, Sales Price, Markup 15Inventory Lot/Serial Number Tracking 15For the Accounting Professional 17Accountant Center 17Starter Copy 18Period/Archive Copy 18QuickBooks Statement Writer 191 Getting Started with QuickBooks 21Understanding QuickBooks 21Using QuickBooks Sample Data 23Creating a New QuickBooks File 24Express Start 25Advanced Setup Using EasyStep Interview 29Creating a New File from an Existing Company File 33Converting from Other Accounting Software 34Converting from Quicken to QuickBooks 35Converting from Peachtree, Small Business Accounting, or Office Accounting to QuickBooks 36Setting Up Users and Permissions 38External Accountant 38Other QuickBooks Users 402 Getting Around QuickBooks 43Home Page and Navigation 43Title Bar 43Menu Bar 44Icon Bar 45Home Page 47Open Windows List 50Tutorials 50Preferences 51Accounting-Company Preferences 51Desktop View-My Preferences 52General-My Preferences 52Spelling-My Preferences 53Help Options 53Selecting a Company File to Open 54Opening Your Data for the First Time 54Choosing from a List of Multiple Data Files 553 Accounting 101 57Basic Principles of Accounting 57The Matching Principle 57Accrual Versus Cash Basis Reporting 59Basic Financial Reports 60Balance Sheet 60Income Statement 61Statement of Cash Flows 61Other Accounting Reports 62Accounting Checklist to Help You Manage Your Financials 62Setting Up a QuickBooks Data File for Accrual or Cash Basis Reporting 63Cash or Accrual Basis Startup Transactions: Accounts Receivable 65Cash or Accrual Basis Startup Transactions: Accounts Payable 69Cash or Accrual Basis Startup Transactions: Bank Account Statement Balance 73Cash or Accrual Basis Startup Transactions: Recording Uncleared Bank Checks 744 Understanding QuickBooks Lists 77Chart of Accounts 77Account Types 78Adding a New Account 80Items 82Adding an Item 82Understanding Items 84Item Types 85Class 86Customer Type 88Managing Lists 89Chart of Account Preferences 89Add/Edit Multiple List Entries 90Importing an Intuit Interchange Format File (IIF) 92Reporting on Lists 94Finding and Fixing Chart of Account Errors 94QuickBooks Required Accounts 95Making an Account Inactive 95Merging Duplicated Accounts 96Modifying an Account in the Chart of Accounts 97Assigning or Removing a Subaccount Relationship 98Finding and Fixing Item List Errors 100Reviewing the Item List on the Computer Screen 100Item Listing Report 102Profit & Loss Standard Report 102Correcting One-Sided Items 105Making an Item Inactive 108Merging Items 109Creating Items as Subitems 1105 Setting Up Inventory 111Overview of Accounting for Inventory 111Inventory Features by QuickBooks Edition 112QuickBooks Pro 2012 112QuickBooks Premier 2012 113QuickBooks Enterprise Solutions 12.0 114Enabling Inventory Preferences 115Inventory Item Type Descriptions 118Inventory Part 119Non-inventory Part 119Group Items and Inventory Assemblies 119Adding or Editing Inventory Items 121Adding or Editing Individual Items 121Using Add/Edit Multiple List Entries 125Importing an Intuit Interchange Format File (IIF) 127Changing Item Prices 128Creating Inventory Assemblies 131Creating Group Items 133Setting Up Multiple Unit of Measurement 134Proper Inventory Processes 137Purchasing, Receiving, and Entering the Vendor Bill 139Paying for Inventory 146Selling Inventory 148Working with Group Items 149Working with Assemblies 150Handling Inventory Backorders 152Handling Customer Inventory Returns 155Handling Vendor Inventory Returns 1586 Managing Inventory 159Adjusting Inventory 159Performing a Physical Inventory Count 160Quantity Adjustments 161Value Adjustments 162Inventory Reporting 165Inventory Center 165Report Center 166Inventory Valuation and Your Financials 168Reviewing the Recorded Average Cost Valuation 170Reviewing Aged Item Receipts 173Reviewing Aged Accounts Payable 176How QuickBooks Handles Negative Inventory 177When Inventory Has an Average Cost from Prior Purchase Transactions 178When Inventory Does Not Have a Prior Average Cost 1807 Setting Up Vendors 185Customizing Your Home Page for Vendor Activities 185Preferences That Affect Accounts Payable 186Accounting 186Bills 188Checking 188General 190Reminders 191Reports and Graphs 191Tax:1099 192Working with the Vendor Center 193Adding or Modifying Vendors 194Finding Vendor Transactions 198The Accounts Payable Process 200Accounts Payable Forms 200Accounts Payable Workflow 202Entering a Purchase Order 204Recording Vendor Bills 205Creating a Vendor Credit 207Paying Vendor Bills 209Applying Vendor Credits 211Taking Discounts on Vendor Bills 2138 Managing Vendors 215Accounts Payable Reporting 215Reconciling Balance Sheet Accounts Payable Balance to A/P Aging Summary Report Total 215Reviewing the Unpaid Bills Detail Report 216Reviewing Aged Open Item Receipts 218Reviewing Item Setup 221Accounts Payable Balance on Cash Basis Balance Sheet 222Tracking and Reporting Vendor 1099-MISC Payments 226Correcting Accounts Payable Errors 235Open Vendor Bills Paid with a Write Checks Transaction 236Misapplied Vendor Credit 238Removing Aged Open Item Receipts or Vendor Bills 239Making General Journal Adjustments to Accounts Payable 241Handling Unique Accounts Payable Transactions 243Bartering Services with Your Vendors 244Recording Vendor Prepayments 245Entering Mid-Year 1099 Balances 248Memorizing Recurring Transactions 249Depositing a Vendor Refund 250Paying and Recording a Credit Card Bill 2519 Setting Up Customers 253Introduction 253Customizing Home Page Customer Activities 254Preferences That Affect Accounts Receivable 254Payments 255Sales & Customers 257Checking 257Finance Charge 258Jobs & Estimates 259Reminders 259Reports & Graphs 260Sales Tax 262Send Forms 263Spelling 264Time & Expenses 265Working with the Customer Center 266Adding or Modifying Customers and Jobs 267Finding Customer Transactions 270Working with Prospects in the Lead Center 272Setting Up Sales Tax 274Creating Sales Tax Items 274Creating Sales Tax Group Items 275Creating Sales Tax Codes 276Assigning Sales Tax Codes to Products or Services 278Assigning Sales Tax Codes and Sales Tax Items to Customers 279Creating Price Level Lists 280Creating Payment Terms 281Customizing QuickBooks Forms 282Using the Customize My Forms Wizard 282Using the Customize Data Layout Tool 285Accounts Receivable Process 289Using QuickBooks Estimates 290Using QuickBooks Sales Orders 292Creating Customer Invoices 292Recording a Sales Receipt 306Recording a Statement Charge 307Recording the Customer Payment 308Making the Bank Deposit 311Recording and Applying a Customer Credit Memo 315Refunding a Customer's Overpayment 31710 Managing Customers 319Accounts Receivable Reporting 319Reviewing A/R Aging Summary and Detail Reports 319Reviewing the Open Invoices Report 321Reconciling Balance Sheet Accounts Receivable Amount to A/R Aging Summary Total 322Viewing the Accounts Receivable Balance on a Cash Basis Balance Sheet 324Using the Collections Center 326Generating the Missing Customer Invoices Report 328Sales Tax Payable Reports 329Reviewing Customer Lists for Tax Code and Tax Item Assigned 329Reviewing the Item List for Tax Code Assigned 330Reconciling Total Sales to Total Income 331Reconciling Sales Tax Liability to Balance Sheet Sales Tax Payable 332When a Check or Bill Was Used to Pay Sales Tax 334Paying Sales Tax 334Paying Sales Tax Without an Adjustment 334Paying Sales Tax with an Adjustment 336Correcting Accounts Receivable Errors 338Removing an Open Balance from a Customer Invoice 338Correcting Customer Payments 342When a Credit Memo Is Applied to the Wrong Customer Invoice 346When Deposits Were Made Incorrectly 347Eliminating the Print Queue for Customer Invoices Marked to Print 353Correcting Sales Tax Errors 354When a Check or Bill Was Used to Pay the Sales Tax 354When the Sales Tax Liability Report Shows Past Sales Tax Due 356When Total Sales Does Not Equal Total Income 358Correcting Undeposited Funds Account Errors 361Reviewing the Balance in the Undeposited Funds Account 361Removing Old Dated Payments in the Undeposited Funds Account 364Unique Customer Transactions 366Recording Your Accountant's Year-End Adjusting Journal Entry to Accounts Receivable 366When a Customer Is Also a Vendor 366Recording a Customer's Bounced Check 368Tracking Customer Deposits in QuickBooks 370Unique Sales Tax Transactions 371When Your State Imposes a Maximum Sales Tax 371Multiple Sales Tax Rates on One Invoice 373Issuing Credit Memos When Sales Tax Should Not Have Been Charged 37411 Setting Up Payroll 377Getting Started 377Payroll Process Overview 377Selecting and Activating a Payroll Service Subscription 379Updating Payroll Tax Tables 381Employer Resources 382Creating Payroll Accounts in the Chart of Accounts 384Setting Up Payroll Tax Vendors 385Payroll Preferences 387Using the Payroll Setup Interview 390Using the Run Payroll Checkup Diagnostic Tool 397Managing Employees 401Using the Employee Center 401Adding or Editing Employee Information 402Finding Payroll Transactions 404Managing Payroll Items 406Adding or Editing Payroll Items 406Reporting About Payroll Items 409Paying Employees 410Payroll Home Page Workflow 410Entering Employee Time 411Preparing Employee Paychecks 413Printing Paychecks or Paystubs 415Preparing Payroll Liability Payments 415Paying Scheduled Liabilities 416Adjusting Payroll Liabilities 41712 Managing Payroll 419Payroll Reporting 419Report Center Payroll Reports 419Excel Reports 420Tax Forms and Filings 421Preparing and Printing Tax Forms 422E-Filing Tax Payments and Forms 423Troubleshooting Payroll 424Comparing Payroll Liability Balances to the Balance Sheet 424Comparing Payroll Summary to Filed Payroll Returns 426Reconciling Payroll Reports to Business Financials 427Recording Unique Payroll Transactions 427Employee Loan Payment and Repayment 427Reprinting a Lost Paycheck 431Paying a Taxable Bonus 433Adjusting an Employee Paycheck 434Depositing a Refund of Payroll Liabilities 43513 Working with Bank and Credit Card Accounts 437Importance of Bank and Credit Card Balances 437Preferences that Affect Banking and Credit Card Management 437Working with Write Check Transactions 438Using the Expenses Tab and Items Tab 439Writing a Check 440Printing Checks 443Entering a Bank Debit Charge 445Entering Credit Card Charges 446Paying the Credit Card Bill 447Transferring Funds Between Bank Accounts 448Online Banking Center 449Choosing an Online Banking Mode Preference 449Activating Online Services with Your Financial Institution 449Retrieving Online Transactions 450Adding Downloaded Transactions to QuickBooks 452Renaming Rules in Online Banking 453Other Online Banking Features 454Reconciling the Bank or Credit Card Account 458Troubleshooting Reconciliations 461Determining If the Account Has Been Reconciled 461Verifying That All Account Transactions Have Been Entered 463Identifying All Uncleared Transactions 464Completing the Multiyear or Multimonth Bank Reconciliation 465Reviewing Uncleared Transactions 465Reviewing Previous Bank Reconciliation Reports 468Locating Bank Account Reconciliation Discrepancies 468Reviewing the Voided/Deleted Transactions Reports 469Restarting a Previously Completed Bank Reconciliation 470Undoing a Previous Bank Reconciliation 470Reconciling with an Adjustment 47114 Reporting in QuickBooks 473Using the Company Snapshot 473Customizing the Company Snapshot 473Defaulting the Company Snapshot as Home Page 476Report Center 476Reports & Graphs Preferences 479My Preferences 479Company Preferences 479Modifying Reports 482Modifying Options Available on the Report Window 482Customizing Reports 484Report Groups 485Creating Report Groups 485Using Report Groups 485Managing Report Groups 487Memorized Reports 488Exporting and Importing Report Templates 489Exporting a Report or Report Group Template 489Importing a Report or Report Group Template 490Exporting Reports to a .CSV File or to Excel 490Emailing Reports 49315 Reviewing Your Data 495Importance of Reviewing Your Data 495Reviewing the Balance Sheet 495Account Types 497Prior Year Balances 497Bank Account Balance(s) 498Accounts Receivable 498Undeposited Funds 499Inventory 500Other Current Assets 501Fixed Assets 502Accounts Payable 503Credit Cards 503Payroll Liabilities 503Sales Tax Payable 504Other Current Liabilities and Long-Term Liabilities 505Equity 505Reviewing the Profit & Loss Report 505Other Reviews 506Tracking Changes to Closed Accounting Periods 506Using the Audit Trail Report 507Using the Credit Card Audit Trail Report 508Reporting on Voided/Deleted Transactions 510Viewing the Transactions List by Date Report 511Troubleshooting Open Balance Equity Account 51216 Sharing QuickBooks Data with Your Accountant 517Overview 517Benefits for the Business Owner 517Benefits for the Accountant 518QuickBooks File Types 518Choosing a Method to Share Data 520Data Sharing for the Business Owner 522Reviewing Your QuickBooks Data 523Creating an Accountant's Copy of Your Data 523What the Business Owner Can and Cannot Do 529Importing Your Accountant's Changes 530Canceling an Accountant's Copy 536Data Sharing for the Accountant 537Creating an External Accountant User Type 538Preparing Your Client for Data Exchange 538Receiving an Accountant's Copy File 539What the Accountant Can Do 542What the Accountant Cannot Do 545Returning the Accountant's Copy Change File to the Client 545What to Request from the Client When the Import Is Complete 549Converting the Accountant's Copy to a Regular Company File 54917 Managing Your QuickBooks Database 551The QuickBooks Database 551System Requirements 552Installing QuickBooks for Single-User Mode 554Installing QuickBooks for Multi-User Mode 554The QuickBooks Database Server Manager 555Windows Permissions Required for QuickBooks 557Using the QuickBooks Connection Diagnostic Tool 558Keeping Your Software Current 559Upgrading Your QuickBooks Version 559Installing a QuickBooks Maintenance Release 560Protecting Your QuickBooks Database 561Creating a QuickBooks Backup 561Protecting the QuickBooks Operating Environment 564Using Intuit Data Protect Online Backup Service 567Monitoring Your QuickBooks Database 567The Product Information Dialog Box 567Using the Verify Data Utility 569QuickBooks Database Corruption 570Common Causes of Corruption 570Signs of Data Corruption 570The QBWin.log File 571Repairing List Corruptions 574Reducing Database File Fragments 575Rebuilding Your Company File 576Using the QuickBooks Company File Diagnostic Tool 577Resolving QuickBooks Program File Corruption Issues 57918 Using Other Planning and Management Tools 581Planning and Budgeting 581Create a Budget 581Edit a Budget 584Print Budget Reports 585Delete a Budget 587QuickBooks Loan Manager 587Information to Collect 587Getting QuickBooks Ready 587Setting Up a New Loan 588Setting Up a Loan Payment 589Using the Year-End Guide 591Synchronizing QuickBooks Lists with Microsoft Outlook 592Using the QuickBooks Timer 596Installing the QuickBooks Timer 596Preparing the Timer for Activities 597Tracking Time with the Timer 597Exporting Timer Activities 598Importing Timer Activities into QuickBooks 599A Client Data Review 601B QuickBooks Statement Writer 657C QuickBooks Shortcuts 687TOC, 9870789749185, 7/19/2012
