Sky High Building Services has seen a growth in business in recent months and, based on the advice of the Accountant, has created a small proprietary company in order to run the building services operations. Sky High has branched into buying and selling wholesale building products (inventory). Sky High accounts for this inventory on a periodic basis and all purchases are recorded in a purchases account. Sky High still provides building services to regular clients on a cash only basis. All sales on credit are for the sale of inventory. The Balance Sheet for Sky High Building Services Ltd (SHBS) as at 31 May 2020 is shown below:

Requirements :

1. Record June transactions

2. Prepare:

a. Aged Accounts Receivable

b. Aged Accounts payable

c. Proft and Loss Statement for 30 June 2020

d. Balance Sheet as at 30 June 2020

Hi,

I hope you can help me to find those answers.

P.S This is not very urgent.

Thank you

Sky High Building Services Unadjusted Trial Balance as at 31 May 2020 Account Cash at bank Accounts receivable GST receivable Dr Cr 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 4 18 75% 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 $0.00 $0.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 $0.00 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 $28,900.00 $11,360.00 $40,260.00 $0.00 HK 5/8 . 100% Date June-01 June-01 June-03 June-04 Transaction Amount Purchased inventory from Rain Proof Ltd on credit. $17,600 including GST; terms n/30. Purchased 24 month insurance cover from PC Insurance for motor $6,160 inclusive of GST vehicle. direct payment. 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. $22,500 plus GST; terms n/60 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 $1,056 including GST. Supplies, due 15 July Paid salaries to employees for work up to 8th of June. Ignore PAYG. $9,500 June-04 June-05 June-08 June-08 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-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. Purchased inventory on credit from Outdoor Cement Supplies. June-23 $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 Sky High Building Services Unadjusted Trial Balance as at 31 May 2020 Account Cash at bank Accounts receivable GST receivable Dr Cr 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 4 18 75% 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 $0.00 $0.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 $0.00 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 $28,900.00 $11,360.00 $40,260.00 $0.00 HK 5/8 . 100% Date June-01 June-01 June-03 June-04 Transaction Amount Purchased inventory from Rain Proof Ltd on credit. $17,600 including GST; terms n/30. Purchased 24 month insurance cover from PC Insurance for motor $6,160 inclusive of GST vehicle. direct payment. 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. $22,500 plus GST; terms n/60 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 $1,056 including GST. Supplies, due 15 July Paid salaries to employees for work up to 8th of June. Ignore PAYG. $9,500 June-04 June-05 June-08 June-08 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-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. Purchased inventory on credit from Outdoor Cement Supplies. June-23 $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