Accounting Excel

Spreadsheet_PCU3.xls

Home >Business & Finance homework help >Accounting homework help >Accounting Excel

Title page

www.perdisco.com

spreadsheet version: PCU3e.S1

Worksheet


					Moondollars - Worksheet
					June 30, 20XX
	Acct. No.	Account Name	Unadjusted Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
			Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
	100	Cash	103,835
	102	Short-term Investments	20,000
	110	ARC - Accounts Receivable Control	6,895
	112	Interest Receivable
	120	Merchandise Inventory	73,322
	130	Office Supplies	7,083
	140	Prepaid Rent	6,000
	141	Prepaid Advertising	9,000
	142	Prepaid Insurance	2,950
	150	Office Furniture	9,000
	151	Accum Depn: Office Furniture		2,031
	160	Office Equipment	43,000
	161	Accum Depn: Office Equipment		13,532
	210	APC - Accounts Payable Control		155
	220	Wages Payable
	221	Electricity Payable
	222	Water Payable
	225	Interest Payable
	250	Bank Loan Payable		55,000
	300	Common Stock		80,000
	301	Retained Earnings		100,401
	400	Sales Revenue		46,370
	401	Sales Returns and Allowances	1,198
	402	Sales Discounts	284
	403	Interest Revenue		234
	500	Purchases	735
	501	Purchase Returns and Allowances		1,403
	502	Purchase Discounts		66
	511	Advertising Expense
	516	Wages Expense	10,685
	540	Rent Expense
	541	Electricity Expense
	542	Water Expense
	543	Insurance Expense
	544	Office Supplies Expense
	545	Salary Expense	5,200
	560	Depn Expense: Office Furniture			156
	561	Depn Expense: Office Equipment
	571	Interest Expense
	572	Admin. Expense - Bank Charges	5
		Totals	299,192	299,192
		Net income or loss
		Totals	299,192	299,192

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Schedules of accounts

	Schedule of accounts receivable
	Moondollars Schedule of Accounts Receivable June 30, 20XX
	Account No.	Name	Debit ($)	Credit ($)
	Total
	Schedule of accounts payable
	Moondollars Schedule of Accounts Payable June 30, 20XX
	Account No.	Name	Debit ($)	Credit ($)	Terms
	Total

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Income statement


	Moondollars Income Statement For the month ended June 30, 20XX
	INCOME
	Revenue
	Net sales revenue
	COST OF GOODS SOLD
	GROSS PROFIT
	OPERATING EXPENSES
	Selling expenses
	Total selling expenses
	General and administrative expenses
	Total general and administrative expenses
	TOTAL OPERATING EXPENSES
	INCOME/(LOSS) FROM OPERATIONS
	Other revenue
	Other expenses
	NET INCOME/(LOSS)

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Stockholders' equity


	Moondollars Statement of Stockholders' Equity For the month ended June 30, 20XX
	COMMON STOCK
	Opening balance May 31, 20XX
	Issue of common stock
	Closing balance June 30, 20XX
	RETAINED EARNINGS
	Opening balance May 31, 20XX
	Net income/(loss)
	Dividend paid
	Closing balance June 30, 20XX

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Balance sheet


	Moondollars Balance Sheet June 30, 20XX
	ASSETS
	Current Assets
	Total Current Assets
	Property, Plant and Equipment
	Total Property, Plant and Equipment
	TOTAL ASSETS
	LIABILITIES
	Current Liabilities
	Total Current Liabilities
	Long-term Liabilities
	TOTAL LIABILITIES
	STOCKHOLDERS' EQUITY
	TOTAL EQUITY
	TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Post-closing trial balance


	Moondollars Post-closing Trial Balance June 30, 20XX
	Account No.	Name	Debit ($)	Credit ($)
	Total

&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)