BAC11 IT for Accountants: MYOB Practical Assignment 2018

This document presents a solution to a practical assignment involving the MYOB accounting software, specifically focusing on the reconciliation reports for West Coast Advertising. The reports cover bank reconciliations, account transactions, and bank registers for February and March 2014. The assignment requires students to download a MYOB file (WEST.MYO), complete an exercise, and submit the .MYO file along with printed PDF reports. The reports include details of outstanding deposits and cheques, reconciled deposits and cheques, and a reconciliation of the AccountRight Enterprise balance with the expected balance on the bank statement. The transactions include various deposits, withdrawals, and bank fees, providing a comprehensive view of the company's financial activities during the specified periods. The reports are essential for understanding bank reconciliation processes and financial reporting within MYOB.

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Reconciliation Report
12-07-2018
16:23:17
Page 1
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1110 Cheque Account
Date of Bank Statement: 01-02-2014
Reconciled Cheques
CR000001 01-02-2014 Outstanding deposit - owner c 1,500.00
Total: 0.00 1,500.00
Reconciled Deposits
265 01-02-2014 Outstanding cheque - Diners C 6,000.00
Total: 6,000.00 0.00
Outstanding Cheques
265 01-02-2014 Outstanding cheque - Diners C 6,000.00
Total: 0.00 6,000.00
Outstanding Deposits
CR000001 01-02-2014 Outstanding deposit - owner c 1,500.00
Total: 1,500.00 0.00
Reconciliation
ccountRight Enterprise Balance on 01-02-2014: -13,365.00
Add: Outstanding Cheques: 6,000.00
Subtotal: -7,365.00
Deduct: Outstanding Deposits: 1,500.00
Expected Balance on Statement: -8,865.00

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Reconciliation Report
12-07-2018
16:24:02
Page 1
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1110 Cheque Account
Date of Bank Statement: 28-02-2014
Reconciled Cheques
265 01-02-2014 Outstanding cheque - Diners C 6,000.00
266 06-02-2014 Really Big Bank 500.00
267 12-02-2014 MasterCard 1,670.00
268 20-02-2014 Really Big Bank 500.00
269 25-02-2014 Really Big Bank 2,110.00
SC280214 28-02-2014 Bank Fees 23.20
Total: 0.00 10,803.20
Reconciled Deposits
CR000001 01-02-2014 Outstanding deposit - owner c 1,500.00
CR000004 10-02-2014 Bank Deposit 8,250.00
CR000007 27-02-2014 Bank Deposit 4,895.00
Total: 14,645.00 0.00
Reconciliation
ccountRight Enterprise Balance on 28-02-2014: -5,023.20
Add: Outstanding Cheques: 0.00
Subtotal: -5,023.20
Deduct: Outstanding Deposits: 0.00
Expected Balance on Statement: -5,023.20

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Bank Register
01-02-2014 To 28-02-2014
12-07-2018
16:25:36
Page 1
ID# Src Date Memo/Payee Deposit Withdrawal Balance
1-1110 Cheque Account
265 CD 01-02-2014 Outstanding cheque - Dine 6,000.00 -19,365.00
265 CD 01-02-2014 Outstanding cheque - Dine 6,000.00 -13,365.00
CR000001 CR 01-02-2014 Outstanding deposit - own 1,500.00 -11,865.00
CR000001 CR 01-02-2014 Outstanding deposit - own 1,500.00 -13,365.00
266 CD 06-02-2014 Really Big Bank 500.00 -13,865.00
CR000004 CR 10-02-2014 Bank Deposit 8,250.00 -5,615.00
267 CD 12-02-2014 MasterCard 1,670.00 -7,285.00
268 CD 20-02-2014 Really Big Bank 500.00 -7,785.00
269 CD 25-02-2014 Really Big Bank 2,110.00 -9,895.00
CR000007 CR 27-02-2014 Bank Deposit 4,895.00 -5,000.00
SC280214 CD 28-02-2014 Bank Fees 23.20 -5,023.20
20,645.00 12,303.20

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Reconciliation Report
12-07-2018
16:29:07
Page 1
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1110 Cheque Account
Date of Bank Statement: 31-03-2014
Reconciled Cheques
270 01-03-2014 Petty Cash 200.00
271 06-03-2014 Really Big Bank 500.00
SC310314 31-03-2014 Bank Charges 19.90
Total: 0.00 719.90
Reconciled Deposits
CR000008 03-03-2014 Radio Ad 9,900.00
CR000009 13-03-2014 TV Ad 6,380.00
CR000010 18-03-2014 Radio Ad 8,140.00
CR000012 28-03-2014 Bank Deposit 924.00
Total: 25,344.00 0.00
Outstanding Cheques
272 31-03-2014 Classy Computers 3,916.00
273 31-03-2014 Petty Cash 86.90
Total: 0.00 4,002.90
Reconciliation
ccountRight Enterprise Balance on 31-03-2014: 15,598.00
Add: Outstanding Cheques: 4,002.90
Subtotal: 19,600.90
Deduct: Outstanding Deposits: 0.00
Expected Balance on Statement: 19,600.90

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Account Transactions [Accrual]
01-03-2014 To 31-03-2014
12-07-2018
16:30:05
Page 1
ID# Src Date Memo/Payee Debit Credit Job No.
1-1130 Petty Cash
270 CD 01-03-2014 Petty Cash 200.00
1 CD 15-03-2014 Eat at Joe's 46.75
2 CD 22-03-2014 Canary Cabs 14.30
3 CD 24-03-2014 Aussie Post 25.85
273 CD 31-03-2014 Petty Cash 86.90
286.90 86.90

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Bank Register
01-03-2014 To 31-03-2014
12-07-2018
16:31:15
Page 1
ID# Src Date Memo/Payee Deposit Withdrawal Balance
1-1110 Cheque Account
270 CD 01-03-2014 Petty Cash 200.00 -5,223.20
CR000008 CR 03-03-2014 Radio Ad 9,900.00 4,676.80
271 CD 06-03-2014 Really Big Bank 500.00 4,176.80
CR000009 CR 13-03-2014 TV Ad 6,380.00 10,556.80
CR000010 CR 18-03-2014 Radio Ad 8,140.00 18,696.80
CR000012 CR 28-03-2014 Bank Deposit 924.00 19,620.80
272 CD 31-03-2014 Classy Computers 3,916.00 15,704.80
273 CD 31-03-2014 Petty Cash 86.90 15,617.90
SC310314 CD 31-03-2014 Bank Charges 19.90 15,598.00
25,344.00 4,722.80

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Reconciliation Report
12-07-2018
16:33:22
Page 1
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1110 Cheque Account
Date of Bank Statement: 31-03-2014
Reconciled Cheques
270 01-03-2014 Petty Cash 200.00
271 06-03-2014 Really Big Bank 500.00
SC310314 31-03-2014 Bank Charges 19.90
Total: 0.00 719.90
Reconciled Deposits
CR000008 03-03-2014 Radio Ad 9,900.00
CR000009 13-03-2014 TV Ad 6,380.00
CR000010 18-03-2014 Radio Ad 8,140.00
CR000012 28-03-2014 Bank Deposit 924.00
Total: 25,344.00 0.00
Outstanding Cheques
272 31-03-2014 Classy Computers 3,961.00
273 31-03-2014 Petty Cash 86.90
Total: 0.00 4,047.90
Reconciliation
ccountRight Enterprise Balance on 31-03-2014: 15,553.00
Add: Outstanding Cheques: 4,047.90
Subtotal: 19,600.90
Deduct: Outstanding Deposits: 0.00
Expected Balance on Statement: 19,600.90

West Coast Advertising_Usman Shabbir
880 Swan Street
Perth WA 6000
Bank Register
01-03-2014 To 31-03-2014
12-07-2018
16:33:58
Page 1
ID# Src Date Memo/Payee Deposit Withdrawal Balance
1-1110 Cheque Account
270 CD 01-03-2014 Petty Cash 200.00 -5,223.20
CR000008 CR 03-03-2014 Radio Ad 9,900.00 4,676.80
271 CD 06-03-2014 Really Big Bank 500.00 4,176.80
CR000009 CR 13-03-2014 TV Ad 6,380.00 10,556.80
CR000010 CR 18-03-2014 Radio Ad 8,140.00 18,696.80
CR000012 CR 28-03-2014 Bank Deposit 924.00 19,620.80
272 CD 31-03-2014 Classy Computers 3,961.00 15,659.80
273 CD 31-03-2014 Petty Cash 86.90 15,572.90
SC310314 CD 31-03-2014 Bank Charges 19.90 15,553.00
25,344.00 4,767.80