Access over 20 million homework & study documents

20200930125326trial Balance

Content type
User Generated
Subject
Excel
Type
Homework
Rating
Showing Page:
1/35

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/35

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/35

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 35 pages?
Access Now
Unformatted Attachment Preview
The Cool Air Conditioning Corporation (CoolAir) installs and repairs air conditioning units in the South Florida housing market. CoolAir was started by Jordyn in January after she quit her job after 10 years of experience at another firm. Business Operations: Clients' calls are received in the office and an A/C technician must be scheduled to visit the house. If a new unit is required and it is not in stock it must be ordered. If a repair is required it normally can be completed at that time with the inventory of parts on the technician's truck, wh which is tracked and monitored in the central accounting system. Significant Accounting Policies: The business has adopted the following accounting policies: l Fixed assets that cost less than $2,000.00 are expensed. l Inventory is valued using a perpetual inventory system. u Specific identification is used to determine the cost of air conditioning units sold. l The allowance method is used to account for bad debts. l Rent payments are expensed in the period in which they are incurred. l When calculating depreciation, assets purchased during a month are treated as if purchased on the first day of the month. CoolAir has supplied their General Journal for the month of January. (See the sheet labeled 'Jan' Required: Use Excel or an ETL process, Extraction, Transformation, and Loading, to clean and scrub the January General Journal sheet and export an Unadjusted Trial Balance to Excel. See the sam below and answer the following ques ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents