Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would need help how to make a bank and cash reconciliation from scratch. 1) 720 2_ 2400 5) 406.8 8B)2200 8A)800 11)45.2 13A)400 13B)40

image text in transcribed

image text in transcribed

I would need help how to make a bank and cash reconciliation from scratch.

1) 720

2_ 2400

5) 406.8

8B)2200

8A)800

11)45.2

13A)400

13B)40

14)40

*last digit is 4.

ASSETS Current Assets Cash Accounts Receivables Prepaid Insurance Prepaid Promotion and Publicity Prepaid Rent Supplies Capital Assets Organizational Costs Equipment - Tools less: Accumulated Depreciation - Tools 3,100.00 2,750.00 0.00 121.00 0.00 3,710.00 4,000.00 7,333.33 (5,280.00) 15,734.33 Current Liabilities Dividends Payable Accounts Payable Advances from Customers HST Payable Loan and accrued interest payable Phone Payable Employees Expense Payable Income Tax Payable Shareholder's Equity Share Capital Retained Earnings 472.00 2,370.00 0.00 372.00 808.00 85.00 350.00 312.00 4.000.00 6,965.33 15,734.33 Debits Credits Balance 3,100.00 730.00 2,370.00 (7a) (1) (2) (5) 350.00 Date April 1 April 1 April 1-30 April 1 April 1 April 1 April 3 April 1-20 April 20-30 April 9 April 10 April 12 April 15 April 29 April 29 April 30 Description Opening balance CHEQUE #78 DEPOSITS CHEQUE #80 CHEQUE #77 CHEQUE #81 CHEQUE #83 DEPOSITS DEPOSITS Withdraw CHEQUE #82 CHEQUE #79 CHEQUE #84 NSF cheque received NSF fee MONTHLY SERVICE CHARGE TOTALS (86) (8) 472.00 8.00 (11) 85.00 (13a) (13) (14) Notes: (1) The amount must be equal to 180 times the last digit of your student number (rent). No HST (2) The amount is equal to 600 times the last digit of your student number (insurance). No HST. (5) The total amount of the invoice is 90 times your last digit + 13% for HST = 1.13 multiplied 90 times the last digit of your student number (promotion). (8b) In April collected 80% of accounts receivables that were outstanding on March 31st, 2021. (7a) The amount must be equal to 1.13 multiplied by 600 times the last digit of your student number (the invoices issued by Tony have HST segregated and customers are asked to pay 13% HST on top of the 600 times the last digit). (8a) Also, some potential customers paid in advance for future services, they receive a receipt for the funds deposited but the invoice will be prepared and submitted once the work is done. 200 times the last digit of your student number is for prepaid revenues (money collected but services not provided yet, no HST). (11) The amount must be equal to 120 times the last digit of your student number (accountant). The cheques is 1.13 multiplied by 1/12 of 120 times the last digit of your student number. (13a) The amount must be equal to 100 times the last digit of your student number (NSF cheque) (13b) The amount must be equal to 10 times the last digit of your student number (NSF fee). No HST. Tony is responsible for this charge, and this fee will not be collected from the customer. (14) The amount is 10 times the last digit of your student number (bank fee). No HST

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Anthony A. Atkinson, Robert S. Kaplan, S. Mark Young, Rajiv D. Banker, Pajiv D. Banker

3rd Edition

9780130101952

More Books

Students also viewed these Accounting questions