Make financial statements and adjusted trial balance
Background information Aaron Brand, a QUT Alumni, started Map Resolution Pty Ltd recently. The company specialises in high-resolution aerial imagery and provides services in aerial photography, site surveying, mast photography and architectural visualisation. The following is the trial balance as at 31 July 2019. Debit Credit Cash at Bank 16,595.00 Accounts Receivable 8,520.00 Prepaid Insurance 1,800.00 Aerial Photography Supplies 4,125.00 Aerial Photography Equipment: Original Cost 21,750.00 Accumulated Depreciation - Aerial Photography Equipment 4,350.00 Accounts Payable 7,704.00 Wages Payable PAYG Withholding* 2,025.00 Loan Payable - Current 1,947.00 Tax Payable (GST Clearing) ** 1,619.00 Loan Payable - Non Current 4,025.00 Share Capital 21,000.00 Retained Earnings 4,554.00 Service Revenue 18,840.00 Aerial Photography Supplies Expense Depreciation Expense - Aerial Photography Equipment Insurance Expense Interest Expense 114.00 Office Cleaning Expense Rent Expense 2,200.00 Repair Expense 1,200.00 Staff Training Expense Utilities Expense 3,560.00 Wages Expense 6,200.00 66,064.00 66,064.00 *PAYG withholding is tax withheld from staff wages owed to the government. **Tax Payable (GST Clearing) is the account set up for the GST owing. Reckon will also add another account named Tax Payable as you process transactions with GST. You will have 2 GST accounts when your assignment is complete: Tax Payable (GST Clearing) and Tax Payable. Accounts Receivable Details as at 31 July Belle Rural Property Pty Ltd Dalby Site Surveying Pty Ltd Skymax Tour Pty Ltd Total 3,300.00 3,000.00 2,220.00 8,520.00 Accounts Payable Details as at 31 July AutoRilot Services Pty Ltd Fastcraft Technology Pty Ltd Mission Visuals Pty Ltd Total 2,730.00 2,622.00 2,352.00 7,704.00 Aaron Brand has provided the following transactions for you, the Graduate Accountant, to determine the accounting implications. You need to decide if each transaction involves: a normal Reckon transaction, an adjusting entry or requires NO transaction at all. Map Resolution Pty Ltd uses Reckon accounting software to maintain its financial records. Adjusting entries and financial statements are prepared on a monthly basis. Further information 1. 31 July Received cash of $1,500 as part payment on account from Dalby Site Surveying Pty Ltd. 2. 31 July Received an invoice from Autopilot Services Pty Ltd for $946 (including GST $86) in relation to staff training expenses during July. 3. 31 July The manager of Highland Resort Groups advised by email that they wish to go ahead with the quote from Map Resolution Pty Ltd to undertake site mapping for its holiday resorts. This is expected to generate approximately $22,000 (including GST $2,000) of annual services. The effective date for services to start is 1 September, 2019. 4. 31 July Paid Fastcraft Technology Pty Ltd $622 with cheque number 264. 5. 31 July Prepared a quote for Skymax Tour Pty Ltd for $3,300 (including GST $300) for outback photography services to be completed in Mission Beach in October 2019. 6. 31 July Invoiced Belle Rural Property Pty Ltd for aerial property photography services, Invoice number BD48 for $8,800 (including GST $800). 7. 31 July Paid the monthly office cleaning expense with cheque number 265 for $440 (including GST $40). 8. 31 July Hired a new intern technician whose annual salary is $30,000 and who will commence work on 15 September, 2019. 9. 31 July Received cash of $2,200 (including GST $200) from a client for aerial photography services completed. 10. 31 July Submitted a proposal for a tender to supply architectural visualisation services to Daintree Rainforest Experiences Pty Ltd for $6,600 (including GST $600). 11.31 July Signed a lease for new office effective from 1 October 2019 with an annual rent of $26,400 (including GST $2,400), with monthly payment required from 1 October. 12. Aerial Photography Supplies on hand at 31 July total $2,125. 13. Depreciation on Aerial Photography Equipment is calculated using the Straight Line Method over 5 years with $0 estimated residual value. Round the amount of depreciation up to the nearest whole dollar. Note that the calculation is for 1 month only (i.e. July depreciation). 14. Wages owing as at 31 July are $2,600. 15. Prepaid 6 months of Insurance on 1 July (refer to trial balance). Background information Aaron Brand, a QUT Alumni, started Map Resolution Pty Ltd recently. The company specialises in high-resolution aerial imagery and provides services in aerial photography, site surveying, mast photography and architectural visualisation. The following is the trial balance as at 31 July 2019. Debit Credit Cash at Bank 16,595.00 Accounts Receivable 8,520.00 Prepaid Insurance 1,800.00 Aerial Photography Supplies 4,125.00 Aerial Photography Equipment: Original Cost 21,750.00 Accumulated Depreciation - Aerial Photography Equipment 4,350.00 Accounts Payable 7,704.00 Wages Payable PAYG Withholding* 2,025.00 Loan Payable - Current 1,947.00 Tax Payable (GST Clearing) ** 1,619.00 Loan Payable - Non Current 4,025.00 Share Capital 21,000.00 Retained Earnings 4,554.00 Service Revenue 18,840.00 Aerial Photography Supplies Expense Depreciation Expense - Aerial Photography Equipment Insurance Expense Interest Expense 114.00 Office Cleaning Expense Rent Expense 2,200.00 Repair Expense 1,200.00 Staff Training Expense Utilities Expense 3,560.00 Wages Expense 6,200.00 66,064.00 66,064.00 *PAYG withholding is tax withheld from staff wages owed to the government. **Tax Payable (GST Clearing) is the account set up for the GST owing. Reckon will also add another account named Tax Payable as you process transactions with GST. You will have 2 GST accounts when your assignment is complete: Tax Payable (GST Clearing) and Tax Payable. Accounts Receivable Details as at 31 July Belle Rural Property Pty Ltd Dalby Site Surveying Pty Ltd Skymax Tour Pty Ltd Total 3,300.00 3,000.00 2,220.00 8,520.00 Accounts Payable Details as at 31 July AutoRilot Services Pty Ltd Fastcraft Technology Pty Ltd Mission Visuals Pty Ltd Total 2,730.00 2,622.00 2,352.00 7,704.00 Aaron Brand has provided the following transactions for you, the Graduate Accountant, to determine the accounting implications. You need to decide if each transaction involves: a normal Reckon transaction, an adjusting entry or requires NO transaction at all. Map Resolution Pty Ltd uses Reckon accounting software to maintain its financial records. Adjusting entries and financial statements are prepared on a monthly basis. Further information 1. 31 July Received cash of $1,500 as part payment on account from Dalby Site Surveying Pty Ltd. 2. 31 July Received an invoice from Autopilot Services Pty Ltd for $946 (including GST $86) in relation to staff training expenses during July. 3. 31 July The manager of Highland Resort Groups advised by email that they wish to go ahead with the quote from Map Resolution Pty Ltd to undertake site mapping for its holiday resorts. This is expected to generate approximately $22,000 (including GST $2,000) of annual services. The effective date for services to start is 1 September, 2019. 4. 31 July Paid Fastcraft Technology Pty Ltd $622 with cheque number 264. 5. 31 July Prepared a quote for Skymax Tour Pty Ltd for $3,300 (including GST $300) for outback photography services to be completed in Mission Beach in October 2019. 6. 31 July Invoiced Belle Rural Property Pty Ltd for aerial property photography services, Invoice number BD48 for $8,800 (including GST $800). 7. 31 July Paid the monthly office cleaning expense with cheque number 265 for $440 (including GST $40). 8. 31 July Hired a new intern technician whose annual salary is $30,000 and who will commence work on 15 September, 2019. 9. 31 July Received cash of $2,200 (including GST $200) from a client for aerial photography services completed. 10. 31 July Submitted a proposal for a tender to supply architectural visualisation services to Daintree Rainforest Experiences Pty Ltd for $6,600 (including GST $600). 11.31 July Signed a lease for new office effective from 1 October 2019 with an annual rent of $26,400 (including GST $2,400), with monthly payment required from 1 October. 12. Aerial Photography Supplies on hand at 31 July total $2,125. 13. Depreciation on Aerial Photography Equipment is calculated using the Straight Line Method over 5 years with $0 estimated residual value. Round the amount of depreciation up to the nearest whole dollar. Note that the calculation is for 1 month only (i.e. July depreciation). 14. Wages owing as at 31 July are $2,600. 15. Prepaid 6 months of Insurance on 1 July (refer to trial balance)
