Group Project 3 Duplicate Deposit Slips Copies Written Checks 0 points) Supreme Comgany Date: 417/10 Problem 1 Deposit Sip Cash Currency Coins 00 UD 1 st of Checks 125 00 915 00 Pay to tme Order of Janas &Company 3010 Supreme Company's boukkeeper prepared the bank reconalaton for May 31, 2010. The bookkeeper Total had tha wg ad i d TA prapiranon afthe NBT Bank One Hundrod Twenty-Fiye and no centa tha chacks, which were signad hy tha owner Deposit SilipC ck uency Coins 750 00 R OuTar, Adally.haa vartad and sgnad all chackn Mamo: Supplies il Supreme e to cash in he cash puyments journal. Assume tal the ofice manaper periomed all other duties Jenes Supreme Company Date: 415/10 Total 92 Pay to Order of Jordon $ 112 00 Deposit Silp Belance of creinUR hank statementco.4/30 3 7 ot CheciaLimency Coins 156 0 Ong Hundred twohye and no cants NRT Bank 54/10 cibwr diecixee Qurent baance as ol Uhis stalemen Sde : do 234 lSupreme $ 15, 379 eposit Sip Currency Coins 500 00 Supreme Compe Dote: 421/10 393 Date moun Transition Tyrpe Bae Dupicate Depase Sips Paga 2 Pay to the Order of Janes & Compan- 513/10 Luce 500.00 Deposil S 1,000 Total NBT Bank Fve Hundred and no cents $ 050 Mamo: rwoice 513 Supreme Deposit S815 Currency Coirns600 00 Deposit Slip Cesh tof Checks Supreme Com Dute: 424/10 394 Service Charge Bank Colection 129 00 Total 9UL $2.550 Collecton on nota, princpal $2.500 Pay to the Order of King and Cempany 21500 mount Twn Hundred nteen ars NHT Bank Date Check N See Carbon Copy of Checks Isaued Pages - 39- 125 Memo: rwnire 700 Depsit Si 44 00 ISupremes Cash Checks Duder Currency Coin 52710 370 Total Date: 4/28010 Supreme Company. 195 1 Pay to the Order of Jones & Company 10000 One Hundred and no centsa NAT Bank Depost SipC r umency Coins Memo: invoice 23609 Supreme s41 S11 03 Suureme Company Date: 24/10 Late: 4/3010 Supreme Company 396 U2 SUPREME COMPANY'S BOOKS Pay to the Order at Inity Campany" Pay to the Order of Al Kazam Leisure Man 8514 00 175.00 Cash Recelpts Recorded in Cash Recelpts Journal NBT Mank Fve Hundred tourteen and no centa Huncred seventy tve and no cents NBT Bank Memo: Invaica 010 Mamo: May Elkctrc R J Supreme Suprema 1,288 850 Date: 4/00/10 Uule: 5/27/10 Supreme Company Supreme Cumpuns 8 77100 Pay to the Order of ClyRop. Pay to the Order of Jones Intermaonal $ 415.00 Total 36.331 Seven Hundred ent ong and no vents Enu Hunded tttern and ng cents NHI Uank NBI Hank Memo: Imaice 010 Supreme Memo: Inunice s002. JJL Supreme ts Rocorded In Cash Payments Journal nredn Cash Payr eck No Sunreme Company Date: 52810 Sunrome Company Date: 501/10 104 Pay to the Order of Ca Onice 9ureler 750 00 Pay to t Order Gardiner Compeny S300.00 S1/2 3415 402 NAT Bank Sauen Hurdrad t0y and no centa Three Hundred and no can NRT Bank Memo: Imoice 870 Jil Supremes lSupreme Memo: inwaie 44 S 514 Date: 512/10 Date: 5/3010 Suprsme Com Supreme Company 05 Total-4S09 $1000 00 Pay to the Order of Jl Supreme Pay to the Onder of Father & Sons 16000 NBT Bank One Thousand and no canta NRT Bank Ono Hundred shty and no rents See duplicate deposit sips on page 2. See duplicate carbon copies of checks on pages 3-5 Asaume that gener-Jil Sunrame counted al cash recaipts dshe verifed the debit in the cash |: Whd Memo: invoioe 123 Supreme Jil Supreme me- recepts joumal and the bookkeeper deposted n bank on the same day Date: 5/20/10 Assame 4 deccr aisd e cRsh recepts Supreme Comany Supreme Company Oule: 5031/10 06 S 514 00 t did not clear the bank by the next dey was never deposhed in the bank Pay to the Order of Haprah s543 00 Pay to the Order a Thomson Leamng receipt Ftve Hundred isty ss and no cents NBT Bank NUT Uunk Five Hundred lourleen and nu cens Date Froi e Cradit Memo: Immico 571 Suprome Memo: Bogksa Jl Supremes Balance 11,338 12,760 arh Herents Canh Pavmenter 6331 Supreme Company Date 5/22/10 401 Supreme Company Dote: 5/21/10 107 4.9 Pay to Order of King & Company $ 450 00 Pay to t Order of Clpop s 800.00 Check No. 400 as ued for S543 lo H n paymen ul an Bus puyat. The NS thecK NOT Dunk Four Hundred fly and no cemtu NUT Dunt Eighl Hundred and no cenls Memo: Imvoke 5 Memo: Invoice 5020 Se Jl Supremes Racatvable, The NSF check hast not bean racedad in tha ganaral ledgan The Iolomng is the bank reconalson prepared by the bookheeper for April 30, 2010. SUPREME COMPANY ND shaald racalva the cash raca pta and maia tha dapcait at the hank whan thar BANK RECONCILIATION Who shoule prepare the monthty bank recondlation? Indude the ratonale for your SUPREME COMPANY ancwer ay 31, 2010 sian the chedka? incude therationala for BANK RECONCILIATION shde da ehesidnocina Incuso tho ratonao rvour ese (Pronare Ean 3 15.379 ng tn hnk sIeaert April 30, 2010 3 on the Group Project Excel Spreadsheet Probiem 1 parts 2 Jtab) $915 ncvdng a ounal entry for the embezdement eaume the embezzlement wae newer $12.760 $915 Cash baiance according to bank ststoment Less t& Record the jaurmal entres on the Group Project Excel Spreadsheet Problrm 1 Qustancing Chacs Make sure lo rdude euch Outstandng hecka 407 800 125 $14.570 Adjusied Balance 00 Problem 2 (40 points) 305 100 E2200 1. Rad lhe kalg isaic spresdstel Problem 2 parls 26 ta nd stml sl meal n th Gp PrciE and Probim 2 pat7 l edliore to Haek account art recreded on baos praceeds trom col ecton of natn tJeuary 1 cl tre r. In the (Group Project Excel Spreads heet Problem 2 Parts 2- tab) bttul accounts 12,200 CrecH 2. cutert r Adjusted Baisno 1141 $ 15.311 sp200 Cash balance accordng to the ledger Deductions by bank not recorded on books. 10 Che Aumed $561 Princea $2500 3 Rcd saang a a n banaral journal form in th Group Prolae Empr in recardinn Chesk don Emrar in recordng check 35 Adjusted Balance 4. Fact heae trancactions to the three ssiected accounts above and to Accounts recocvabie in the $270 oject Excel spr Decuctore by bank not recorded on booss Required: the erding balanca in tha - cuns Rcaahla acccunt Etar thase halancea in tha Group Project Excel Spraadshest ESdbet Drio 1 parts 1 &4 tab Adjusted Balance Acceptod a $20,000 one year, N nong dated April 1 from Bruce Harcon for Aer 1, 09 2 nect i ce Gu r x edbat and wrot: oe remainder as uncolect F& Knc C, taengl thal $14,500 wil be uncollecle, Record the adustng entry using the Aang . ano inemal comrols to peovart tris ambezziement tom buin E 1 wi he only pard wha wl be wonding in Dec. 31 Record the adjustng entry for irteres accrued on the Eruce Hanson noe Incude in yr isssion the folowin 7 of 12 2752 words Group Project 3 Duplicate Deposit Slips Copies Written Checks 0 points) Supreme Comgany Date: 417/10 Problem 1 Deposit Sip Cash Currency Coins 00 UD 1 st of Checks 125 00 915 00 Pay to tme Order of Janas &Company 3010 Supreme Company's boukkeeper prepared the bank reconalaton for May 31, 2010. The bookkeeper Total had tha wg ad i d TA prapiranon afthe NBT Bank One Hundrod Twenty-Fiye and no centa tha chacks, which were signad hy tha owner Deposit SilipC ck uency Coins 750 00 R OuTar, Adally.haa vartad and sgnad all chackn Mamo: Supplies il Supreme e to cash in he cash puyments journal. Assume tal the ofice manaper periomed all other duties Jenes Supreme Company Date: 415/10 Total 92 Pay to Order of Jordon $ 112 00 Deposit Silp Belance of creinUR hank statementco.4/30 3 7 ot CheciaLimency Coins 156 0 Ong Hundred twohye and no cants NRT Bank 54/10 cibwr diecixee Qurent baance as ol Uhis stalemen Sde : do 234 lSupreme $ 15, 379 eposit Sip Currency Coins 500 00 Supreme Compe Dote: 421/10 393 Date moun Transition Tyrpe Bae Dupicate Depase Sips Paga 2 Pay to the Order of Janes & Compan- 513/10 Luce 500.00 Deposil S 1,000 Total NBT Bank Fve Hundred and no cents $ 050 Mamo: rwoice 513 Supreme Deposit S815 Currency Coirns600 00 Deposit Slip Cesh tof Checks Supreme Com Dute: 424/10 394 Service Charge Bank Colection 129 00 Total 9UL $2.550 Collecton on nota, princpal $2.500 Pay to the Order of King and Cempany 21500 mount Twn Hundred nteen ars NHT Bank Date Check N See Carbon Copy of Checks Isaued Pages - 39- 125 Memo: rwnire 700 Depsit Si 44 00 ISupremes Cash Checks Duder Currency Coin 52710 370 Total Date: 4/28010 Supreme Company. 195 1 Pay to the Order of Jones & Company 10000 One Hundred and no centsa NAT Bank Depost SipC r umency Coins Memo: invoice 23609 Supreme s41 S11 03 Suureme Company Date: 24/10 Late: 4/3010 Supreme Company 396 U2 SUPREME COMPANY'S BOOKS Pay to the Order at Inity Campany" Pay to the Order of Al Kazam Leisure Man 8514 00 175.00 Cash Recelpts Recorded in Cash Recelpts Journal NBT Mank Fve Hundred tourteen and no centa Huncred seventy tve and no cents NBT Bank Memo: Invaica 010 Mamo: May Elkctrc R J Supreme Suprema 1,288 850 Date: 4/00/10 Uule: 5/27/10 Supreme Company Supreme Cumpuns 8 77100 Pay to the Order of ClyRop. Pay to the Order of Jones Intermaonal $ 415.00 Total 36.331 Seven Hundred ent ong and no vents Enu Hunded tttern and ng cents NHI Uank NBI Hank Memo: Imaice 010 Supreme Memo: Inunice s002. JJL Supreme ts Rocorded In Cash Payments Journal nredn Cash Payr eck No Sunreme Company Date: 52810 Sunrome Company Date: 501/10 104 Pay to the Order of Ca Onice 9ureler 750 00 Pay to t Order Gardiner Compeny S300.00 S1/2 3415 402 NAT Bank Sauen Hurdrad t0y and no centa Three Hundred and no can NRT Bank Memo: Imoice 870 Jil Supremes lSupreme Memo: inwaie 44 S 514 Date: 512/10 Date: 5/3010 Suprsme Com Supreme Company 05 Total-4S09 $1000 00 Pay to the Order of Jl Supreme Pay to the Onder of Father & Sons 16000 NBT Bank One Thousand and no canta NRT Bank Ono Hundred shty and no rents See duplicate deposit sips on page 2. See duplicate carbon copies of checks on pages 3-5 Asaume that gener-Jil Sunrame counted al cash recaipts dshe verifed the debit in the cash |: Whd Memo: invoioe 123 Supreme Jil Supreme me- recepts joumal and the bookkeeper deposted n bank on the same day Date: 5/20/10 Assame 4 deccr aisd e cRsh recepts Supreme Comany Supreme Company Oule: 5031/10 06 S 514 00 t did not clear the bank by the next dey was never deposhed in the bank Pay to the Order of Haprah s543 00 Pay to the Order a Thomson Leamng receipt Ftve Hundred isty ss and no cents NBT Bank NUT Uunk Five Hundred lourleen and nu cens Date Froi e Cradit Memo: Immico 571 Suprome Memo: Bogksa Jl Supremes Balance 11,338 12,760 arh Herents Canh Pavmenter 6331 Supreme Company Date 5/22/10 401 Supreme Company Dote: 5/21/10 107 4.9 Pay to Order of King & Company $ 450 00 Pay to t Order of Clpop s 800.00 Check No. 400 as ued for S543 lo H n paymen ul an Bus puyat. The NS thecK NOT Dunk Four Hundred fly and no cemtu NUT Dunt Eighl Hundred and no cenls Memo: Imvoke 5 Memo: Invoice 5020 Se Jl Supremes Racatvable, The NSF check hast not bean racedad in tha ganaral ledgan The Iolomng is the bank reconalson prepared by the bookheeper for April 30, 2010. SUPREME COMPANY ND shaald racalva the cash raca pta and maia tha dapcait at the hank whan thar BANK RECONCILIATION Who shoule prepare the monthty bank recondlation? Indude the ratonale for your SUPREME COMPANY ancwer ay 31, 2010 sian the chedka? incude therationala for BANK RECONCILIATION shde da ehesidnocina Incuso tho ratonao rvour ese (Pronare Ean 3 15.379 ng tn hnk sIeaert April 30, 2010 3 on the Group Project Excel Spreadsheet Probiem 1 parts 2 Jtab) $915 ncvdng a ounal entry for the embezdement eaume the embezzlement wae newer $12.760 $915 Cash baiance according to bank ststoment Less t& Record the jaurmal entres on the Group Project Excel Spreadsheet Problrm 1 Qustancing Chacs Make sure lo rdude euch Outstandng hecka 407 800 125 $14.570 Adjusied Balance 00 Problem 2 (40 points) 305 100 E2200 1. Rad lhe kalg isaic spresdstel Problem 2 parls 26 ta nd stml sl meal n th Gp PrciE and Probim 2 pat7 l edliore to Haek account art recreded on baos praceeds trom col ecton of natn tJeuary 1 cl tre r. In the (Group Project Excel Spreads heet Problem 2 Parts 2- tab) bttul accounts 12,200 CrecH 2. cutert r Adjusted Baisno 1141 $ 15.311 sp200 Cash balance accordng to the ledger Deductions by bank not recorded on books. 10 Che Aumed $561 Princea $2500 3 Rcd saang a a n banaral journal form in th Group Prolae Empr in recardinn Chesk don Emrar in recordng check 35 Adjusted Balance 4. Fact heae trancactions to the three ssiected accounts above and to Accounts recocvabie in the $270 oject Excel spr Decuctore by bank not recorded on booss Required: the erding balanca in tha - cuns Rcaahla acccunt Etar thase halancea in tha Group Project Excel Spraadshest ESdbet Drio 1 parts 1 &4 tab Adjusted Balance Acceptod a $20,000 one year, N nong dated April 1 from Bruce Harcon for Aer 1, 09 2 nect i ce Gu r x edbat and wrot: oe remainder as uncolect F& Knc C, taengl thal $14,500 wil be uncollecle, Record the adustng entry using the Aang . ano inemal comrols to peovart tris ambezziement tom buin E 1 wi he only pard wha wl be wonding in Dec. 31 Record the adjustng entry for irteres accrued on the Eruce Hanson noe Incude in yr isssion the folowin 7 of 12 2752 words