West Coast Advertising Bank Reconciliation Report

Verified

Added on  2023/06/10

|8
|880
|175
AI Summary
This is a Bank Reconciliation Report for West Coast Advertising for the period of 01-02-2014 to 31-03-2014. It includes details of outstanding deposits, outstanding cheques, reconciled cheques, reconciled deposits, and expected balance on the statement.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
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

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
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
Document Page
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
Document Page
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

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
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
Document Page
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
Document Page
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

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
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
1 out of 8
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]