Lecture and practical applications, conducted exclusively in a computer lab.
1.1 Review basic spreadsheet concepts.
1.2 Review and apply basic accounting concepts.
1.3 Prepare spreadsheets and charts for financial statements, financial analyses, and supporting schedules including an accounting related project.
1.4 Learn appropriate use of spreadsheet formulas and functions
2.1 Introduce Simply Accounting
2.2 Create a new company or use predefined templates
2.3 Set up the General Ledger and Chart of Accounts; process day-to-day and adjusting entries
2.4 Print journals, general ledger reports and trial balance
2.5 Generate financial statements
2.6 Export and import the Chart of Accounts to and from Excel; export the Trial Balance to Excel
2.7 Perform month-end and year-end procedures. Print post-closing Trial Balance
2.8 Prepare Bank Reconciliation
3.1 Activate and set up the Accounts Receivable module
3.2 Process day-to-day transactions, including invoices, cash receipts and adjustments
3.3 Perform period-end processing, including interest and write-offs
3.4 Generate reports, including the aged receivable report
4.1 Activate and set up the Accounts Payable module
4.2 Process day-to-day transactions, including invoices and adjustments
4.3 Process payments, both manual and computer generated cheques
4.4 Generate reports, including the aged payables report
5.1 Activate and set up the Payroll module
5.2 Process day-to-day transactions, including adding employees and deductions
5.3 Process payroll with correcting entries
5.4 Generate reports.
At the end of the course, the successful student should be able to:
- Create accounting-related spreadsheets and charts by applying previously acquired accounting skills and expanding on previously acquired computer skills
- Set up and use the Simply Accounting General Ledger module to produce financial reports and prepare a bank reconciliation
- Set up and use the Simply Accounting Accounts Receivable module
- Set up and use the Simply Accounting Accounts Payable module
- Set up and use the Simply Accounting Payroll module.
| Excel | ||
| Assignment(s) and Quiz(zes)-minimum one of each | 10% | |
| Excel examination | 20% | |
| Total Excel |
30% | |
| Simply Accounting | ||
| Assignments | 10% | |
| Tests: | ||
| General Ledger | 10% | |
| Accounts Receivable | 10% | |
| Accounts Payable | 10% | |
| Payroll | 10% | |
| Comprehensive Simply Accounting Examination | 20% | |
| Total Simply Accounting |
70% | |
| 100% |
Students must write both examinations in order to obtain credit for the course.
Grauer, R. T., Mulbery and Mary Anne Poatsy. Exploring Microsoft Excel Comprehensive 2010, latest edition, Pearson Educational
Freedman, H. and Smith, C. Learning Simply Accounting 2012 Pro, latest edition, Thomson Nelson.
or other textbooks approved by the Accounting Department.
ACCT 1110 or ACCT 1235 text or equivalent.