FNS40217 ABC Ltd Reconciliation Project: Computerised System T3 2018

This document presents a reconciliation report for ABC Ltd, dated 23-03-2019. It includes details of cleared cheques and deposits, outstanding cheques, and outstanding deposits. The report reconciles the balance on 28-07-2018 with outstanding items to arrive at an expected balance on the statement. This project is part of the FNS40217 Certificate IV in Accounting & Bookkeeping, specifically for the Computerised Accounting System unit in T3 2018. Desklib offers a variety of solved assignments and study resources for students.

ABC Ltd. (Abtullah 201736848)
23, Richmond Street,
Sydney
Reconciliation Report
23-03-2019
0:04:07
Page 1
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1100 Cheque Account
Date of Bank Statement: 28-07-2018
Last Reconciled:
Last Reconciled Balance: $0.00
Cleared Cheques
2 01-07-2018 AAMI Insurance $2,750.00
8 14-07-2018 XYZ Cleaning $330.00
21 28-07-2018 AJ Event Management L $550.00
SC280718 28-07-2018 Bank charges $28.60
Total: $0.00 $3,658.60
Cleared Deposits
CR000008 14-07-2018 Dividend Income $126.67
Total: $126.67 $0.00
Outstanding Cheques
1 01-07-2018 LJ Hooker $3,267.00
3 01-07-2018 Daily Telegraph $220.00
4 01-07-2018 AJ Event Management $880.00
5 01-07-2018 Hospitality Services $715.00
6 01-07-2018 Hospitality Services $506.00
GJ000002 03-07-2018 Weekly Wages Paid to Maya B $595.08
GJ000003 03-07-2018 Weekly Wages Paid to Jane L $595.08
7 11-07-2018 Hospitality Supplies $770.00
10 17-07-2018 The Fun Factory $237.60
11 17-07-2018 Hospitality Supplies $772.20
9 17-07-2018 Tunney's Wholesale $3,447.00
12 20-07-2018 Daily Telegraph $330.00
13 24-07-2018 Tunney's Wholesale $1,467.00
14 24-07-2018 The Fun Factory $414.70
15 28-07-2018 XYZ Cleaning $330.00
Total: $0.00 $14,546.66
Outstanding Deposits
CR000001 04-07-2018 Cash for 00000001 $3,898.00
CR000002 05-07-2018 Cash for 00000002 $1,591.08
CR000003 08-07-2018 Cash for 00000003 $4,435.20
CR000004 15-07-2018 Cash for 00000004 $3,722.40
CR000005 17-07-2018 Payment; Cash $132.00
CR000006 22-07-2018 Cash for 00000005 $2,484.90
Total: $16,263.58 $0.00

ABC Ltd. (Abtullah 201736848)
Reconciliation Report
23-03-2019
0:04:07
Page 2
ID# Date Memo/Payee Deposit Withdrawal
Cheque Account: 1-1100 Cheque Account
Date of Bank Statement: 28-07-2018
Last Reconciled:
Last Reconciled Balance: $0.00
Outstanding Deposits
Reconciliation
ccountRight Enterprise Balance on 28-07-2018: $78,184.99
Add: Outstanding Cheques: $14,546.66
Subtotal: $92,731.65
Deduct: Outstanding Deposits: $16,263.58
Expected Balance on Statement: $76,468.07