So, I am doing this accounting assignment about bank reconciliations and the adjustments should equal each other, but they don't for me. So can you please look at my work as well as the information I used to complete the assignment to help me figure out where I went wrong. I will link everything as attachments.
AutoSave . Off) assign_ledger - Compatibility M... - Saved G Kareena Ali KA X File Home Insert Design Layout References Mailings Review View Help Ginger Table Design Layout Share Comments Find LO X Arial * 10 ~ A" A" Aa A AaBbCc[ AaBbCc[ AaBbCcD AaBbCcL AaBbCCI Paste Copy c Replace 1 Normal 1 No Spac... Subtitle Subtle Em... Emphasis Dictate Ginger Format Painter BIU ab X x A LA Select Clipboard Font Paragraph Styles Editing Voice Ginger Tools +. Bank Account Ledger Cheque Date Descriptions of transaction Amount Amount Balance # of of Cheque Deposit 1-Oct Balance forward 13,610.39 1-Oct Deposit 75.50 0 13,685.89 220 1-Oct John Green 975.00 0 12,710.89 221 2-Oct Ontario Telephone 42.75 0 12,668.14 222 5-Oct Ontario Hydro 99.65 12,568.49 223 5-Oct Toronto Office Supply 25.64 12,542.85 224 5-Oct Propane Fuels 79.41 0 12,463.44 225 7-Oct Shell 20.78 0 12,442.66 226 7-Oct Toronto Office Supply 124.96 0 12,317.70 227 10-Oct Toronto Office Supply 15.44 12,302.26 228 12-Oct 407 ETR 65.21 0 12,237.05 229 12-Oct Heidi Lanscome, Accountant 325.00 11,912.05 230 15-Oct Esso 15.88 11,896.17 231 15-Oct Car Repair Shop 96.42 0 11,799.75 17-Oct Deposit 0 648.74 0 12,448.49 232 19-Oct Mobile Phone Unit 32.69 0 12,415.80 20-Oct Deposit 550.50 0 12,966.30 233 21-Oct J.D. Power Insurance 147.82 12,818.48 25-Oct Deposit 450.25 0 13,268.73 31-Oct Deposit 98.70 13,367.43 234 31-Oct DRV Fuels 106.55 13,260.88 235 31-Oct Property Management Team 1,250.00 12,010.88 Page 1 of 1 161 words [ English (United States) " Focus + 100% N 7:30 PM O Type here to search eo S X W 0 7 ( ENG 2019-12-09assign_stmt - Compatibility M... - Saved O G Kareena Ali KA X AutoSave . Off) File Home Insert Design Layout References Mailings Review View Help Ginger Table Design Layout Share Comments Find X Cut Times New Rom * 10 A" A Aa Po 24 AaBbCc[ AaBbCc[ AaBbCcD AaBbCcL AaBbCCI Paste [ Copy c Replace BIUbXX ALA. 1 Normal 1 No Spac... Subtitle Subtle Em... Emphasis Select v Dictate Ginger Format Painter Clipboard Font Paragraph Styles Editing Voice Ginger Tools 2102 Queen St. North Small Town, Ontario MAW 2E6 BANK STATEMENT Leduc Web Design Account # 5577-68992-103 Date Description Deposits Cheques Balance 1-Oct Balance forward 13,956.52 1-Oct Deposit 450.00 14.406.52 1-Oct Deposit 87.49 14.474.00 1-Oct Deposit 75.50 14.549.50 t Cheque # 221 42.75 14.506.75 5-Oct Cheque # 188 96.02 14.410.73 t Cheque # 218 18.60 14.392.13 t Cheque # 224 79.41 14.312.72 16-Oct Cheque # 223 25.64 14.287.08 17-Oct Deposit 648.74 14,935.82 18-Oct Cheque # 228 124.96 14.810.86 19-Oct Cheque # 230 15.88 14.794.98 20-Oct Deposit 550.50 15.345.48 20-Oct Cheque # 228 85.21 15.280.27 20-Oct Cheque # 231 96.42 15.183.85 21-Oct Cheque # 203 748.09 14.434.86 22-Oct NS 580.50 13,854.36 25-Oct Deposit 450.25 14.304.61 25-Oct Cheque # 232 32.69 14.271.92 28-Oct Cheque # 225 20.78 14.251.14 27-Oct Cheque # 227 15.44 14.235.70 31-Oct Cheque # 234 106.55 14.129.15 31-Oct Cheque # 222 99.65 14.029.50 31-Oct Service fee 30.00 13.909.50 Note: The NSF cheque is from Texacor Inc. for $550.50 plus a bank service charge of $30.00 for the NSF cheque. Page 1 of 1 174 words [ English (United States) [ Focus H + 75% 7:30 PM O Type here to search e o N X W " (ENG 2019-12-09AutoSave . Off) 15 - 7) - assign_prior_rec - Compatibility M... - Saved G Kareena Ali KA X File Home Insert Design Layout References Mailings Review View Help Ginger Table Design Layout Share Comments LO X Cut Arial v 9 A" A Aa A 24 Find AaBbCc[ AaBbCc[ AaBbCcD AaBbCcL AaBbCCI c Replace Paste Copy BIUxx ALA. 1 Normal 1 No Spac... Subtitle Subtle Em... Emphasis Ginger Format Painter Select v Dictate Clipboard Font Paragraph Styles Editing Voice Ginger Tools Leduc Web Design Bank Reconciliation Statement For the month ended September 30, 20xx Balance as per bank statement September 30, 20xx $ 13,956.52 Plus: Outstanding Deposits 30-Sep $ 450.00 30-Sep 67.48 0 0 $ 517.48 Less: Outstanding Cheque # 188 $ 96.02 # 203 748.99 # 218 18.60 863.61 Adjusted balance as per bank Sep. 30, 20xx $ 13.610.39 Balance as per bank ledger account $ 13,640.39 Less: Bank service charge 30.00 30.00 Adjusted balance as per bank account Sep 30, 20xx $ 13,610 39 Page 1 of 1 87 words [ English (United States) [ Focus + 100% 7:31 PM O Type here to search X W 0 7( ENG 2019-12-09AutoSave . Off) H U7A2 Template (1) - Compatibility Mode - Sav. Search Kareena Ali KA X File Home Insert Page Layout Formulas Data Review View Help Share Comments LO Arial 10 ~ A A = = ab Wrap Text General IX Ex AYO Paste BIU ~ E GEE Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas K14 X V A B C D E F G H J K L M N O P Q R S T Leduc Web Design Bank Reconciliation Statement For the month ended October 31, 2015 Balance as per bank statement October 31, 2015 $13,999.50 Plus: Outstanding Deposits 31-Oct $ 98.70 98.70 10 11 Less: Outstanding Cheques 01-Oct $ 975.00 12 12-Oct 325.00 13 21-Oct 147.82 14 31-Oct 1,250.00 2,697.82 15 16 Adjusted balance as per bank October 31, 2015 $11.400.38 17 18 19 Balance as per bank ledger account $12,010.88 20 21 Less: NSF 22-Oct $ 580.50 22 580.50 23 24 Adjusted balance as per bank account October 31, 2015 $11.430.38 25 26 27 reconciliation journal Sheet3 + I + 100% X W 7:28 PM Type here to search 0 / ENG 2019-12-09 LJ
