|Addventive Bookkeeping    | About | News | Excerpts | Book Contents | Resources | Training | Contact | Order | Home |



   NEW!
» DOWNLOADABLE OFFICE FORMS


bk cover small

Bookkeeping With QuickBooks ® In Canada
by Arlene Nora Arlow

The best book on the best-selling bookkeeping software, by one of the most expert users in Canada.  Get an in-depth exposure to the software, and learn powerful tricks and tips as you progress.

CLICK HERE to order!




Bookkeeping with QuickBooks Bookkeeping With QuickBooks In Canada

TABLE OF CONTENTS 

CHAPTER 1 - INTRODUCTION TO BOOKKEEPING

 

What Are Good Books And Why Are They Important?

1-1

Knowledge Is Power:  How Good Books Can Help The Business Succeed

1-1

What Is "Reasonable"?

1-2

The Language Of Accounting

1-2

Basic Bookkeeping Principles:  Assets, Liabilities, Equity, Income And Expenses

1-2

The Accounting Equation 

1-3

Debits And Credits 

1-4

Types Of Business Entities:  Proprietorship, Partnership, Limited Company

1-4

What Kind Of Taxes Are There In Canada?

1-5

What Is A Fiscal Period?

1-6

What Is A Chart Of Accounts?

1-6

What Is The General Ledger?

1-7

GAAP, Accrual Accounting And Other Official Stuff

1-7

Do I Need To Understand Bookkeeping To Use QuickBooks?

1-8

The “Who” and “What” In QuickBooks

1-8

 

 

CHAPTER 2 - QUICKBOOKS FEATURES

 

Where To Find It In QuickBooks

2-1

 

 

Chapter 3 - INSTALLING, UPDATING, REGISTERING QUICKBOOKS

 

Before Installing/Reinstalling QuickBooks:  Creating A Backup Folder

3-1

Installing/Reinstalling QuickBooks

3-5

Launching QuickBooks For The First Time

3-13

Sample Companies:  Opening A Sample Company File

3-15

Registering QuickBooks

3-18

Update Service

3-23

Loading Updates

3-26

Checking Your QuickBooks Version Release Number

3-28

Payroll Tax Tables

3-29

Payroll Service Key

3-30

My License

3-31

Manually Downloading And Installing QuickBooks Updates

3-32

 

 

CHAPTER 4 - CREATING A COMPANY AND MOVING AROUND THE DESKTOP

 

Creating A Company File - The Quick Method

4-1

Newcomers:  Moving Around In QuickBooks

4-10

Menus

4-15

Icon Bar - Removing From And Adding To

4-17

Customer Centre

4-21

Vendor Centre

4-23

Employee Centre

4-25

Report Centre

4-28

The Home Page And The Coach

4-31

Closing All Windows

4-34

“ALT” Key

4-34

Keyboard Shortcuts

4-35

Password

4-36

 

 

cont’d

 

CHAPTER 5 - SETTINGS AND THE CHART OF ACCOUNTS

 

QuickBooks Login

5-1

Deleting A User

5-2

Are We There Yet? - What To Do First After You Have Created A Company File

5-3

Company Information

5-3

Preferences

5-4

Chart of Accounts:  Automatically Creating Accounts

5-8

Chart Of Accounts:  An Overview

5-11

Chart Of Accounts:  Account Numbers

5-14

Chart Of Accounts:  Sorting & Resorting Account Order

5-15

Printing The Account Listing Report

5-17

Chart Of Accounts:  Default Accounts

5-21

Chart Of Accounts:  Editing Accounts

5-22

Chart Of Accounts:  Tax-Line Mapping

5-30

Chart Of Accounts:  Adding Accounts

5-32

Chart Of Accounts:  Parent And Subaccounts

5-42

Start Date

5-45

Chart Of Accounts:  Opening Balances

5-45

Reviewing, Editing, Or Changing A Transaction In A Register

5-54

Preferences:  Banking, Cheques And Paycheques

5-59

Chart Of Accounts:  GST/HST or PST Opening Balance

5-60

Chart Of Accounts:  Opening Balances Uncleared Bank Transactions

5-62

Chart Of Accounts:  Deleting Accounts

5-67

Chart Of Accounts:  Changing An Account Type

5-69

Chart Of Accounts:  Making An Account Inactive Or Active

5-71

Chart Of Accounts:  Merging Accounts

5-73

Opening Balances:  I Forgot An Account Opening Balance

5-76

The Journal Report

5-77

Item List

5-83

Item List:  Adding An Item And An Account To The COA On-the-fly

5-89

Item List:  Customer Payments, Undeposited Funds And Payment Methods

5-92

Item List:  Sales Tax Items

5-94

Item List:  Making An Item Inactive

5-97

Sales Tax Code List

5-97

Sales Tax Code List:  Making A Code Inactive Or Active

5-99

Multicurrency:  Turning On And The Chart Of Accounts

5-100

 

 

CHAPTER 6 - BASIC CUSTOMER (RECEIVABLES) TASKS

 

Customer Centre And Opening Balances For Customers

6-1

Opening Balances:  I Forgot A Customer Opening Balance

6-9

Customer Types

6-9

Invoices

6-10

Invoices:  Credit Limit And Price Over-rides

6-15

Invoices:  Removing The Class Column

6-17

Credit Memos And Customer Adjustments

6-17

Applying Credits Against Invoices

6-21

Reports:  A/R Aging Report

6-26

Reports:  A/R Aging Report

6-28

Invoices And Credit Memos:  Inserting A Blank Line, Deleting A Line

6-31

Sales Receipts

6-36

Spell Check On Sales Transactions

6-41

Printing Invoices, Credit Memos And Sales Receipts

6-42

   

cont’d

 

CHAPTER 6 - cont’d

 

Adding A Non-printing Memo To An Invoice, Credit Memo Or Sales Receipt

6-45

Customers: Writing Off Bad Debts

6-46

 

 

CHAPTER 7 - BASIC VENDOR (PAYABLES) TASKS

 

Vendor Centre And Opening Balances For Vendors

7-1

Opening Balances:  I Forgot A Vendor Opening Balance

7-9

Vendor Types

7-9

Bills

7-10

Transaction Not In Balance:  Over-riding Sales Taxes

7-17

Bill Credits

7-19

Jobs:  Charging Expenses To A Customer

7-20

Chart Of Accounts:  The Accounts Payable Register

7-28

Applying Bill Credits To Bills

7-31

Bill Payment Cheques

7-38

Revising Cheque Numbers In The Bank Register

7-45

Vendor Overpayments

7-47

Cheques

7-48

Cheque Numbers

7-55

Credit Card Transactions

7-56

Using Credit Cards To Pay Bills

7-63

Payments To Credit Cards

7-66

Adding (And Searching For) A Memo In A Cheque, Bill Or Credit Card Transaction

7-67

Printing Cheques Or Bill Payment Cheques

7-72

Using The Journal Entry To Post Business Expenses Paid For By Cash

7-76

 

 

CHAPTER 8 - BASIC BANKING TASKS

 

Manual Cheques, Printed Cheques And Duplicate Cheque Numbers

8-1

Extraordinary Bank Deposits

8-2

Bank Deposits From Undeposited Funds

8-3

Adding A Column To A “QuickReport”

8-10

Deposit Summary Reports

8-14

Bank Service Charges

8-15

Creating A Memorized Transaction

8-18

Bank Interest Income

8-25

Stale-Dated Cheques And Old Banking Transactions

8-27

The Bank Reconciliation

8-28

To Reconcile A Credit Card Account

8-36

 

 

CHAPTER 9 - INVENTORY

 

Turning On Inventory

9-1

Adding Inventory Accounts To The Chart Of Accounts

9-2

Items For Resale Not Posted In Inventory

9-5

Inventory & Inventory Items

9-6

Receiving Inventory (Bills)

9-10

Changing Item Prices In Inventory

9-13

Adjusting Inventory

9-14

Inventory Valuation Summary Report

9-16

 

 

CHAPTER 10 - GST/HST RETURNS

 

What Is "In Trust"?

10-1

GST/HST Periods And Due Dates

10-1

   

cont’d

 

CHAPTER 10 - cont’d

 

GST/HST Installments

10-2

GST/HST And Journal Entries

10-2

QuickBooks Reports For The GST/HST Return

10-3

The “File Sales Tax” Feature

10-5

 

 

CHAPTER 11 - REPORTS AND REPORT TOOLS

 

QuickReport

11-2

Balance Sheet

11-3

Profit & Loss (Income Statement)

11-4

Trial Balance

11-6

A/R Aging And A/P Aging

11-7

The Journal (The Most Useful Report)

11-8

The General Ledger

11-9

Memorized Reports

11-11

Printing Memorized Reports

11-15

Sorting Report Columns

11-16

Removing A Report Column

11-17

Adding A Report Column

11-19

Previewing And Printing Reports With Many Columns

11-20

Print Settings

11-23

Printing One of Multiple Pages

11-24

Foreign Currency Columns For Reports

11-24

 

 

CHAPTER - 12 PAYROLL

 

What To Do First

12-1

Company Information

12-2

Preferences:  Turning On Payroll

12-2

Subscribing To The QuickBooks Payroll Service And Payroll Tax Tables

12-3

Fine-Tuning The Chart Of Accounts For Payroll

12-3

Editing The Payroll Item List

12-5

Adding Payroll Items

12-10

Workers Compensation - Set Up

12-22

Benefits

12-28

Payroll Schedule

12-29

Payroll Defaults And Vac Pay

12-31

Important Things To Note Regarding Payroll

12-35

The Employee Centre:  Adding Employees

13-36

Employee Opening Balances:  Year-to-Date (YTD) Amounts

12-44

Creating A Paycheque And Printing A Paystub

12-56

Other Paycheque Scenarios

12-66

Verifying Vacation Pay Balances - QuickReport

12-75

Releasing An Employee And The ROE

12-80

PD7A Report

12-84

Payroll Liabilities - Federal

12-85

Payroll Liabilities - Workers Compensation

12-89

The Payroll Liability Balances Report

12-91

TD1 Amounts

12-93

Workers Compensation Annual Maintenance

12-93

T4’s

12-101

 

 

cont’d

 

CHAPTER 13 - QUICKBOOKS MAINTENANCE AND TOOLS

 

Adjustments After Customer, Vendor And Employee Opening Balances

13-1

Using QuickBooks Cell Calculator

13-3

Setting The Number Of Company Files To Display

13-3

Closing Date

13-6

Data Integrity And Corrupt Transactions

13-8

Computer Maintenance And Technical Support

13-9

Customizing Forms (Templates)

13-10

Printer Alignment And Settings

13-18

Dates (Display)

13-20

Back Ups (Onsite And Offsite)

13-21

Restoring A Backup File

13-26

 

 

Credits

13-33

 

 

Index

Index-1

 

 

 

 




|Addventive Bookkeeping    | About | News | Excerpts | Book Contents | Resources | Training | Contact | Order | Home |