- ホーム
- > 洋書
- > 英文書
- > 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 2013: more productivity, more business knowledge, and more value! Drawing on her unsurpassed QuickBooks consulting and accounting 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 and payroll to invoicing.* Create a new QuickBooks file; convert from other software; and set up users, permissions, and preferences* New! Learn how to use tools specific to your version of QuickBooks, including QuickBooks Enterprise Solutions* Understand QuickBooks lists from the chart of accounts, items, classes, and more* Set up and manage inventory, vendors, customers, and payroll* Track product or service sales and manage the profitability of your company* Efficiently download bank and credit card transactions* Master all the essentials of financial reporting; customize and memorize reports* Review the accuracy of your data, with step-by-step instructions accompanied by checklists* Share QuickBooks data with your accountant or client at tax time* Use QuickBooks 2013's tools for managing loans, planning and preparing for year-end, and syncing with Outlook contacts* Efficiently review and correct client data errors, from misclassified transactions to incorrect beginning balances* Prepare customized reports and documents using MS Excel and Word integration* Master powerful shortcuts for working more efficiently and saving precious time* Learn how to reliably back up your data, troubleshoot database errors, and manage QuickBooks data integrityAll 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 2013 book you need!
Contents
Introduction 1How This Book Is Organized 1Conventions Used in This Book 3Menu Commands 3Web Pages and Manufacturer Information 4Special Elements 4What's New in QuickBooks 2013 5Easy to Learn and Use 5What's New Tips Overlay Help 6New Modern Design 6New Transaction Ribbon Toolbar 7Icon Bar Selection 7Assign a Company Flag Color 10New and Improved Features 10Time and Expenses Preference 11Improved Customer, Vendor, and Employee Centers 11Assign Default Method of Payment for Customers 13Print Vendor Bill 13Reporting Preference for Item-Based Reports 14Hide Zero Quantity Items on Inventory Reports 15Use Available Quantity on Inventory Reorder Reports 15Collapse Summary Report Line Details 16Item Group Limit Increased 17Improved Upgrade Experience for Plus Subscribers 17For the Accounting Professional 18Send General Journal Entries 18Batch Enter Transactions 20Improved: Find and Fix Client Errors Faster 21Easier Access to Creating New Data File from Template 22For QuickBooks Enterprise Users 23Default Class Assignment 23Create Auto Purchase Orders 24Increased List Limits 25QuickBooks Enterprise with Advanced Inventory Subscription 25Row, Shelf or Bin Location Tracking 26Barcode Scanning 27FIFO Cost Lot History Report 291 Getting Started with QuickBooks 31Understanding QuickBooks 31Using QuickBooks Sample Data 33Creating a New QuickBooks File 34Express Start 35Advanced Setup or Detailed Start-Formerly the EasyStep Interview 41Creating a New File from an Existing Company File 45Converting from Other Accounting Software 46Converting from Quicken to QuickBooks 46Converting from Peachtree, Small Business Accounting, or Office Accounting to QuickBooks 48Setting Up Users and Permissions 50External Accountant 50Other QuickBooks Users 51User Security in QuickBooks Enterprise 52Overview 53Set Up and Modify User Roles 53Set Up Users 57Reporting on User Activity 592 Getting Around QuickBooks 61Home Page and Navigation 61Title Bar 62Menu Bar 63Top Icon Bar 63Left Icon Bar 66Home Page 68Open Windows List 71Tutorials 72Preferences 72Accounting-Company Preferences 73Desktop View-My Preferences 73General-My Preferences 75Spelling-My Preferences 76Help Options 76Selecting a Company File to Open 77Opening Your Data for the First Time 77Choosing from a List of Multiple Data Files 783 Accounting 101 81Basic Principles of Accounting 81The Matching Principle 81Accrual Versus Cash Basis Reporting 83Basic Financial Reports 84Balance Sheet 85Income Statement 85Statement of Cash Flows 86Other Accounting Reports 86Accounting Checklist to Help You Manage Your Financials 87Setting Up a QuickBooks Data File for Accrual or Cash Basis Reporting 88Cash or Accrual Basis Startup Transactions: Accounts Receivable 89Cash or Accrual Basis Startup Transactions: Accounts Payable 94Cash or Accrual Basis Startup Transactions: Bank Account Statement Balance 98Cash or Accrual Basis Startup Transactions: Recording Uncleared Bank Checks 994 Understanding QuickBooks Lists 101Chart of Accounts 102Account Types 102Adding a New Account 104Items 106Adding an Item 106Understanding Items 108Item Types 109Class 111Customer Type 113Managing Lists 114Chart of Account Preferences 114Add/Edit Multiple List Entries 115Add Your Excel Data to QuickBooks Utility 118Importing an Intuit Interchange Format File (IIF) 123Reporting on Lists 125Finding and Fixing Chart of Account Errors 126QuickBooks Required Accounts 126Making an Account Inactive 127Merging Duplicated Accounts 127Modifying an Account in the Chart of Accounts 129Assigning or Removing a Subaccount Relationship 130Finding and Fixing Item List Errors 132Reviewing the Item List on the Computer Screen 132Item Listing Report 134Profit & Loss Standard Report 135Correcting One-Sided Items 137Making an Item Inactive 140Merging Items 141Creating Items as Subitems 1425 Setting Up Inventory 145Inventory Features by QuickBooks Edition 146QuickBooks Pro 2013 146QuickBooks Premier 2013 147QuickBooks Enterprise Solutions 13.0 147Enabling Inventory Preferences 149Inventory Item Type Descriptions 152Inventory Part 152Non-inventory Part 153Group Items and Inventory Assemblies 153Adding or Editing Inventory Items 154Adding or Editing Individual Items 155Using Add/Edit Multiple List Entries 159Importing an Intuit Interchange Format File (IIF) 161Changing Item Prices 162Creating Inventory Assemblies 164Creating Group Items 166Setting Up Multiple Unit of Measurement 168Proper Inventory Processes 171Purchasing, Receiving, and Entering the Vendor Bill 173Paying for Inventory 181Selling Inventory 183Working with Group Items 184Working with Assemblies 185Handling Inventory Backorders 187Handling Customer Inventory Returns 191Handling Vendor Inventory Returns 1946 Managing Inventory 195Adjusting Inventory 195Performing a Physical Inventory Count 196Quantity Adjustments 197Value Adjustments 198Inventory Reporting 201Inventory Center 201Report Center 202Inventory Valuation and Your Financials 203Reviewing the Recorded Average Cost Valuation 206Reviewing Aged Item Receipts 208Reviewing Aged Accounts Payable 212How QuickBooks Handles Negative Inventory 212When Inventory Has an Average Cost from Prior Purchase Transactions 213When Inventory Does Not Have a Prior Average Cost 2157 Setting Up Vendors 219Customizing Your Home Page for Vendor Activities 219Preferences That Affect Accounts Payable 220Accounting 220Bills 221Calendar 222Checking 222General 223Reminders 224Reports and Graphs 225Tax:1099 226Time & Expenses 227Working with the Vendor Center 228Adding or Modifying Vendors 230Finding Vendor Transactions 233The Accounts Payable Process 235Accounts Payable Transactions 236Accounts Payable Workflow 238Entering a Purchase Order 240Recording Vendor Bills 240Recording Vendor Credits 243Paying Vendor Bills 245Applying Vendor Credits 248Taking Discounts on Vendor Bills 2508 Managing Vendors 253Accounts Payable Reporting 253Reconciling Balance Sheet Accounts Payable Balance to A/P Aging Summary Report Total 253Reviewing the Unpaid Bills Detail Report 255Reviewing Aged Open Item Receipts 256Reviewing Item Setup 258Accounts Payable Balance on Cash Basis Balance Sheet 260Tracking and Reporting Vendor 1099-MISC Payments 263Correcting Accounts Payable Errors 273Open Vendor Bills Paid with a Write Checks Transaction 273Misapplied Vendor Credit 276Removing Aged Open Item Receipts or Vendor Bills 277Making General Journal Adjustments to Accounts Payable 279Handling Unique Accounts Payable Transactions 282Bartering Services with Your Vendors 282Recording Vendor Prepayments 283Entering Midyear 1099 Balances 286Memorizing Recurring Transactions 287Depositing a Vendor Refund 288Paying and Recording a Credit Card Bill 2899 Setting Up Customers 291Customizing Home Page Customer Activities 292Preferences That Affect Accounts Receivable 292Payments 293Sales & Customers 295Checking 296Finance Charge 296Jobs & Estimates 297Reminders 298Reports & Graphs 299Sales Tax 301Send Forms 302Spelling 303Time & Expenses 304Working with the Customer Center 305Adding or Modifying Customers and Jobs 307Finding Customer Transactions 311Working with Prospects in the Lead Center 312Setting Up Sales Tax 314Creating Sales Tax Items 315Creating Sales Tax Group Items 316Creating Sales Tax Codes 317Assigning Sales Tax Codes to Products or Services 318Assigning Sales Tax Codes and Sales Tax Items to Customers 319Creating Price Level Lists 320Creating Payment Terms 321Customizing QuickBooks Forms 322Using the Customize My Forms Wizard 323Using the Customize Data Layout Tool 325Accounts Receivable Processes 329Using QuickBooks Estimates 331Using QuickBooks Sales Orders 332Creating Customer Invoices 333Recording a Sales Receipt 350Recording a Statement Charge 351Recording the Customer Payment 352Making the Bank Deposit 355Recording and Applying a Customer Credit Memo 359Refunding a Customer's Overpayment 36010 Managing Customers 363Accounts Receivable Reporting 363Reviewing A/R Aging Summary and Detail Reports 364Reviewing the Open Invoices Report 365Reconciling Balance Sheet Accounts Receivable Amount to A/R Aging Summary Total 367Viewing the Accounts Receivable Balance on a Cash Basis Balance Sheet 368Using the Collections Center 370Generating the Missing Customer Invoices Report 372Sales Tax Payable Reports 374Reviewing Customer Lists for Tax Code and Tax Item Assigned 374Reviewing the Item List for Tax Code Assigned 375Reconciling Total Sales to Total Income 375Reconciling Sales Tax Liability to Balance Sheet Sales Tax Payable 376When a Check or Bill Was Used to Pay Sales Tax 377Paying Sales Tax 378Paying Sales Tax Without an Adjustment 378Paying Sales Tax with an Adjustment 379Correcting Accounts Receivable Errors 381Removing an Open Balance from a Customer Invoice 382Correcting Customer Payments 385When a Credit Memo Is Applied to the Wrong Customer Invoice 390When Deposits Were Made Incorrectly 391Eliminating the Print Queue for Customer Invoices Marked to Print 396Correcting Sales Tax Errors 397When a Check or Bill Was Used to Pay the Sales Tax 397When the Sales Tax Liability Report Shows Past Sales Tax Due 399When Total Sales Does Not Equal Total Income 400Correcting Undeposited Funds Account Errors 404Reviewing the Balance in the Undeposited Funds Account 404Removing Old Dated Payments in the Undeposited Funds Account 407Unique Customer Transactions 409Recording Your Accountant's Year-End Adjusting Journal Entry to Accounts Receivable 409When a Customer Is Also a Vendor 409Recording a Customer's Bounced Check 411Tracking Customer Deposits in QuickBooks 413Unique Sales Tax Transactions 414When Your State Imposes a Maximum Sales Tax 415Multiple Sales Tax Rates on One Invoice 416Issuing Credit Memos When Sales Tax Should Not Have Been Charged 41711 Setting Up Payroll 419Getting Started 419Payroll Process Overview 419Selecting and Activating a Payroll Service Subscription 421Updating Payroll Tax Tables 423Employer Resources 424Creating Payroll Accounts in the Chart of Accounts 426Setting Up Payroll Tax Vendors 427Payroll Preferences 429Using the Payroll Setup Interview 432Using the Run Payroll Checkup Diagnostic Tool 439Setting Up Employees 442Using the Employee Center 442Adding or Editing Employee Information 443Finding Payroll Transactions 446Setting Up Payroll Items 447Adding or Editing Payroll Items 448Reporting About Payroll Items 450Paying Employees 452Payroll Home Page Workflow 452Entering Employee Time 453Preparing Employee Paychecks 455Printing Paychecks or Paystubs 457ViewMyPaycheck 458Preparing Payroll Liability Payments 459Paying Scheduled Liabilities 459Adjusting Payroll Liabilities 46012 Managing Payroll 463Report Center Payroll Reports 463Excel Reports 465Tax Forms and Filings 466Preparing and Printing Tax Forms 466E-Filing Tax Payments and Forms 469Troubleshooting Payroll 469Comparing Payroll Liability Balances to the Balance Sheet 469Comparing Payroll Summary to Filed Payroll Returns 472Reconciling Payroll Reports to Business Financials 472Recording Unique Payroll Transactions 473Employee Loan Payment and Repayment 473Reprinting a Lost Paycheck 477Paying a Taxable Bonus 478Adjusting an Employee Paycheck 480Allocating Indirect Costs to Jobs Through Payroll 481Depositing a Refund of Payroll Liabilities 485Recording Payroll When Using an Outside Payroll Service 48613 Working with Bank and Credit Card Accounts 489Preferences That Affect Banking and Credit Card Management 489Working with Write Check Transactions 490Using the Expenses Tab and Items Tab 490Writing a Check 493Printing Checks 496Entering a Bank Debit Charge 498Entering Credit Card Charges 499Paying the Credit Card Bill 500Transferring Funds Between Bank Accounts 501Online Banking Center 502Choosing an Online Banking Mode Preference 502Activating Online Services with Your Financial Institution 502Retrieving Online Transactions 504Adding Downloaded Transactions to QuickBooks 505Renaming Rules in Online Banking 507Other Online Banking Features 508Reconciling the Bank or Credit Card Account 512Troubleshooting Reconciliations 514Determining Whether the Account Has Been Reconciled 515Verifying That All Account Transactions Have Been Entered 516Identifying All Uncleared Transactions 518Completing the Multiyear or Multimonth Bank Reconciliation 518Reviewing Uncleared Transactions 519Reviewing Previous Bank Reconciliation Reports 521Locating Bank Account Reconciliation Discrepancies 522Reviewing the Voided/Deleted Transactions Reports 523Restarting a Previously Completed Bank Reconciliation 524Undoing a Previous Bank Reconciliation 524Reconciling with an Adjustment 52514 Reporting in QuickBooks 527Using the Company Snapshot 527Customizing the Company Snapshot 527Defaulting the Company Snapshot as Home Page 530Report Center 530Reports & Graphs Preferences 533My Preferences 533Company Preferences 533Modifying Reports 536Modifying Options Available on the Report Window 536Customizing Reports 537Report Groups 538Creating Report Groups 538Using Report Groups 539Managing Report Groups 541Memorized Reports 542Exporting and Importing Report Templates 543Exporting a Report or Report Group Template 543Importing a Report or Report Group Template 544Exporting Reports to a .CSV File or to Excel 544Emailing Reports 54615 Reviewing Your Data 549Reviewing the Balance Sheet 549Account Types 551Prior Year Balances 551Bank Account Balance(s) 552Accounts Receivable 553Undeposited Funds 554Inventory 555Other Current Assets 555Fixed Assets 557Accounts Payable 557Credit Cards 558Payroll Liabilities 558Sales Tax Payable 559Other Current Liabilities and Long-Term Liabilities 560Equity 560Reviewing the Profit & Loss Report 560Other Reviews 561Tracking Changes to Closed Accounting Periods 561Using the Audit Trail Report 562Using the Credit Card Audit Trail Report 563Reporting on Voided/Deleted Transactions 565Viewing the Transactions List by Date Report 566Troubleshooting Open Balance Equity Account 56816 Sharing QuickBooks Data with Your Accountant 571Overview 571Benefits for the Business Owner 571Benefits for the Accountant 572QuickBooks File Types 572Choosing a Method to Share Data 573Data Sharing for the Business Owner 577Reviewing Your QuickBooks Data 578Creating an Accountant's Copy of Your Data 578What the Business Owner Can and Cannot Do 583Importing Your Accountant's Changes 584Canceling an Accountant's Copy 589Data Sharing for the Accountant 590File Manager 2013 590Creating an External Accountant User Type 591Preparing Your Client for Data Exchange 592Receiving an Accountant's Copy File 592What the Accountant Can Do 596What the Accountant Cannot Do 599Returning the Accountant's Copy Change File to the Client 599What to Request from the Client When the Import Is Complete 602Converting the Accountant's Copy to a Regular Company File 603Other Methods of Sharing Data 603Send General Journal Entries 603Batch Enter Transactions 60617 Managing Your QuickBooks Database 609The QuickBooks Database 609System Requirements 610Express Installation of QuickBooks 612Installing QuickBooks for Multiuser Mode 612The QuickBooks Database Server Manager 613Windows Permissions Required for QuickBooks 615Using the QuickBooks Connection Diagnostic Tool 616Keeping Your Software Current 617Upgrading Your QuickBooks Version 617Installing a QuickBooks Maintenance Release 618Protecting Your QuickBooks Database 619Creating a QuickBooks Backup 619Protecting the QuickBooks Operating Environment 622Using Intuit Data Protect Online Backup Service 625Monitoring Your QuickBooks Database 626The Product Information Dialog Box 626Using the Verify Data Utility 628Monitoring QuickBooks Performance Using Windows Task Manager 629QuickBooks Database Corruption 630Common Causes of Corruption 630Signs of Data Corruption 630The QBWin.log File 631Repairing List Corruptions 634Reducing Database File Fragments 634Rebuilding Your Company File 636Using the QuickBooks File Doctor 636Resolving QuickBooks Program File Corruption Issues 63818 Using Other Planning and Management Tools 639Planning and Budgeting 639Create a Budget 639Edit a Budget 641Print Budget Reports 643Delete a Budget 644QuickBooks Loan Manager 645Information to Collect 645Getting QuickBooks Ready 646Setting Up a New Loan 646Setting Up a Loan Payment 647Using the Year-End Guide 649Synchronizing QuickBooks Lists with Microsoft Outlook 650Using the QuickBooks Timer 654Installing the QuickBooks Timer 654Preparing the Timer for Activities 655Tracking Time with the Timer 655Exporting Timer Activities 656Importing Timer Activities into QuickBooks 657A Client Data Review 659B QuickBooks Statement Writer 717C QuickBooks Enterprise Solutions Inventory Features 747D QuickBooks Shortcuts 785TOC, 1/31/2031, 9780789750396
