KOI Business Finance Reconciliation Report - Analysis 2017

This reconciliation report, prepared by Gurpreet, details the reconciliation of two accounts: a Business Cheque Account and an Investment Account. The Business Cheque Account reconciliation, as of June 30, 2017, begins with a last reconciled balance of ₹10,873.92. It includes a list of reconciled cheques, deposits, and outstanding cheques, with adjustments made for outstanding items to arrive at an expected balance. The Investment Account reconciliation, also as of June 30, 2017, starts with a last reconciled balance of ₹15,039.62. It includes outstanding cheques and deposits, leading to an expected balance on the statement after accounting for these items. The report provides a clear overview of the financial reconciliation process, including the identification and handling of outstanding transactions to ensure accurate financial reporting.

Gurpreet 11801288
31 Market street,
Sydney 2000 NSW.
ABN: 21 911 801 288
Email: [e-mail]
Created: 26-09-2019 20:03
Reconciliation Report
Page 1 of 2
ID No. Date Memo/Payee Deposit Withdrawal
Account: 1-1110 Business Cheque Account
Date Of Bank Statement: 30-06-2017
Last Reconciled: 30-06-2017
Last Reconciled Balance: ₹ 10,873.92
Reconciled Cheques
182 17-05-2017Engel Aust Pty Ltd ₹ 1,943.70
184 01-06-2017Ozzie Trailblazers ₹ 5,834.00
185 02-06-2017Commercial Realty ₹ 2,750.00
186 06-06-2017Telstra ₹ 592.70
187 08-06-2017Employees ₹ 2,890.00
188 23-06-2017Employees ₹ 2,290.00
189 23-06-2017Engel Aust Pty Ltd ₹ 2,833.00
SC300617 30-06-2017 ₹ 98.18
₹ 0.00 ₹ 19,231.58Total:
Reconciled Deposits
1 02-06-20171-1140 Petty Cash/Cash On Hand ₹ 5,000.00
CR000008 16-06-2017Bank Deposit ₹ 6,688.00
CR000009 22-06-2017Payment; Adventure Tours ₹ 3,310.70
CR000010 29-06-2017Payment; Scout Shop ₹ 4,732.50
₹ 19,731.20 ₹ 0.00Total:
Outstanding Cheques
190 29-06-2017 ₹ 1,000.00
191 30-06-2017Office Desk ₹ 2,050.00
192 30-06-2017 ₹ 6,000.00
193 30-06-2017 ₹ 138.30
₹ 0.00 ₹ 9,188.30Total:
Reconciliation:
AccountRight Balance On 30-06-2017: ₹ 1,685.62
Add: Outstanding Cheques: ₹ 9,188.30
SubTotal: ₹ 10,873.92
Deduct: Outstanding Deposits: ₹ 0.00
Expected Balance On Statement: ₹ 10,873.92
Account: 1-1120 investment account
Date Of Bank Statement: 30-06-2017
Last Reconciled: 31-05-2017
Last Reconciled Balance: ₹ 15,039.62
Outstanding Cheques
1 02-06-20171-1140 Petty Cash/Cash On Hand ₹ 5,000.00
₹ 0.00 ₹ 5,000.00Total:

Gurpreet 11801288
31 Market street,
Sydney 2000 NSW.
ABN: 21 911 801 288
Email: [e-mail]
Created: 26-09-2019 20:03
Reconciliation Report
Page 2 of 2
ID No. Date Memo/Payee Deposit Withdrawal
Outstanding Deposits
192 30-06-2017 ₹ 6,000.00
₹ 6,000.00 ₹ 0.00Total:
Reconciliation:
AccountRight Balance On 30-06-2017: ₹ 16,039.62
Add: Outstanding Cheques: ₹ 5,000.00
SubTotal: ₹ 21,039.62
Deduct: Outstanding Deposits: ₹ 6,000.00
Expected Balance On Statement: ₹ 15,039.62