book

QuickBooks 2016: The Missing Manual

Name: QuickBooks 2016: The Missing Manual
Author: Bonnie Biafore
ISBN: 9781491935613

by Bonnie Biafore

October 2015

Intermediate to advanced

822 pages

27h 36m

English

O'Reilly Media, Inc.

Read now

Unlock full access

QuickBooks 2016: 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 2016When 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
One. Setting Up QuickBooks
1. Creating a Company File
Opening QuickBooksChoosing a Start DateCreating a Company FileOptions for Creating a Company FileUsing QuickBooks SetupUsing the EasyStep InterviewCreating Your Company FileCustomizing Your Company FileAdding Details to Your Company FileConverting from Another Program to QuickBooksConverting from Quicken Home & BusinessCleaning Up Your Quicken FileConverting Your Quicken FileFine-Tuning Your Converted Quicken DataConverting from QuickBooks for MacConverting 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 BarThe Home PageThe Insights TabWorking with WindowsSwitching among Open WindowsSupermax ViewTransaction Window RibbonsResizing Drop-Down Lists and Columns
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
Working with the Customer CenterCreating Customers in QuickBooksCreating a New CustomerEntering Contact InformationEntering Payment InformationSpecifying Sales Tax InformationSpecifying Additional Customer InformationAdding More Customer ContactsCreating Jobs in QuickBooksCreating a New JobWorking with the Vendor CenterCreating Vendors in QuickBooksCreating a VendorAddress InfoPayment SettingsTax SettingsAccount SettingsAdditional 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 RecordsCustomizing 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
Two. 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 ExpensesViewing Payables with Bill TrackerEntering BillsEntering Bills for Services and Non-Inventory ItemsRecording 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 CreditsRecording Vendor RefundsRecording Vendor CreditsRunning Expense-Related ReportsA/P Aging and Vendor Balance ReportsReports about PurchasesThe Insights Tab
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 a Link to Pay OnlineAdding a Memo to YourselfChoosing How to Send the InvoiceCreating 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 & ExpensesSelecting Billable Time and CostsCreating a Batch of Time and Expenses InvoicesChecking for Unbilled CostsInvoicing for Backordered ProductsUsing Pending Invoices for BackordersUsing Sales Orders for BackordersSelling Products on ConsignmentConsigning Products to Someone Else to SellWhen You Deliver Products to ConsigneesWhen Consignees Sell Your StuffSelling Consignment Goods Received from Someone ElseAdding Consignment Items to Your InventoryRecording Consignment SalesPaying ConsignorsEstimating 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 Invoices When You Receive PaymentsDiscounting 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 Customers’ 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 TransactionsModifying Transactions During ReconciliationStopping and Restarting a ReconciliationReconciliation ReportsCorrecting 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 PayrollWhat You Need from the GovernmentEmployee-Related Forms You NeedPayroll Decisions You Need to MakeIntuit Payroll ServicesRecording Transactions from a Payroll ServicePaying YourselfTaking a DrawReclassifying Shareholders’ 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 Owner’s ContributionsRecording Initial Noncash ContributionsRecording Home-Office Expenses
17. Performing Year-End Tasks
Checking for ProblemsGetting Rid of Uncleared Transactions from Closed PeriodsViewing Your Trial BalanceGenerating Financial ReportsThe Profit & Loss ReportGenerating a Profit & Loss ReportOther Profit & Loss ReportsThe Balance SheetGenerating a Balance Sheet ReportThe 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
Three. 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 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 ExcelSetting Up a Budget in ExcelImporting a Budget into QuickBooksRunning Budget ReportsThe Budget Overview ReportReport LayoutsThe Budget vs. Actual ReportThe Profit & Loss Budget Performance ReportThe Budget 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 ReportsAdding Comments to ReportsPrinting and Saving ReportsSaving Reports as FilesCustomizing ReportsChoosing Date RangesSelecting SubtotalsCustomizing ColumnsAdding 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
Four. 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 AppExporting 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 InfoAdditional CustomizationManaging TemplatesCopying a TemplateDeleting or Hiding a TemplateExchanging Templates Between Company Files
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
Five. Appendixes
A. Installing QuickBooks
Before You InstallInstalling QuickBooksInstalling QuickBooks for the First TimeInstalling or Upgrading to a New Version of QuickBooksActivating 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 QuickBooks 2016: The Missing Manual (which covers the Windows version of QuickBooks), you’re in control: you get step-by-step instructions on how and when to use specific features, along with basic bookkeeping and accounting advice to guide you through the learning process. Discover new and improved features like the Insights dashboard and easy report commenting.

The important stuff you need to know:

Get started fast. Quickly set up accounts, customers, jobs, and invoice items.
Follow the money. Track everything from billable and unbillable time and expenses to income and profit.
Keep your company financially fit. Examine budgets and actual spending, income, inventory, assets, and liabilities.
Gain insights. Open a dashboard that highlights your company’s financial activity and status the moment you log in.
Spend less time on bookkeeping. Create and reuse bills, invoices, sales receipts, and timesheets.
Find key info. Use 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: 9781491935682Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills