Introduction 1 About This Book 1 Foolish Assumptions 3 Icons Used in This Book 3 Beyond the Book 4 Where to Go from Here 4 Part 1: Getting Started with QuickBooks Online 5 Chapter 1: Welcome to QuickBooks Online 7 What Is QuickBooks Online? 8 Checking on QuickBooks Pricing 10 QuickBooks subscription pricing 10 Payroll and time track pricing 11 Other add-on pricing 13 Comparing QuickBooks Features 13 QuickBooks Online Self-Employed 14 QuickBooks Simple Start 14 QuickBooks Online Essentials 15 QuickBooks Online Plus 15 Usage limits for QuickBooks Simple Start, Essentials, and Plus 16 QuickBooks Online Advanced 17 QuickBooks Online Accountant 18 Chapter 2: Creating a QuickBooks Online Company 19 Signing Up for QuickBooks Online 19 Exploring Your New Company 22 Reviewing the QuickBooks interface 25 Updating the Chart of Accounts 28 Editing or inactivating accounts 33 Adding account numbers 36 Importing a chart of accounts 37 Reviewing Company Settings 38 Company preferences 39 Billing & Subscription preferences 39 Usage statistics 40 Sales preferences 40 Customizing sales forms 41 Expenses preferences 44 Payments preferences 44 Time preferences 45 Advanced preferences 45 QuickBooks Online Apps 46 QuickBooks Online Desktop app 47 QuickBooks Online Mobile apps 48 QuickBooks App Store 48 QuickBooks Labs 48 Chapter 3: Importing from QuickBooks Desktop and Sage 50 51 Knowing the Ins and Outs of Converting Data 51 Using an online tool to migrate QuickBooks Desktop online 54 Using an online service to migrate Sage 50 to QuickBooks Online 55 Double-Checking Your Data After Conversion 56 Part 2: Managing Your Books 59 Chapter 4: Customer, Vendor, and Employee Lists 61 Adding New Records to a List 61 Creating a new record 62 Using customer types 66 Working with Records 67 Searching lists 68 Accessing attachments 69 Switching from record to record 70 Sorting a list on the Customers and Vendors page 71 Working with a batch of records 71 Changing Settings for Lists 72 Accessing Other Lists 73 Importing Customers and Vendors 74 Downloading the sample file 75 Importing lists 77 Exporting lists to Excel or Google Sheets 80 Introducing Spreadsheet Sync 81 Installing the Spreadsheet Sync add-in 82 Managing list records with Spreadsheet Sync 84 Uninstalling Spreadsheet Sync 86 Chapter 5: Managing Sales Tax, Services, and Inventory 87 Setting Up Sales Tax 88 Understanding sales tax liability 88 Enabling the Automated Sales Tax feature 89 Converting sales tax from QuickBooks Desktop 91 Switching from manual to automated sales tax 91 Exploring the Economic Nexus Feature 92 Custom sales tax rates 93 Auditing your customer list 94 Reporting and paying sales taxes 95 Working with Products and Services 97 Adding inventory, non-inventory, and services items 98 Reordering inventory items 103 Creating inventory adjustment transactions 104 Establishing categories 108 Changing item types 110 Simplifying your invoicing process 110 Using pricing rules 111 Working with bundles 112 Importing and Exporting Products and Services 114 Downloading the sample file 114 Importing lists 116 Exporting lists to Excel or Google Sheets 116 Managing Products and Services with Spreadsheet Sync 117 Chapter 6: Invoicing Customers and Receiving Payments 121 Getting Oriented with Sales Transactions 122 Creating Invoices 123 Configuring Automatic Subtotals 129 Creating Billable Time Entries 131 Entering time activities 131 Adding billable time and expenses to an invoice 134 Printing a Batch of Invoices or Packing Slips 136 Recording Customer Payments 137 Understanding the Payments to Deposit account 138 Recording invoice payments 138 Entering a sales receipt 140 Recording Bank Deposits 142 Keeping Tabs on Invoice Status and Receiving Payment 144 Giving Money Back to a Customer 146 Recording a credit memo 147 Issuing a refund to a customer 148 Writing Off Bad Debt 151 Setting up a bad debt account and item 151 Creating bad debt write-off transactions 152 Reviewing and Creating Transactions with Spreadsheet Sync 153 Chapter 7: Paying Bills and Writing Checks 157 Looking at Expense and Bill Payment Methods 157 Understanding the Transaction Types 158 Entering an Expense 159 Writing a Check 163 Entering a Bill 164 Paying Bills 166 Paying two or more bills at once 166 Writing a check to pay a bill 169 Recording Vendor Credits and Refunds 171 Entering a vendor credit 171 Applying vendor credits against bills 172 Recording vendor refund checks and payments 172 Managing Recurring Transactions 174 Reviewing and Creating Transactions with Spreadsheet Sync 179 Chapter 8: Paying Employees and Contractors 181 Getting Started with QuickBooks Payroll 182 Turning on QuickBooks Payroll 182 Setting payroll preferences 187 Setting up payroll taxes 189 Preparing Payroll 191 Recording payroll information 192 Enabling employee time tracking 193 Reviewing and generating payroll checks 194 Establishing or correcting payroll exemptions 197 Printing payroll reports 199 Managing Payroll Taxes 200 Paying payroll taxes 200 Viewing payroll tax forms 202 Paying Contractors 202 Setting up 1099-eligible contractors 203 Paying contractors 205 Reporting on 1099 vendor payments 205 Preparing 1099s 207 Chapter 9: Working in Registers 209 Understanding Registers 209 Customizing the Register View 211 Entering and Editing Transactions 214 Entering transactions 215 Editing a transaction 219 Performing Other Register Activities 220 Sorting transactions 220 Filtering transactions 220 Printing a register 222 Exporting a register 223 Chapter 10: Administering Bank and Credit Card Accounts 225 Setting Up a Bank or Credit Card Account 225 Making a Bank Deposit 228 Making a Credit Card Payment 230 Recording a Credit Card Credit 231 Reconciling a Bank or Credit Card Account 233 Chapter 11: Synchronizing with Financial Institutions 239 Connecting QuickBooks Accounts to Financial Institutions 239 Connecting or not connecting 240 Accessing bank and credit card-related pages in QuickBooks 241 Being Direct: Connecting a Bank or Credit Card Account 244 Managing uploaded or downloaded activity 247 Reviewing transactions 249 Automating downloaded activity with rules 253 Fixing mistakes in uploaded or downloaded transactions 259 Using Indirect Connections to Financial Institutions 261 Downloading Web Connect and text files 261 Opening text files in Microsoft Excel or Google Sheets 262 Editing text files 263 Saving CSV files 265 Uploading Web Connect and CSV files 266 Connecting to Online Providers through App Transactions 269 Converting Paper Receipts to Electronic Transactions 269 Chapter 12: Working with Purchase Orders, Estimates, Projects, and Tags 275 Working with Purchase Orders 276 Enabling the purchase order feature 277 Creating purchase orders 278 Copying an existing purchase order 281 Receiving items against purchase orders 281 Closing purchase orders 284 Tracking open purchase orders 285 Working with Estimates 286 Preparing an estimate 286 Copying an estimate to a purchase order 288 Converting an estimate to an invoice 291 Copying an existing estimate 293 Creating a progress invoice for an estimate 294 Managing Projects 296 Turning on the Project feature 296 Contrasting projects with sub-customers 298 Creating a new project 299 Adding transactions to a project 302 Reporting on projects 302 Updating project status 304 Deleting projects 304 Tagging Transactions 305 Creating Tag Groups and Tags 307 Tagging existing transactions 308 Tagging new transactions 310 Disabling the Tags feature 310 Part 3: Budgeting, Reporting, and Analysis 311 Chapter 13: Creating Budgets in QuickBooks 313 Creating a Budget 313 Importing Budgets 316 Basing Spreadsheet Budgets on Actuals 318 Deleting Budgets 320 Chapter 14: Utilizing QuickBooks Reports 321 Looking at the Reports Page 321 Finding the Report You Want 323 Examining standard reports 323 Finding customized reports 324 Reviewing management reports 325 Contemplating Multi-Co reporting 326 Searching for a report 327 Printing a Report 327 Customizing Reports 329 Saving a customized report 332 Taking actions with custom reports 334 Exporting Reports from QuickBooks 336 <.