book

QuickBooks 2014: The Missing Manual

Name: QuickBooks 2014: The Missing Manual
Author: Bonnie Biafore
ISBN: 9781449341756

by Bonnie Biafore

October 2013

Intermediate to advanced

808 pages

27h 8m

English

O'Reilly Media, Inc.

Read now

Unlock full access

QuickBooks 2014: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
About the AuthorAbout the Creative TeamAcknowledgementsThe Missing Manual Series
Introduction
What’s New in QuickBooks 2014When QuickBooks May Not Be the AnswerChoosing the Right EditionThe QuickBooks Premier ChoicesAccounting Basics: The Important StuffAbout This BookAbout the OutlineThe Very BasicsAbout→These→ArrowsAbout the Online ResourcesMissing CDRegistrationFeedbackErrataSafari® Books Online
1. Setting Up QuickBooks
1. Creating a Company File
Opening QuickBooksBefore You Create a Company FileChoosing a Start DateAccount Balances and TransactionsCreating a Company FileOptions for Creating a Company FileUsing Express StartCompany InformationBusiness Contact InformationCreating Your Company FileUsing the EasyStep InterviewCreating Your Company FileCustomizing Your Company FileBeginning to Use QuickBooksStart WorkingReopening the QuickBooks Setup Dialog BoxConverting from Another Program to QuickBooksConverting from Quicken Home & BusinessCleaning up your Quicken fileConverting your Quicken fileFine-Tuning Your Converted Quicken DataConverting from QuickBooks for MacintoshConverting from a Non-Intuit ProgramOpening an Existing Company FileOpening a Recently Opened Company FileOpening Any Company FileOpening a Portable Company FileModifying Company Info
2. Getting Around in QuickBooks
Menus and the Icon BarsSwitching among Open WindowsSupermax ViewThe Home PageVendorsCustomersEmployeesCompany FeaturesBankingThe Company Snapshot
3. Setting Up a Chart of Accounts
Acquiring a Chart of AccountsImporting a Chart of AccountsPlanning the Chart of AccountsDo You Need Another Account?Naming and Numbering AccountsOrganizing Account NumbersViewing Account NumbersChoosing Good Account NamesCreating Accounts and SubaccountsCreating an AccountWorking with AccountsModifying AccountsHiding AccountsDeleting AccountsMerging Accounts
4. Setting Up Customers, Jobs, and Vendors
Creating Customers in QuickBooksCreating a New CustomerEntering Contact InformationEntering Payment InformationSpecifying Sales Tax InformationSpecifying Additional Customer InformationAdding More Customer ContactsCreating Jobs in QuickBooksCreating a New JobSetting Up VendorsCreating a VendorEntering Address InformationPayment SettingsSales Tax SettingsFilling in Expense Accounts AutomaticallyAdditional InfoWorking with Customers, Jobs, and VendorsModifying Customer, Job, and Vendor InformationCategorizing Customers, Jobs, and VendorsUnderstanding Customer, Job, and Vendor TypesCreating a Vendor, Customer, or Job TypeHiding RecordsDeleting RecordsMerging RecordsManaging Leads
5. Setting Up Items
What Items DoWhen You Don’t Need ItemsShould You Track Inventory with Items?Planning Your ItemsGeneric or Specific?Naming ItemsSubitemsCreating ItemsService ItemsService Items Without Associated CostsService Items with Associated CostsProduct ItemsNon-Inventory Part FieldsOther Types of ItemsOther ChargeSubtotalGroupDiscountPaymentWorking with ItemsModifying ItemsHiding ItemsDeleting Items

6. Data Entry Shortcuts for Lists
Adding and Editing Multiple RecordsSelecting a List to Work WithCustomizing the Table’s ColumnsDisplaying the Records You WantAdding or Editing List EntriesEntering Data Directly in the TableCopying and Pasting Values from ExcelSaving ChangesCorrecting ErrorsImporting Customer, Vendor, and Item InformationImporting with the Excel Import Wizard TemplatesImporting Data From Your Own Excel File
7. Setting Up Other QuickBooks Lists
Categorizing with ClassesTurning on Class TrackingSetting Up ClassesPrice LevelsCreating a Price LevelApplying Price LevelsCustomer and Vendor Profile ListsSales Rep ListCustomer Type ListVendor Type ListJob Type ListTerms ListSetting Up Terms Using Elapsed TimeSetting Up Date Driven TermsCustomer Message ListPayment Method ListShip Via ListVehicle ListFixed Asset ItemsManaging ListsCreating EntriesEditing EntriesHiding EntriesDeleting EntriesFinding List Entries in TransactionsSorting ListsPrinting ListsBlasting Out a Quick ListCustomizing a Printed List
2. 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 QuickBooksFilling out 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 BillsRecording a Deposit to a VendorHandling 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 AccountPaying Selected BillsWriting Checks Without Entering BillsUsing the Write Checks WindowAdding Checks to an Account RegisterProducing ChecksWriting Checks by HandSetting Up QuickBooks to Print ChecksPrinting ChecksPaying Using Other Payment MethodsPaying with Credit CardsPaying with a Debit CardPaying with PayPalPaying with CashRecording ATM Withdrawals and Deposits to Petty CashRecording Purchases Made with Petty CashRecording Vendor Refunds and CreditsRunning Expense-Related ReportsA/P Aging and Vendor Balance Reports
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 ItemsModifying Line ItemsApplying Subtotals, Discounts, and Percentage ChargesAdding a Message to the CustomerAdding an Online Payment LinkSigning Up for Intuit PaymentNetworkSetting Online Payment Link PreferencesChoosing How to Send the InvoiceAdding a Memo to YourselfCreating Batch InvoicesBefore You Create Your First Batch InvoiceSetting Up a Batch InvoiceDeposits, Down Payments, and RetainersSetting Up QuickBooks for PrepaymentsRecording PrepaymentsApplying a Deposit, Down Payment, or RetainerRefunding PrepaymentsInvoicing for Billable Time and CostsSetting Up Invoicing for Time and CostsAdding Billable Time and Costs to InvoicesUsing Invoice for Time & ExpensesInvoicing One Customer or Job for Time and ExpensesCreating a Batch of Time and Expenses InvoicesSelecting 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 Customer Refunds and CreditsCreating a Credit Memo from an InvoiceCreating Credit MemosCreating Refund ChecksApplying Credits to Existing InvoicesApplying Credits to New InvoicesModifying InvoicesEditing InvoicesVoiding and Deleting Invoices
11. Producing Statements
Generating StatementsCreating Statement ChargesGenerating Customer StatementsChoosing the Date RangeSelecting CustomersSetting Additional OptionsPreviewing StatementsGenerating StatementsEmailing StatementsPrinting Statements
12. Transaction Timesavers
Printing FormsSetting Print OptionsAligning Forms and PaperChoosing a Print MethodPrinting One FormPrinting in BatchesPrinting Mailing and Shipping LabelsPrinting Packing SlipsEmailing FormsChoosing a Send MethodEmailing One FormEmailing in BatchesMemorizing TransactionsCreating a Memorized TransactionUsing a Memorized TransactionRecording a Transaction When You’re RemindedRecording an Occasional TransactionRecording a Transaction AutomaticallyEditing a Memorized TransactionCreating Memorized Groups of TransactionsFinding TransactionsSearching with QuickBooks’ CentersFinding ItemsUsing QuickBooks SearchUsing the Find FeatureFinding Made SimpleAdvanced Find MethodsUsing Search Results
13. Managing Accounts Receivable
Receivables AgingViewing Receivables with Income TrackerGetting a High-level View with the Company SnapshotViewing Receivables Detail in the Customer CenterAccounts Receivable Aging ReportsSeeing What Customers Owe with ReportsReceiving Payments for Invoiced IncomeApplying Credits to InvoicesDiscounting for Early PaymentCorrecting Misapplied Customer PaymentsWrong Invoice, Right Customer or JobWrong Invoice, Wrong CustomerApplying 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. Bank Accounts and Credit Cards
Entering Transactions in an Account RegisterOpening a Register WindowCreating a Transaction in an Account RegisterHandling Bounced ChecksManaging Bounced Checks You WroteUsing the Record Bounced Check FeatureHandling Customer’s Bounced Checks on Your OwnItem for Removing the Bounced-Check Amount from Your Bank AccountItems for Bounced-Check Service ChargesRecording 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 DiscrepanciesUsing the Discrepancy Report to Find Problem TransactionsRe-Reconciling Corrected TransactionsOther 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 Payments
15. Doing Payroll
Getting Started with QuickBooks PayrollWhat You Need from the GovernmentEmployee-Related Forms You NeedPayroll Decisions You Need to MakeIntuit Payroll ServicesSigning Up for an Intuit Payroll ServiceSetting Up Payroll in QuickBooksSetting Up Compensation and BenefitsSetting Up EmployeesSetting Employee DefaultsCreating Employee RecordsSetting Up Payroll TaxesEntering Historical PayrollFine-Tuning Payroll ItemsTracking Payroll in More DetailAdding and Editing Payroll ItemsRunning PayrollPrinting Paychecks and Pay StubsPaying Payroll LiabilitiesPreparing Payroll Tax FormsRunning Payroll ReportsRecording Transactions from a Payroll ServicePaying YourselfTaking a DrawReclassifying Shareholder’s Distribution to SalaryReclassifying Payroll Withholdings
16. Making Journal Entries
Balancing Debit and Credit AmountsSome Reasons to Use Journal EntriesCreating Journal EntriesChecking Journal EntriesReclassifications and CorrectionsReclassifying AccountsReassigning JobsRecording Depreciation with Journal EntriesRecording Owners’ ContributionsRecording Initial Noncash ContributionsRecording Home-Office Expenses
17. Performing Year-End Tasks
Checking for ProblemsViewing Your Trial BalanceGenerating Financial ReportsThe 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 ReportsGenerating Tax ReportsSharing a Company File with Your AccountantCreating an Accountant’s Review CopyMerging 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
3. Managing Your Business
18. Keeping Track of Financial Tasks
Tracking To-DosCreating a To-DoEditing a To-DoViewing To-DosAdding NotesRemindersYour Financial Calendar
19. Managing QuickBooks Files
Switching Between Multi- and Single-User ModeBacking Up FilesChoosing Standard Backup SettingsBacking Up ManuallyAutomated 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 UtilityCondensing DataRunning the Condense Data UtilityCleaning Up after Deleting Files
20. Managing Inventory
Following the Inventory Money TrailSetting Up Inventory ItemsTurning on QuickBooks InventoryCreating Inventory ItemsPurchasing InventoryCreating Purchase OrdersReceiving Inventory and Bills SimultaneouslyReceiving Inventory before the BillSelling InventoryRunning Inventory ReportsPurchases ReportsHow Much Is Inventory Worth?Inventory Valuation Summary ReportInventory Valuation Detail ReportInventory Stock StatusViewing One Inventory ItemWorking with the Inventory CenterPerforming a Physical InventoryAdjusting Inventory in QuickBooksAdjusting QuantitiesAdjusting Quantities and Values
21. Working with Sales Tax
Setting Up Sales TaxTurning on QuickBooks Sales TaxOther Sales Tax PreferencesSetting Up Sales Tax FeaturesSales Tax CodesAssigning Tax Codes to CustomersAssigning Tax Codes to ItemsCreating Additional Sales Tax CodesSales Tax ItemsProducing Reports of the Sales Tax You OwePaying Sales Tax
22. Budgeting and Planning
Types of BudgetsWays to Build BudgetsCreating Budgets in QuickBooksCreating Customer:Job or Class BudgetsFilling in Budget ValuesCopying Across ColumnsAdjust Row AmountsCreating and Copying Budgets with ExcelExporting Your BudgetWorking with a Budget in ExcelImporting a Budget into QuickBooksRunning Budget ReportsThe Budget Overview ReportReport LayoutsBudget vs. Actual ReportProfit & Loss Budget Performance ReportBudget vs. Actual Graph
23. Tracking Finances with Reports and Graphs
Finding the Right ReportsReviewing Reports in the Report CenterWorking with Reports in the Report CenterFinding Frequently Used ReportsRunning ReportsPrinting and Saving ReportsSaving Reports as 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 Report TemplateImporting Report Templates
4. QuickBooks Power
24. Banking Online with QuickBooks
Setting Up Your Accounts for Online ServicesApplying for Online ServicesActivating Online Services for Your QuickBooks AccountExchanging Data with Your BankQuickBooks’ Online Banking ModesDownloading Statements with Web ConnectCreating Online Items for Direct ConnectionsPaying Bills OnlineSending a Message to Your BankTransferring Funds Between AccountsBanking Online Using Express ModeSending and Receiving TransactionsMatching TransactionsMatching Unmatched TransactionsMatching DepositsMatching Checks and ExpensesAdding Multiple TransactionsDeleting Downloaded TransactionsBanking Online Using Classic ModeSending and Receiving ItemsWorking with Online ItemsMatching TransactionsAdding Multiple TransactionsDeleting Downloaded Transactions
25. Configuring Preferences to Fit Your Company
Preferences: The BasicsAccountingBillsCalendarCheckingChoosing the Bank Accounts You UseSettings for Company ChecksChoosing Company-Wide Payroll AccountsSelecting a Bank Feeds ModeDesktop ViewWindow PreferencesPreferences for Saving the DesktopCustomizing the Home PageFinance ChargeGeneralTuning QuickBooks to Your LikingCompany-Wide General PreferencesIntegrated ApplicationsItems & InventoryJobs & EstimatesMultiple CurrenciesPaymentsPayroll & EmployeesRemindersReports and GraphsPreferences for the Reports You GenerateCompany-Wide Report PreferencesSales & CustomersSales TaxSearchSend FormsSetting Your Send PreferencesCustomizing MessagesService ConnectionSpellingTax: 1099Time & Expenses
26. Integrating QuickBooks with Other Programs
Mail Merge to a Word DocumentCreating Letters and Envelopes in QuickBooksSynchronizing ContactsUsing QuickBooks Contact Sync for OutlookWorking with Other AppsFinding Add-on AppsSetting Up an Integrated ApplicationExporting QuickBooks DataExporting Lists and AddressesExporting Lists to a Text FileExporting AddressesExporting ReportsCustomized Exports Using Contact List ReportsImporting Data from Other ProgramsImporting a Delimited File
27. Customizing QuickBooks
Customizing the Home PageTurning Customer and Vendor Icons On and OffTurning Related Preferences On and OffAccount BalancesFast Access to Favorite FeaturesBuilding Your Favorites MenuCustomizing the Icon BarAdding and Removing IconsAdding Windows or Reports to the Icon BarChanging an Icon’s AppearanceChanging the Order of IconsCustomizing the Company SnapshotCustomizing FormsStarting with an Existing Template in QuickBooksBasic CustomizationAdding a LogoApplying a Color SchemeChanging FontsIncluding Basic Company and Transaction InformationAdditional CustomizationManaging TemplatesCopying a TemplateDeleting or Hiding a TemplateExchanging Templates Between Company FilesWorking with Form DesignsCreating a Form DesignManaging Form Designs
28. 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 Rights
5. Appendixes
A. Installing QuickBooks
Before You InstallInstalling QuickBooksInstalling QuickBooks for the First TimeInstalling or Upgrading to a New Version of QuickBooksRegistering QuickBooksSetting Up QuickBooks on a NetworkWhere to Store Your Company FilesStoring Company Files on a Network
B. Help, Support, and Other Resources
QuickBooks HelpIntuit CommunityAccessing the Community within QuickBooksOther Kinds of HelpOther Help ResourcesQuickBooks Training
Index
About the Author
Copyright

Overview

How can you make your bookkeeping workflow smoother and faster? Simple. With this Missing Manual, you’re in control of QuickBooks 2014 for Windows. You get step-by-step instructions on how and when to use specific features, along with basic accounting advice to guide you through the learning process. That’s why this book is the Official Intuit Guide to QuickBooks 2014.

The important stuff you need to know:

Get started. Quickly set up your accounts, customers, jobs, and invoice items.
Learn new features. Get up to speed on the Bank Feed Center, Income Tracker, and other improvements.
Follow the money. Track everything from billable time and expenses to income and profit.
Spend less time on bookkeeping. Use QuickBooks to create and reuse bills, invoices, sales receipts, and timesheets.
Keep your company financially fit. Examine budgets and actual spending, income, inventory, assets, and liabilities.
Find key info fast. Rely on QuickBooks’ Search and Find features, as well as the Vendor, Customer, Inventory, and Employee Centers.

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: 9781449341749Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills