Question: OOO AutoSave OFF P ... Cash Problem Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments MMv Slicer A Tables

OOO AutoSave OFF P ... Cash Problem Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments MMv Slicer A Tables Data from Illustrations Add-ins Recommended ~ :i y Maps PivotChart Sparklines Link Tex Picture Charts Timeline New Comment E15 X fx A B C D E F G H Date Deposit Amount NP w Friday, November 27, 2020 2,500.00 4,000.00 Monday, November 30, 2020 3,500.00 2,000.00 6,000.00 6 00 10 Tuesday, December 15, 2020 5,000.00 11 12,000.00 12 13 Monday, December 28, 2020 10,000.00 14 3,000.00 15 16 Thursday, December 31, 2020 1,400.00 17 500.00 18 100.00 19 20 Thursday, January 7, 2021 1,500.00 21 2,000.00 22 23 D Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bank Stmt + Ready + 150%OOO AutoSave OFF t ... Cash Problem Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments E Slicer 4 Tables Data from Illustrations Add-ins Recommended Liv Maps PivotChart Sparklines Timeline Link New Tex Picture Charts Comment C15 X V fx 23500 A B C D E F G H Balance per Bank 17,250.00 w Reconciling Items UI A Deposits in Transit November 27 4,000.00 November 30 3,500.00 Outstanding Checks 10 1913 300.00 11 1918 400.00 12 1919 550.00 13 14 15 Balance per General Ledger $ 23,500.00 16 17 18 19 20 21 22 23 21 Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bank Stmt + Ready " - + 150%OOO AutoSave OFF P ... 3Cash Problem Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Slicer 4 Tables Data from Illustrations Add-ins Recommended Liv Maps PivotChart Sparklines Timeline Link New Tex Picture Charts Comment F13 X fx A B C D E F G H I Balance per Bank on December 31, 2020 $ 25,000.00 Provided by Client on January 7, 2021 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 21 4 D Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bank Stmt + Ready + 150%OOO AutoSave OFF Cash Problem Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me LE Share Comments Slicer Tables Data from Illustrations Add-ins Recommended d vivi Maps PivotChart Sparklines Timeline Link New Tex Picture Charts Comment E7 X V fx A B C D E F G H Bank Balance December 31, 2020 25,000.00 Deposits Made January 2, 2021 10,000.00 January 2, 2021 3,000.00 January 8, 2021 1,500.00 January 8, 2021 2,000.00 9 Checks Cashed 10 1913 300.00 11 1927 900.00 12 1933 500.00 13 1938 7,000.00 14 1939 800.00 15 1940 9,000.00 16 1943 2,000.00 17 1944 1,900.00 18 1945 200.00 19 1946 400.00 20 21 NSF Check Returned (Check Deposited 12/28/20) s 3,000.00 22 23 Bank Balance January 10, 2021 $ 15,500.00 Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bank Stmt + Ready + 150%O AutoSave OFF P ... Cash Problem (1) Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Calibri (Body) v 12 V AA % Conditional Formatting v O Format as Table Paste BIUV DVAv Alignment Number Cells Editing Analyze Sensitivity Create and Share i Cell Styles v Data Adobe PDF G8 X V fx A B C D E F G H K Check Date Check Number Check Amount - WN Monday, November 23, 2020 1911 200.00 1912 500.00 1913 300.00 1914 50.00 Monday, November 30, 2020 1915 1,000.00 1916 $ 2,500.00 10 1917 400.00 11 1918 400.00 12 1919 550.00 13 1920 1,900.00 14 15 Monday, December 7, 2020 1921 2,100.00 16 1922 100.00 17 1923 200.00 18 1933 500.00 19 1924 750.00 20 1925 8,000.00 21 22 Monday, December 14, 2020 1926 VOID 23 1927 900.00 Cash Disbursement Journal Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bar + Ready + 150%OOO AutoSave OFF 3 Cash Problem (1) Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me LE Share Comments Calibri (Body) v 12 AA % " Conditional Formatting O. Format as Table Paste BI UV vAv Alignment Number Cells Editing Analyze Sensitivity Create and Share Cell Styles v Data Adobe PDF G8 X V fx A B C D E F G H K 22 Monday, December 14, 2020 1926 VOID 23 1927 S 900.00 24 25 Monday, December 21, 2020 1928 $ 1,500.00 26 1929 $ 3,000.00 27 1930 100.00 28 1931 50.00 29 1932 250.00 30 1934 2,500.00 31 32 Monday, December 28, 2020 1935 1,000.00 33 1936 300.00 34 1937 600.00 35 1938 7,000.00 36 1939 800.00 37 1940 9,000.00 38 1941 250.00 39 1942 100.00 40 41 Monday, January 4, 2021 1943 ur 2,000.00 42 1944 $ 1,900.00 43 1945 200.00 44 1946 400.00 Cash Disbursement Journal Cash Receipts Journal November 30 Bank Reconciliation December 31 Bank Confirmation January 10 Cut Off Bar + Ready - + 150%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1. What is the balance per bank that should be on the top line of the bank reconciliation? 2. What is the total amount of Deposits in Transit that should be included on the December 31 bank...

GO16_XL_CH01_GRADER_1G_AS - Regional Restaurant 1.5 Project Description: In the following project, you will create a worksheet summarizing the regional sales to restaurants for 2016. Steps to...

URGENT!!!!!! Excel File Edit View Insert Format Tools Data Window Help a a 20 Wed Apr 6 4:14 PM AutoSave OFF MB2 C... Book3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share...

Raven Apartments is a Canadian Apartment rental company that is looking to find ways to improve its services to improve customer satisfaction.The company requires us to develop for it a new system...

Raider Industries must follow the Lower of Cost or Market (LCM) Rule for its inventory. The following information was taken from Raiders inventory records as of December 31, 2021: Selling Replacement...

The results from the CAPM imply that the real return from a given stock (Stock(i) Rf) are directly proportional to the real return from the market portfolio (Mkt Rf). The Risk coefficient measures...

Neuqun, Inc., a publicly traded firm, is considering the acquisition of a private company, Artforever.com, which specializes in restoring damaged artwork and vintage photographs for high net worth...

"With the additional responsibilities of being a strategic business partner, the modern HR function now faces greater pressure to make sound and impactful decisions. As a result, data-driven...

Excel File Edit View Insert Format Tools Data Window Help 25% Tue 8:15:44 AM Q DE AutoSave OFF health_PS3 (3) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments & Office...

The number of households that watched the Miss Universe Pageant was 4.62 million in 2010 and decreased by about 0.13 million per year until 2014 (Source: Nielsen Media Research). Let n = f 1t2 be the...

Which of the following is NOT true of control variables? O They help establish internal validity. O They help define the control group. O They are essential in experimental designs. O They are kept...

Which one of the following statements is correct? Group of answer choices Only the trade - off theory suggests that a firm has an optimal capital structure. Both the trade - off theory and the...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...