XLSX

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

Ben Cook Traders

General Ledger
Date Account Description Ref. Transaction Balance
Debit Credit Debit
6/30/2014 Advertising 55,000.00
6/30/2014 Bad debts 12,000.00
6/30/2014 Bank
6/30/2014 Buildings 800,000.00
6/30/2014 Buying expenses 14,800.00
6/30/2014 Cartage outwards 120,000.00
6/30/2014 Commission revenue
6/30/2014 Discount expense 2,500.00
6/30/2014 Discount received
6/30/2014 Donations 5,000.00
6/30/2014 Electricity 40,000.00
6/30/2014 GST payable
6/30/2014 Input tax credits 10,000.00
6/30/2014 Interest expenses 176,000.00
6/30/2014 Lease expense 6,000.00
6/30/2014 Legal costs 75,000.00
6/30/2014 Loan BL Finance due 2020
6/30/2014 Mortgage
6/30/2014 Motor vehicle expense 50,000.00
6/30/2014 Office salaries 40,000.00
6/30/2014 Manager salaries 100,000.00
6/30/2014 Wages 80,000.00
6/30/2014 Office stationary 4,000.00
6/30/2014 Petty cash advance 500.00
6/30/2014 Provision for annual leave
6/30/2014 Provision for long service leave
6/30/2014 Purchases 360,000.00
6/30/2014 Purchases returns and allowances
6/30/2014 Rates and taxes 15,250.00
6/30/2014 Rent revenue
6/30/2014 Sales
6/30/2014 Stock (01/07/14) 120,000.00
6/30/2014 Creditors control
6/30/2014 Debtors control 80,000.00
6/30/2014 Provision for doubtful debts
6/30/2014 Equipment 900,000.00
6/30/2014 Accumulated depreciation - equipment
6/30/2014 Drawings 63,750.00
6/30/2014 Motor vehicle 320,000.00
6/30/2014 Accumulated depreciation - motor vehicle
6/30/2014 Capital
Total 3,449,800.00
Balance
Credit

30,000.00

59,900.00

1,800.00

15,000.00

600,000.00
400,000.00

25,300.00
15,000.00

27,000.00
300,000.00
900,000.00

50,000.00

2,800.00

315,000.00

168,000.00
540,000.00
3,449,800.00 -
Ben Cook Traders
General Ledger
Date Account Description Ref. Transaction Balance
Debit Credit Debit Credit
6/30/2014 Accrued revenue 5,100.00 5,100.00 x
6/30/2014 Advertising 5,000.00 50,000.00 x
6/30/2014 Annual leave expense 25,300.00 25,300.00 x
6/30/2014 Bad debts 12,000.00 - - x
6/30/2014 Bank 30,000.00 b
6/30/2014 Buildings 800,000.00 b
6/30/2014 Buying expenses 14,800.00 x
6/30/2014 Cartage outwards 120,000.00 x
6/30/2014 Commission revenue 5,100.00 65,000.00 x
6/30/2014 Depreciation expense - equipment 87,750.00 87,750.00 x
6/30/2014 Depreciation expense - motor vehicle 60,750.00 60,750.00 x
6/30/2014 Discount expense 2,500.00 x
6/30/2014 Discount received 1,800.00 x
6/30/2014 Donations 5,000.00 x
6/30/2014 Doubtful debt expense 17,180.00 17,180.00 x
6/30/2014 Electricity 40,000.00 x
6/30/2014 Gain on sell 6,250.00 6,250.00 x
6/30/2014 GST payable 500.00 14,500.00 b
6/30/2014 Input tax credits 6,000.00 16,000.00 b
6/30/2014 Interest expenses 4,000.00 180,000.00 x
6/30/2014 Interest payable 4,000.00 4,000.00 b
6/30/2014 Lease expense 6,000.00 x
6/30/2014 Legal costs 75,000.00 x
6/30/2014 Loan 41,000.00 41,000.00 b
6/30/2014 Loan BL Finance due 2020 600,000.00 b
6/30/2014 Long service leave expense 6,900.00 6,900.00 x
6/30/2014 Mortgage 400,000.00 b
6/30/2014 Motor vehicle expense 50,000.00 x
6/30/2014 Office salaries 40,000.00 x
6/30/2014 Manager salaries 100,000.00 x
6/30/2014 Wages 10,000.00 90,000.00 x
6/30/2014 Wages payable 10,000.00 10,000.00 b
6/30/2014 Office stationary 4,000.00 x
6/30/2014 Petty cash advance 500.00 b
6/30/2014 Prepaid advertising 5,000.00 5,000.00 b
6/30/2014 Provision for annual leave 25,300.00 b
6/30/2014 Provision for doubtful debts 180.00 180.00 b
6/30/2014 Provision for long service leave 32,200.00 47,200.00 b
6/30/2014 Purchases 360,000.00 x
6/30/2014 Purchases returns and allowances 27,000.00 x
6/30/2014 Rates and taxes 15,250.00 x
6/30/2014 Rent revenue 300,000.00 x
6/30/2014 Sales 900,000.00 x
6/30/2014 Stock (01/07/14) 20,000.00 100,000.00 b
6/30/2014 Stock Loss 20,000.00 20,000.00 x
6/30/2014 Creditors control 50,000.00 b
6/30/2014 Debtors control 5,500.00 74,500.00 b
6/30/2014 Provision for doubtful debts 2,800.00 b
6/30/2014 Equipment 900,000.00 b
6/30/2014 Accumulated depreciation - equipment 87,750.00 402,750.00 b
6/30/2014 Drawings 63,750.00 b
6/30/2014 Motor vehicle 65,000.00 255,000.00 b
6/30/2014 Accumulated depreciation - motor vehicle 45,500.00 122,500.00 b
6/30/2014 Capital 540,000.00 b
Total 293,980.00 293,980.00 3,590,280.00 3,590,280.00
Ben Cook Traders
General Ledger
Date Account Description Ref. Transaction Balance
Debit Credit Debit Credit
6/30/2014 Accrued revenue 5,100.00 b
6/30/2014 Bank 30,000.00 b
6/30/2014 Buildings 800,000.00 b
6/30/2014 GST payable 14,500.00 b
6/30/2014 Input tax credits 16,000.00 b
6/30/2014 Interest payable 4,000.00 b
6/30/2014 Loan 41,000.00 b
6/30/2014 Loan BL Finance due 2020 600,000.00 b
6/30/2014 Mortgage 400,000.00 b
6/30/2014 Wages payable 10,000.00 b
6/30/2014 Petty cash advance 500.00 b
6/30/2014 Prepaid advertising 5,000.00 b
6/30/2014 Provision for annual leave 25,300.00 b
6/30/2014 Provision for doubtful debts 180.00 b
6/30/2014 Provision for long service leave 47,200.00 b
6/30/2014 P&L 70,380.00 70,380.00 b
6/30/2014 Stock (01/07/14) 100,000.00 b
6/30/2014 Creditors control 50,000.00 b
6/30/2014 Debtors control 74,500.00 b
6/30/2014 Provision for doubtful debts 2,800.00 b
6/30/2014 Equipment 900,000.00 b
6/30/2014 Accumulated depreciation - equipment 402,750.00 b
6/30/2014 Drawings 63,750.00 b
6/30/2014 Motor vehicle 255,000.00 b
6/30/2014 Accumulated depreciation - motor vehicle 122,500.00 b
6/30/2014 Capital 540,000.00 b
-
Ben Cook Traders
General Journal
Date Description Ref. Transaction
Debit Credit
6/30/2014 Interest expense 4,000.00
6/30/2014 Interest payable 4,000.00

6/30/2014 Wages 10,000.00


6/30/2014 Wages payable 10,000.00

6/30/2014 Bad debts 5,000.00


6/30/2014 GST payable 500.00
6/30/2014 Debtors control 5,500.00

6/30/2014 Provision for doubtful debts 17,000.00


6/30/2014 Bad debts 17,000.00

6/30/2014 Doubtful debt expense 17,180.00


6/30/2014 Provision for doubtful debts 17,180.00

6/30/2014 Accrued revenue 5,100.00


6/30/2014 Commission revenue 5,100.00

6/30/2014 Long service leave expense 6,900.00


6/30/2014 Provision for long service leave 6,900.00

6/30/2014 Annual leave expense 25,300.00


6/30/2014 Provision for long service leave 25,300.00

6/30/2014 Prepaid advertising 5,000.00


6/30/2014 Advertising expense 5,000.00
6/30/2014 Depreciation expense - equipment 87,750.00
6/30/2014 Accumulated depreciation - equipment 87,750.00

6/30/2014 Depreciation expense vehicle - Holden Cruze 18,750.00


6/30/2014 Accumulated depreciation - motor vehicle 18,750.00

6/30/2014 Depreciation expense vehicle - Volvo 3,000.00


6/30/2014 Accumulated depreciation - motor vehicle 3,000.00

6/30/2014 Depreciation expense vehicle 39,000.00


6/30/2014 Accumulated depreciation - motor vehicle 39,000.00

6/30/2014 Disposal MV 125,000.00


6/30/2014 MV 125,000.00

6/30/2014 Accumulated depreciation - motor vehicle 106,250.00


6/30/2014 Disposal MV 106,250.00

6/30/2014 Disposal MV 6,250.00


6/30/2014 Gain on sell 6,250.00

6/30/2014 MV 60,000.00
6/30/2014 Input tax credits 6,000.00
6/30/2014 Disposal MV 25,000.00
6/30/2014 Loan 41,000.00

6/30/2014 Stock Loss 20,000.00


6/30/2014 Stock/Inventory 20,000.00
45,500.00
Ben Cook Traders
General Journal
Date Description Ref. Transaction
Debit Credit
6/30/2014 Advertising 50,000.00
6/30/2014 P&L 50,000.00

6/30/2014 Annual leave expense 25,300.00


6/30/2014 P&L 25,300.00

6/30/2014 Buying expenses 14,800.00


6/30/2014 P&L 14,800.00

6/30/2014 Cartage outwards 120,000.00


6/30/2014 P&L 120,000.00

6/30/2014 Commission revenue 65,000.00


6/30/2014 P&L 65,000.00

6/30/2014 Depreciation expense - equipment 87,750.00


6/30/2014 P&L 87,750.00

6/30/2014 Depreciation expense - motor vehicle 60,750.00


6/30/2014 P&L 60,750.00

6/30/2014 Discount expense 2,500.00


6/30/2014 P&L 2,500.00

6/30/2014 Discount received 1,800.00


6/30/2014 P&L 1,800.00

6/30/2014 Donations 5,000.00


6/30/2014 P&L 5,000.00

6/30/2014 Doubtful debt expense 17,180.00


6/30/2014 P&L 17,180.00

6/30/2014 Electricity 40,000.00


6/30/2014 P&L 40,000.00

6/30/2014 Gain on sell 6,250.00


6/30/2014 P&L 6,250.00

6/30/2014 Interest expenses 180,000.00


6/30/2014 P&L 180,000.00

6/30/2014 Lease expense 6,000.00


6/30/2014 P&L 6,000.00

6/30/2014 Legal costs 75,000.00


6/30/2014 P&L 75,000.00

6/30/2014 Long service leave expense 6,900.00


6/30/2014 P&L 6,900.00

6/30/2014 Motor vehicle expense 50,000.00


6/30/2014 P&L 50,000.00

6/30/2014 Office salaries 40,000.00


6/30/2014 P&L 40,000.00

6/30/2014 Manager salaries 100,000.00


6/30/2014 P&L 100,000.00
6/30/2014 Wages 90,000.00
6/30/2014 P&L 90,000.00

6/30/2014 Office stationary 4,000.00


6/30/2014 P&L 4,000.00

6/30/2014 Purchases 360,000.00


6/30/2014 P&L 360,000.00

6/30/2014 Purchases returns and allowances 27,000.00


6/30/2014 P&L 27,000.00

6/30/2014 Rates and taxes 15,250.00


6/30/2014 P&L 15,250.00

6/30/2014 Rent revenue 300,000.00


6/30/2014 P&L 300,000.00

6/30/2014 Sales 900,000.00


6/30/2014 P&L 900,000.00

6/30/2014 Stock Loss 20,000.00


6/30/2014 P&L 20,000.00
2670480 2620480
50000
Ben Cook Traders
Fixed Asset Register

Ref.
Name Holden Cruze
Description Vehicle
Location
Model Holden Cruze Serial No. ZGL 036
Supplier Smart Car Invoice No. -
Purchase Date 1/1/2010 Cost
Asset Type Vehicle
Depreciation 5 years

History
Date Description Debit Credit

Total
ZGL 036
-

Written Down Value


Ben Cook Traders
Trial Balance
As at 30 June 2014
Account Name Ref. Debit Credit
Accrued revenue 5,100.00
Advertising 55,000.00 5,000.00
Annual leave expense 25,300.00
Bad debts 12,000.00 12,000.00
Bank 30,000.00
Buildings 800,000.00
Buying expenses 14,800.00
Cartage outwards 120,000.00
Commission revenue 65,000.00
Depreciation expense - equipment 87,750.00
Depreciation expense - motor vehicle 60,750.00
Discount expense 2,500.00
Discount received 1,800.00
Donations 5,000.00
Doubtful debt expense 17,180.00
Electricity 40,000.00
Gain on sell 6,250.00
GST payable 500.00 15,000.00
Input tax credits 16,000.00
Interest expenses 180,000.00
Interest payable 4,000.00
Lease expense 6,000.00
Legal costs 75,000.00
Loan 41,000.00
Loan BL Finance due 2020 600,000.00
Long service leave expense 6,900.00
Mortgage 400,000.00
Motor vehicle expense 50,000.00
Office salaries 40,000.00
Manager salaries 100,000.00
Wages 90,000.00
Wages payable 10,000.00
Office stationary 4,000.00
Petty cash advance 500.00
Prepaid advertising 5,000.00
Provision for annual leave 25,300.00
Provision for doubtful debts 180.00
Provision for long service leave 47,200.00
Purchases 360,000.00
Purchases returns and allowances 27,000.00
Rates and taxes 15,250.00
Rent revenue 300,000.00
Sales 900,000.00
Stock (01/07/14) 120,000.00 20,000.00
Stock Loss 20,000.00
Creditors control 50,000.00
Debtors control 80,000.00 5,500.00
Provision for doubtful debts 2,800.00
Equipment 900,000.00
Accumulated depreciation - equipment 402,750.00
Drawings 63,750.00
Motor vehicle 320,000.00 65,000.00
Accumulated depreciation - motor vehicle 45,500.00 168,000.00
Capital 540,000.00
Total 3,743,780.00 3,743,780.00
Ben Cook Traders
Trial Balance
As at 30 June 2014
Account Name Ref. Debit Credit
Accrued revenue 5,100.00 A
Bank 30,000.00 A
Buildings 800,000.00 A
GST payable 14,500.00 L
Input tax credits 16,000.00 A
Interest payable 4,000.00 L
Loan 41,000.00 L
Loan BL Finance due 2020 600,000.00 L
Mortgage 400,000.00 L
Wages payable 10,000.00 L
Petty cash advance 500.00 A
Prepaid advertising 5,000.00 A
Provision for annual leave 25,300.00 L
Provision for doubtful debts 180.00 L
Provision for long service leave 47,200.00 L
P&L 70,380.00 E
Stock (01/07/14) 100,000.00 A
Creditors control 50,000.00 L
Debtors control 74,500.00 A
Provision for doubtful debts 2,800.00 L
Equipment 900,000.00 A
Accumulated depreciation - equipment 402,750.00 A
Drawings 63,750.00 E
Motor vehicle 255,000.00 A
Accumulated depreciation - motor vehicle 122,500.00 A
Capital 540,000.00 E
Total 2,290,230.00 2,290,230.00
Ben Cook Traders
Trial Balance
As at 30 June 2014
Account Name Ref.
Petty cash advance 500.00 A
Bank - 30,000.00 A
Accrued revenue 5,100.00 A
Prepaid advertising 5,000.00 A
Input tax credits 16,000.00 A
Debtors control 74,500.00 A
Stock (01/07/14) 100,000.00 A
Buildings 800,000.00 A
Equipment 900,000.00 A
Accumulated depreciation - equipment - 402,750.00 A
Motor vehicle 255,000.00 A
Accumulated depreciation - motor vehicle - 122,500.00 A
1,600,850.00
GST payable - 14,500.00 L -1
Interest payable - 4,000.00 L
Loan - 41,000.00 L
Loan BL Finance due 2020 - 600,000.00 L
Mortgage - 400,000.00 L
Wages payable - 10,000.00 L
Provision for annual leave - 25,300.00 L
Provision for doubtful debts - 180.00 L
Provision for long service leave - 47,200.00 L
Creditors control - 50,000.00 L
Provision for doubtful debts - 2,800.00 L
- 1,194,980.00
405,870.00
Capital - 540,000.00 E
Drawings 63,750.00 E
P&L 70,380.00 E
- 405,870.00 -

You might also like