| Introduction |
|
1 | (6) |
|
|
|
1 | (2) |
|
|
|
3 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
5 | (2) |
|
PART 1 GETTING STARTED WITH QBO AND QBOA |
|
|
7 | (22) |
|
Chapter 1 Presenting QuickBooks Online |
|
|
9 | (8) |
|
Comparing QuickBooks and QB Accountant |
|
|
9 | (1) |
|
|
|
10 | (3) |
|
Taking a look at QuickBooks Online Mobile |
|
|
13 | (1) |
|
|
|
13 | (4) |
|
Chapter 2 Embracing QuickBooks Online |
|
|
17 | (12) |
|
|
|
17 | (1) |
|
QuickBooks Online Self-Employed |
|
|
18 | (1) |
|
|
|
19 | (1) |
|
QuickBooks Online Essentials |
|
|
19 | (1) |
|
|
|
20 | (1) |
|
QuickBooks Online Advanced |
|
|
21 | (1) |
|
Usage limits for QuickBooks Simple Start, Essentials, and Plus |
|
|
22 | (1) |
|
The Dollars and Cents of QuickBooks Subscriptions |
|
|
23 | (1) |
|
|
|
24 | (1) |
|
Migration from QuickBooks Desktop |
|
|
25 | (1) |
|
|
|
26 | (3) |
|
PART 2 MANAGING YOUR BOOKS |
|
|
29 | (230) |
|
Chapter 3 Creating a QuickBooks Online Company |
|
|
31 | (32) |
|
Signing Up for QuickBooks Online |
|
|
32 | (2) |
|
|
|
34 | (2) |
|
Understanding the Dashboard |
|
|
36 | (4) |
|
Updating the Chart of Accounts |
|
|
40 | (4) |
|
Establishing Company Settings |
|
|
44 | (1) |
|
Examining company preferences |
|
|
44 | (1) |
|
Examining billing and subscription settings and use limits |
|
|
45 | (1) |
|
Setting sales preferences |
|
|
46 | (1) |
|
Taking a look at expense preferences |
|
|
46 | (1) |
|
Examining options to receive customer payments |
|
|
47 | (1) |
|
Reviewing advanced preferences |
|
|
48 | (2) |
|
|
|
50 | (4) |
|
Taking Advantage of QuickBooks Labs |
|
|
54 | (1) |
|
Working with Multiple Currencies |
|
|
55 | (1) |
|
Seeing how the Multicurrency feature changes QBO |
|
|
56 | (1) |
|
Changing your home currency |
|
|
57 | (1) |
|
|
|
58 | (1) |
|
Using multiple currencies |
|
|
58 | (5) |
|
Chapter 4 Managing List Information |
|
|
63 | (40) |
|
Importing Customers and Vendors |
|
|
63 | (6) |
|
Adding New Records to a List |
|
|
69 | (1) |
|
|
|
69 | (2) |
|
|
|
71 | (1) |
|
|
|
72 | (1) |
|
|
|
72 | (1) |
|
|
|
73 | (1) |
|
Attaching files to a record |
|
|
74 | (1) |
|
Adding attachments to specific transactions |
|
|
74 | (1) |
|
Switching from record to record |
|
|
75 | (1) |
|
Sorting a list on the Customers or Vendors page |
|
|
76 | (1) |
|
Exporting a list to Excel or Google Sheets |
|
|
77 | (1) |
|
Working with a batch of records |
|
|
78 | (1) |
|
Changing Settings for Lists |
|
|
78 | (2) |
|
|
|
80 | (2) |
|
Working with Products and Services Items |
|
|
82 | (1) |
|
|
|
83 | (2) |
|
Adding service and noninventory items |
|
|
85 | (3) |
|
Creating an inventory item |
|
|
88 | (2) |
|
|
|
90 | (2) |
|
|
|
92 | (2) |
|
|
|
94 | (2) |
|
Adjusting inventory item information |
|
|
96 | (5) |
|
|
|
101 | (2) |
|
Chapter 5 Dealing with the Outflow of Money |
|
|
103 | (30) |
|
|
|
103 | (2) |
|
|
|
105 | (1) |
|
Assigning a check to accounts or items |
|
|
105 | (4) |
|
Writing a check for an outstanding bill |
|
|
109 | (2) |
|
|
|
111 | (1) |
|
Entering a Purchase Order |
|
|
112 | (1) |
|
Turning on the purchase-order feature |
|
|
113 | (1) |
|
Creating a purchase order |
|
|
114 | (2) |
|
Receiving items against purchase orders |
|
|
116 | (4) |
|
Entering and Paying Bills |
|
|
120 | (1) |
|
|
|
120 | (2) |
|
Managing recurring transactions |
|
|
122 | (3) |
|
Recording a vendor credit |
|
|
125 | (2) |
|
Handling a refund check from a vendor |
|
|
127 | (3) |
|
|
|
130 | (3) |
|
Chapter 6 Managing the Inflow of Money |
|
|
133 | (46) |
|
Getting Started with Sales Transactions |
|
|
133 | (1) |
|
|
|
134 | (5) |
|
Printing invoices and packing slips |
|
|
139 | (2) |
|
Configuring automatic subtotals |
|
|
141 | (3) |
|
Keeping tabs on invoice status |
|
|
144 | (1) |
|
Recording a customer payment |
|
|
145 | (2) |
|
Using the Payments to Deposit account |
|
|
147 | (1) |
|
|
|
148 | (1) |
|
Recording electronic transaction fees |
|
|
149 | (2) |
|
|
|
151 | (2) |
|
Giving Money Back to a Customer |
|
|
153 | (1) |
|
|
|
153 | (2) |
|
Issuing a refund to a customer |
|
|
155 | (2) |
|
|
|
157 | (1) |
|
|
|
158 | (3) |
|
Managing estimate statuses |
|
|
161 | (1) |
|
Copying an estimate to a purchase order |
|
|
161 | (1) |
|
Converting an estimate to an invoice |
|
|
162 | (3) |
|
Copying an existing estimate |
|
|
165 | (1) |
|
Creating a progress invoice for an estimate |
|
|
165 | (2) |
|
Creating Billable Time Entries |
|
|
167 | (1) |
|
Entering a single time activity |
|
|
168 | (2) |
|
Adding a billable expense to an invoice |
|
|
170 | (1) |
|
|
|
171 | (1) |
|
Turning on the Projects feature |
|
|
172 | (1) |
|
Enabling projects in Customer lists |
|
|
173 | (1) |
|
Converting subcustomers to projects |
|
|
173 | (2) |
|
|
|
175 | (1) |
|
Adding transactions to a project |
|
|
176 | (1) |
|
|
|
177 | (2) |
|
Chapter 7 Working in Registers |
|
|
179 | (14) |
|
|
|
179 | (2) |
|
Customizing the Register View |
|
|
181 | (3) |
|
Entering and Editing Transactions |
|
|
184 | (1) |
|
|
|
184 | (3) |
|
|
|
187 | (1) |
|
Other Things You Can Do in a Register |
|
|
188 | (1) |
|
|
|
189 | (1) |
|
|
|
190 | (1) |
|
|
|
191 | (1) |
|
|
|
192 | (1) |
|
Chapter 8 Handling Bank and Credit Card Transactions |
|
|
193 | (40) |
|
Setting Up a Bank or Credit Card Account |
|
|
193 | (2) |
|
|
|
195 | (3) |
|
Reconciling a Bank Account |
|
|
198 | (4) |
|
Connecting QuickBooks Accounts to Financial Institutions |
|
|
202 | (1) |
|
Connecting or not connecting |
|
|
202 | (2) |
|
Directly connecting a Bank or Credit Card account |
|
|
204 | (3) |
|
Troubleshooting connections to financial institutions |
|
|
207 | (6) |
|
Managing Downloaded Activity |
|
|
213 | (3) |
|
|
|
216 | (1) |
|
|
|
217 | (1) |
|
Confirming correct guesses |
|
|
217 | (1) |
|
Changing incorrect guesses |
|
|
217 | (1) |
|
Examining transactions QuickBooks thinks it can match |
|
|
218 | (1) |
|
Establishing rules to accept transactions |
|
|
219 | (5) |
|
|
|
224 | (1) |
|
Converting Paper Receipts to Electronic Transactions |
|
|
225 | (3) |
|
Controlling the Appearance of Bank Accounts |
|
|
228 | (1) |
|
|
|
229 | (4) |
|
Chapter 9 Paying Employees and Contractors |
|
|
233 | (26) |
|
Understanding the Employee Payroll Process |
|
|
234 | (1) |
|
Getting Started with QuickBooks Payroll |
|
|
234 | (1) |
|
Turning on QuickBooks Payroll |
|
|
234 | (6) |
|
Setting payroll preferences |
|
|
240 | (2) |
|
|
|
242 | (2) |
|
|
|
244 | (1) |
|
Recording payroll information |
|
|
245 | (1) |
|
Letting employees use time sheets |
|
|
245 | (2) |
|
Reviewing and generating payroll checks |
|
|
247 | (2) |
|
Establishing or correcting payroll exemptions |
|
|
249 | (3) |
|
|
|
252 | (1) |
|
|
|
252 | (1) |
|
|
|
252 | (1) |
|
Viewing payroll tax forms |
|
|
253 | (1) |
|
|
|
254 | (1) |
|
Setting up 1099-eligible contractors |
|
|
255 | (1) |
|
|
|
256 | (843) |
|
Reporting on 1099 vendor payments |
|
|
256 | (2) |
|
|
|
258 | (1) |
|
PART 3 REPORTING AND ANALYSIS |
|
|
259 | (32) |
|
Chapter 10 Evaluating How the Business Is Doing |
|
|
261 | (16) |
|
Reviewing Income and Expenses |
|
|
261 | (2) |
|
Finding the Report You Want |
|
|
263 | (1) |
|
Examining standard reports |
|
|
263 | (1) |
|
Finding customized reports |
|
|
264 | (1) |
|
Reviewing management reports |
|
|
264 | (2) |
|
Contemplating Multi-Co Reporting |
|
|
266 | (1) |
|
|
|
266 | (1) |
|
|
|
267 | (1) |
|
|
|
268 | (3) |
|
Saving a customized report |
|
|
271 | (3) |
|
|
|
274 | (2) |
|
|
|
276 | (1) |
|
Exporting to Google Sheets |
|
|
276 | (1) |
|
Chapter 11 Analyzing QuickBooks Data in Excel |
|
|
277 | (14) |
|
Automatically Opening Excel Reports Exported from QuickBooks |
|
|
278 | (2) |
|
Sifting through Excel Reports |
|
|
280 | (1) |
|
|
|
281 | (2) |
|
Guarding against a tricky trap |
|
|
283 | (1) |
|
|
|
284 | (2) |
|
|
|
286 | (1) |
|
Custom Reporting with Pivot Tables |
|
|
287 | (1) |
|
Understanding pivot table requirements |
|
|
287 | (1) |
|
|
|
288 | (1) |
|
|
|
289 | (2) |
|
PART 4 WORKING IN QUICKBOOKS ONLINE ACCOUNTANT |
|
|
291 | (116) |
|
Chapter 12 Setting Up Shop in QuickBooks Online Accountant |
|
|
293 | (22) |
|
Registering for and Signing in to QuickBooks Online Accountant |
|
|
294 | (2) |
|
Examining the QB Accountant Interface |
|
|
296 | (1) |
|
Working with Your Practice view |
|
|
296 | (4) |
|
|
|
300 | (1) |
|
|
|
300 | (4) |
|
Controlling the Appearance of the Client List |
|
|
304 | (2) |
|
Understanding and Using the Free QB Accountant Company |
|
|
306 | (1) |
|
Working with the Sample Company |
|
|
307 | (1) |
|
Closing Companies in QB Accountant |
|
|
308 | (1) |
|
Working with ProAdvisor Preferred Pricing |
|
|
309 | (1) |
|
Signing up for ProAdvisor Preferred Pricing |
|
|
309 | (1) |
|
Adding existing clients to your ProAdvisor Preferred |
|
|
|
|
|
310 | (2) |
|
Removing clients from your ProAdvisor Preferred |
|
|
|
|
|
312 | (2) |
|
Stopping consolidated billing |
|
|
314 | (1) |
|
Chapter 13 Adding Companies to the QB Accountant Client List |
|
|
315 | (22) |
|
Adding a Client's Company to the Client List |
|
|
316 | (1) |
|
When a client invites you to be the accountant user |
|
|
316 | (3) |
|
When you invite a client to your practice |
|
|
319 | (2) |
|
Transferring primary rights to your client |
|
|
321 | (4) |
|
Importing QuickBooks Desktop Data into QuickBooks Online |
|
|
325 | (1) |
|
|
|
326 | (2) |
|
Understanding what won't import |
|
|
328 | (1) |
|
Updating your edition of QuickBooks Desktop |
|
|
329 | (2) |
|
Transferring data from desktop to online |
|
|
331 | (3) |
|
Double-checking things after conversion |
|
|
334 | (2) |
|
Switching between Client QuickBooks Companies |
|
|
336 | (1) |
|
Chapter 14 Exploring a Client's Company from QB Accountant |
|
|
337 | (14) |
|
Opening a Client's Company |
|
|
337 | (1) |
|
Reviewing a Client's QuickBooks Company |
|
|
338 | (1) |
|
Taking a look at the Client Overview page |
|
|
338 | (3) |
|
Examining company setup information |
|
|
341 | (3) |
|
Taking a look at the chart of accounts |
|
|
344 | (3) |
|
Reviewing list information |
|
|
347 | (1) |
|
Exporting and importing bank feed rules |
|
|
348 | (3) |
|
Chapter 15 Working in a Client's Company |
|
|
351 | (12) |
|
|
|
351 | (1) |
|
|
|
351 | (1) |
|
|
|
352 | (2) |
|
Working in two companies simultaneously |
|
|
354 | (1) |
|
Examining Available Transaction Types |
|
|
355 | (1) |
|
Searching for Transactions |
|
|
356 | (1) |
|
|
|
357 | (2) |
|
Communicating with a Client |
|
|
359 | (4) |
|
Chapter 16 Using Accountant Tools |
|
|
363 | (26) |
|
Reporting and Paying Sales Taxes |
|
|
363 | (2) |
|
|
|
365 | (1) |
|
|
|
366 | (1) |
|
Creating projects and tasks |
|
|
367 | (3) |
|
|
|
370 | (1) |
|
Editing and deleting project information |
|
|
371 | (1) |
|
|
|
372 | (1) |
|
|
|
373 | (1) |
|
Communicating with team members about work |
|
|
374 | (1) |
|
Facilitating Accountant Activities |
|
|
375 | (1) |
|
|
|
375 | (2) |
|
Examining voided and deleted transactions |
|
|
377 | (1) |
|
|
|
378 | (1) |
|
|
|
378 | (1) |
|
|
|
379 | (1) |
|
|
|
380 | (1) |
|
Reclassifying transactions |
|
|
380 | (2) |
|
|
|
382 | (1) |
|
Understanding the Prep for Taxes page |
|
|
383 | (4) |
|
Taking a brief look at other accountant tools |
|
|
387 | (2) |
|
Chapter 17 Automating QuickBooks Analysis with Power Query |
|
|
389 | (18) |
|
|
|
389 | (1) |
|
Connecting to QuickBooks Reports |
|
|
390 | (2) |
|
|
|
392 | (1) |
|
|
|
393 | (1) |
|
Removing unwanted columns |
|
|
394 | (2) |
|
Filtering unnecessary rows |
|
|
396 | (1) |
|
Returning the data to Excel |
|
|
396 | (2) |
|
Creating Self-Updating Reports |
|
|
398 | (1) |
|
Setting Power Query to refresh automatically |
|
|
399 | (3) |
|
|
|
402 | (1) |
|
Transforming QuickBooks Data |
|
|
403 | (1) |
|
|
|
404 | (1) |
|
|
|
405 | (2) |
|
|
|
407 | (20) |
|
Chapter 18 Ten Ways to Use Chrome Effectively |
|
|
409 | (18) |
|
|
|
409 | (2) |
|
Duplicating and Pinning Tabs |
|
|
411 | (1) |
|
Using Chrome on Multiple Monitors |
|
|
411 | (1) |
|
|
|
412 | (1) |
|
Using Bookmarks in Chrome |
|
|
412 | (1) |
|
|
|
413 | (1) |
|
Displaying the Bookmarks bar |
|
|
414 | (1) |
|
|
|
415 | (1) |
|
|
|
415 | (1) |
|
|
|
416 | (2) |
|
|
|
418 | (1) |
|
Working with Chrome Profiles |
|
|
419 | (1) |
|
|
|
419 | (1) |
|
Opening a different profile |
|
|
420 | (1) |
|
Editing and removing profiles |
|
|
421 | (1) |
|
Managing Privacy in Chrome |
|
|
421 | (1) |
|
|
|
421 | (1) |
|
|
|
422 | (1) |
|
Working in Incognito mode |
|
|
422 | (1) |
|
Deleting browsing history |
|
|
422 | (2) |
|
Reviewing miscellaneous privacy settings |
|
|
424 | (1) |
|
Using Google tools to manage privacy |
|
|
425 | (1) |
|
Managing Security in Chrome |
|
|
426 | (1) |
| Appendix: Quickbooks Online, Quickbooks Desktop, And Data Conversion |
|
427 | (16) |
| Index |
|
443 | |
