BBS Advance Bookkeeping Certification Course using QuickBooks Desktop:

  • 100 hours of classroom and individual training via on-site, phone or internet support
  • Applicants must pass a skill based test on Introductory Accounting Principles, Basic Excel, and Basic QuickBooks
  • Classroom training will be at the location of Bernal Business Services Inc and will include lectures and practice
  • On-site training will be at the employers location with a focus on the application of classroom theory in the real world

Topics covered include:

    • Labour cost topics (20 hours):
      • filing the annual T4, T5018, WCB annual returns, dealing with PIER report requests from the government (5 hours)
      • Correcting payroll errors in QuickBooks (2 hours)
      • Dealing with employee loans / advances (1 hour)
      • Accounting for Expense Reimbursements and chargebacks to subcontractors (1 hour)
      • Alberta Labour Standards and their application to employees (8 hours)
        • Know the difference between and “employee” and “self-employed” individual.  Both individuals can be “contractors”.
      • Issuing ROE’s (2 hours)
    • Reconciling accounts (10 hours):
      • Bank and credit card reconciliations (2 hours)
      • Loan, mortgage , and investment reconciliations (2 hours)
      • Holdback and Retainage account (2 hours)
      • Vendor statement reconciliations including differences between vendor records and Allstyle records (4 hours)
      • Expense report reconciliations (where people pay for things and are then reimbursed by Allstyle, or, where individuals such as Alex use the Allstyle credit card for personal expenses and then have this deducted from his cheque) (2 hours)
    • Recording monthly transactions and accruals such as (14 hours):
      • Prepaid expenses (i.e. – insurance paid in one lump sum, but should be broken out monthly and show on the Profit and Loss Statement each moth (1 hour)
      • Calculating and recording depreciation (4 hours)
      • Accruing labour costs to the proper period (ie: cut off is March 30th but the cheques are dated the April 1st.  Your total labour cost for that period shows up in April, but actually applies to March) (3 hours)
      • Accruing projected income to the proper periods (ie. You have a job that takes 2 months to complete.  One third of it is completed in February, and the balance is completed in March.  You invoice April 1.  An estimate of the amount earned Feb 28, and March 30, should be entered into the bookkeeping) (6 hours)
    • Reviewing the Financial Statements (6 hours)
      • Are they reasonable (are there monthly amounts showing for mortgage interest, insurance costs, property taxes)
      • Reviewing % comparisons, (eg. Sales increased 30% – has labour also increased 30%?  If not is it significantly higher or lower – if your sales go down, has your labour cost gone down as well?  What about material costs?)
      • Reviewing the General Ledger
    • Other accounting functions (20 hours):
      • Filing GST and preparing the Year End Working papers for the accountant (8 hours)
      • What is deductible and not deductible (how to maximize your tax deductible expenses) (8 hours)
      • How to use Revenue Canada online access for your business information (2 hours)
      • Setting up and managing your office (2 hours)
    • Managing TSheets (4 hours):
      • Setting up employees and contractors
      • Setting up schedules
      • Syncing with QuickBooks and importing timesheets

It looks like the course will cost $7,500 plus $300 for materials plus GST.  If approved, the grant will pay 2/3 of this cost up to $10,000 per employee.  Thus, the cost to you, including GST, would be $ 2730.00 (or $27.30/hr)

Training is tentatively broken out as:

  • 9 days of 8 hour classroom training, broken up into 2 – 4 hour sessions (total 72 hours)
  • 30 hours of on-site or phone / internet support as required
  • Classroom training will probably be once a week and on an on-going basis so if a class is missed, it can be made up at a later date.