- Enclosed is the bank reconciliation as provided by your client, consider the following:
- What audit procedures would you do on the reconciliation?
- What additional information if any, would you ask for from your client to facilitate the audit of this bank reconciliation?
- Mark up this working paper - in excel or PDF
- Red to reference another working paper
- Green to denote working paper notations
Beginning balance 60,739.28 Date Num Name Clr Amount Balance 133 Type Cheques and Payments - 23 items Liability Cheque Liability Cheque Pay Cheque Pay Cheque Pay Cheque Pay Cheque Pay Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Bill Pmt -Cheque Bill Pmt -Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Bill Pmt -Cheque Cheque Cheque Bill Pmt -Cheque Total Cheques and Payments Deposits and Credits - 11 items Cheque Deposit 11/17/2028 11/17/2028 11/30/2028 11/30/2028 11/30/2028 11/30/2028 11/30/2028 11/01/2030 11/01/2030 11/12/2030 11/12/2030 11/12/2030 11/14/2030 11/24/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 12/01/2030 12/31/2030 Debit 132 Debit Debit Debit Debit Receiver General -9,844.48 Insurance Experts -195.00 Rob de Montarnal -4,113.74 Lynette Farriot -3,887.07 Jacque Hudspet -3,610.41 Kyle Kilat -2,840.73 Christiane Spenard -2,820.73 Minister of Finance -42,182.68 Dobson's Properties -1,522.50 Franztastic Bikes -70,332.00 Sheldon's Parts -50,274.00 Bike By Mike -19.656.00 Receiver General -4,839.83 Insurance Experts -245.00 Blitz Marketing -892.50 Small Business Development Loan Com -650.00 Roger's and Company CA's -450.00 Barata's Fine Wines -384.20 Utility Corp -360.15 The Phone Co -164.87 Bank of Royals -16.00 Dobson's Properties -1,522.50 Craig's Lists of Stuff -5.00 -220,809.39 -9,844.48 -10,039.48 -14,153.22 -18,040.29 -21,650.70 -24,491.43 -27,312.16 -69,494.84 -71,017.34 -141,349.34 -191,623.34 -211,279.34 -216,119.17 -216,364.17 -217,256.67 -217,906.67 -218,356.67 -218,740.87 -219, 101.02 -219,265.89 -219,281.89 -220,804.39 -220,809.39 -220,809.39 Debit 134 debit Debit 135 Deposit Deposit Payment Deposit Deposit 10/03/2030 11/30/2030 11/30/2030 11/30/2030 12/04/2030 12/15/2030 12/15/2030 Accounting Cycle ABC Co Dance Shop 1-2-3 Sky's Airplanes Ko, Adwin Rocky's Quarry XYZ Ltd 12.00 78.75 3,905.28 14,443.00 47,460.00 62,633.64 80,908.00 209,440.67 12.00 90.75 3,996.03 18,439.03 65,899.03 128,532.67 209,440.67 209,440.67 Total Deposits and Credits Total Cleared Transactions -11,368.72 Cleared balance 49,370.56 Type Date Num Name Clr Amount Balance Uncleared Transactions Cheques and payments Cheque Cheque Cheque Cheque 12/31/2030 12/31/2030 12/31/2030 12/31/2030 139 136 137 138 Rick's Office Superstore Craig's Lists of Stuff Daniel's Gunes's Marketing -200.00 -574.52 -389.85 -367.25 -1,531.62 -200.00 -774.52 -1,164.37 -1,531.62 -1,531.62 Deposits Deposit Deposit Deposit Deposit 12/31/2030 12/31/2030 12/31/2030 12/31/2030 Baseline Buildings Canada Business Specialists Luke's Lucky Lanes Auto Associates 12,000.00 575.00 8,500.00 15,550.00 36,625.00 12,000.00 12,575.00 21,075.00 36,625.00 36,625.00 Total uncleared transactions 35,093.38 General ledger balance 84,463.94 Beginning balance 60,739.28 Date Num Name Clr Amount Balance 133 Type Cheques and Payments - 23 items Liability Cheque Liability Cheque Pay Cheque Pay Cheque Pay Cheque Pay Cheque Pay Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Bill Pmt -Cheque Bill Pmt -Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Cheque Bill Pmt -Cheque Bill Pmt -Cheque Cheque Cheque Bill Pmt -Cheque Total Cheques and Payments Deposits and Credits - 11 items Cheque Deposit 11/17/2028 11/17/2028 11/30/2028 11/30/2028 11/30/2028 11/30/2028 11/30/2028 11/01/2030 11/01/2030 11/12/2030 11/12/2030 11/12/2030 11/14/2030 11/24/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 11/30/2030 12/01/2030 12/31/2030 Debit 132 Debit Debit Debit Debit Receiver General -9,844.48 Insurance Experts -195.00 Rob de Montarnal -4,113.74 Lynette Farriot -3,887.07 Jacque Hudspet -3,610.41 Kyle Kilat -2,840.73 Christiane Spenard -2,820.73 Minister of Finance -42,182.68 Dobson's Properties -1,522.50 Franztastic Bikes -70,332.00 Sheldon's Parts -50,274.00 Bike By Mike -19.656.00 Receiver General -4,839.83 Insurance Experts -245.00 Blitz Marketing -892.50 Small Business Development Loan Com -650.00 Roger's and Company CA's -450.00 Barata's Fine Wines -384.20 Utility Corp -360.15 The Phone Co -164.87 Bank of Royals -16.00 Dobson's Properties -1,522.50 Craig's Lists of Stuff -5.00 -220,809.39 -9,844.48 -10,039.48 -14,153.22 -18,040.29 -21,650.70 -24,491.43 -27,312.16 -69,494.84 -71,017.34 -141,349.34 -191,623.34 -211,279.34 -216,119.17 -216,364.17 -217,256.67 -217,906.67 -218,356.67 -218,740.87 -219, 101.02 -219,265.89 -219,281.89 -220,804.39 -220,809.39 -220,809.39 Debit 134 debit Debit 135 Deposit Deposit Payment Deposit Deposit 10/03/2030 11/30/2030 11/30/2030 11/30/2030 12/04/2030 12/15/2030 12/15/2030 Accounting Cycle ABC Co Dance Shop 1-2-3 Sky's Airplanes Ko, Adwin Rocky's Quarry XYZ Ltd 12.00 78.75 3,905.28 14,443.00 47,460.00 62,633.64 80,908.00 209,440.67 12.00 90.75 3,996.03 18,439.03 65,899.03 128,532.67 209,440.67 209,440.67 Total Deposits and Credits Total Cleared Transactions -11,368.72 Cleared balance 49,370.56 Type Date Num Name Clr Amount Balance Uncleared Transactions Cheques and payments Cheque Cheque Cheque Cheque 12/31/2030 12/31/2030 12/31/2030 12/31/2030 139 136 137 138 Rick's Office Superstore Craig's Lists of Stuff Daniel's Gunes's Marketing -200.00 -574.52 -389.85 -367.25 -1,531.62 -200.00 -774.52 -1,164.37 -1,531.62 -1,531.62 Deposits Deposit Deposit Deposit Deposit 12/31/2030 12/31/2030 12/31/2030 12/31/2030 Baseline Buildings Canada Business Specialists Luke's Lucky Lanes Auto Associates 12,000.00 575.00 8,500.00 15,550.00 36,625.00 12,000.00 12,575.00 21,075.00 36,625.00 36,625.00 Total uncleared transactions 35,093.38 General ledger balance 84,463.94