Question: Make an adjusted trial Balance with the information provided. Gst rates 10% Sky High Building Services Unadjusted Trial Balance as at 31 May 2020 Account



Make an adjusted trial Balance with the information provided.
Gst rates 10%
Sky High Building Services Unadjusted Trial Balance as at 31 May 2020 Account Cash at bank Accounts receivable GST receivable Cr Dr 98,650 54,600 3,690 9,000 145,000 45,380 172,600 Prepaid rent Inventory Building supplies Building equipment Accumulated depreciation - Building equipment Motor vehicle Accumulated depreciation - motor vehicle Accounts payable 62,900 84,500 25,750 40,260 4,400 Wages payable Unearned fees Loan payable - due 30 June 2020 GST payable Loan payable - due 30 June 2023 Share capital Retained earnings Fees revenue 45,500 15,600 58,000 122,000 141,620 188,900 Electricity expense 4,250 Fuel expense Rent expense Salaries expense 8,760 25,000 48,700 Telephone expense Totals 4,800 704,930 704,930 Aged Receivables As at 31 May 2020 Sky High Building Services Ltd Current April March February Total Receivables Dodgy Bros Builders Perfect Apartments Housing Commission Total Receivables $8,670.00 $3,420.00 $14,790.00 $26,880.00 $4,120.00 $2,220.00 $10,230.00 $16,570.00 $6,600.00 $0.00 $4,550.00 $11,150.00 $0.00 S0.00 S0.00 $0.00 $19,390.00 $5,640.00 $29,570.00 $54,600.00 Aged Payables As at 31 May 2020 Sky High Building Services Ltd Current April March February Total Payables Rain proof Ltd Outdoor cement supplies Total Payables $6,400.00 $5,860.00 $12,260.00 $0.00 $1,400.00 $1,400.00 $22,500.00 $4,100.00 $26,600.00 $0.00 S0.00 $0.00 $28,900.00 $11,360.00 $40,260.00 June 2020 transactions: Date June-01 Transaction Purchased inventory from Rain Proof Ltd on credit. Amount $17,600 including GST; terms n/30. $6,160 inclusive of GST direct payment. June-01 June-03 Purchased 24 month insurance cover from PC Insurance for motor vehicle. Received a payment from Perfect Apartments to pay outstanding April account. Paid Outdoor Cement Supplies for outstanding March and April accounts. Purchased supplies from Rain Proof Ltd on credit. June-04 June-04 $22,500 plus GST; terms n/60. June-05 June-08 Paid $5,000 to Rain Proof Ltd on account, and issued a 90-day 5% bill payable for the balance of the March account. GST inclusive. Purchased building supplies on credit from Outdoor Cement Supplies, due 15 July Paid salaries to employees for work up to 8th of June. Ignore PAYG. $1,056 including GST. June-08 $9,500 June-10 Sold inventory on account to Dodgy Bros Builders. $23,400 plus GST; terms 2/10, n/30. $20,000 June-11 Received cash for the issue of additional share capital. June-15 Sold inventory to Housing Commission on account. $33,200 plus GST; terms 2/10, n/30. $6,200.00 June-15 Paid salaries to employees for work up to 22nd of June. Ignore PAYG. Record cash sales for building services from 1 June to 15 June. June-16 $28,500 plus GST. June-17 Dodgy Bros Builders paid outstanding March and April accounts. June-19 June-20 Electricity bill received. Purchased inventory from Rain Proof Ltd Suppliers. $780 plus GST. $14,600 incl. GST; terms n/60. June-22 Paid ATO to cover GST owing from previous month. June-22 $11,400 plus GST. Received a cash deposit from a customer, A Paine, for building work to be completed during July 2020. June-23 Purchased inventory on credit from Outdoor Cement Supplies. $13,400; terms 1/14, n/30 (incl. GST). $820 incl. GST. June-26 Received and paid telephone bill for month of June June-28 Sold inventory to Perfect Apartments on account. $12,800 plus GST; terms n/30. $21,650 plus GST. June-30 Cash sales from building services for 15 June to June 31 June-30 Received bank interest $350 Additional information: 1. A physical count of building supplies on 30 June shows $58,880 of unused supplies on hand. Depreciation on the building equipment is estimated to be $26,000 per year. 2. 3. Depreciation on the motor vehicle is estimated to be $17,000 per year. 4. The balance in the prepaid rent account covers a period of six months. This was paid at the end of May. 5. Ending inventory is estimated to be $147,500. 6. Salaries for the last week of June are unpaid and amount to $3,600. You do not need to account for PAYG for this assignment. 8. 7. Interest expense of $235 has accrued on the loan payable (due 2023). All payments made to the bank for any loan amounts due at the end of the month. 9. A fuel bill for June for $3,600 (excluding GST) has not been recorded or paid (to be entered as a reversing journal). Sky High Building Services Unadjusted Trial Balance as at 31 May 2020 Account Cash at bank Accounts receivable GST receivable Cr Dr 98,650 54,600 3,690 9,000 145,000 45,380 172,600 Prepaid rent Inventory Building supplies Building equipment Accumulated depreciation - Building equipment Motor vehicle Accumulated depreciation - motor vehicle Accounts payable 62,900 84,500 25,750 40,260 4,400 Wages payable Unearned fees Loan payable - due 30 June 2020 GST payable Loan payable - due 30 June 2023 Share capital Retained earnings Fees revenue 45,500 15,600 58,000 122,000 141,620 188,900 Electricity expense 4,250 Fuel expense Rent expense Salaries expense 8,760 25,000 48,700 Telephone expense Totals 4,800 704,930 704,930 Aged Receivables As at 31 May 2020 Sky High Building Services Ltd Current April March February Total Receivables Dodgy Bros Builders Perfect Apartments Housing Commission Total Receivables $8,670.00 $3,420.00 $14,790.00 $26,880.00 $4,120.00 $2,220.00 $10,230.00 $16,570.00 $6,600.00 $0.00 $4,550.00 $11,150.00 $0.00 S0.00 S0.00 $0.00 $19,390.00 $5,640.00 $29,570.00 $54,600.00 Aged Payables As at 31 May 2020 Sky High Building Services Ltd Current April March February Total Payables Rain proof Ltd Outdoor cement supplies Total Payables $6,400.00 $5,860.00 $12,260.00 $0.00 $1,400.00 $1,400.00 $22,500.00 $4,100.00 $26,600.00 $0.00 S0.00 $0.00 $28,900.00 $11,360.00 $40,260.00 June 2020 transactions: Date June-01 Transaction Purchased inventory from Rain Proof Ltd on credit. Amount $17,600 including GST; terms n/30. $6,160 inclusive of GST direct payment. June-01 June-03 Purchased 24 month insurance cover from PC Insurance for motor vehicle. Received a payment from Perfect Apartments to pay outstanding April account. Paid Outdoor Cement Supplies for outstanding March and April accounts. Purchased supplies from Rain Proof Ltd on credit. June-04 June-04 $22,500 plus GST; terms n/60. June-05 June-08 Paid $5,000 to Rain Proof Ltd on account, and issued a 90-day 5% bill payable for the balance of the March account. GST inclusive. Purchased building supplies on credit from Outdoor Cement Supplies, due 15 July Paid salaries to employees for work up to 8th of June. Ignore PAYG. $1,056 including GST. June-08 $9,500 June-10 Sold inventory on account to Dodgy Bros Builders. $23,400 plus GST; terms 2/10, n/30. $20,000 June-11 Received cash for the issue of additional share capital. June-15 Sold inventory to Housing Commission on account. $33,200 plus GST; terms 2/10, n/30. $6,200.00 June-15 Paid salaries to employees for work up to 22nd of June. Ignore PAYG. Record cash sales for building services from 1 June to 15 June. June-16 $28,500 plus GST. June-17 Dodgy Bros Builders paid outstanding March and April accounts. June-19 June-20 Electricity bill received. Purchased inventory from Rain Proof Ltd Suppliers. $780 plus GST. $14,600 incl. GST; terms n/60. June-22 Paid ATO to cover GST owing from previous month. June-22 $11,400 plus GST. Received a cash deposit from a customer, A Paine, for building work to be completed during July 2020. June-23 Purchased inventory on credit from Outdoor Cement Supplies. $13,400; terms 1/14, n/30 (incl. GST). $820 incl. GST. June-26 Received and paid telephone bill for month of June June-28 Sold inventory to Perfect Apartments on account. $12,800 plus GST; terms n/30. $21,650 plus GST. June-30 Cash sales from building services for 15 June to June 31 June-30 Received bank interest $350 Additional information: 1. A physical count of building supplies on 30 June shows $58,880 of unused supplies on hand. Depreciation on the building equipment is estimated to be $26,000 per year. 2. 3. Depreciation on the motor vehicle is estimated to be $17,000 per year. 4. The balance in the prepaid rent account covers a period of six months. This was paid at the end of May. 5. Ending inventory is estimated to be $147,500. 6. Salaries for the last week of June are unpaid and amount to $3,600. You do not need to account for PAYG for this assignment. 8. 7. Interest expense of $235 has accrued on the loan payable (due 2023). All payments made to the bank for any loan amounts due at the end of the month. 9. A fuel bill for June for $3,600 (excluding GST) has not been recorded or paid (to be entered as a reversing journal)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
