Question

Create a general ledger on excel or google sheets using this information.

	Cutz and Co.
	General Journal
	December 31, 2018
Account Number	Month	Description	Debit	Credit		(Notes)
		Cash	$200,000.00
		Accounts Receivable		$200,000.00
		Cash	$1,000.00
		Rent Expense		$1,000.00
		Cash	$2,300.00
		Insurance Expense		$2,300.00
		Office Equipment	$1,000.00
		Accounts Payable		$1,000.00
		Equipment	$3,000.00
		Accounts Payable		$3,000.00
		Cash	$15,000.00
		Machine 1		$15,000.00
		Cash	$10,000.00
		Machine 2		$10,000.00
		Depreciation Expense
		Accumulated Depreciation
		Supplies Expense	$15,650.00
		Accounts Payable		$15,650.00
		Materials	$9,000.00			$10x900units
		Accounts Payable		$9,000.00
		Wages Expense	$5,000.00
		Wages Payable		$5,000.00
		Accounts Receivables	$11,500.00
		Sales		$11,500.00

Answer 1

General Ledger
Account	Event	Debit	Credit	Balance
Accounts Payable	d		$          1,000	$      1,000
	e		$          3,000	$      4,000
	i		$        15,650	$    19,650
	j		$          9,000	$    28,650
Accounts Receivable	a		$      200,000	$-200,000
	l	$        11,500		$-188,500
Accumulated Depreciation	h
Cash	a	$     200,000		$ 200,000
	b	$          1,000		$ 201,000
	c	$          2,300		$ 203,300
	f	$        15,000		$ 218,300
	g	$        10,000		$ 228,300
Depreciation Expense	h
Equipment	e	$          3,000		$      3,000
Insurance Expense	c		$          2,300	$    -2,300
Machine 1	f		$        15,000	$ -15,000
Machine 2	g		$        10,000	$ -10,000
Materials	j	$          9,000		$      9,000
Office Equipment	d	$          1,000		$      1,000
Rent Expense	b		$          1,000	$    -1,000
Sales	l		$        11,500	$    11,500
Supplies Expense	i	$        15,650		$    15,650
Wages Expense	k	$          5,000		$      5,000
Wages Payable	k		$          5,000	$      5,000