Please help! I can't reconcile this for the life of me. How can I reconcile these accounts?
Royal Bank Stella's Hair Studio 1284 - 2nd Street 1010 - Cash Account: General Ledger BANK STATEMENT Peachland, BC VOH 3V4 as of July 31, 20XX Stella's Hair Studio 3581 Holroyd Avenue Statement Period July 1 - July 31, 20XX Statement Date July 31, 20XX Description Ref Debit Credit Balance Peachland, BC VOH 3P7 Date Account No. 5811-001 6,947.90 Jun-30 Opening Balance Debit Card 22.89 6,925.01 Date Code/ Cheques Deposits Jul-01 Maria's Cafe (lunch with client) Details Jun-30 Balance Forward Cheque & Debits & Credits Balance Jul-02 Telus Communications ch# 0852 54.00 6,871.01 Jul-02 Cheque 7,922.14 EFT in 117.60 6,988.61 0849 Jul-03 Caroline Shuster (product) Jul-02 POS Debit 465.96 7,456.18 27.54 6,961.07 Jul-02 Interest on Account DR memo 7,433.29 Jul-05 Save on Foods -salon flowers ch# 0854 22.89 Jul-02 Deposit INT 7.84 7,441.13 Chelsea C ch# 0855 572.34 6,288.73 Jul-03 EFT DEP 1,249.85 8,690.98 Jul-05 Tabitha Trimm -payroll ch# 0856 327.88 5,960.85 Jul-05 Deposit CR memo 1 17.60 8,808.58 DEP 895.50 6,856.35 395.50 9,704.08 Jul-05 weekly deposit Deposit Jul-05 Cheque Jul-05 Cheque 0851 354.75 9,349.33 Jul-08 Shopper's Drug Mart (toiletries) Debit Card 17.99 6,838.36 Jul-05 Cheque 0855 672.34 8,676.99 Jul-08 Andrea Stone (7 kids bday cuts) EFT in 105.00 6,943.36 0856 Jul-08 EFT 327.88 8,349.11 94.75 CR memo 7,038.11 Jul-08 EFT 105.00 EFT in 8,454.11 Jul-08 John Gregorson (perm) Jul-08 POS Debit CR memo 94.75 8,548.86 Jul-09 Ron's Express Delivery ch# 0857 22.40 7,015.71 DR memo Jul-09 Cheque 17.99 3,530.87 Jul-09 Walmart -office supplies ch# 0858 31.48 6,984.23 0843 Jul-09 Cheque 672.3 7,858.53 0853 32.60 Jul-09 Sally's Beautician Boutique ch# 0859 79.53 6,704.70 Jul-09 Cheque 7,825.93 0857 22.40 ,803.53 Jul-11 Costco -computer supplies ch# 0860 82.87 6,621.83 Jul-10 Cheque 0854 27.54 Jul-12 Cheque 7,775.99 Jul-11 BC Beauty Store ch# 0861 412.98 6,208.85 0852 54.00 Jul-12 EFT ,721.99 Jul-12 weekly deposit Deposit CR memo 1,008.65 7,217.50 200.00 7,921.99 Jul-12 Deposit DEP 1,008.65 3,930.64 Jul-12 Roger Jones (mother's gift cert) EFT in 200.00 7,417.50 Jul-14 Cheque 0848 57.50 8,773.14 Jul-16 EFT - MasterCard EFT out 749.27 6,668.23 Jul-15 NSF -returned chq NS 85.45 8,687.69 Jul-19 Chelsea Chop -payrol Jul-15 NSF -handling fee ch# 0862 SC 672.34 15.00 5,995.89 3,672.69 Jul-16 EFT bill payment -Mastercard |DR memo Jul-19 Tabitha Trimm -payroll 49.27 7,923.42 ch# 0863 327.88 5,668.01 Jul-19 Deposit DEP 1,304.75 9,228.17 Jul-19 weekly deposit Deposit 1,304.75 6,972.76 Jul-20 Cheque 0850 1 10.00 9, 1 18.17 Jul-22 Kingdom Beauty Supplies ch# 0864 Jul-21 EFT bill payment -BC Hydro DR memo 61.79 474.29 9,056.38 6,498.47 Jul-22 BC Beauty Store Jul-22 Cheque 0859 279.53 8,776.85 ch# 0865 1,019.84 5,478.63 Jul-22 EFT -CRA refd CR memo 1,008.61 9,785.46 Jul-22 EFT - CRA Refund EFT in 1,008.61 6,487.24 Jul-24 POS Debit DR memo 16.74 9,768.72 Jul-24 VOID ch# 0866 6,487.24 Jul-24 EFT CR memo 225.00 9,993.72 Jul-24 Canada Post (stamps) Jul-25 Cheque 0863 27.88 9,665.84 Debit Card 16.74 6,470.50 Jul-24 Jennifer Wyte (wedding hair) Jul-26 Cheque 0858 31.48 9,634.36 EFT in 225.00 Jul-26 Cheque 0860 32.87 9,551.49 Jul-26 weekly deposit 6,695.50 Deposit 1,229.00 Jul-26 Deposit DEP 1,229.00 10,780.49 7,924.50 Jul-27 Caroline Shuster (returned product) EFT out 0862 672.34 10, 108.15 33.59 Jul-27 Cheque Jul-29 Jason Issler (cut/color 7,890.91 Jul-27 EFT - refund DR memo 33.59 0,074.56 EFT in 69.75 ,960.66 Jul-28 Cheque 0864 447.29 9,627.27 Jul-30 Local Trendz Magazine ch# 0867 4.95 7,895.71 Jul-28 Cheque 0865 1,019.84 8,607.43 Jul-30 Sarah Cutlas (deposit for grad hair) EFT in 75.00 Jul-29 Cheque 0861 412.98 8,194.45 Jul-31 Millie Maid Cleaning 7,970.71 Jul-29 EFT CR memo 69.75 8,264.20 ch# 0868 354.75 7,615.96 Jul-30 EFT CR memo 75.00 8,339.20 Jul-31 Medical Services Plan ch# 0869 110.00 8,320.20 7,505.96 SC 19.00 Jul-31 end of month deposit Jul-31 Bank Charges Deposit 443.15 7,949.11 2Stella's Hair Studio has hired you to prepare their bank reconciliation for the month of July, Enclosed you will find the following: a) Previous month's bank reconciliation b) July's general ledger for the bank account C) July's bank statement d ) Weekly deposit slips and canceled cheques 1. Prepare a bank reconciliation for Stella's Hair Studio for the month ending July 31, 20XX Stella's Hair Studio Bank Reconciliation June 30, 20XX Balance as per GL, June 30, 20XX $ 6,947.90 Balance as per Bank Statement, June 30, 20XX 7,922.14 ADD Deposits in Transit 28-Jun weekly deposit $ 1,249.85 1,249.85 LESS Outstanding Cheques 17-Feb #0784 Holly's Supplies 388.54 21-Jun #0843 Chelsea Chop -payroll 672.34 25-Jun #0845 District of Peachland 75.00 26-Jun #0848 Roy's Catering 157.50 28-Jun #0849 Receiver General for Canada 465.96 28-Jun #0850 Medical Services Plan 110.00 28-Jun #0851 Millie Maid Cleaning 354.75 (2,224.09) Adjusted Balance as per Bank Statement, June 30, 20XX $ 6,947.90
