Question
As you return to your desk from your lunch break, you meet Rosaline who asks you to create a bank deposit slip dated 7 January
As you return to your desk from your lunch break, you meet Rosaline who asks you to create a bank deposit slip dated 7 January 2021 and enter the cheques received during the first week of January into that deposit slip. She also asks you to print the latest trial balance, aged receivables and aged payables report immediately. She wants to know the current state of the company's accounts because she has to meet prospective investors soon. Rosaline then tells you that she will ask more questions about your work today after returning from the meeting.
The trial balance: Early January
The trial balance for Intermaweb Computer as of 7 January 2021 is shown below:
Intermaweb Computer
Trial Balance
January 2021
Account # | Account | YTD Debit ($) | YTD Credit ($) |
|
1-1110 | Cheque Account |
|
|
|
1-1200 | Accounts Receivable |
|
|
|
1-1210 | Less Prov'n for Doubtful Debts |
| 738 |
|
1-1300 | Inventory |
|
|
|
1-1400 | Office Supplies |
|
|
|
1-3110 | Property & Equipment at Cost |
|
|
|
1-3120 | Property & Equipment Accum Dep |
| 21,700 |
|
2-1200 | Accounts Payable |
|
|
|
2-1310 | GST Collected |
|
|
|
2-1330 | GST Paid |
|
|
|
2-1420 | PAYG Withholding Payable |
| 2,100 |
|
2-1800 | Short Term Loans |
|
|
|
2-2100 | Bank Loans |
| 48,000 |
|
3-1100 | Share Capital |
| 40,000 |
|
3-8000 | Retained Earnings |
| 138,314 |
|
4-1100 | Sales Revenue |
|
|
|
5-1100 | Cost of Sales |
|
|
|
6-1100 | Depreciation Expense | 21,700 |
|
|
6-1800 | Office Supplies Expense |
|
|
|
6-1930 | Salaries Expense | 15,618 |
|
|
6-2200 | Telephone Expense | 3,791 |
|
|
6-2420 | Electricity Expense | 3,759 |
|
|
6-2500 | Bank Charges | 38 |
|
|
6-2600 | Bad Debts Expense | 1,102 |
|
|
9-1000 | Interest Expense | 480 |
|
|
| Total: | 46488 | 250852 |
|
Aged Receivables [Summary] report
The Aged Receivables [Summary] report for Intermaweb Computer as of 7 January 2021 is shown below:
Intermaweb Computer
Aged Receivables [Summary]
7/01/2021
Name | Total Due ($) |
|
Handys Electronics |
|
|
Radio Hut |
|
|
Turbo Tech |
|
|
Total | 0 |
|
Aged Payables [Summary] report
The Aged Payables [Summary] report for Intermaweb Computer as of 7 January 2021 is shown below:
Intermaweb Computer
Aged Payables [Summary]
As of 7/01/2021
Name | Total Due ($) |
|
Big Telco |
|
|
Mega Tech |
|
|
Moon Megasystems |
|
|
Total |
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started