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
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