book

QuickBooks 2010: The Missing Manual

Name: QuickBooks 2010: The Missing Manual
Author: Bonnie Biafore
ISBN: 9780596804022

by Bonnie Biafore

October 2009

Beginner to intermediate

700 pages

22h 19m

English

O'Reilly Media, Inc.

Read now

Unlock full access

A Note Regarding Supplemental Files
Missing Credits
About the AuthorAbout the Creative TeamAcknowledgmentsThe Missing Manual Series
Introduction
What’s New in QuickBooks 2010When QuickBooks May Not Be the AnswerChoosing the Right QuickBooks ProductThe QuickBooks Premier ChoicesAccounting Basics—The Important StuffAbout This BookAbout the OutlineThe Very BasicsAbout → These → ArrowsAbout MissingManuals.comSafari® Books Online
I. Getting Started
1. Creating a Company File
Opening QuickBooksAbout the EasyStep InterviewBefore You Create Your Company FileStart DateAccount BalancesOther Important InformationStarting the EasyStep InterviewCompany InformationCreating Your Company FileCustomizing Your Company FileBeginning to Use QuickBooksModifying Company InformationWhat’s Next?Opening an Existing Company FileOpening a Recently Opened Company FileOpening Any Company FileRestoring a Backup FileOpening a Portable Company FileConverting from Another Program to QuickBooksConverting from Quicken Home & BusinessConverting from a Non-Intuit Program
2. Getting Around in QuickBooks
Getting Around the QuickBooks Home PageVendorsCustomersEmployeesCompany FeaturesBankingThe QuickBooks CoachThe Company SnapshotUsing Menus and the Icon BarSwitching Between Open Windows
3. Setting Up a Chart of Accounts
Acquiring a Chart of AccountsUsing a QuickBooks Chart of AccountsImporting a Chart of AccountsImporting a Downloaded Chart of AccountsAccount Naming and NumberingSetting Up Account NumbersStandardizing Account NamesCreating Accounts and SubaccountsCreating an AccountViewing Account Names and NumbersModifying AccountsHiding and Deleting AccountsHiding AccountsDeleting AccountsMerging Accounts
4. Setting Up Customers and Jobs
Before You Create Customers and JobsCategorizing Customers and JobsUnderstanding customer typesCreating a customer typeCategorizing jobsCreating Customers in QuickBooksCreating a New CustomerEntering address informationSpecifying additional customer informationDesignating payment informationCustomer Data Entry ShortcutsImporting Customer InformationExporting Customer InformationExporting to ExcelCustomized exports using the Contact List reportExporting a text fileAdding and Editing Multiple Customer RecordsSelecting the list to work withAdding or editing list entriesSaving changesCreating Jobs in QuickBooksCreating a New JobModifying Customer and Job InformationAdding Notes About CustomersMerging Customer RecordsHiding and Deleting CustomersDeleting CustomersHiding and Restoring Customers
5. Setting Up Invoice Items
What Items DoWhen You Don’t Need ItemsShould You Track Inventory with Items?Planning Your ItemsGeneric or Specific?Naming ItemsSubitemsCreating ItemsService ItemsProduct ItemsInventory Part FieldsNon-Inventory Part FieldsOther Types of ItemsOther ChargeSubtotalGroupDiscountPaymentSetting Up Sales TaxSales Tax CodesAssigning tax codes to customersAssigning tax codes to itemsCreating additional sales tax codesSales Tax ItemsModifying ItemsHiding and Deleting ItemsHiding ItemsDeleting Items
6. Setting Up Other QuickBooks Lists
The Vendor ListEntering Address InformationAdditional InfoImporting Vendor InformationFilling in Expense Accounts AutomaticallyCategorizing with ClassesPrice LevelsCreating a Price LevelApplying a Price LevelCustomer and Vendor Profile ListsSales Rep ListCustomer Type ListVendor Type ListJob Type ListTerms ListSetting up terms using elapsed timeSetting up date-driven termsCustomer MessagePayment Method ListShip Via ListVehicle ListFixed Asset ItemsCreating and Editing List EntriesCreating EntriesEditing EntriesMerging List EntriesHiding and Deleting List EntriesHiding EntriesDeleting EntriesFinding List Entries in TransactionsSorting ListsPrinting ListsBlasting Out a Quick ListCustomizing a Printed List

7. Managing QuickBooks Files
Switching Between Multi-User and Single-User ModeBacking Up FilesChoosing Standard Settings for Your BackupsBacking Up to Your Computer Right AwayAutomated QuickBooks BackupsSetting up automatic backupsScheduling backups for a single company fileRestoring BackupsSending Company Files to OthersCreating a Portable Company FileOpening a Portable Company FileVerifying Your QuickBooks DataRunning the Verify Data UtilityReviewing ProblemsRunning the Rebuild Data UtilityCleaning Up DataRunning the Clean Up Company File ToolCleaning Up After Deleting Files
II. Bookkeeping
8. Tracking Time and Mileage
Setting Up Time TrackingTurning on Time TrackingSetting Up the People Who Track TimeSetting Up Items and Customers for Time TrackingEntering Time in TimesheetsFilling in Weekly TimesheetsEntering Time for One ActivityRunning Time ReportsTracking MileageAdding a VehicleSetting the Mileage RateRecording Mileage DrivenGenerating Mileage Reports
9. Paying for Expenses
When to Pay ExpensesEntering BillsAutomating Recurring BillsMemorizing a BillUsing a Memorized BillCreating Memorized Groups of BillsPurchasing InventoryCreating Purchase OrdersReceiving Inventory and Bills SimultaneouslyReceiving Inventory Before the BillHandling Reimbursable ExpensesSetting Up Reimbursements As IncomeRecording Reimbursable ExpensesPaying Your BillsSelecting Bills to PayModifying Payment AmountsApplying Discounts and Credits to PaymentsApplying discounts manuallyApplying credits manuallySetting the Payment Method and AccountPay Selected BillsProducing ChecksWriting Checks by HandSetting Up QuickBooks to Print ChecksPrinting ChecksWriting Checks Without Entering BillsUsing the Write Checks WindowAdding Checks to an Account RegisterPaying with CashPaying with Credit CardsRecording Vendor CreditsRunning Expense-Related ReportsA/P Aging and Vendor Balance ReportsPurchases ReportsPaying Sales TaxSales Tax Payment PreferencesProducing Reports of the Sales Tax You OweRemitting Sales Taxes
10. Invoicing
Choosing the Right Type of FormSales ReceiptsStatementsInvoicesSales Forms and AccountsCreating InvoicesCreating an InvoiceFilling in Invoice Header FieldsChoosing the customer or jobChoosing an invoice templateThe other header fieldsEntering Invoice Line ItemsInserting and deleting line itemsApplying Subtotals, Discounts, and Percentage ChargesAdding a Message to the CustomerChoosing How to Send the InvoiceAdding a Memo to YourselfInvoicing for Billable Time and CostsSetting Up Invoicing for Time and CostAdding Billable Time and Costs to InvoicesUsing the Invoice for Time and Expenses CommandSelecting Billable Time and CostsChecking for Unbilled CostsInvoicing for Backordered ProductsUsing Pending Invoices for BackordersUsing Sales Orders for BackordersEstimating JobsCreating an EstimateCreating Multiple EstimatesCreating an Invoice from an EstimateComparing Estimates to ActualsCreating Progress InvoicesProgress Invoicing OptionsFine-Tuning a Progress InvoiceHandling Refunds and CreditsCreating Credit MemosCreating Refund ChecksApplying Credits to Existing InvoicesApplying Credits to New InvoicesEditing InvoicesVoiding and Deleting Invoices
11. Producing Statements
Producing StatementsCreating Statement ChargesGenerating Customer StatementsChoosing the date rangeSelecting customersSetting printing optionsPreviewing StatementsGenerating Statements
12. Transaction Timesavers
Printing Sales FormsSetting Print OptionsAligning Forms and PaperChoosing a Print MethodPrinting One FormPrinting in BatchesPrinting Mailing and Shipping LabelsPrinting Packing SlipsEmailing Sales FormsChoosing a Send MethodEmailing One FormEmailing in BatchesMemorized TransactionsUsing a Memorized TransactionEditing a Memorized TransactionFinding TransactionsSearching with Google DesktopSearching with QuickBooks CentersFinding ItemsUsing the Find CommandFinding made simpleAdvanced find methodsUsing search results
13. Managing Accounts Receivable
The Aging of ReceivablesAccounts Receivable Aging ReportsCustomer & Job ReportsReceiving Payments for Invoiced IncomeApplying Credits to InvoicesDiscounting for Early PaymentDeposits, Down Payments, and RetainersSetting Up QuickBooks for PrepaymentsRecording PrepaymentsApplying a Deposit, Down Payment, or Retainer to an InvoiceRefunding PrepaymentsApplying Finance ChargesFinance Charge PreferencesAssessing Finance Charges on Overdue BalancesCash SalesCreating Sales ReceiptsEditing Sales ReceiptsVoiding and Deleting Sales ReceiptsMemorizing a Batch Sales TransactionReconciling Excess and Short CashMaking DepositsChoosing Payments to DepositRecording DepositsDepositing Money from Merchant Card Accounts
14. Doing Payroll
Adding Payroll Transactions from an Outside ServiceChoosing a Payroll ServiceApplying for a Payroll ServiceSetting Up PayrollSetting Up Compensation and BenefitsSetting Up EmployeesSetting employee defaultsCreating employee recordsSetting Up Payroll TaxesEntering Historical PayrollRunning PayrollPrinting Paychecks and Pay StubsPaying Payroll TaxesPreparing Payroll Tax Forms
15. Bank Accounts, Credit Cards, and Petty Cash
Entering Transactions in an Account RegisterOpening a Register WindowCreating a Transaction in an Account RegisterHandling Bounced ChecksSetting Up QuickBooks to Handle Bounced ChecksBounced check reimbursement itemService charges for bounced checksRecording Bank ChargesRe-invoicing for Bounced ChecksTransferring FundsReconciling AccountsPreparing for the First ReconciliationPreparing for Every ReconciliationStarting a ReconciliationReconciling TransactionsReconciliation ReportsModifying Transactions During ReconciliationStopping and Restarting a ReconciliationCorrecting DiscrepanciesThe Discrepancy ReportOther ways to find discrepanciesUndoing the Last ReconciliationWhen Your Bank Makes a MistakeManaging LoansSetting Up a LoanAdding a Loan to Loan ManagerBasic setupPayment informationInterest rate informationModifying Loan TermsSetting Up PaymentsWhat-If ScenariosTracking Petty CashRecording ATM Withdrawals and Deposits to Petty CashRecording Purchases Made with Petty Cash
16. Making Journal Entries
Balancing Debit and Credit AmountsSome Reasons to Use Journal EntriesCreating General Journal EntriesFilling in General Journal Entry FieldsChecking General Journal EntriesReclassifications and CorrectionsReclassifying AccountsReassigning JobsRecording Depreciation with Journal EntriesRecording Owners’ Contributions
17. Generating Financial Statements
The Profit & Loss ReportUnderstanding the Profit & Loss ReportGenerating a Profit & Loss ReportOther Profit & Loss ReportsThe Balance SheetUnderstanding the Balance SheetGenerating a Balance Sheet ReportThe Statement of Cash FlowsUnderstanding the Statement of Cash FlowsGenerating a Statement of Cash FlowsOther Helpful Financial Reports
18. Performing End-of-Year Tasks
Checking for ProblemsViewing the Trial BalanceGenerating Year-End Financial ReportsGenerating Tax ReportsSharing the Company File with Your AccountantCreating an Accountant’s Review CopySending a Copy Directly to Your AccountantMerging Accountant Changes into Your Company FileCanceling an Accountant’s Review CopySetting Up an External Accountant User1099sGenerating 1099 ReportsPrinting 1099-MISC FormsClosing the Books for the Year
III. Managing Your Business
19. Managing Inventory
The QuickBooks Inventory ProcessSetting Up Inventory ItemsPurchasing and Selling InventoryRunning Inventory ReportsInventory Valuation: How Much Is Inventory Worth?Inventory Valuation Summary reportInventory Valuation Detail reportInventory Stock StatusViewing One Inventory ItemPerforming a Physical InventoryAdjusting Inventory in QuickBooksAdjusting QuantitiesAdjusting Quantities and Values
20. Budgeting and Planning
Types of BudgetsWays to Build BudgetsCreating Budgets in QuickBooksFilling in Budget ValuesCopy Across ColumnsAdjust Row AmountsCreating Additional Customer:Job or Class BudgetsCopying Budgets and Creating What-if BudgetsRunning Budget ReportsThe Budget Overview ReportReport layoutsBudget vs. Actual ReportProfit & Loss Budget Performance ReportBudget vs. Actual Graph
21. Working with QuickBooks Reports
Finding the Right ReportsReviewing Reports in the Report CenterWorking with Reports in the Report CenterFinding Frequently-used ReportsRunning ReportsPrinting and Saving ReportsSaving Reports to FilesCustomizing ReportsDate RangesSubtotalsCustomizing the Columns in ReportsAdding and removing columns in summary reportsAdding or removing columns in detail reportsResizing and moving columnsSorting ReportsFiltering ReportsReport Headers and FootersFonts and NumbersMemorizing ReportsSwapping Reports Between Company FilesExporting a ReportImporting Report Templates
IV. QuickBooks Power
22. Online Banking Services
Setting Up Your Internet ConnectionSetting Up Your Accounts for Online ServicesApplying for Online ServicesActivating Online Services for Your QuickBooks AccountAn Introduction to Exchanging Data with Your BankQuickBooks Online Banking ModesDownloading Statements with WebConnectCreating Online Items for Direct ConnectionsPaying bills onlineSending a message to your bankTransferring funds between accountsOnline Banking Using Side-by-side ModeSending and ReceivingMatching TransactionsMatching Unmatched TransactionsMatching depositsMatching checks and expensesAdding Multiple TransactionsDeleting Downloaded TransactionsOnline Banking Using Register ModeSending and ReceivingWorking with Online ItemsMatching TransactionsUnmatched checksUnmatched depositsBank chargesAdding Multiple TransactionsDeleting Downloaded Transactions
23. Configuring Preferences to Fit Your Company
An Introduction to PreferencesAccountingBillsCheckingChoosing the Bank Accounts You UseSetting the Way Company Checks WorkChoosing Company-Wide Payroll AccountsChoosing the Online Banking ModeDesktop ViewWindow PreferencesPreferences for Saving the DesktopChoosing a Color SchemeSetting Up the QuickBooks Home PageFinance ChargeGeneralTuning QuickBooks to Your LikingCompany-Wide General PreferencesIntegrated ApplicationsItems & InventoryJobs & EstimatesMultiple CurrenciesPaymentsPayroll & EmployeesRemindersReminders on the My Preferences TabReminders for EveryoneReports and GraphsPreferences for the Reports You GeneratePreferences That Apply to Every Company ReportSales & CustomersSales TaxSend FormsSpellingTax: 1099Time & Expenses
24. Integrating QuickBooks with Other Programs
Mail Merge to a Word DocumentCreating Letters and Envelopes in QuickBooksSynchronizing ContactsUsing QuickBooks Contact Sync for OutlookSetting Up an Integrated ApplicationExporting QuickBooks DataExporting Lists and AddressesExporting lists to a text fileExporting addressesExporting ReportsImporting Data from Other ProgramsImporting an Excel SpreadsheetImporting a Delimited File
25. Customizing QuickBooks
Customizing the DesktopCustomizing the Home PageFast Access to Favorite CommandsBuilding Your Favorites MenuCustomizing the Icon BarAdding and removing iconsAdding windows to the icon barChanging icon appearanceChanging the order of iconsCustomizing the Company SnapshotCustomizing FormsWorking with Form DesignsCreating a form designManaging form designsEditing an Existing Form in QuickBooksBasic CustomizationAdding a logoApplying a color schemeChanging fontsIncluding basic company and transaction informationAdditional CustomizationManaging TemplatesCopying a TemplateDeleting a TemplateHiding a Template (Making It Inactive)Exchanging Templates Between Company Files
26. Keeping Your QuickBooks Data Secure
Setting Up the AdministratorAssigning the Administrator User Name and PasswordResetting the Administrator PasswordComplying with Credit Card Security RegulationsCreating QuickBooks UsersAdding New UsersResetting a User PasswordRestricting Access to Features and DataWhat the Access Areas RepresentSetting Access RightsAudit Trails
V. Appendixes
A. Installing QuickBooks
Before You InstallInstalling QuickBooksRunning QuickBooks for the First TimeRegistering QuickBooksSetting Up QuickBooks on a NetworkWhere to Store Your Company FilesStoring company files on a network
B. Help, Support, and Other Resources
QuickBooks HelpLive CommunityOther Kinds of HelpThe QuickBooks CommunityOther Help ResourcesQuickBooks Training
Index
About the Author
Colophon
Copyright

Content preview from QuickBooks 2010: The Missing Manual

Colophon

Rachel Monaghan provided quality control for QuickBooks 2010: The Missing Manual.

The cover of this book is based on a series design originally created by David Freedman and modified by Mike Kohnke, Karen Montgomery, and Fitch (www.fitch.com). Back cover deisgn, dog illustration, and color selection by Fitch.

David Futato designed the interior layout, based on a series design by Phil Simpson. This book was converted by Abby Fox to FrameMaker 5.5.6. The text font is Adobe Minion; the heading font is Adobe Formata Condensed; and the code font is LucasFont’s TheSansMonoCondensed. The illustrations that appear in the book were produced by Robert Romano using Adobe Photoshop CS4 and Illustrator CS4.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780596809379Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

QuickBooks 2010: The Missing Manual

by Bonnie Biafore

Colophon

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.