FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do the following question. I can pay for additional question after you did that one. Could you Arrange the trial balances given in Raw Data

Do the following question. I can pay for additional question after you did that one.

Could you Arrange the trial balances given in Raw Data and displaying them side by side on the same page. When doing this, please pull the data from the raw trial balances with excel formulas.

2014 Trial Balance
Account Code Debit Credit Debit Balance Credit Balance
100 117,112.98 101,986.19 15,126.79 0.00
101 7,331,264.95 6,010,308.20 1,320,956.75 0.00
102 191,398,862.79 187,949,954.40 3,448,908.39 0.00
108 711,593.21 592,045.68 119,547.53 0.00
120 58,362,795.81 45,011,885.88 13,499,857.37 148,947.43
121 698,589.41 698,589.41 0.00 0.00
136 312,179.47 294,997.74 17,181.73 0.00
153 30,444,571.27 30,008,832.30 440,738.97 0.00
180 200,450.03 144,322.94 56,127.10 0.00
181 10,492.21 5,017.85 5,474.36 0.00
191 5,126,042.51 5,126,042.51 0.00 0.00
192 13,013.97 12,345.72 668.25 0.00
193 362,827.33 82,839.90 279,987.43 0.00
195 1,500.00 0.00 1,500.00 0.00
196 26,725.00 7,500.00 19,225.00 0.00
226 1,660.19 0.00 1,660.19 0.00
254 45,033.22 0.00 45,033.22 0.00
255 974,229.29 0.00 974,229.29 0.00
257 0.00 665,241.20 0.00 665,241.20
264 11,942.02 0.00 11,942.02 0.00
268 0.00 10,210.12 0.00 10,210.12
280 72,279.57 0.00 72,279.57 0.00
296 84,000.00 0.00 84,000.00 0.00
300 5,882,248.85 6,058,208.85 0.00 175,960.00
309 19,394.72 20,623.39 0.00 1,228.68
320 30,390,584.78 41,000,344.59 20,453.57 10,630,213.39
321 0.00 756,628.00 0.00 756,628.00
331 881,973.79 881,973.79 0.00 0.00
335 811,951.34 876,436.80 0.00 64,485.47
360 4,987,108.14 7,081,183.93 0.00 2,094,075.79
361 404,989.43 436,076.62 0.00 31,087.19
368 6,570.91 45,996.13 0.00 39,425.22
370 258,047.97 258,047.97 0.00 0.00
371 258,047.97 258,047.97 0.00 0.00
373 1,272,812.72 2,153,838.80 0.00 881,026.08
380 44,980.00 44,980.00 0.00 0.00
391 9,794,630.80 9,794,630.80 0.00 0.00
392 12,345.72 13,013.97 0.00 668.25
438 0.00 72,279.57 0.00 72,279.57
500 0.00 1,272,501.50 0.00 1,272,501.50
540 0.00 233,243.21 0.00 233,243.21
549 0.00 595,991.25 0.00 595,991.25
570 949,671.89 2,325,367.14 0.00 1,375,695.26
590 1,027,289.08 1,027,289.08 0.00 0.00
600 0.00 32,596,060.98 0.00 32,596,060.98
600.01 0.00 31,948,206.31 0.00 31,948,206.31
600.02 0.00 647,854.67 0.00 647,854.67
601 0.00 108,475.24 0.00 108,475.24
601.01 0.00 104,548.04 0.00 104,548.04
601.02 0.00 3,927.20 0.00 3,927.20
602 0.00 125,203.67 0.00 125,203.67
610 86,605.79 9,114.47 77,491.32 0.00
621 29,098,113.98 188,167.32 28,909,946.67 0.00
642 0.00 37,231.30 0.00 37,231.30
646 311.79 1,169,186.76 0.00 1,168,874.97
653 43,615.00 65.65 43,549.35 0.00
656 1,359,128.76 0.11 1,359,128.65 0.00
679 0.00 68,629.21 0.00 68,629.21
689 13,947.20 0.01 13,947.19 0.00
760 570,962.09 0.00 570,962.09 0.00
760.01 488,530.62 0.00 488,530.62 0.00
760.02 82,431.48 0.00 82,431.48 0.00
770 1,760,622.20 50,322.38 1,710,299.82 0.00
770.01 874,800.28 0.00 874,800.28 0.00
770.03 11,264.26 0.00 11,264.26 0.00
770.04 247,297.89 8,676.18 238,621.71 0.00
770.05 135,124.59 279.76 134,844.84 0.00
770.06 122,237.11 0.00 122,237.11 0.00
770.07 155,982.10 0.00 155,982.10 0.00
770.08 20,374.03 0.00 20,374.03 0.00
770.09 7,401.32 2,296.76 5,104.57 0.00
770.10 186,140.64 39,069.69 147,070.95 0.00
780 33,316.70 156.37 33,160.34 0.00
780.01 33,316.70 156.37 33,160.34 0.00
2015 Trial Balance
Account Code Debit Credit Debit Balance Credit Balance
100 83,999.30 55,699.05 28,300.25 0.00
101 10,201,917.26 8,850,069.06 1,351,848.20 0.00
102 378,698,599.71 376,294,482.86 2,404,116.85 0.00
108 980,347.15 834,907.14 145,440.01 0.00
120 69,346,240.36 47,688,955.06 22,526,254.32 868,969.02
121 479,203.62 479,203.62 0.00 0.00
136 555,550.52 538,211.51 17,339.01 0.00
153 43,853,518.43 41,587,413.41 2,266,105.03 0.00
180 293,742.44 219,358.04 74,384.40 0.00
181 11,019.73 5,474.36 5,545.37 0.00
191 6,789,705.10 6,789,705.10 0.00 0.00
192 20,344.37 15,746.79 4,597.58 0.00
193 712,706.09 268,236.89 444,469.21 0.00
195 1,500.00 0.00 1,500.00 0.00
196 19,225.00 19,225.00 0.00 0.00
226 1,660.19 0.00 1,660.19 0.00
254 45,033.22 13,512.55 31,520.67 0.00
255 1,014,536.62 0.00 1,014,536.62 0.00
257 13,512.55 771,250.36 0.00 757,737.81
264 11,942.02 0.00 11,942.02 0.00
268 518.43 12,013.18 0.00 11,494.75
280 72,279.57 72,279.57 0.00 0.00
296 84,000.00 0.00 84,000.00 0.00
300 7,537,070.78 7,587,070.78 0.00 50,000.00
309 48,280.67 49,072.04 0.00 791.37
320 37,915,269.68 56,860,924.50 933,454.75 19,879,109.56
321 791,939.52 858,428.44 0.00 66,488.92
331 797,945.49 797,945.49 0.00 0.00
335 837,966.53 890,746.24 1,279.49 54,059.21
360 6,007,270.81 9,075,395.05 0.00 3,068,124.24
361 389,940.51 424,855.06 0.00 34,914.55
368 39,425.53 111,705.10 0.00 72,279.57
370 279,987.43 279,987.43 0.00 0.00
371 279,987.43 279,987.43 0.00 0.00
373 3,260,576.46 3,778,418.19 0.00 517,841.73
391 12,994,342.45 12,994,342.45 0.00 0.00
392 15,746.79 20,344.37 0.00 4,597.58
438 72,279.57 72,279.57 0.00 0.00
500 0.00 1,272,501.50 0.00 1,272,501.50
540 0.00 370,573.54 0.00 370,573.54
549 0.00 595,991.25 0.00 595,991.25
570 939,227.26 2,481,697.77 0.00 1,542,470.51
590 1,106,002.51 1,106,002.51 0.00 0.00
600 0.00 43,676,029.15 0.00 43,676,029.15
600.01 0.00 42,534,329.14 0.00 42,534,329.14
600.02 0.00 1,141,700.01 0.00 1,141,700.01
601 0.00 151,816.13 0.00 151,816.13
601.01 0.00 140,027.29 0.00 140,027.29
601.02 0.00 11,788.84 0.00 11,788.84
602 0.00 109,785.55 0.00 109,785.55
610 800,680.08 0.00 800,680.08 0.00
621 39,674,683.57 1,288,791.37 38,385,892.21 0.00
642 0.00 164,844.36 0.00 164,844.36
646 0.00 1,156,815.70 0.00 1,156,815.70
653 136,417.34 497.57 135,919.78 0.00
656 1,443,845.19 32,444.81 1,411,400.39 0.00
679 32.80 84,232.33 0.00 84,199.53
689 41,997.20 0.00 41,997.20 0.00
760 555,247.26 4,715.60 550,531.66 0.00
760.01 435,280.84 0.00 435,280.84 0.00
760.02 119,966.42 4,715.60 115,250.82 0.00
770 1,833,693.15 3,999.89 1,829,693.26 0.00
770.01 905,158.52 0.00 905,158.52 0.00
770.03 26,788.92 325.84 26,463.08 0.00
770.04 280,092.48 317.48 279,775.00 0.00
770.05 151,400.56 206.15 151,194.41 0.00
770.06 128,589.53 0.00 128,589.53 0.00
770.07 128,158.95 0.00 128,158.95 0.00
770.08 18,880.33 0.00 18,880.33 0.00
770.09 14,196.88 3,150.42 11,046.46 0.00
770.10 180,426.99 0.00 180,426.99 0.00
780 8,159.32 1,132.30 7,027.02 0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

7. LO.1, 8, 9 In late 2013, the Polks come to you for tax advice. They are considering selling some stock investments for a loss and making a contribution to a traditional IRA. In reviewing their...

Answered: 1 week ago

Question

★★★★★
The items that follow are from the Income Statement columns of winters Repair Shops work sheet for the year ended December 31, 2014. Prepare journal entries to close the revenue, expense, Income...

Answered: 1 week ago

Question

★★★★★
On January 1, 2017, Busy Beaver bought a new industrial lathe for $210,000. It expects to use the lathe for 10,000 hours over the next 5 years and then sell it for $10,000. Busy Beaver used the lathe...

Answered: 1 week ago

Question

★★★★★
Entity C bought equipment for $140,000 on January 1, 2021. It estimated the useful life to be 5 years with no salvage value, and the straight-line method of depreciation was used resulting in a book...

Answered: 1 week ago

Question

★★★★★
Refer to Case Study D - The presentation You must create presentation (report) that will promote the organisation's products/services to the business community at a local trade event. This is raising...

Answered: 1 week ago

Question

★★★★★
You act for the vendor of a travel agency business known as "Golden Wings Travel". The name of the vendor is Beaumont Investments Pty Ltd, the trustee of the Beaumont Family Trust, and the company...

Answered: 1 week ago

Question

★★★★★
1. The surface area of an inflating weather balloon is described by A(x) = 4x 1 where x is the number of seconds and A is measured in L. a) Determine the average rate of change between 3 and 9 sec....

Answered: 1 week ago

Question

★★★★★
4. The exit gas from an alcohol fermenter is an air-CO mixture containing 10 mol% CO that is to be absorbed in a 5.0 M triethanolamine (TEA) solution containing 0.020 mol CO2/mol TEA. The column...

Answered: 1 week ago

Question

★★★★★
An aluminum foil manufacturer wants to improve the quality of his product and is trying to develop a probability model for the flaws that occur in a sheet of foil. Assume that X, the number of flaws...

Answered: 1 week ago

Previous Question Next Question