We Consult You
		Cash Transactions
		March 31, 2022
General Ledger/ Company Books			Bank Statement
Transaction Type			Transaction Type
Check 1762	1,414.13		Deposit 1224	127.98
Check 1763	1,783.98		Deposit 1228	2,985.12
Check 1764	2,041.73		NSF Check 1213	2,645.05
Check 1765	987.34		NSF Check 1217	924.17
Check 1766	1,501.19		NSF Fees 1	25.00
Check 1767	2,278.18		NSF Fees 2	35.00
Check 1768	4,398.01		Deposit 1227	1,819.13
Check 1769	1,349.56		Deposit 1225	289.75
Check 1770	2,430.61		Deposit 1226	699.46
Check 1771	1,513.19		Deposit 1223	2,073.14
Check 1772	2,985.09		Deposit 1229	993.09
Check 1773	865.23		Deposit 1230	3,012.23
Check 1774	152.90		Check 1762	1,414.13
Deposit 1223	2,073.14		Check 1764	2,041.73
Deposit 1224	127.98		Check 1765	987.34
Deposit 1225	289.75		Check 1766	1,501.19
Deposit 1226	699.46		Check 1767	2,478.18
Deposit 1227	1,819.13		Check 1768	4,398.01
Deposit 1228	2,985.12		Check 1769	1,349.56
Deposit 1229	993.09		Check 1770	2,430.61
Deposit 1230	3,012.23		Note Collect 1	1,500.00
Deposit 1231	1,264.20		Interest Earned	11.05
Deposit 1232	1,265.38
Deposit 1233	2,613.29

The cells highlighted in red are those items that need to be reconciled.

The cells in the general ledger column highlighted in red are items recorded by the company but not by the bank. The checks highlighted in red would be considered outstanding checks. The deposits highlighted in red would be considered outstanding deposits.

The cells in the bank statement column highlights in red are items recorded by the bank but not by the company.

The cells pertaining to the same check or deposit number highlighted in both the general ledger and the bank statement column are considered to be errors.

Part 2:

Prepare the Bank Reconciliation Schedule.