Index

Numerics

1099 forms

1099-MISC payments, reporting, 226-235

mid-year balances, entering, 248-249

preferences, 192-193

A

accessing CDR tools, 604-605

Account Balances task group (CDR)

Reclassify Transactions dialog box, 615-617

Troubleshoot Prior Account Balances tool, 611-615

Accountant Center, customizing, 605-607

accountant’s changes to data file, importing, 530-533

Accountant’s Copy

canceling, 536

converting to company file, 549-550

accounting checklist, 62-63

Accounting preferences, 186-188

accounting principles

accrual versus cash basis reporting, 59

matching principle, 57-58

accounts

deactivating, 95-96

one-sided items, correcting, 105-108

subaccount relationships, 98-100

accounts payable

aged accounts payable, reviewing, 176

aged item receipts, reviewing, 218-220

balance on cash-basis Balance Sheet report, 222-225

bartering, 244-245

errors, correcting

misapplied vendor credits, 238-239

open vendor bills paid with Write Checks transaction, 236-238

forms, 200-202

items, reviewing setup, 221

journal adjustments, 241-243

preferences affecting

Checking preferences, 257-258

Finance Charge preference, 258-259

Jobs & Estimates preference, 259

Payments preference, 255-256

Reminders preference, 259-260

Reports and Graphs preference, 260-261

Sales & Customers preference, 257

Sales Tax preference, 262-263

Send Forms preference, 263-264

Spelling preference, 264-265

Time and Expense preference, 265-266

purchase orders, entering, 204

recurring transactions, memorizing, 249-250

startup transactions, configuring, 69-73

Unpaid Bills Detail report, reviewing, 216-218

vendor bills

discounts, 213-214

entering, 205-207

paying, 209-211

vendor credits

applying, 211-213

creating, 207-208

vendors, recording prepayments, 245-247

workflow, 202-204

Accounts Payable task group (CDR), 631-633

accounts receivable

Collections Center, 326-328

errors, correcting

customer payment errors, 342-346

depostis, 347-353

open balance, removing from customer invoice, 338-342

startup transactions, configuring, 65-69

transactions, 289-290

year-end adjusting journal entry, recording, 366

Accounts Recievable task group (CDR), 623-631

accrual basis reporting, versus cash basis reporting, 59

activating

Online Banking feature, 449-450

payroll service subscriptions, 379-381

Add New Account dialog box, 80-82

Add/Edit Multiple List Entries feature, 125-127

Add/Edit Multiple List Entries feature (chart of accounts), 90-92

adding

Calc icon to icon bar, 47

employee information in Employee Center, 402-404

inventory part items, 121-123

items to data file, 82-84

jobs to Customer Center, 267-270

non-inventory part items, 123-125

supporting documents, 680-681

vendors to data file, 194-198

adjusting

employee paychecks, 434-435

payroll liabilities, 417-418

Admin user, 38

advanced setup process, EasyStep Interview, 29-33

aged accounts payable, reviewing, 176

aged item receipts

removing, 239-240

reviewing, 173-176, 218-220

A/P Aging Summary report, reconciling to balance sheet, 215-216

applying

credit memos to vendor bills, 239

vendor credits, 211-213

A/R Aging Summary, reviewing, 319-321

assemblies, 119-120, 150-152

creating, 131-133

assets in chart of accounts list, 78

assigning

customer types, 88-89

sales tax codes, 278-280

subaccount relationships, 98-100

Audit Trail report, 507

automatic repayment deductions, 429-430

average cost valuation

negative inventory, handling, 179-183

reviewing, 170-173

B

backorders, handling, 152-155

backup files

creating, 561-564

Intuit Data Protect, 567

balance sheets, 59-61

account types, reviewing, 497

A/P Aging Summary report, reconciling, 215-216

bank balance, reviewing, 498

Credit Card account balance, reviewing, 503

Equity accounts, reviewing, 505

liability balances, comparing with, 424-425

Other Current Asset accounts, reviewing, 501-502

prior year balance, reviewing, 497

Sales Tax payable balance, reviewing, 504

undeposited funds, reviewing, 499-500

Bank Reconciliation task group (CDR), 646-647

banking

accounts, transferring funds between, 448

balance, configuring startup transactions, 71-73

deposits, making, 311-313

preferences affecting, 437-438

bartering, 244-245

batch invoicing, 295-297

bills

credit card bills, paying and recording, 251-252, 447

vendor bills

discounts, 213-214

paying, 209-211

Bills preferences, 188

bonuses, paying to employees, 433-434

bounced checks, recording, 368-369

budgets

creating, 581-583

deleting, 587

editing, 584-585

printing, 585

business owners, data sharing, 522-536

C

Calc icon, adding to icon bar, 47

canceling the Accountant’s Copy, 536

Carousel view, Report Center, 477

cash basis reporting

accounts payable balance on Balance Sheet report, 222-225

accounts payable, configuring data files, 69-73

accounts receivable balance, reviewing, 324-326

accounts receivable, configuring data files, 65-69

versus accrual, 59

bank balance, configuring data files, 71-73

uncleared bank checks, configuring data files, 74-75

causes of database corruption, 570

CDR (Client Data Review) feature, 601-603

Account Balances task group

Reclassify Transactions dialog box, 615-617

Troubleshoot Prior Account Balances tool, 611-615

Accountant Center

customizing, 605-607

Accounts Payable task group, 631-633

Accounts Recievable task group, 623-631

Bank Reconciliation task group, 646-647

customizing, 607-611

Inventory task group, 638-643

Miscellaneous task group, 648-652

Payroll task group, 643-646

reopening a review, 654

review, saving as PDF, 652

review activity, reporting on, 655

Review List Changes feature, 618-623

Sales Tax task group, 633-638

tools, accessing, 604-605

workflow, 601-602

chart of accounts, 77

accounts

deactivating, 95-96

merging, 96-98

Add/Edit Multiple List Entries feature, 90-92

assets, 78

cost of goods sold, 79

equity, 79

expenses, 79-80

IIF files, exporting, 92-93

income, 79

liabilities, 78-79

new accounts, creating, 80-82

payroll accounts, creating, 384-385

preferences, 89-90

required accounts, 95

subaccount relationships, 98-100

Checking preferences, 188-189, 389

effect on accounts payable, 257-258

checklists, accounting checklist, 62-63

checks

printing, 443-445

recording bounced checks, 368-369

writing, 440-442

classes, 86-88

classifying workers as employees, 382

closed accounting periods, tracking changes to, 506-507

codes (sales tax), creating, 276-278

Collections Center, 326-328

Columns tab (Report Designer), 664

company files, repairing, 576-577

Company Information dialog box, 422

Company Preferences, 479-482

customizing, 51

Company Setup (Payroll Setup Interview), 391-392

Company Snapshot

customizing, 473-475

defaulting as Home page, 476

comparing

accrual and cash basis reporting, 59

balance sheet and liability balance, 424-425

Inventory Valuation Summary report with Balance Sheet Inventory Asset balance, 168-170

QuickBooks versions, 21

completing multimonth/multiyear bank reconciliation, 465

configuring. See also preferences

Multiple Unit of Measure feature, 134-137

user accounts

External Accountant, 38-39

permissions, 40

confirming 1099-MISC payments, 234

connectivity, troubleshooting with QuickBooks Connection Diagnostic Tool, 558

conversion tool, downloading, 37

converting

Accountant’s Copy to company file, 549-550

data files from other software, 34-38

Peachtree, 36-38

Quicken, 35-36

correcting

accounts payable errors

misapplied vendor credits, 238-239

open vendor bills paid with Write Checks transaction, 236-238

accounts receivable errors

customer payment errors, 342-346

deposits, 347-353

misapplied credit memos, 346-347

open balance, removing from customer invoice, 338-342

one-sided items, 105-108

sales tax errors, 354-361

undeposited fund account errors, 361-366

corrupt data

causes of, 570

detecting with Verify Data utility, 568-569

list corruption, repairing, 574-575

program files, repairing, 579

cost of goods sold, in chart of accounts list, 79

creating

Accountant’s Copy of data, 523-529

assemblies, 131-133

backup files, 561-564

customer refund checks, 315-316

data files, 24-25

EasyStep Interview, 29-33

from existing company file, 33-34

with Express Start, 25-29

estimates, 290-292

External Accountant user type, 655-656

group items, 133-134

invoices, 292-294

lead records, 273-274

memorized transactions, 298-300

new accounts, 80-82

payment terms, 281-282

payroll accounts, 384-385

Portable Company File, 575-576

price level lists, 280

progress invoices, 300-303

purchase orders, 142-143

report groups, 485-486

sales receipts, 306

sales tax codes, 276-278

sales tax group items, 275-276

sales tax items, 274-275

subitems, 110

supporting documents, 684-685

templates, 285-289

Time and Expense invoices, 304-306

vendor credits, 207-208

Credit Card Audit Trail report, 508-510

credit cards

accounts, reconciling, 458-460

bills, paying and recording, 251-252, 447

charges, recording, 446-447

deposits, recording, 313-315

credit memos

issuing for sales tax, 374-375

misapplied, correcting, 346-347

credits, vendor credits

applying, 211-213

creating, 207-208

.CSV files, exporting reports to, 490-492

Custom Data Layout tool, 285-289

Customer Center, 266-272

jobs, adding, 267-270

transactions, finding, 270-272

customer refund checks, creating, 315-316

customer returns, handling, 155-158

customers

bartering, 244-245

Home Page activities, customizing, 254

sales tax codes, assigning, 279-280

types of, 88-89

Customize My Forms wizard, 282-285

customizing

Accountant Center, 605-607

CDR, tasks, 607-611

Company Snapshot, 473-475

Home page, 46-50

data display, 49-50

icons, 46-49

for vendor activities, 185

Home Page customer activities, 254

item list, 101

preferences

Company Preferences, 51

My Preferences, 52-53

reports, 484

D

data corruption

causes of, 570

detecting with Verify Data utility, 568-569

list corruption, repairing, 574-575

program files, repairing, 579

data files

accountant’s changes, importing, 530-533

backup files, creating, 561-564

cash or accrual basis startup transactions

accounts payable, 69-73

accounts receivable, 65-69

classes, enabling, 87-88

converting from other software, 34-38

Quicken, 35-36

Small Business Accounting, 36-38

creating, 24-25

EasyStep Interview, 29-33

from existing company file, 33-34

with Express Start, 25-29

defragmenting, 565-566

icon bar, 45-47

IIFfiles, importing, 92-94

items

adding, 82-84

types of, 85-86

menu bar, 44

new accounts, creating, 80-82

opening, 54

Peachtree, converting to QuickBooks, 36-38

selecting from multiple data files, 55

shortcuts, 690

startup transactions

bank balance, 71-73

uncleared bank checks, 74-75

title bar, 43

data sharing

for the accountant, 537-550

Accountant’s Copy change file, returning to client, 545-548

Accountant’s Copy, receiving, 539-542

accounting activities, 543-544

data exchange, preparing client for, 538-539

lists, managing, 544

transactions, 545

for the business owner, 522-536

Accountant’s Copy of data, creating, 523-529

method of, selecting, 520-522

date shortcuts, 690

deactivating

accounts, 95-96

items, 108

debit charges, entering, 445

defragmenting data files, Windows Disk Defragmentation utility, 565-566

deleting budgets, 587

depositing

refunds from overpayment of taxes, 435-436

vendor refunds, 250

deposits, tracking, 370-371

detecting corrupt data, 568-569

diagnostic tools, Run Payroll Checkup, 397-400

dialog boxes

Add New Account, 80-82

Company Information dialog box, 422

Make Journal Entries, 241-243

opening, 688

Product Information dialog box, 567-568

Reclassify Transactions dialog box, 615-617

warnings, reinstating, 542

Write Checks, 439

discounts on vendor bills, 213-214

discrepancies in bank account reconciliation, locating, 455-469

downloading the conversion tool, 37

E

EasyStep Interview, advanced setup process, 29-33

editing

budgets, 584-585

employee information in Employee Center, 402-404

inventory part items, 121-123

payroll items, 406-408

preferences

Accounting preferences, 186-188

Bills preferences, 188

Checking preferences, 188-189

General preferences, 190-191

Reports and Graphs, 191-192

shortcuts, 688-689

supporting documents, 683

e-filing tax forms, 423

emailing reports, 493

Employee Center, 401-406

employee information, adding and editing, 402-404

payroll transactions, finding, 404-406

Employee Setup (Payroll Setup Interview), 392-393

employees

paycheck advances

automatic repayment deductions, 429-430

loan details, tracking, 430-431

paying, 427-429

paying, 413-414

enabling

classes, 87-88

Inventory preferences, 115-118

entering

debit charges, 445

mid-year 1099 balances, 248-249

purchase orders, 204

timesheets (employee), 411-412

vendor bills, 145-146, 205-207

equity, in chart of accounts list, 79

Equity accounts, reviewing, 505

errors in sales tax errors, correcting, 354-361

estimates, creating, 290-292

Excel

reports, 420-421

reports, exporting to, 490-492

existing company files, creating new data files from, 33-34

expenses in chart of accounts list, 79-80

exporting

QuickBooks Timer activities, 598-599

report templates, 489

reports, to Excel, 490-492

Express Start, creating data files, 25-29

External Accountant user type, 538

configuring, 38-39

creating, 655-656

F

federal identification, requirements, 382-383

file types, 518

filed payroll returns, comparing with payroll summary, 426-427

Finance Charge preference, effect on accounts payable, 258-259

financial reports

balance sheets, 59-61

income statements, 61

statement of cash flows, 61-62

finding

missing accounts, 671-672

payroll transactions in Employee Center, 404-406

vendor transactions, 198-200

forms

accounts payable, 200-202

Customize My Forms wizard, 282-285

funds, transferring between bank accounts, 448

G

General preferences, 190-191

generating Missing Customer Invoices report, 328

group items, 119-120, 149-150

creating, 133-134

sales tax group items, creating, 275-276

H

handling

backorders, 152-155

inventory returns, 155-158

reviewing, vendor returns, 158

Headers & Formatting tab (Report Designer), 666-667

Help options, accessing, 53

Home Page

Company Snapshot, setting as default page, 476

customer activities, customizing, 254

customizing, 46-50

for vendor activities, 185

data display, customizing, 49-50

icons, customizing, 46-49

I

icon bar, 45-47

Calc icon, adding, 47

icons, customizing on Home page, 46-49

identifying uncleared transactions, 464-465

IIF (Intuit Interchange Format) files

importing, 92-94, 127-128

importing

accountants’ changes, 530-533

IIF files, 92-94, 127-128

report templates, 490

timer activities, 599-600

income, in chart of accounts list, 79

income statements, 61

installing

maintenance releases, 560-561

QuickBooks

for multi-user mode, 554-555

required Windows permissions, 557-558

for single-user mode, 554

QuickBooks Timer, 596

Intuit Data Protect, 567

Intuit Online Payroll subscription, 381

inventory

accounting, overview, 111-112

aged accounts payable, reviewing, 176

aged item receipts, reviewing, 173-176

average cost valuation, reviewing, 170-173

backorders, handling, 152-155

features of different QuickBooks versions, 111-115

items

adding, 121-137

assemblies, 119-120, 131-133, 150-152

group items, 119-120, 133-134, 149-150

inventory part, 119

non-inventory part, 119

prices, changing, 128-130

receiving, 143-145

Multiple Unit of Measure feature, 134-137

negative inventory, 178-183

average cost from prior purchase transactions, handling, 179-183

paying for, 146-148

physical inventory count, performing, 160

quantity adjustments, 161-162

returns, handling, 155-158

selling, 148-149

value adjustments, performing, 162-165

vendor bill, entering, 145-146

vendor returns, handling, 158

Inventory Center, 165-166

Inventory feature

preferences, 115-118

purchase orders, creating, 142-143

transactions, types of, 139

inventory part item, 119

adding, 121-123

Inventory task group (CDR), 638-643

Inventory Valuation Summary report, comparing with Balance Sheet Inventory Asset report, 168-170

invoices

batch invoicing, 295-297

creating, 292-294

print queue, eliminating, 353

progress invoices, creating, 300-303

templates, creating, 285-289

Time and Expense invoices, creating, 304-306

issuing credit memos for sales tax, 374-375

Item Listing report, 102-103

items, 84-85

for accounts payable, reviewing setup, 221

deactivating, 108

inventory items

adding, 121-137

assemblies, 119-120, 131-133, 150-152

group items, 119-120, 133-134, 149-150

inventory part, 119

non-inventory part, 119

prices, changing, 128-130

receiving, 143-145

merging, 109-110

one-sided items, correcting, 105-108

payroll

adding and editing, 406-408

reporting, 409-410

sales tax, creating, 274-275

subitems, creating, 110

types of, 85-86

J-K

jobs, adding to Customer Center, 267-270

Jobs & Estimates preference, effect on accounts payable, 259

journal adjustments, for accounts payable, 241-243

L

Lead Center, 272-274

Learning Center, tutorials, 50

liabilities

balances, comparing with balance sheet, 424-425

in chart of accounts list, 78-79

sales tax, reconciling to balance sheet sales tax payable, 332-334

scheduled liabilities, paying, 416-417

lists

Add/Edit Multiple List Entries feature, 125-127

chart of accounts

accounts, merging, 96-98

Add/Edit Multiple List Entries feature, 90-92

assets, 78

cost of goods sold, 79

equity, 79

expenses, 79-80

income, 79

liabilities, 78-79

new accounts, creating, 80-82

payroll accounts, creating, 384-385

preferences, 89-90

required accounts, 95

subaccount relationships, 98-100

classes, 86-88

customer lists, reviewing, 329

IIF (Intuit Interchange Format) files, importing, 92-94

items, 84-85

adding to data file, 82-84

deactivating, 108

merging, 109-110

one-sided items, correcting, 105-108

reviewing, 100-102

subitems, creating, 110

types of, 85-86

list corruption, repairing, 574-575

managing, 544

price level lists, creating, 280

reviewing, 94

synchronizing with Microsoft Outlook, 592-594

Loan Manager, 587-591

new loans, setting up, 588-589

payments, setting up, 589-591

loans, employee paycheck advances

automatic repayment deductions, 429-430

loan details, tracking, 430-431

paying, 427-429

lost checks, reprinting, 431-433

M

maintenance releases, installing, 560-561

Make Journal Entries dialog box, 241-243

managing

credit cards, preferences affecting, 437-438

inventory

aged accounts payable, reviewing, 176

aged item receipts, reviewing, 173-176

average cost valuation, reviewing, 170-173

Inventory Center, 165-166

Inventory Valuation Summary report, comparing with Balance Sheet Inventory Asset balance, 168-170

negative inventory, 178-183

Report Center, 166-168

returns, 155-158

lists, 544

payroll, tax vendors, 385-387

report groups, 487-488

matching principle, 57-58

memorized reports, 488-489

memorized transactions, 689

creating, 298-300

memorizing recurring transacdtions, 249-250

menu bar, 44

merging

accounts in chart of accounts, 96-98

items, 109-110

Microsoft Outlook, synchronizing lists, 592-594

Microsoft Word, QSW toolbar, 682

mid-year 1099 balances, entering, 248-249

Mid-Year Payroll Setup (Payroll Setup Interview), 394-397

misapplied credit memos, correcting, 346-347

misapplied vendor credits, correcting, 238-239

Miscellaneous task group (CDR), 648-652

missing accounts, finding, 671-672

Missing Customer Invoices report, generating, 328

modifying

report options, 482-484

Statement Writer reports, 669-679

supporting documents, 680-681

multiple list entries, adding, 90-92

Multiple Unit of Measure feature, 134-137

multi-user mode, QuickBooks installation, 554-555

multiyear bank reconciliation, completing, 465

My Preferences, 479

customizing, 52-53

N

navigating

icon bar, 45-47

menu bar, 44

title bar, 43

negative inventory, 178-183

average cost from prior purchase transactions, handling, 179-183

new loans, setting up, 588-589

non-inventory part, adding, 123-125

non-inventory part item, 119

non-payroll transactions, researching, 405-406

O

one-sided items, correcting, 105-108

Online Banking feature, 449-458

activating, 449-450

deposits, assigning to open customer invoices, 456-457

downloaded transactions, adding to QuickBooks, 452-453

online payments, 458

renaming rules, 453-454

transactions

adding/deleting, 457

assigning to open vendor bills, 455-456

retrieving, 450-452

open balance, removing from customer invoice, 338-342

Open Invoices report, reviewing, 321-322

open vendor bills paid with Write Checks transaction, correcting, 236-238

Open Windows List, 50

opening

data files, 54

dialog boxes, 688

previously created reports in QSW, 668

Report Center, 166-168

sample data files, 23

Opening Balance Equity account, troubleshooting, 512-515

operating environment, protecting, 564-566

overpayments

refunding, 317

of taxes, deposting refunds, 435-436

overview of payroll, 377-379

P

partially-paid balances, preparing reports, 67-69

partially-paid vendor bills, preparing reports, 71-73

paychecks, printing, 415

payment transaction list detail reports, creating, 350

payments

credit card bills, 251-252

for employees, 417-418

recording, 308-311

sales tax, 334-337

scheduled liabilities, 416-417

terms, creating, 281-282

Payments preference, effect on accounts payable, 255-256

payroll

Employee Center, 401-406

employee paycheck advances

automatic repayment deductions, 429-430

paying, 427-429

items

adding and editing, 406-408

reporting, 409-410

liabilities

adjusting, 417-418

balances, comparing with balance sheet, 424-425

scheduled liabilities, paying, 416-417

overview, 377-379

paychecks, adjusting, 434-435

payroll summary, comparing with filed payroll returns, 426-427

preferences, 387-389

refunds, depositing, 435-436

requiired state and federal identification, 382-383

Run Payroll Checkup diagnostic tool, 397-400

service subscriptions, activating, 379-381

tax tables, updating, 381-382

taxable bonuses, paying to employees, 433-434

timesheets (employee), entering, 411-412

workers, classifying as employees, 382

Payroll Setup Interview, 390-397

Company Setup, 391-392

Employee Setup, 392-393

Mid-Year Payroll Setup, 394-397

Tax Setup, 393-394

Payroll task group (CDR), 643-646

PDF, saving CDR review as, 652

Peachtree, converting data files to QuickBooks, 36-38

performing

physical inventory count, 160

value adjustments, 162-165

permissions

configuring, 40

required Windows permissions for installation, 557-558

physical inventory count, performing, 160

Pivot Tables (Excel), reports, 420-421

Portable Company File, creating, 575-576

preferences

for accounts payable

1099 forms, 192-193

Accounting, 186-188

Bills, 188

Checking preferences, 188-189

General preferences, 190-191

Reports and Graphs, 191-192

in chart of accounts, configuring, 89-90

Company Preferences, customizing, 51

of Inventory feature, 115-118

My Preferences, customizing, 52-53

for payroll, 387-389

Reporting preferences

Company Preferences, 479-482

My Preferences, 479

Preferences and Formats menu (QuickBooks Statement Writer), 660-663

preparing

client for data exchange with accountant, 538-539

employee paychecks, 413-414

QuickBooks Timer for activities, 597

tax forms, 422-423

prepayments, recording, 245-247

price level lists, creating, 280

prices, changing for inventory items, 128-130

principles of accounting

accrual versus cash basis reporting, 59

matching principle, 57-58

printing

budget reports, 585

checks, 443-445

paychecks, 415

tax forms, 422-423

prior year balance, reviewing on balance sheet, 497

Product Information dialog box, 567-568

Profit & Loss Standard report, 102-105

reviewing, 505-506

program files, repairing, 579

progress invoices, creating, 300-303

purchase orders

creating, 142-143

entering, 204

Q

.QBA files, 522

.QBB files, 520-521

.QBM files, 521

.QBW files, 520

QSW toolbar in Microsoft Word, 682

QBWin.log file, viewing, 571-574

.QBX files, 521

.QBY files, 522

quantity adjustments, performing, 161-162

QuickBooks

benefits for business owner, 517-518

benefits for the accountant, 518

system requirements, 552-553

QuickBooks Accountant 2012, 523

QuickBooks Company File tool, 577-578

QuickBooks Connection Diagnostic Tool, 558

QuickBooks Database Server Manager, 555-557

QuickBooks Enterprise Solutions 12.0, inventory features, 114-115

QuickBooks Premier 2012, inventory features, 113

QuickBooks Pro 2012, inventory features, 112-113

QuickBooks Statement Writer

launching, 659-660

new reports, creating from memorized reports, 668

Preferences and Formats menu, 660-663

previously created reports, opening, 668

Report Designer

Columns tab, 664

Headers & Formatting tab, 666-667

Report Content tab, 663

Review & Finish tab, 667-668

Rows/Accounts tab, 664-666

reports, printing, 685-686

Statement Writer reports, modifying, 669-679

supporting documents, 680-685

creating, 684-685

editing, 683

QuickBooks Timer

activities, exporting, 598-599

installing, 596

preparing for activities, 597

time, tracking, 597-598

Quicken, converting data files to QuickBooks, 35-36

R

Rebuild Data utility, 576-577

receipts, aged item receipts

removing, 239-240

reviewing, 218-220

receiving

Accountant’s Copy, 539-542

items into inventory, 143-145

Reclassify Transactions dialog box, 615-617

reconciliations

restarting, 470

troubleshooting, 461-472

reconciling

with adjustment, 471-472

A/P Aging Summary report to balance sheet, 215-216

balance sheet A/R to A/R Aging Summary total, 322-323

credit card accounts, 458-460

financials and sales tax reports, 359-360

payroll reports to business financials, 427

sales tax liability balance sheet to sales tax payable, 332-334

total sales to total income, 331-332

while Accountant’s Copy is pending, 529-530

recording

bank deposits, 311-313

bounced checks, 368-369

credit card bills, 251-252

credit card charges, 446-447

credit card deposits less a discount fee, 313-315

customer payments, 308-311

statement charges, 307-308

vendor bills, 205-207

vendor prepayments, 245-247

recurring transacdtions, memorizing, 249-250

refunds

customer refund checks, creating, 315-316

for overpayments, 317

vendor refunds, depositing, 250

reinstating warnings, 542

Reminders preference, effect on accounts payable, 259-260

removing

subaccount relationships, 98-100

vendor bills, 239-240

renaming rules, 453-454

reopening a CDR review, 654

repairing

company files, 576-577

list corruption, 574-575

program files, 579

Report Center, 166-168, 476-479

views, 419

Report Content tab (Report Designer), 663

Report Designer

Columns tab, 664

Headers & Formatting tab, 666-667

Report Content tab, 663

Review & Finish tab, 667-668

Rows/Accounts tab, 664-666

report groups, 485-487

creating, 485-486

managing, 487-488

report templates

exporting, 489

importing, 490

Reporting preferences

Company Preferences, 479-482

My Preferences, 479

reports

A/P Aging Summary report, reconciling to balance sheet, 215-216

A/R Aging Summary, reviewing, 319-321

budgets, printing, 585

cash-basis Balance Sheet report, accounts payable balance, 222-225

Credit Card Audit Trail report, 508-510

customizing, 484

emailing, 493

Excel reports, 420-421

exporting to Excel, 490-492

Inventory Valuation Summary report, comparing with financials, 168-170

Item Listing report, 102-103

memorized reports, 488-489

Missing Customer Invoices report, 328

Open Invoices report, reviewing, 321-322

options, modifying, 482-484

payment transaction list detail reports, creating, 350

payroll, reconciling to business financials, 427

Profit & Loss Standard report, 102-105

reviewing, 505-506

Statement Writer reports, modifying, 669-679

for tracking employee loan details, 430-431

Transaction List by Date report, 511-512

Unpaid Bills Detail report, reviewing, 216-218

Reports and Graphs preference, 191-192

effect on accounts payable, 260-261

reprinting lost checks, 431-433

required accounts in chart of accounts, 95

required state and federal identification, 382-383

researching

payroll and non-payroll transactions, 405-406

vendor transactions, 199-200

restarting bank reconciliations, 470

restoring Portable Company File, 575-576

retrieving online transactions, 450-452

returning Accountant’s Copy change file to client, 545-548

Review & Finish tab (Report Designer), 667-668

Review List Changes feature (CDR), 618-623

reviewing

aged item receipts, 218-220

A/R Aging Summary, 319-321

Audit Trail report, 507

balance sheets

account types, 497

bank account balance, 498

Credit Card account balance, 503

Equity accounts, 505

Other Current Asset accounts, 501-502

prior year balance, 497

Sales Tax payable balance, 504

undeposited funds, 499-500

bank reconciliation reports, 468

customer lists, 329

inventory

aged item receipts, 173-176

average cost valuation, 170-173

item list, 100-102

items, for accounts payable, 221

lists, 94

Open Invoices report, 321-322

reports, Profit & Loss Standard report, 505-506

uncleared transactions, 465-468

Unpaid Bills Detail report, 216-218

voided/deleted transactions, 469

Rows/Accounts tab (Report Designer), 664-666

S

Sales & Customers preference, effect on accounts payable, 257

sales orders, 152-155, 292

sales receipts, creating, 306

sales tax

codes, creating, 276-278

credit memos, issuing, 374-375

errors, correcting, 354-361

multiple rates on one invoice, paying, 334-337

state-imposed maximum sales tax, tracking, 371-372

sales tax group items, creating, 275-276

sales tax items, creating, 274-275

Sales Tax preference

effect on accounts payable, 262-263

Sales Tax task group (CDR), 633-638

sample data, 23-24

saving CDR review as PDF, 652

scheduled liabilities, paying, 416-417

selecting

data files from multiple data files, 55

data sharing method, 520-522

selling inventory, 148-149

Send Forms preference, effect on accounts payable, 263-264

Service items, adding to data file, 82-83

service subscriptions (payroll)

activating, 379-381

sharing data

for the accountant, 537-550

Accountant’s Copy change file, returning to client, 545-548

Accountant’s Copy, receiving, 539-542

accounting activities, 543-544

data exchange, preparing client for, 538-539

lists, managing, 544

transactions, 545

for the business owner, 522-536

Accountant’s Copy of data, creating, 523-529

vendor bills, 209-211

shortcuts

data files, opening, 690

for dates, 690

dialog boxes, opening, 688

memorized transactions, 689

miscellaneous, 691

standard text editing, 689

transactions, editing, 688

single-user mode, QuickBooks installation, 554

Small Business Accounting, converting data files to QuickBooks, 36-38

Spelling preference, effect on accounts payable, 264-265

state identification, requirements, 382-383

state-imposed maximum sales tax, tracking, 371-372

statement charges, recording, 307-308

statement of cash flows, 61-62

Statement Writer reports, modifying, 669-679

subaccount relationships, 98-100

subitems, creating, 110

supporting documents, 680-685

creating, 684-685

editing, 683

modifying, 680-681

symptoms of database corruption, 570-571

synchronizing lists with Microsoft Outlook, 592-594

system requirements for QuickBooks, 552-553

T

tasks in CDR, customizing, 607-611

tax code, proper assignment of, 330-331

tax forms

1099 forms

1099-MISC payments, reporting, 226-235

mid-year balances, entering, 248-249

preferences, 192-193

e-filing, 423

printing, 422-423

Tax Setup (Payroll Setup Interview), 393-394

tax tables, updating, 381-382

tax vendors, 385-387

taxable bonuses, paying to employees, 433-434

templates

creating, 285-289

report templates

exporting, 489

importing, 490

terms for payments, creating, 281-282

text editing shortcuts, 689

time, tracking with QuickBooks Timer, 597-598

Time and Expense invoices

creating, 304-306

Time and Expense preference, 389

effect on accounts payable, 265-266

timesheets (employee), entering, 411-412

title bar, 43

total sales, reconciling to total income, 331-332

tracking

1099-MISC payments, 226-235

changes to closed account periods, 506-507

customer deposits, 370-371

employee loan details, 430-431

state-imposed maximum sales tax, 371-372

time with QuickBooks Timer, 597-598

Transaction List by Date report, 511-512

transactions

accounts payable, 202

accounts receivable, 289-290

data sharing for the accountant, 545

memorized transactions, 689

creating, 298-300

non-payroll transactions, researching, 405-406

online transactions, retrieving, 450-452

payroll transactions, researching, 405-406

recurring, memorizing, 249-250

types of, 139

uncleared, identifying, 464-465

uncleared transactions, reviewing, 465-468

vendor transactions, finding, 198-200

voided/deleted transactions, reporting on, 510-511

Write Check transactions, 438-445

transferring funds between bank accounts, 448

Troubleshoot Prior Account Balances tool, 611-615

troubleshooting

accounts payable errors

misapplied vendor credits, 238-239

open vendor bills paid with Write Checks transaction, 236-238

Opening Balance Equity account, 512-515

payroll

liability balances, comparing with balance sheet, 424-425

payroll summary, comparing with filed payroll returns, 426-427

reports, reconciling to business financials, 427

with QuickBooks Company File tool, 577-578

with QuickBooks Connection Diagnostics Tool, 558

reconciliations, 461-472

with Run Payroll Checkup diagnostic toll, 397-400

tutorials, 50

type of items, 85-86

U

uncleared bank checks, configuring startup transactions, 74-75

uncleared transactions, reviewing, 465-468

undeposited funds

errors, correcting, 361-366

reviewing, 499-500

Unpaid Bills Detail report, reviewing, 216-218

updating payroll tax tables, 381-382

upgrading QuickBooks version, 559-560

UPS power protection, 564

user accounts

External Accountant user type

configuring, 38-39

creating, 655-656

permissions, configuring, 40

V

value adjustments, performing, 162-165

vendor bills

discounts, 213-214

entering, 145-146

paying, 209-211

recording, 205-207

Vendor Center, 193-200

transactions, finding, 198-200

vendors

adding to data file, 194-198

bartering, 244-245

as customers, 366-368

prepayments, recording, 245-247

refunds, depositing, 250

returns, handling, 158

tax vendors, 385-387

transactions, finding, 199-200

Verify Data utility, 568-569

versions of QuickBooks

comparing, 21

effect on data sharing, 519

inventory features, 112-115

upgrading, 559-560

viewing QBWin.log file, 571-574

views, Report Center, 419

virus protection, 564-565

voided/deleted transactions

reporting on, 510-511

reviewing, 469

W

warnings, reinstating, 542

Windows Disk Defragmentation utility, 565-566

Windows permissions, requirements for QuickBooks installation, 557-558

workers, classifying as employees, 382

workflow

for accounts payable, 202-204

CDR, 601-602

Write Check transactions, 438-445

Write Checks dialog box, 439

writing checks, 440-442

X-Y-Z

year of QuickBooks version, effect on data sharing, 519

year-end adjusting journal entry, recording to accounts receivable, 366

Year-End Guide, 591-592

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset