Monday

Welcome

Welcome to Accounting 12!
This is the self-paced version of Accounting 12. (There is also a class available from February to June.)

In this course you will first learn several new basic accounting procedures that were not included in Accounting 11. Following that you will learn to perform accounting procedures using the computer. You will do this by learning to use the accounting software called Sage 50 Accounting.

Prerequisite: Pass the Accounting 12 assessment or recent completion of Accounting 11 at PALC.
Working knowledge of basic computer operation and Windows functions (for saving and back up)
1.     Materials:
The following book is rented:
  1. Accounting 1, 7th Edition by Syme and Ireland (same text you used for Accounting 11)

Free Download for your home computer:
2.     A student download of Sage 50 Simply Accounting for use on your home computer. Software Instructions:
·        You will download the Sage 50 Simply Accounting 2016 (Do not download other years.
 Here is the link: 
·        Read and re-read the instructions for downloading the software. Here is the link: http://na.sage.com/ca/about-us/education
Follow the directions on the website.
Name of your school: Pearson Adult Learning Centre; 
Type of school: High School
·        If you are able to follow these instructions and successfully download the software, this is a very good indication that you will be successful in this course.
·        If you are having trouble downloading and installing the software, re-read the instructions and follow them exactly.
·        If you still cannot download or install your software, you may ask a teacher to help you.



Other:
  1. Workbook pages: There are several pages you need from the Accounting 1 Workbook (Accounting 11 workbook). You may still have this workbook from Accounting 11. If not, ask a teacher for the copies of the pages as you need them.

  1. Project Handouts

2.     Self-paced students get their assignments from the following website :
Click “Courses”, click “Electives” and click “Accounting 12”

Keep a record of your marks on the attached Marks Record Sheet.

3.     You will provide a memory stick and binder and paper. All assignments should be kept in a neat and orderly fashion. Memory sticks are available at reasonable prices at a variety of stores.

Here is the course:

1.     Chapter 9.3, 10 and Payroll Test                          15%
2.     Project 1                                                               12%
3.     Project 2                                                               12%
4.     Project 3                                                               12%
5.     Project 4                                                               12%
6.     Project 5                                                               12%
7.     Project 6                                                               25%
           100%


Accounting 12

Marks Record Sheet

Chapters
Percent of Total
Mark
Ch. 9.3, 19 and Payroll Test
15%

Project 1
12%

Project 2
12%

Project 3
12%

Project 4               
12%

Project 5              
        12%     

Project 6
25%

Total
100%






Text Work

  • Self-Paced Accounting 12
    Textbook Work

    Complete this work from your Accounting 11 text and workbook

    Chapters 9.3, 10.1-10.5 and Payroll

    A.   Chapter 9.3 Accounting Controls for Cash
    ·       Read pages 355-362
    ·       Do pages 362-367 questions 2 -4
    ·       Do the Bank Reconciliation Exercise below. The answer key is below.


    B.   Chapter 10-Merchandising

    Text Lesson 10.1- Merchandising Business
    • Read pages 396-401
    • Do questions 1-5, pages 402-403

    Text Lesson 10.2- Accounting Procedures for a Merchandising Business
    • Read pages 404-406
    • Do questions 1-3, pages 406-408
    •  
    Text Lesson 10.3 -Work Sheet for a Merchandising Business -
    • Read pages 408-413
    • Do questions 1-3, pages 414-416

    Text Lesson 10.4- Merchandise Returns & Allowances
    • Read pages 417-424
    • Do questions 1-5, pages 424-427

    Text Lesson 10.5- Sales Discounts
    • Read pages 427-431
    • Do questions 1-4, pages 324-434


    D.   Appendix-Payroll

    Text - Read pages 620 – 632
    ·       Do questions 1-3, p.633 – 634


    Review for the Test
    Review Ch. 9.3


    • Page 386-388- #2 and 3
    • Do the bank reconciliation exercise below. The answer key follows 











    Review Ch. 10
    • Page 455-462 #2 -5 and #10-11

    Review Payroll
    ·       Page 634 #4

    As you review, keep in mind that when you write your tests, you are allowed to bring with you TWO page (two sides) of HANDWRITTEN notes. These cannot be typed, photocopied, or reproduced by any other means than your OWN handwriting. When you ask for your test, make sure you show your page to the staff person who hands you the test.

    E. When you’re ready to write your test, go to the PALC lab and ask a teacher for Accounting 12, Chapter Test 9.3, 10 and Payroll Test



Sage 50 Introduction

To print-go to the bottom of the page.

Sage 50 Introductions
Here is a brief introduction to some of the Sage 50 windows. Try and open similar screens on your computer.






















Project 1

To print-go to the bottom of the page.

Self-Paced Accounting Project 1 Muriel’s Murals


In this module you'll get practical experience working with actual accounting files for various "real" companies.
About the Projects
In this module you are given the opportunity to use the accounting skills you have learned by using Sage 50-Accounting to simulate a variety of small-business practices. The projects contain real accounting applications and represent a variety of business types and settings. The author of the projects has included company profiles (descriptions) for each of the project companies to help you feel like you're doing the accounting for an actual business. I recommend that you get yourself right into the role of being the accountant for each business and enjoy the process of doing its accounting procedures.
The four projects, each using a different company, will cover the following in Simply Accounting:

  • Project 1: General Journal (Muriel’s Murals)
  • Project 2: Payables (Groen Fields)
  • Project 3: Receivables (Phoebe’s Photos)
  • Project 4: Payroll (Helena’s Academy)
  • Project 5: Inventory (Flabuless Fitness)
  • Project 6: General, Payables, Receivable, Payroll, Inventory Set Up (Velocity)

You Need:
  • A computer
  • The software: Sage50-Accounting -2016
  • Data files and the projects handouts: Ask your teacher.

About Asking for Help
You should know enough accounting to do a lot of the accounting work on the projects by yourself without help from the instructor. 
Consider yourself to be the new accounting assistant in the company. Your job is to assist in making accounting entries, and provide regular accounting reports. 
Consider your course teacher as resource to help you when you cannot figure out what to do on your own.
If you encounter problems or things you don't know how to do, try to solve the problem yourself before you ask your teacher. Be prepared to tell your teacher what you did on your own.
Notes before you begin the projects:
  • Finish reading a project's assignment page first! That way you'll find out EVERYTHING you need to know before you start working.
  • Ensure the accuracy of your work. Remember, you can always get a fresh copy of the data file and start over if you need the practice or have made too many errors. You can also start over from a previous day's backup, if you've made too many errors on any given day.
  • Make sure you only work on the WORKING copy of the data files.
  • Create a copy (Save As) of your work every time you start a new session date..
    (There's a page about this in this Module.)

If you need help:
  • Sage 50 has Help files built in to the software. Typing your problem into a search engine is usually very efficient.
  • Use your textbook.
  •  
“Save As” (not Backups_

Why are backups so important?

Making backups of computer files is important in all situations in order to ensure you don't lose your data. In business, losing data could mean losing a few days of company time (or more) while you re-enter data. In accounting work, having a good BACKUP system for your data is essential. In fact, it's more than essential -- having a good backup could save your company thousands of dollars in lost data, lost time, etc. Therefore, accountants are always very careful to keep backup copies of everything they do.
Get used to this very important idea: If you lose accounting data, you will likely also lose your job! This is because you are expected to have a backup of any lost data so you can recover from any computer disaster.
If something happens to a computer such that your accounting records are corrupted or destroyed, you MUST always have a recent version of your work to restore and use. Even if the computer problem was not your fault, NOT having a backup of the data WOULD BE your fault. 
Therefore, backing up your work is your responsibility, both in this course and in any accounting job. Backing up your accounting work should be done daily, or even after every session of entering data
The following is ESSENTIAL information. Refer back to it often!
Where to back up your data files:
  • During this course you will probably be keeping all your work on your own hard drive or on your memory stick. So, in addition to the location of your "working copy" of your accounting files, you must ALSO keep backup copies in a separate location from your working copies.
  • You could create separate backup folders on a second hard drive in your own computer.
  • If working on the school computers, use your memory stick for backups.

Preventing confusion between copies of your data
Having two or more separate copies of your data could cause confusion...(oh no! which one is my working copy, which one is my backup, which one was I just using...etc). So here are some guidelines: 
  • Get used to the idea that you will have 2 or more copies of your work at all times.
  • For each course accounting project, you should have two separate folders on TWO separate hard drives.
  • CAREFULLY LABEL each disk or data folder, as follows. Both should be labelled with the company name (or the assignment title, or the project name, whatever works for you). IN ADDITION, one of these should be labelled "Backup Copy" + the date so you always know which one is your working copy and which one is your backup copy (which you never work on!).
    • EXAMPLE NAME OF BACKUP FILE: 2010sept23_VillageGalleries_backup
  • After making a backup copy, remember to close that file completely. Before entering any further transactions, return to your original working copy by re-opening the "working copy" file again.
  • It is good practice to keep each company in a separate windows folder and/or on a separate backup memory stick.
Backups vs. "Save As"
"Save As" is different from the "Backup" command in Simply Accounting
  • "Save As" creates a working copy of your file directly, one identical to the original.
  • The Simply Accounting "Backup" command creates a special kind of copy of the files which must be restored using the "Restore" command before you can use it.
  • The Backup function in Simply Accounting doesn't work on the school computers.ALWAYS USE THE "SAVE AS" METHOD AT SCHOOL,
    even when the lessons ask you to use the Backup function in Simply Accounting!
An Example of a company backup system
Note: You don't have to do this for the course. But read through this example so you'll know how detailed a backup system can be.
An accountant will typically have several backup files. There should be a minimum of one for each day, plus one for each week of the month, plus one for the most recent month. 
  • Monday's work is backed up on the MONDAY backup media.
  • Tuesday's work is backed up on the TUESDAY backup media.
  • Wednesday's work is backed up on the WEDNESDAY backup media.
  • Thursday's work is backed up on the THURSDAY backup media.
  • Friday's work is backed up on the FRIDAY backup media.
  • Friday's work is ALSO backed up on THE FIRST WEEK's backup media.
Then:
  • The next Monday's work is backed up on the same MONDAY backup media.
  • ....and so on until Friday...
  • Friday's work is backed up on both the FRIDAY backup media AND on THE SECOND WEEK's backup media.
  • This continues every week.
  • At the end of the month, an additional backup is made on THE MONTH's backup media. 
The result is that you would have:
  • 5 daily backups
  • PLUS one backup for the end of each week in the month
  • PLUS one backup for the end of each month
If you make an error or have a computer disaster:
  • If today you happened to make too many mistakes in your bookkeeping, or if your system      crashes today, you could just begin again from the data you saved on yesterday's backup. You've lost less than a day's work. [Note: if you start from yesterday's backup copy, FIRST MAKE A COPY OF the data. (Don't use the original copy, because then you won't have it to go back to if you have a second problem!)
  • If you discover a major error you made at the beginning of the week, you could go back to last Friday's backup and re-do this week's entries.
  • If it were needed, you could go back to the end of the previous month, and begin entries again.
Those are very unlikely scenarios, but at least you'd be covered in times of disasters with your data files. 
Personalizing your assignment files
This is important.
1. Your own name must be a part of the company name
When you hand in reports from your work, your teacher needs to know whose work it is, and that you have done your own work on the projects.
Whenever you name a new company as you do your exercises in Simply Accounting, include YOUR NAME in the company name. For example, if you have a company called "City Computers ", you should name it YourName City Computers (for example: "Sandra's City Computers").
For each company you work on throughout the course, even if the setup has been pre-done for you (when you are using data files that have some of the setup done), you should rename the company to include your name. How to do this:
  • Go to the SETUP menu and select SYSTEM SETTINGS
  • Select COMPANY INFORMATION
  • Put your cursor in front of the company's name
  • Type your name
  • Click "OK"


PROJECT 1: General Journal (Muriel’s Murals)
This project gives you practical experience in using Simply Accounting's general journals.

Assignment:
  1. Ask a teacher to give you the Muriel’s Murals data files from the Accounting 12 file in the PALC computer lab.
  2. Ask your teacher for a copy of the Muriel’s Murals project.
  3. Read and work through the whole project.

NOTE the way the project information is organized. Each project is arranged in a similar manner:
1. The Chapter begins with Company Information.
2. Following that, the actual Instructions for your work begins
3. Then, you'll find the Source Documents/Keystrokes section, a step-by-step help with your work.

NOTE also that after you have completed the entries, there are still instructions left to do. Always check back to the page containing the list of Project Instructions after making all the entries.

  1. Ensure the accuracy of your work. Remember, you can always use a fresh copy of the data file and start over if you need the practice or have made too many errors
  2. You will not print your projects; you will give your teacher a copy of your project.
  3. After handing in your work, proceed to the next project. Allow a few days for your instructor to mark your work.
To hand in your project:
  1. Look at all the reports listed under instruction #2.
  2. Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example: GeorgeMuralFeb28

Project 2

To print-go to the bottom of the page.


PROJECT 2: Payables
Groen Fields
Assignment:
  1. Ask a teacher for the Fields data files from the Accounting 12 file in the PALC computer lab.
  2. Ask your teacher for a copy of the Groen Fields project.
3.     Read and work through the whole project.

4.     The chapter begins with Company Information.
Following that, the actual Instructions for your work begins
Then, you'll find the Source Documents/Keystrokes section, a step-by-step help with your work.
5.     Ensure the accuracy of your work. Remember, you can always use a fresh copy of the data file and start over if you need the practice or have made too many errors.
  1. You will not print your projects; you will give your teacher a copy of your project file.
  2. After handing in your work, proceed to the next project. Allow a few days for your instructor to mark your work.
To hand in your project:

  1. Look at all the reports listed under instruction #2.
  2. Give your teacher these two files with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example:  “YourName”FieldsMay31”  

Project 3

Project 3 Receivables

Phoebe’s Photos


Assignment:
  1. Ask a teacher for the Phoebe’s Photos data files from the Accounting 12 file in the PALC computer lab.
  2. Ask your teacher for a copy of the Phoebe’s Photos project.
Read and work through the whole chapter,

  1. You will not print your projects; you give your teacher a copy of your project.
  2. After handing in your work, proceed to the next project. Allow a few days for your instructor to mark your work.
To hand in your project :

  1. Look at all the reports listed under instructions
  2. Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example:  “YourNamePhotoJul31”

Project 4

Project 4 Payroll

Helena’s Academy


Assignment:
  1. Ask a teacher for the Helena’s Academy data files from the Accounting 12 file in the PALC computer lab.
  2. Ask your teacher for a copy of the Helena’s Academy project.
Read and work through the whole chapter,
  1. You will not print your projects; you give your teacher a copy of your project.
  2. After handing in your work, proceed to the next project. Allow a few days for your instructor to mark your work.
To hand in your project :
  1. Look at all the reports listed under instructions
  2. Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example: “YourNameHelenaDec31”

Project 5

Project 5 Inventory

Flabuless Fitness


Assignment:
  1. Ask a teacher for the Flabuless Fitness data files from the Accounting 12 file in the PALC computer lab.
  2. Ask your teacher for a copy of the Flabuless Fitness project.
Read and work through the whole chapter,
  1. You will not print your projects; you give your teacher a copy of your project.
  2. After handing in your work, proceed to the next project. Allow a few days for your instructor to mark your work.
To hand in your project :
  1. Look at all the reports listed under instructions
  2. Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example: “YourNameFlabFeb28”

Sunday

Project 6

Self-Paced Accounting 12 -Project 6 VeloCity

Two parts
Assisted Setup of a Company

The project is done as two parts:
First, the setup;
Second, the accounting entries.
Instructions in the project will guide you through the process completely. You may also want to refer back to earlier projects if you need further information or help with specifics.
The word "assisted" in the title of this project ("Assisted Setup") means that the handout contains guidance/assistance for each step of the setup.
VeloCity, Part 1
This is the first half of the assignment, the company setup.

Assignment:
Note: This project involves creating a company's data files. That means there is no data file.

  1. Ask your teacher for a copy of the VeloCity project.
  2. Read and work through the project.
    Stop after:
    - the SETUP is complete
    - AND you have changed History status to Finished

  3. Look at the following reports:
-Chart of Accounts
-Employee Summary
-Inventory Summary
-Balance Sheet
-Income Statement
-Trial Balance

To hand in your project:
  1. Look at all the reports
  2. Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example:  GeorgeVeloPt1.
  3. You cannot start Part 2 of VeloCity until your teacher has marked your Part 1.



VeloCity Part 2
This is the second half of the assignment, making entries for the company you just set up.
You will start this part when you receive your marked VeloCity Part 1 from your teacher.

Assignment:
  1. Use the VeloCity data file that you created in Part 1
  2. Follow the Instructions for May
3.     Look at all the reports listed under the Instructions.

4.     Give your teacher a copy of your file with your name and the project name. It should be in a folder which contains both parts of the Sage 50 files. For example:  GeorgeVeloPt2May31