Perfecto Coffee's November Transactions And Accounting Information In An Essay. (70 Characters)

Background and Facts

Background and Facts

Alberto Holland is the owner of Perfecto Coffee, a specialty coffee machine business he started two years ago.  Alberto sells 2 types of coffee machines that he purchases from manufacturers. He operates the business himself and employs one person full-time as an assistant. Alberto also provides specialty barista training services to private clients on how to make perfect coffee.

Perfecto Coffee is operated from a rented premise and the business pays rent quarterly in advance.

The business has a variety of clients with whom Alberto has built up a strong relationship. He offers them terms of 2/10, net/30.

The business uses a FIFO perpetual inventory system (First In, First Out).

The business is registered for GST. Business Activity Statements (BAS) are submitted quarterly to the Australia Taxation Office on an accrual basis.

Currently, the business uses a manual accounting system but plans to test a MYOB accounting system later in the year.

Accounting Information

Perfecto Coffee uses the following specialised and general journals to record business transactions.

• Sales Journal - to record all invoices issued for sales of inventory
• Purchases Journal - to record all credit purchases
• Cash Receipts Journal - to record all cash received
• Cash Payments Journal - to record all cash payments
• General Journal - to record all other transactions

Perfecto Coffee uses a general ledger in the form of a 4-column running balance (as described on page 22 (page 72) Exhibit 2-13 of Custom Text Chapter 1 (Chapter 2 of original). An Accounts Receivable and Accounts Payable subsidiary ledger is also used in this format.

Financial Statements are prepared at the end of each month, and the accounts are closed off at the end of each month.

All necessary pro-formas are included and are to be used to complete the manual practice set for November. The assignment can be completed either manually using the Excel templates provided or by computer in Excel.

Chart of Accounts and Opening Balances 1^st November

Account Number	Account Name	Debit	Credit
110	Cash at Bank	18,835
120	Accounts receivable	16,140
121	Allowance for Doubtful Debts		646
130	Prepaid Insurance
140	Prepaid Rent	3000
150	Office Supplies	950
160	Inventory	19,000
180	Delivery Van
181	Accumulated Depreciation – Delivery Van
200	Accounts Payable		16,995
220	Wages Payable		377
230	GST Clearing		1,045
250	Superannuation Payable		756
300	Capital		38,106
310	Drawings
350	Income Summary
410	Sales Revenue
412	Sales Discounts
415	Services Revenue
420	Interest Revenue
500	Cost of Sales
512	Bad debts expense
515	Bank Charges
521	Depreciation expense – Delivery Van
530	Electricity and Gas Expense
540	Insurance Expense
560	Office Supplies Expense
565	Rent Expense
570	Superannuation expense
590	Wages Expense

 
All account balances at 1^st November are normal in nature.

Subsidiary Ledgers

Accounts Receivable Subsidiary Ledger

As at 1 November

Cayden’s Coffee Club	4,000
H. Proctor	12,140
	16,140

Accounts Payable Subsidiary Ledger

As at 1 November

Arabica Pty Ltd	6,765
Crema Supplies Pty Ltd	10,230
	16,995

Inventory on Hand

As at 1 November

	Units on Hand	Cost per Unit	Total
Espresso Sprint	40	320	12,800
Espresso Deluxe	10	620	6,200
			$19,000

NOVEMBER TRANSACTIONS

The transactions for Perfecto Coffee during November are listed below.

Note:  All amounts are GST-inclusive where applicable.

Credit sales are made on credit terms of 2/10, n/30

Round all amounts to the nearest dollar.

	Date	Details
1.	November 1	Purchased a delivery van for $33,000 from Holland Autos on credit.  Terms are n/60. Invoice number 15448.
2.	November 1	Paid insurance for 5 months in advance - $2,200 – chq 71.
3.	November 1	Paid Arabica Pty Ltd in full for outstanding account balance at 1st November – no discounts applicable - chq 72.
4.	November 2	Sold 10 Espresso Sprint machines for cash - $6,050.
5.	November 6	Purchased office supplies for cash - $330- chq 73.
6.	November 9	Received amount owed by Cayden’s Coffee Club for July invoices less the discount.
7.	November 9	Paid fortnightly wages of $1,760 – chq 74. ($1,383 relates to November wages; $377 relates to the wages accrued for July)
8.	November 12	Received payment from H. Proctor for part of the November balance - $2,140. There was no discount allowed.
9.	November 14	Purchased 15 Espresso Deluxe coffee machines from Arabica Pty Ltd for $10,395. Terms 3/10, n/30, Inv. 5430.
10.	November 15	Sold 17 Espresso Sprint machines to Cayden’s Coffee Club for $10,285, Inv. 4564.
11.	November 16	Invoiced Cayden’s Coffee Club for Barista training, Inv. 4565 for $3,300.
12.	November 16	The owner withdrew cash of $2,350 - chq 75.
13.	November 20	Paid the 1st November amount owing to Crema Supplies Pty Ltd with chq 76. No discounts were applicable.
14.	November 22	Paid electricity and gas bill, $390 – chq 77.
15.	November 23	Paid fortnightly wages of $1,760 – chq 78.
16.	November 23	Paid superannuation contributions owing from July of $756 – chq 79.
17.	November 24	Received payment from Cayden’s Coffee Club for invoice 4564, less the applicable discount.
18.	November 26	Sold to H. Proctor, 10 Espresso Deluxe machines - $9,350, inv. 4566.
19.	November 26	Purchased 20 Espresso Sprints coffee machines from Crema Supplies Pty Ltd for $7084. Terms 2/10, n/30, inv. 1389.
20.	November 30	Recorded bank charges of $40 and interest earned of $22.

Instructions for Completion of Practice Set

3. Open all general ledger accounts by inserting the opening balances at 1 November as shown in the Chart of Accounts on page 3.  For example, the balance of account 110 - Cash at Bank is $18,835 debit.  Write “Opening Balance” in the “Details” column, and place $18,835 in the “Debit” balance column.

4. Open all subsidiary ledger accounts for accounts receivable and accounts payable by inserting the opening balances as at 1 November as shown in the schedule of accounts receivable and accounts payable on page 4.  Insert the opening inventory balances into the inventory cards.

Note:  For the general ledger, accounts receivable subsidiary ledger and accounts payable subsidiary ledgers, all accounts have normal balances

1. Record the transactions for November in the appropriate journals provided (narrations are not required).
2. Post daily to the accounts receivable and accounts payable subsidiary ledgers.

Post daily from the general journal. All other amounts will be posted at the end of the month.

Note: For posting reference purposes, use the journal page names and numbers. For example, when posting from the sales journal the reference will be “SJ9”.

1. Total all columns of the special journals.  Post from the special journals to the general ledger. 
2. Prepare schedules of Accounts Receivable and Accounts Payable.  Check that the total of the Schedule of Accounts Receivable equals the Accounts Receivable Control account in the general ledger and that the Schedule of Accounts Payable equals the Accounts Payable account in the general ledger.
3. Use the worksheet provided to prepare an Unadjusted Trial Balance as at 30 November.

Check figures for this stage of the assignment are as follows:

• Total of the Cash column in the Cash Receipts Journal - $22212
• Cash at Bank account balance – Dr $14466
• Inventory account balance – $20050.
• GST Clearing account balance -  Dr $1200
• Unadjusted trial balance from worksheet - $115603

Note: If any of your figures do not match those above, you have made an error which you will need to find and correct.

1. Using the following information record the necessary adjusting journal entries at 30 November in the general journal.  Post these to the general ledger.
2. Insurance

Alberto paid 5 months insurance in advance on November 1.

2. Depreciation

On November 1, the business purchased a delivery van.  It has a useful life of 10 years and a residual value of $6,000. The vehicle is depreciated using the straight-line method. Record depreciation for one month.

3. Accrued Wages

Wages owing at 30 November totalled $880.

4. Superannuation

Superannuation contributions accrued for November total $871.

5. Office Supplies

A stocktake of office supplies was performed on November 30.  It was noted that $650 of supplies remain.

6. Bad Debts

An assessment of bad and doubtful debts at November 30 showed an increase in the amount falling into this category. Alberto has decided to increase the Allowance for Doubtful Debts to 6% of the accounts receivable balance at November 30.

7. Rent

Rent of $4,500 is paid every quarter, and was last paid on the 1^st of October.

1. Record these adjustments in the adjustments column of the worksheet.
2. Complete the worksheet.
3. Record all closing entries in the general journal and post them to the general ledger.
4. Prepare a Post-closing Trial Balance as at 30 November.
5. Prepare the Income Statement (functional format), Statement of Changes in Equity, and Classified Balance Sheet.

Cash at Bank					Account Number: 110
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance		18835
30-Nov	Total Cash Receipts	CRJ	41046		22211
	Total Cash Payments	CPJ	14465			26581

a

Accounts Receivable					Account Number: 120
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance		16140
30-Nov	Total Credit Purchase	SJ	39075		22935
	Total Cash Receipts	CRJ	22650			16425

Allowance for Doubtful Debts					Account Number: 121
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			646
30-Nov	New Bad Debt	GJ		1359		713

Prepaid Insurance					Account Number: 130
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Insurance paid in Advance	CPJ	2000		2000
30-Nov	Insurance Expired	GJ	1600			400

Prepaid Rent					Account Number: 140
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance		3000
30-Nov	Rent Expired	GJ	1500			1500

Office Supplies					Account Number: 150
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance		950
6-Nov	Cash Purchase of Office Supplies	CPJ	1250		300
30-Nov	Supplies Consumed	GJ	650			600

Inventory					Account Number: 160
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance		19000
30-Nov	Total credit Purchase	PJ	34890		15890
	Total cash sales	CRJ	31690			3200
	Total credit sales	SJ	20050			11640

Delivery Van					Account Number: 180
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Van purchased on credit	PJ	30000		30000
			30000

Accumulated Depreciation - Delivery Van					Account Number: 181
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Depreciation Charged	GJ		200		200
				200

Accounts Payable					Account Number: 200
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			16995
30-Nov	Total Credit Purchase	PJ		67474		50479
	Total Cash Repayment	CPJ		50479	16995

Wages Payable					Account Number: 220
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			377
9-Nov	Due Wages Paid	CPJ		0	377
30-Nov	Accrued Wages	GJ		880		880

GST Clearing					Account Number: 230
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			1045
30-Nov	Total Cash Receipts	CRJ		1595		550
	Total Sales Discounts	CRJ		1569	26
	Total Credit Sales	SJ		3654		2085
	Total Cash Payments	CPJ		3389	265
	Total Credit Purchase	PJ	1200		4589

Superannuation Payable					Account Number: 250
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			756
23-Nov	Due Superannuation paid	CPJ		0	756
30-Nov	Superannuation Due	GJ		871		871

Capital					Account Number: 300
Date	Details	Post ref	Debit	Credit	Dr	Cr
1-Nov	Opening Balance			38106
30-Nov	Income Summary	GJ13		40676.73		2570.73
	Drawings	GJ13		38326.73	2350.00

Drawings					Account Number: 310
Date	Details	Post ref	Debit	Credit	Dr	Cr
16-Nov	Cash Withdrawl	CPJ	2350		2350
30-Nov	Capital	GJ13	0			2350

Income Summary					Account Number: 350
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Total Revenue	GJ13		26372		26372.00
	Total Expenses	GJ13		2570.73	23801.27
	Capital	GJ13		0.00	2570.73

Sales Revenue					Account Number: 410
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Total Cash Sales	CRJ		5500		5500
	Total Credit Sales	SJ		23350		17850
	Closing Entry	GJ13		0	23350
Sales Discounts					Account Number: 412
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Total Sales Discounts	CRJ	260		260
	Closing Entry	GJ13	0			260
Service Revenue					Account Number: 415
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Total Service Revenue	SJ		3000		3000
	Closing Entry	GJ13		0	3000
Interest Revenue					Account Number: 420
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Interest from Bank	CRJ		22		22
	Closing Entry	GJ13		0	22
Cost of Sales					Account Number: 500
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Total Cash sales	CRJ	3200		3200
	Total Credit sales	SJ	14840		11640
	Closing Entry	GJ13	0			14840
Bad Debts Expense					Account Number: 512
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Bad Debt Expenses	GJ	713		713
	Closing Entry	GJ13	0			713
Bank Charges					Account Number: 515
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Bank Charges paid	CPJ	40		40
	Closing Entry	GJ13	0			40
Depreciation Expense - Delivery Van					Account Number: 521
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Depreciation on Van	GJ	200		200
	Closing Entry	GJ13	0			200
Electricity and Gas Expense					Account Number: 530
Date	Details	Post ref	Debit	Credit	Dr	Cr
22-Nov	Electricity & Gas Expenses Paid	CPJ	355		355
	Closing Entry	GJ13	0			355
Insurance Expense					Account Number: 540
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Insurance Expense for the month	GJ	400		400
	Closing Entry	GJ13	0			400
Office Supplies Expense					Account Number: 560
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Office Supplies Expenses	GJ	600		600
	Closing Entry	GJ13	0			600
Rent Expense					Account Number: 565
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Rent Expenses	GJ	1500		1500
	Closing Entry	GJ13	0			1500
Superannuation Expense					Account Number: 570
Date	Details	Post ref	Debit	Credit	Dr	Cr
30-Nov	Superannuation Expenses	GJ	871		871
	Closing Entry	GJ13	0			871
Wages Expense					Account Number: 590
Date	Details	Post ref	Debit	Credit	Dr	Cr
9-Nov	Fortnighly Wages Paid	CPJ	1383		1383
23-Nov	Fortnighly Wages Paid	CPJ	3143		1760
30-Nov	Wages Due	GJ	4023		880
	Closing Entry	GJ13	0			4023

Date	Details	Post ref	Debit	Credit
	ADJUSTING ENTRIES                 Page 12
Date	Details	Post ref	Debit	Credit
30-Nov	Insurance Expense A/c…..Dr.	540	400
	To, Prepaid Insurance A/c.	130		400
	Depreciation Expense - Delivery Van A/c….Dr.	521	200
	To, Accumulated Depreciation - Delivery Van A/c.	181		200
	Wages Expense A/c……Dr.	590	880
	To, Wages Payable A/c.	220		880
	Superannuation Expense A/c……Dr.	570	871
	To, Superannuation Payable A/c.	250		871
	Office Supplies Expense A/c……Dr.	560	600
	To, Office Supplies A/c.	150		600
	Bad Debts Expense A/c…..Dr.	512	713
	To, Allowance for Doubtful Debts A/c.	121		713
	Rent Expense A/c…..Dr.	565	1500
	To, Prepaid Rent A/c.	140		1500
Date	Details	Post ref	Debit	Credit
30-Nov	Income Summary A/c……Dr.	350	23801.27273
	To, Sales Discounts A/c.	412		259.73
	To, Cost of Sales A/c.	500		14840.00
	To, Bad Debts Expense A/c.	512		713.00
	To, Bank Charges A/c.	515		40.00
	To, Depreciation Expense - Delivery Van A/c.	521		200.00
	To, Electricity & Gas Expense A/c.	530		354.55
	To, Insurance Expense A/c.	540		400.00
	To, Office Supplies Expense A/c.	560		600.00
	To, Rent Expense A/c.	565		1500.00
	To, Superannuation Expense A/c.	570		871.00
	To, Wages Expense A/c.	590		4023.00
	Sales Revenue A/c…..Dr.	410	23350.00
	Service Revenue A/c….Dr.	415	3000.00
	Interest Revenue A/c…..Dr.	420	22.00
	To, Income Summary A/c.	350		26372.00
	Income Summary A/c…..Dr.	350	2570.73
	To, Capital A/c.	300		2570.73
	Capital A/c……Dr.	300	2350.00
	To, Drawings A/c.	310		2350.00

A/C No	Account Name	Unadjusted Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
		Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr
110	Cash at Bank	14465.30				14465.30				14465.30
120	Accounts receivable	22650.00				22650.00				22650.00
121	Allowance for Doubtful Debts		646.00		713.00		1359.00				1359.00
130	Prepaid Insurance	2000.00			400.00	1600.00				1600.00
140	Prepaid Rent	3000.00			1500.00	1500.00				1500.00
150	Office Supplies	1250.00			600.00	650.00				650.00
160	Inventory	20050.00				20050.00				20050.00
180	Delivery Van	30000.00				30000.00				30000.00
181	Accumulated Depreciation – Delivery Van				200.00		200.00				200.00
200	Accounts Payable		50479.00				50479.00				50479.00
220	Wages Payable		0.00		880.00		880.00				880.00
230	GST Clearing	1200.43				1200.43				1200.43
250	Superannuation Payable		0.00		871.00		871.00				871.00
300	Capital		38106.00				38106.00				38106.00
310	Drawings	2350.00				2350.00				2350.00
350	Income Summary
410	Sales Revenue		23350.00				23350.00		23350.00
412	Sales Discounts	259.73				259.73		259.73
415	Services Revenue		3000.00				3000.00		3000.00
420	Interest Revenue		22.00				22.00		22.00
500	Cost of Sales	14840.00				14840.00		14840.00
512	Bad Debts Expense			713.00		713.00		713.00
515	Bank charges	40.00				40.00		40.00
521	Depreciation Expense – Delivery Van			200.00		200.00		200.00
530	Electricity and Gas Expense	354.55				354.55		354.55
540	Insurance Expense			400.00		400.00		400.00
560	Office Supplies Expense			600.00		600.00		600.00
565	Rent Expense			1500.00		1500.00		1500.00
570	Superannuation Expense			871.00		871.00		871.00
590	Wages Expense	3143.00		880.00		4023.00		4023.00
		115603.00	115603.00	5164.00	5164.00	118267.00	118267.00	23801.27	26372.00	94465.73	91895.00
	Profit/(loss)							2570.73			2570.73
								26372.00	26372.00	94465.73	94465.73

30th November
A/C No	Account Name	Dr	Cr
110	Cash at Bank	14465.30
120	Accounts receivable	22650.00
121	Allowance for Doubtful Debts		1359.00
130	Prepaid Insurance	1600.00
140	Prepaid Rent	1500.00
150	Office Supplies	650.00
160	Inventory	20050.00
180	Delivery Van	30000.00
181	Accumulated Depreciation – Delivery Van		200.00
200	Accounts Payable		50479.00
220	Wages Payable		880.00
230	GST Clearing	1200.43
250	Superannuation Payable		871.00
300	Capital		38326.73
	TOTAL	92115.73	92115.73

Date	Account credited	Terms	Post ref.	Credit	Debits
				Accounts payable	Inventory	Delivery Van	Other:       Account title	Post ref.	Amount	GST
1-Nov	Holland Autos	n/60	15448	33000		30000		180		3000
14-Nov	Arabica Pty. Ltd.	3/10,n/30	5430	10395	9450			160		945
26-Nov	Crema Supplies Pty. Ltd.	2/10,n/30	1389	7084	6440			160		644
	TOTAL			50479	15890	30000	0	500	0	4589

Date	Invoice no.	Account debited	Post ref.	Debit	Credit			Cost of sales Dr.     Inventory Cr.
				Accounts Receivable	Sales Revenue	Services Revenue	GST
15-Nov	4564	Cayden's Coffee Club	120	10285	9350		935	5440
16-Nov	4565	Cayden's Coffee Club	120	3300		3000	300
26-Nov	4566	H. Proctor	120	9350	8500		850	6200
		TOTAL		22935	17850	3000	2085	11640

Date	Chq. No.	Account debited	Post ref.	Debits			Credits
				Other accounts		Accounts payable	Inventory		Cash
				GST	Net		GST	Net
1-Nov	71	Prepaid Insurance	130	200	2000				2200
1-Nov	72	Arabia Pty. Ltd.	200			6765			6765
6-Nov	73	Office Supplies	150	30	300				330
9-Nov	74	Wages Expense	590		1383				1383
		Wages Payable	220		377				377
16-Nov	75	Drawings	310		2350				2350
20-Nov	76	Crema Supplies Pty. Ltd.	200			10230			10230
22-Nov	77	Electricity & Gas Expenses	530	35	355				390
23-Nov	78	Wages Expenses	590		1760				1760
23-Nov	79	Superannuation Payable	250		756				756
30-Nov		Bank Charges	515		40				40
		TOTAL		265	9321	16995	0	0	26581

Schedule of Accounts Receivable as at 30th November
Account Name		Amount
H.Proctor		19350
Cayden's Coffee House		3300
TOTAL		$22,650

Schedule of Accounts Payable as at 30th November

Account Name		Amount
Arabica Pty. Ltd.		10395
Crema Supplies Pty. Ltd.		7084
Holland Autos		33000
TOTAL		$50,479

Accounts Receivable Subsidiary Ledger

H. Proctor
Date	Details	Invoice No	Post ref	Debit	Credit	Balance
1-Nov	Opening Balance					12140
12-Nov	Cash Receipts		CRJ		2140	10000
26-Nov	Credit Sales	4566	SJ	9350		19350
Cayden's Cofffee Club
Date	Details	Invoice No	Post ref	Debit	Credit	Balance
1-Nov	Opening Balance					4000
9-Nov	Cash Receipts		CRJ		4000	0
15-Nov	Credit Sales	4564	SJ	10285		10285
16-Nov	Service provided on Credit	4565	SJ	3300		13585
24-Nov	Cash Receipts		CRJ		10285	3300

Accounts Payable Subsidiary Ledger

Arabica Pty Ltd
Date	Details	Invoice No	Post ref	Debit	Credit	Balance
1-Nov	Opening Balance					6765
1-Nov	Cash Repayment		CPJ	6765		0
14-Nov	Credit Purchase	5430	PJ		10395	10395
Crema Supplies Pty Ltd
Date	Details	Invoice No	Post ref	Debit	Credit	Balance
1-Nov	Opening Balance					10230
20-Nov	Cash Repayment		CPJ	10230		0
26-Nov	Credit Purchase	1389	PJ		7084	7084
Holland Autos
Date	Details	Invoice No	Post ref	Debit	Credit	Balance
1-Nov	Purchase of Delivery Van on Credit	15448	GJ		33000	33000