Question 1 Use the following tab to answer below question Question 1 Data Required Please prepare the bank reconciliation as of February 28, 2023 for the two bank accounts in proper form Use the data below to answer Question 1 Bank Account A $1,525,361 25 Bank Account A Outstanding Cheques Bank Account B Outstanding Cheques Cheque Cheque Date Cheque Amount Cheque Cheque Date Cheque Amount Bank Account B $92,225 25 30310 28 Feb 23 1577 81 13154 20 Feb 23 690 00 30311 28 Feb 23 130 55 13157 26 Feb 23 175 00 GL Balance $1,592,248 94 12089 28 Feb 23 1022 31 13160 28 Feb 23 695 69 12090 28 Feb 23 263 64 11979 28 Feb 23 3659 00 Imprest (Cash) Account $29,500 00 30310 28 Feb 23 521 00 13156 26 Feb 23 350 00 30311 28 Feb 23 57 55 13161 28 Feb 23 600 00 Deposits Journalized in February but deposited to the bank in March $82,243 77 12088 24 Jan 23 285 58 11973 28 Feb 23 1604 09 30310 28 Feb 23 1215 27 13155 26 Feb 23 69 15 Stop payment for Cheque 13151 reversed twice in error $314 00 30311 28 Feb 23 71 95 13158 26 Feb 23 250 00 30404 25 Jan 23 254 25 13159 26 Feb 23 264 95 30406 1 Feb 23 20 33 13153 31 Jan 23 400 35 30407 1 Feb 23 28 35 11904 15 Jan 23 1804 15 30409 19 Feb 23 19 96 11636 29 Aug 22 40 24 30410 26 Feb 23 67 74 15600 14 Feb 23 115 48 30310 28 Feb 23 1003 28 15601 14 Feb 23 180 00 30311 28 Feb 23 110 81 15602 14 Feb 23 2000 00 30069 24 Jul 22 20 00 15603 16 Feb 23 36 77 30082 18 Oct 22 105 00 15606 27 Feb 23 1100 00 30092 18 Oct 22 105 00 15604 21 Feb 23 600 00 30098 18 Oct 22 105 00 15605 27 Feb 23 369 39 11946 14 Feb 23 1958 36 11915 22 Jan 23 1436 61 21092 3 Oct 22 3000 00 21193 12 Feb 23 750 00 21197 15 Feb 23 57 59 21202 15 Feb 23 86 04 21203 16 Feb 23 6 55 21204 16 Feb 23 944 47 21207 20 Feb 23 190 83 21209 21 Feb 23 400 00 21205 16 Feb 23 12 00 21206 19 Feb 23 356 00 21208 21 Feb 23 127 31 21210 22 Feb 23 1026 00 21211 22 Feb 23 35 00 21212 26 Feb 23 111 55 21213 26 Feb 23 26 99 21214 26 Feb 23 35 41 21215 26 Feb 23 4500 00 21216 27 Feb 23 801 59 21217 27 Feb 23 375 00 21218 27 Feb 23 22 02 21219 28 Feb 23 200 00 21220 28 Feb 23 725 00 11966 14 Feb 23 1192 60 11970 14 Feb 23 461 20 11979 28 Feb 23 40 00 18245 22 Jan 23 2000 00 18244 22 Jan 23 1200 00 18249 31 Jan 23 467 85 11916 22 Jan 23 1021 65 11842 19 Dec 22 72 08 18256 19 Feb 23 132 00 18258 26 Feb 23 277 25 18252 12 Feb 23 958 00 18254 14 Feb 23 250 00 18257 23 Feb 23 125 00 18262 28 Feb 23 200 00 18263 28 Feb 23 802 99 11974 28 Feb 23 555 96 11955 14 Feb 23 2110 28 11978 28 Feb 23 2476 48 11979 28 Feb 23 120 00 18253 14 Feb 23 22 60 18260 27 Feb 23 713 00 18255 19 Feb 23 211 16 18259 26 Feb 23 5323 34 18261 28 Feb 23 47 57 18264 28 Feb 23 514 50 11953 14 Feb 23 1292 69 11954 14 Feb 23 772 07 11901 11 Jan 23 2026 58 23965 19 Feb 23 113 57 23968 20 Feb 23 391 16 11942 13 Feb 23 7152 01 23966 19 Feb 23 99 44 23967 20 Feb 23 573 95 23969 28 Feb 23 616 85 11949 14 Feb 23 453 18 11975 28 Feb 23 3129 94 11979 28 Feb 23 1398 00 11903 12 Jan 23 21 62 25559 20 Feb 23 230 14 25560 28 Feb 23 72 18 25561 28 Feb 23 3500 00 25562 28 Feb 23 250 00 11972 14 Feb 23 549 08 11957 14 Feb 23 1401 26 27570 31 Jan 23 650 00 27574 28 Feb 23 2800 00 27572 26 Feb 23 681 41 27573 28 Feb 23 36 00 27576 28 Feb 23 500 00 11979 28 Feb 23 2044 00 27571 26 Feb 23 525 00 27577 28 Feb 23 3750 00 11976 28 Feb 23 2990 35 27575 28 Feb 23 2400 00 11943 13 Feb 23 3392 15 11963 14 Feb 23 1625 90 11977 28 Feb 23 1979 20 29783 25 Jan 23 113 00 11893 10 Jan 23 1926 29 11769 21 Nov 22 1335 50 11866 24 Dec 22 336 00 29754 8 Oct 22 158 20 29785 8 Feb 23 56 47 29788 16 Feb 23 39 00 29791 16 Feb 23 50 00 29793 22 Feb 23 55 79 29795 28 Feb 23 503 25 29786 12 Feb 23 445 10 29789 16 Feb 23 25 00 29790 16 Feb 23 130 82 29792 21 Feb 23 1412 00 29794 28 Feb 23 50 00 11958 14 Feb 23 1717 25 11959 14 Feb 23 1512 01 11979 28 Feb 23 2739 00 31387 22 Dec 22 150 00 31388 23 Dec 22 265 50 31389 21 Jan 23 1163 50 31390 21 Jan 23 150 00 31391 21 Jan 23 126 56 11931 31 Jan 23 258 90 31392 23 Feb 23 350 00 31393 23 Feb 23 271 50 11965 14 Feb 23 186 62 11846 19 Dec 22 15 00 33203 30 Jan 23 775 00 33207 27 Feb 23 2500 00 33205 27 Feb 23 3000 00 33206 27 Feb 23 2500 00 33204 15 Feb 23 1439 47 33208 27 Feb 23 3000 00 33209 28 Feb 23 752 00

Question: Question 1 Use

Question 1

Use the following tab to answer below question: Question 1 - Data
Required:
Please prepare the bank reconciliation as of February 28, 2023 for the two bank accounts in proper form.

Use the data below to answer Question 1


Bank Account A:	$1,525,361.25	Bank Account A - Outstanding Cheques			Bank Account B - Outstanding Cheques
		Cheque #	Cheque Date	Cheque Amount	Cheque #	Cheque Date	Cheque Amount
Bank Account B:	$92,225.25	30310	28-Feb-23	1577.81	13154	20-Feb-23	690.00
		30311	28-Feb-23	130.55	13157	26-Feb-23	175.00
GL Balance:	$1,592,248.94	12089	28-Feb-23	1022.31	13160	28-Feb-23	695.69
		12090	28-Feb-23	263.64	11979	28-Feb-23	3659.00
Imprest (Cash) Account:	$29,500.00	30310	28-Feb-23	521.00	13156	26-Feb-23	350.00
		30311	28-Feb-23	57.55	13161	28-Feb-23	600.00
Deposits Journalized in February but deposited to the bank in March	$82,243.77	12088	24-Jan-23	285.58	11973	28-Feb-23	1604.09
		30310	28-Feb-23	1215.27	13155	26-Feb-23	69.15
Stop payment for Cheque #13151 reversed twice in error	$314.00	30311	28-Feb-23	71.95	13158	26-Feb-23	250.00
		30404	25-Jan-23	254.25	13159	26-Feb-23	264.95
		30406	1-Feb-23	20.33	13153	31-Jan-23	400.35
		30407	1-Feb-23	28.35	11904	15-Jan-23	1804.15
		30409	19-Feb-23	19.96	11636	29-Aug-22	40.24
		30410	26-Feb-23	67.74	15600	14-Feb-23	115.48
		30310	28-Feb-23	1003.28	15601	14-Feb-23	180.00
		30311	28-Feb-23	110.81	15602	14-Feb-23	2000.00
		30069	24-Jul-22	20.00	15603	16-Feb-23	36.77
		30082	18-Oct-22	105.00	15606	27-Feb-23	1100.00
		30092	18-Oct-22	105.00	15604	21-Feb-23	600.00
		30098	18-Oct-22	105.00	15605	27-Feb-23	369.39
					11946	14-Feb-23	1958.36
					11915	22-Jan-23	1436.61
					21092	3-Oct-22	3000.00
					21193	12-Feb-23	750.00
					21197	15-Feb-23	57.59
					21202	15-Feb-23	86.04
					21203	16-Feb-23	6.55
					21204	16-Feb-23	944.47
					21207	20-Feb-23	190.83
					21209	21-Feb-23	400.00
					21205	16-Feb-23	12.00
					21206	19-Feb-23	356.00
					21208	21-Feb-23	127.31
					21210	22-Feb-23	1026.00
					21211	22-Feb-23	35.00
					21212	26-Feb-23	111.55
					21213	26-Feb-23	26.99
					21214	26-Feb-23	35.41
					21215	26-Feb-23	4500.00
					21216	27-Feb-23	801.59
					21217	27-Feb-23	375.00
					21218	27-Feb-23	22.02
					21219	28-Feb-23	200.00
					21220	28-Feb-23	725.00
					11966	14-Feb-23	1192.60
					11970	14-Feb-23	461.20
					11979	28-Feb-23	40.00
					18245	22-Jan-23	2000.00
					18244	22-Jan-23	1200.00
					18249	31-Jan-23	467.85
					11916	22-Jan-23	1021.65
					11842	19-Dec-22	72.08
					18256	19-Feb-23	132.00
					18258	26-Feb-23	277.25
					18252	12-Feb-23	958.00
					18254	14-Feb-23	250.00
					18257	23-Feb-23	125.00
					18262	28-Feb-23	200.00
					18263	28-Feb-23	802.99
					11974	28-Feb-23	555.96
					11955	14-Feb-23	2110.28
					11978	28-Feb-23	2476.48
					11979	28-Feb-23	120.00
					18253	14-Feb-23	22.60
					18260	27-Feb-23	713.00
					18255	19-Feb-23	211.16
					18259	26-Feb-23	5323.34
					18261	28-Feb-23	47.57
					18264	28-Feb-23	514.50
					11953	14-Feb-23	1292.69
					11954	14-Feb-23	772.07
					11901	11-Jan-23	2026.58
					23965	19-Feb-23	113.57
					23968	20-Feb-23	391.16
					11942	13-Feb-23	7152.01
					23966	19-Feb-23	99.44
					23967	20-Feb-23	573.95
					23969	28-Feb-23	616.85
					11949	14-Feb-23	453.18
					11975	28-Feb-23	3129.94
					11979	28-Feb-23	1398.00
					11903	12-Jan-23	21.62
					25559	20-Feb-23	230.14
					25560	28-Feb-23	72.18
					25561	28-Feb-23	3500.00
					25562	28-Feb-23	250.00
					11972	14-Feb-23	549.08
					11957	14-Feb-23	1401.26
					27570	31-Jan-23	650.00
					27574	28-Feb-23	2800.00
					27572	26-Feb-23	681.41
					27573	28-Feb-23	36.00
					27576	28-Feb-23	500.00
					11979	28-Feb-23	2044.00
					27571	26-Feb-23	525.00
					27577	28-Feb-23	3750.00
					11976	28-Feb-23	2990.35
					27575	28-Feb-23	2400.00
					11943	13-Feb-23	3392.15
					11963	14-Feb-23	1625.90
					11977	28-Feb-23	1979.20
					29783	25-Jan-23	113.00
					11893	10-Jan-23	1926.29
					11769	21-Nov-22	1335.50
					11866	24-Dec-22	336.00
					29754	8-Oct-22	158.20
					29785	8-Feb-23	56.47
					29788	16-Feb-23	39.00
					29791	16-Feb-23	50.00
					29793	22-Feb-23	55.79
					29795	28-Feb-23	503.25
					29786	12-Feb-23	445.10
					29789	16-Feb-23	25.00
					29790	16-Feb-23	130.82
					29792	21-Feb-23	1412.00
					29794	28-Feb-23	50.00
					11958	14-Feb-23	1717.25
					11959	14-Feb-23	1512.01
					11979	28-Feb-23	2739.00
					31387	22-Dec-22	150.00
					31388	23-Dec-22	265.50
					31389	21-Jan-23	1163.50
					31390	21-Jan-23	150.00
					31391	21-Jan-23	126.56
					11931	31-Jan-23	258.90
					31392	23-Feb-23	350.00
					31393	23-Feb-23	271.50
					11965	14-Feb-23	186.62
					11846	19-Dec-22	15.00
					33203	30-Jan-23	775.00
					33207	27-Feb-23	2500.00
					33205	27-Feb-23	3000.00
					33206	27-Feb-23	2500.00
					33204	15-Feb-23	1439.47
					33208	27-Feb-23	3000.00
					33209	28-Feb-23	752.00

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Bank reconciliation for both Bank Account A and Bank Account B presented in a proper format Bank Rec... View full answer

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 Finance Questions!

The bookkeeper at Tony Company has asked you to prepare a bank reconciliation as of February 29. The February bank statement and the February T- account for cash showed the following (summarized):...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

You can use the computer- based Electronic Workpapers on the textbook website to prepare the bank reconciliation solution. Caulco Inc. is the audit client. The February bank statement is shown in...

Cherokee Company had an accounts receivable balance of $16,000 on December 31, 2013. Projected sales for the first three months of 2014 are: January $120,000 February 130,000 March 100,000 All sales...

1. A beverage company is considering whether to discontinue its line of grape soda. What factors will affect the company's decision? What is a qualitative factor? Which of the factors you listed are...

Allyson Company provided the following income statements for its first three years of operation: Required: Prepare common-size income statements by using year 1 as the base period. Round answers to...

3. Think of an aspect of your learning or functioning in a school setting that has been a source of difficulty (e.g., reading comprehension, social relationships, stress management, study habits)....

CASH DIVIDEND AND APPROPRIATION OF RETAINED EARNINGS On January 1, 20--, Krausert Companys retained earnings accounts had the following balances: Appropriated for computer.........$ 50,000...

Which part of an IPV6 Address is equivalent to the host portion of an IPv4 address? a. Subnet Mask O b. Interface ID O c. Subnet ID O d. Global Routing Prefix automates the assignment of IPv4...

Using the article by Wickham, Lehman, and Fillis (2020), define the three factors that comprise the art product. Using examples published in online news sources, discuss how each of these factors can...

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the companys costs: Fixed Cost per Month...

do it fast The following cost data for the current year relate to Puzzle Puppies Pty Ltd, a manufacturer of jigsaw puzzles: Wages for assembly line staff Material cost of cardboard Wages of factory...

Suppose that the amount of taxes in the US is equal to $1800. Suppose that the government expenditures is equal to $1800. In addition, you know that the current level of debt in the US is equal to...

For the upcoming year, Spa Supplies expects to generate $3,850,000 of revenue. Since their busy season is the spring and summer, they expect 78% of the annual revenue to be earned in Q2 and Q3 and...

Question 6 (9 points) Crocley company leased a self-manufactured machine to Yaxon company on January 1, 2022. The machine has a cost of $220,000. The lease is for an 8-year period and requires equal...

Given your personal experience with online college courses and/or remote working, what challenges and benefits have you personally had with remote working in the academic and/or professional...

7.2.2: The Power of Nature Over the past ten years the use of renewable sources of energy has become more popular. Both solar and wind energy are becoming more globally accepted as new sources of...

An environmentalist wants to determine if the median amount of potassium (mg/L) in rainwater in Lincoln County, Nebraska, is different from that in the rainwater in Clarendon County, South Carolina....

Laser Delivery Services, Inc. (LDS) was incorporated January 1. The following transactions occurred during the year: a. Received $ 40,000 cash from the companys founders in exchange for common stock....

Refer to M7-7. Calculate the cost of ending inventory and cost of goods sold assuming a perpetual inventory system is used in combination with (a) FIFO and (b) LIFO. ending inventory and"> Refer M7-7...

Items from the 2013 income statement, statement of retained earnings, and balance sheet of Electronic Arts, Inc., are listed below in alphabetical order. Solve for the missing amounts, and explain...

How do the characters in the story react to each others tendencies and traits?

How do other characters deal with a grieving character? With kindness/misguided good intentions/ frustration? How can this create more conflict?

What events play to their strengths?