Assignment 1 MAA261.xlsx - Input your student ID and name...

Input your student ID and name below
Student ID: 217451118
Student Name: Rayna Wu
Journals
General Journal
Date Account Debit Credit
1/07/2019 Cash at Bank 21,623
Accounts receivable 3,209
Inventory 10,120
Motor Vehicle 22,927
Office Furniture 13,246
Office Supplies 462
Allowance for doubtful debt 446
Accumulated depreciation - Motor Vehicle 2,604
Accounts payable 4,423
Bank Loan 13,863
Telephone Payable 147
Accumulated depreciation_office furniture 1,221
Share Capital 33,508
Retained Earnings 15,375
1/07/2019 Telephone payable 147
Cash at Bank 147
2/07/2019 Accounts receivable 2860
GST Payable 260
Sales 2600
Cost of goods sold 1040
Inventory 1040
3/07/2019 Wages Expense 2339
Wages Payable 2339
5/07/2019 Accounts receivable 2805
GST Payable 255
Sales 2550
Cost of goods sold 1020
Inventory 1020
6/07/2019 Sales Returns & Allowances 200
GST payable 20
Accounts receivable 220
Inventory 80
Cost of goods sold 80
7/07/2019 Accounts payable 1,017
Cash at Bank 1,017

7/07/2019 Inventory 685
GST Receivable 69
Accounts payable 754
11/07/2019 Accounts receivable 4,015
GST Payable 365
Sales 3,650
Cost of goods sold 1,478
Inventory 1,478
12/07/2019 Accounts payable 1,470
Cash at Bank 1,470
13/07/2019 Cash at Bank 864
Accounts receivable 864
14/07/2019 Inventory 523
GST Receivable 52
Accounts payable 575
15/07/2019 Computer 2,270
GST Receivable 227
Accounts payable 2,497
15/07/2019 Advertising Expense 675
GST Receivable 68
Advertising payable 743
17/07/2019 Wages Payable 1,533
Wages Expense 2,339
Cash at Bank 3,872
17/07/2019 Office supplies 613
GST Receivable 61
Office supplies payable 674
18/07/2019 Accounts receivable 3,685
GST Payable 335
Sales 3,350
Cost of Goods Sold 1,366
Inventory 1,366
20/07/2019 Inventory 545
GST Receivable 55
Accounts payable 600
20/07/2019 Cash at Bank 745
Accounts receivable 745
22/07/2019 Accounts receivable 3,410

GST Payable 310
Sales 3,100
Cost of goods sold 1,274
Inventory 1,274
24/07/2019 Inventory 589
GST Receivable 59
Accounts payable 648
25/07/2019 Accounts payable 27
GST payable 2
Inventory 25
25/07/2019 Cash at Bank 504
Accounts receivable 504
26/07/2019 Rent Expense 2,019
GST Receivable 202
Cash at Bank 2,221
27/07/2019 Prepaid Insurance 2,125
GST Receivable 213
Cash at Bank 2,338
27/07/2019 Motor vehicle expenses 97
GST Receivable 10
Cash at Bank 107
29/07/2019 Accounts receivable 2,750
GST payable 250
Sales 2,500
Cost of Goods Sold 1,043
Inventory 1,043
30/07/2019 Accounts payable 1,063
Cash at Bank 1,063
30/07/2019 Inventory 636
GST Receivable 64
Accounts payable 700
31/07/2019 Prepaid Insurance 1,948
Insurance 1,948
31/07/2019 Depreciation - motor vehicle 304
Accumulated depreciation- motor vehicle 304
31/07/2019 Depreciation - office furniture 189
Accumulated depreciation - office furniture 189

31/07/2019 Depreciation - computer 33
Accumulated depreciation - computer 33
31/07/2019 Inventory losses 106
Inventory 106
31/07/2019 Office supplies expenses 203
Office supplies 203
31/07/2019 Bad debt 176
Allowance for doubtful debt 176
31/07/2019 Interest expenses 60
Interest payable 60
31/07/2019 Sales 17,550
Inventory Loss 106
Cost Of Goods Sold 7,141
Advertising Expense 675
Depreciation Expense - Computer 33
Depreciation Expense - Office Furniture 189
Depreciation Expense - Motor Vehicles 304
Rent Expense 2,019
Insurance Expense 177
Office Supplies Expense 203
Wages Expense 3,872
Motor Vehicle Expense 97
Loan Interest Expense 60
Bad Debt Expense 176
profit and loss statement (P&L) 2,498
Total
143107 143107

balances

Student ID: 217451118
Student Name: