QuickBooks Online For Dummies (For Dummies (Computer/Tech))

Description

Get a handle on the world’s most popular cloud bookkeeping and accounting app QuickBooks Online comes second-to-none in providing simple and powerful bookkeeping and accounting features that can streamline your business, make you more profitable, and organize your company’s finances. But if you’re not quite sure how to make it all work, or if you just want to get a grip on its newest features, QuickBooks Online For Dummies is the companion you need to make the most of your favorite cloud accounting software. This book walks you through each and every step of creating an invoice or credit memo, recording a sale, paying bills, setting up and managing your inventory, and tracking your business checkbook and credit cards. It also includes: New updates on exporting data to Microsoft Excel or Google Sheets so that you can analyze your business data new ways.Stepwise walkthroughs of how to install and set up a new instance of QuickBooks Online for your business or personal accounts.Exclusive tips for bookkeepers and accountants working with clients in QuickBooks Online, including new techniques for automating monthly reports that you create in Excel from data that you export from QuickBooks. Whether you’re a small business owner, an accountant, a bookkeeper, or just someone trying to help their boss keep up with their accounting records, QuickBooks Online For Dummies is the resource you need to make the most popular cloud bookkeeping and accounting software in the world work for you! Title Page Copyright Page Table of Contents Introduction About This Book Foolish Assumptions Icons Used in This Book Beyond the Book Where to Go from Here Part 1 Getting Started with QuickBooks Online Chapter 1 Welcome to QuickBooks Online What Is QuickBooks Online? Checking on QuickBooks Pricing QuickBooks subscription pricing Payroll and time track pricing Other add-on pricing Comparing QuickBooks Features QuickBooks Online Self-Employed QuickBooks Simple Start QuickBooks Online Essentials QuickBooks Online Plus Usage limits for QuickBooks Simple Start, Essentials, and Plus QuickBooks Online Advanced QuickBooks Online Accountant Chapter 2 Creating a QuickBooks Online Company Signing Up for QuickBooks Online Exploring Your New Company Reviewing the QuickBooks interface Updating the Chart of Accounts Editing or inactivating accounts Adding account numbers Importing a chart of accounts Reviewing Company Settings Company preferences Billing & Subscription preferences Usage statistics Sales preferences Customizing sales forms Expenses preferences Payments preferences Time preferences Advanced preferences QuickBooks Online Apps QuickBooks Online Desktop app QuickBooks Online Mobile apps QuickBooks App Store QuickBooks Labs Chapter 3 Importing from QuickBooks Desktop and Sage 50 Knowing the Ins and Outs of Converting Data Using an online tool to migrate QuickBooks Desktop online Using an online service to migrate Sage 50 to QuickBooks Online Double-Checking Your Data After Conversion Part 2 Managing Your Books Chapter 4 Customer, Vendor, and Employee Lists Adding New Records to a List Creating a new record Using customer types Working with Records Searching lists Accessing attachments Switching from record to record Sorting a list on the Customers and Vendors page Working with a batch of records Changing Settings for Lists Accessing Other Lists Importing Customers and Vendors Downloading the sample file Importing lists Exporting lists to Excel or Google Sheets Introducing Spreadsheet Sync Installing the Spreadsheet Sync add-in Managing list records with Spreadsheet Sync Uninstalling Spreadsheet Sync Chapter 5 Managing Sales Tax, Services, and Inventory Setting Up Sales Tax Understanding sales tax liability Enabling the Automated Sales Tax feature Converting sales tax from QuickBooks Desktop Switching from manual to automated sales tax Exploring the Economic Nexus Feature Custom sales tax rates Auditing your customer list Reporting and paying sales taxes Working with Products and Services Adding inventory, non-inventory, and services items Reordering inventory items Creating inventory adjustment transactions Adjusting inventory quantities Making an inventory quantity adjustment Adjusting an inventory item’s starting value Establishing categories Changing item types Simplifying your invoicing process Using pricing rules Working with bundles Importing and Exporting Products and Services Downloading the sample file Importing lists Exporting lists to Excel or Google Sheets Managing Products and Services with Spreadsheet Sync Chapter 6 Invoicing Customers and Receiving Payments Getting Oriented with Sales Transactions Creating Invoices Configuring Automatic Subtotals Creating Billable Time Entries Entering time activities Adding billable time and expenses to an invoice Printing a Batch of Invoices or Packing Slips Recording Customer Payments Understanding the Payments to Deposit account Recording invoice payments Entering a sales receipt Recording Bank Deposits Keeping Tabs on Invoice Status and Receiving Payment Giving Money Back to a Customer Recording a credit memo Issuing a refund to a customer Writing Off Bad Debt Setting up a bad debt account and item Creating bad debt write-off transactions Reviewing and Creating Transactions with Spreadsheet Sync Chapter 7 Paying Bills and Writing Checks Looking at Expense and Bill Payment Methods Understanding the Transaction Types Entering an Expense Writing a Check Entering a Bill Paying Bills Paying two or more bills at once Writing a check to pay a bill Recording Vendor Credits and Refunds Entering a vendor credit Applying vendor credits against bills Recording vendor refund checks and payments Managing Recurring Transactions Reviewing and Creating Transactions with Spreadsheet Sync Chapter 8 Paying Employees and Contractors Getting Started with QuickBooks Payroll Turning on QuickBooks Payroll Setting payroll preferences Setting up payroll taxes Preparing Payroll Recording payroll information Enabling employee time tracking Reviewing and generating payroll checks Establishing or correcting payroll exemptions Printing payroll reports Managing Payroll Taxes Paying payroll taxes Viewing payroll tax forms Paying Contractors Setting up 1099-eligible contractors Paying contractors Reporting on 1099 vendor payments Preparing 1099s Chapter 9 Working in Registers Understanding Registers Customizing the Register View Entering and Editing Transactions Entering transactions Editing a transaction Performing Other Register Activities Sorting transactions Filtering transactions Printing a register Exporting a register Chapter 10 Administering Bank and Credit Card Accounts Setting Up a Bank or Credit Card Account Making a Bank Deposit Making a Credit Card Payment Recording a Credit Card Credit Reconciling a Bank or Credit Card Account Chapter 11 Synchronizing with Financial Institutions Connecting QuickBooks Accounts to Financial Institutions Connecting . . . or not connecting Accessing bank and credit card–related pages in QuickBooks Being Direct: Connecting a Bank or Credit Card Account Managing uploaded or downloaded activity Reviewing transactions Automating downloaded activity with rules Creating rules Exporting and importing rules Fixing mistakes in uploaded or downloaded transactions Using Indirect Connections to Financial Institutions Downloading Web Connect and text files Opening text files in Microsoft Excel or Google Sheets Editing text files Saving CSV files Uploading Web Connect and CSV files Connecting to Online Providers through App Transactions Converting Paper Receipts to Electronic Transactions Chapter 12 Working with Purchase Orders, Estimates, Projects, and Tags Working with Purchase Orders Enabling the purchase order feature Creating purchase orders Copying an existing purchase order Receiving items against purchase orders Closing purchase orders Tracking open purchase orders Working with Estimates Preparing an estimate Copying an estimate to a purchase order Converting an estimate to an invoice Copying an existing estimate Creating a progress invoice for an estimate Managing Projects Turning on the Project feature Contrasting projects with sub-customers Creating a new project Adding transactions to a project Reporting on projects Updating project status Deleting projects Tagging Transactions Creating Tag Groups and Tags Tagging existing transactions Tagging new transactions Disabling the Tags feature Part 3 Budgeting, Reporting, and Analysis Chapter 13 Creating Budgets in QuickBooks Creating a Budget Importing Budgets Basing Spreadsheet Budgets on Actuals Deleting Budgets Chapter 14 Utilizing QuickBooks Reports Looking at the Reports Page Finding the Report You Want Examining standard reports Finding customized reports Reviewing management reports Contemplating Multi-Co reporting Searching for a report Printing a Report Customizing Reports Saving a customized report Taking actions with custom reports Exporting Reports from QuickBooks Exporting to Excel Exporting to PDF Exporting to Google Sheets Custom Reporting with Spreadsheet Sync Chapter 15 Analyzing QuickBooks Data in Excel Automatically Opening Excel Reports Exported from QuickBooks Sifting through Excel Reports Filtering data Guarding against a tricky trap Slicing your data Sorting data Creating Custom Reporting with Pivot Tables Understanding pivot table requirements Adding fields Removing fields Spreadsheet Sync Part 4 Features for Accountants Chapter 16 Introducing QB Accountant Getting Started with QuickBooks Online Accountant Setting Up Your Team Assigning lead accountants Examining the QB Accountant Interface Using Your Practice commands Toolbar commands Adding Companies to the Client List Inviting you to be the accountant user Adding a client to your practice Accepting primary admin rights from your client Transferring primary admin rights to your client Working with the Client List Customizing the Client List Removing Clients from Your Client List ProAdvisor Preferred Pricing versus ProAdvisor Revenue Share Signing Up for ProAdvisor Preferred Pricing Adding existing clients to your consolidated billing Removing clients from your consolidated billing Stopping consolidated billing Signing up for ProAdvisor Revenue Share Using Your Free QuickBooks Online Advanced Subscription Chapter 17 Managing Your Clients’ Books Opening a Client’s Company Utilizing the Client Overview page Examining company setup information Taking a look at the chart of accounts Reviewing list information Discovering QuickBooks Online Accountant Tools Reviewing reports Examining voided and deleted transactions Looking at Books Review Reclassifying transactions Writing off invoices Closing the books Understanding the Prep for Taxes page Taking a brief look at other accountant tools Chapter 18 Practice Management Introducing the Work Page Creating templates Creating client requests Managing projects and tasks Looking at Work page views Communicating with Team Members about Work Chapter 19 Automating QuickBooks Analysis with Power Query Introducing Power Query Connecting to QuickBooks Reports Removing header rows Promoting headers Removing unwanted columns Filtering unnecessary rows Returning the data to Excel Creating Self-Updating Reports Setting Power Query to refresh automatically Adding a total row Transforming QuickBooks data Unpivoting columns Refreshing reports Part 5 The Part of Tens Chapter 20 Ten Cool Chrome Shortcuts Plus Ten Bonus Excel Shortcuts Chrome Keyboard Shortcuts Opening and activating a new tab Closing the current tab Navigating to web sites faster Saving open tabs as a bookmark group Toggling full-screen mode Opening your home page in the current tab Activating a specific tab Displaying the Downloads page Displaying the History page Creating a tab in a new profile Microsoft Excel Keyboard Shortcuts Switching between open documents Switching between worksheet tabs Closing an open workbook Moving to cell A1 of a worksheet Saving your work Undoing your work Toggling absolute or mixed references Toggling Enter versus Edit mode Calculating a portion of a formula Summing a range of cells Index EULA