|Resources for Serious Bookkeepers|  Addventive Academy  | About | News | Resources | Order | Contact | Home |



» Resources Main Page


» Canadian Bookkeeping Links


» Seminars and Courses


» Excerpts


» Table of Contents


   NEW!
» DOWNLOADABLE OFFICE FORMS


CLICK TO ORDER      Acceptance Mark
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!

DOWNLOADABLE OFFICE FORMS

Every office needs help with drafting forms that are commonly used.  Choose from our downloadable forms to keep your office or a client's office accountable.  Click on each link to view the PDF form:

» accounting memo generic
» employ annual pay rec spreadsheet
» employ calc spreadsheet
» employ pay timesheet generic
» employ PD7A calc spreadsheet
» employment application generic
» expense claim generic
» fax cover pg generic
» je account rec generic
» memo handwritten generic
» mileage log generic
» rules to work by office employee
» sales cash out rec retail
» spreadsheet generic
»
yr end checklist generic
 




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

 

 

 

 




|Resources for Serious Bookkeepers|  Addventive Academy  | About | News | Resources | Order | Contact | Home |