3341 Assign3 Fall2014

.
ACCT 3341 Intermediate Accounting I
Fall 2014
Assignment #3
Due Date: Friday, October 31 by 11:30pm Instructions:
This is an individual assignment. While you may certainly discuss concepts from this assignment with your classmates, remember that the assignment must be completed and submitted on an individual basis.
Late submissions will NOT be accepted.
Include your full name and A# at the top of the first page of your submission.
Your assignment may only be submitted in the Blackboard assignment as a Microsoft Excel (.xlsx) file. Complete each question on a separate worksheet in your file.
Show all calculations. If Excel is used, must show calcs outside of cells (other than obvious, ie. stmts.)

Question 1 (20 marks)

Bookkeeping Co. has opened a new bank account and would like you to reconcile it. Its unadjusted cash general ledger balance at October 31, 2014 is $7,181. The bookkeeper has compiled the following information and notes:

Bookkeeping Co.

Cheque Register

Cheq #
Date
Payee
Amount
1
01-Oct-14
Zhou Inc.
80
2
02-Oct-14
Guo Co.
45
3
02-Oct-14
Xiao Inc.
50
4
02-Oct-14
John Doe Inc.
182
5
02-Oct-14
Shoes Inc.
400
6
02-Oct-14
Socks Inc.
650
7
11-Oct-14
Glasses Co.
890
8
19-Oct-14
Sheep Inc.
220
9
22-Oct-14
Pens Co.
55
10
23-Oct-14
Sally Smith
1,600
11
24-Oct-14
Fred Flinstone
1,500
12
24-Oct-14
Sammy Inc.
2,100
13
25-Oct-14
Stapler Co.
652

8,424

Deposit Listing
Date
Notes
Amount
02-Oct-14
Cheques and Cash total
880
09-Oct-14
Cheques and Cash total
2000
16-Oct-14
Cheques and Cash total
450
20-Oct-14
Cheques and Cash total
375
27-Oct-14
Cheques and Cash total
750
31-Oct-14
Cheques and Cash total
360

4,815

Bookkeeping Co.

Trust Bank

Bank Statement

Date
Description
Debit
Credit
Balance

Bookkeeper notes
01-Oct-14
Balance transferred

9,900
9,900

02-Oct-14
CHQ#00002
45 9,855

02-Oct-14
CHQ#00003
55 9,800