Please help! How can I reconcile these accounts?! I am beyond stuck. Thank you!
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 Peachland, BC VOH 3P7 Statement Date July 31, 20XX Ref Debit Credit Balance Account No. 5811-001 Date Description ,947.90 Jun-30 Opening Balance Date Code/ 22.89 6,925.01 Details Cheques Deposits Jul-01 Maria's Cafe (lunch with client) Debit Card 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 0849 Jul-03 Caroline Shuster (product) EFT in 117.60 6,988.61 Jul-02 POS Debit 465.96 7,456.18 Jul-02 Interest on Account DR memo 22.89 27.54 7,433.29 Jul-05 Save on Foods -salon flowers ch# 0854 6,961.07 Jul-02 Deposit INT 1.84 7,441.13 Jul-05 Chelsea Chop -payrol ch# 0855 572.34 6,288.73 Jul-03 EFT DEP 1,249.85 8,690.98 h# 0856 327.88 5,960.85 Jul-05 Deposit CR memo 117.60 8,808.58 Jul-05 Tabitha Trimm -payroll 895.50 Jul-05 weekly deposit Deposit 895.50 6,856.35 Jul-05 Cheque DEP 9,704.08 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 0856 327.88 Jul-08 Andrea Stone (7 kids bday cuts EFT in 105.00 6,943.36 Jul-08 EFT 8,349.11 Jul-08 EFT CR memo 105.00 8,454.11 Jul-08 John Gregorson (perm EFT in 94.75 7,038.11 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 8,530.87 0843 Jul-09 Walmart -office supplies ch# 0858 31.48 6,984.23 Jul-09 Cheque 572.34 7,858.53 0853 32.60 7,825.93 Jul-09 Sally's Beautician Boutique ch# 085 279.53 6,704.70 Jul-09 Cheque 0857 22.40 7,803.53 ul-11 Costco -computer supplies ch# 0860 Jul-10 Cheque 82.87 6,621.83 0854 Jul-12 Cheque 27.54 7,775.99 Jul-11 BC Beauty Store 0852 ch# 086 54.00 12.98 6,208.85 Jul- 12 EFT 7,721.99 CR memo Jul-12 weekly deposit Jul-12 Deposit 200.00 7,921.99 Deposit 1,008.65 7,217.50 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 157.50 8,773.14 Jul-16 EFT - MasterCard Jul-15 NSF -returned cho EFT ou 749.27 85.45 6,668.23 NS 8,687.69 Jul-15 NSF -handling fee Jul-19 Chelsea Chop -payroll SC 15.00 ch# 0862 8,672.69 672.34 5,995.89 Jul-16 EFT bill payment -Mastercard DR memo 749.27 7,923.42 Jul-19 Tabitha Trimm -payroll ch# 0863 327.88 5,668.01 Jul-19 Deposit DEP 1,304.75 9,228.17 Jul-19 weekly deposit Jul-20 Cheque Deposit 1,304.75 6,972.76 0850 1 10.00 9, 1 18.17 Jul-22 Kingdom Beauty Supplies Jul-21 EFT bill payment -BC Hydro DR memo 61.79 ch# 0864 9,056.38 474.29 6,498.47 Jul-22 Cheque 0859 279.53 ul-22 BC Beauty Store 8,776.85 ch# 0865 1,019.84 9,785.46 ul-22 EFT - CRA Refund 5,478.63 Jul-22 EFT -CRA refo CR memo 1,008.61 LEFT in 1,008.61 Jul-24 POS Debit DR memo 16.74 9,768.72 Jul-24 VOID 6,487.24 Jul-24 EFT ch# 0866 CR memo 225.00 9,993.72 Jul-24 Canada Post (stamps) 6,487.24 Jul-25 Cheque 0863 327.88 9,665.84 Debit Card Jul-26 Cheque 0858 31.48 9,634.36 Jul-24 Jennifer Wyte (wedding hair) 16.74 6,470.50 EFT in 225.00 Jul-26 Cheque 0860 82.87 9,551.49 Jul-26 weekly deposit 5,695.50 Deposit Jul-26 Deposit DEP 1,229.00 10,780.49 1,229.00 Jul-27 Caroline Shuster (returned product) EFT out 7,924.50 Jul-27 Cheque 0862 672.34 10, 108.15 Jul-29 Jason Issler (cut/color) 33.59 7,890.91 Jul-27 EFT - refund DR memo 33.59 0,074.56 EFT in 59.75 9,627.27 7,960.66 Jul-28 Cheque 0864 147.29 Jul-30 Local Trendz Magazine ch# 0867 64.95 Jul-28 Cheque 0865 ,019.84 3,607.43 Jul-30 Sarah Cutlas (deposit for grad hair) EFT in 7,895.71 Jul-29 Cheque 0861 412.98 8, 194.45 Jul-31 Millie Maid Cleaning 75.00 7,970.71 Jul-29 EF CR memo 59.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 SC 19.00 8,320.20 Jul-31 end of month deposit 110.00 7,505.96 Jul-31 Bank Charges Deposit 443.15 7,949.11onciliation 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) Ijusted Balance as per Bank Statement, June 30, 20XX $ 6,947.90
