Question

Special Journal problem: Four days of sales data for the campus bookstore are listed below. Design a cash sales journal in a spreadsheet to record this data so each day is a SINGLE row. Use column headings to indicate the items to record and whether an entry in that column is a debit or credit. Also be sure to include a miscellaneous debit and credit columns with an accompanying column for the account number. Which columns would you total? What do you do with these totals? Include appropriate formulas for those totals.

Day 1 Cash $4,687.52 Postage expense $50.12 Sales returns $200.88 Sales tax payable $212.52 Sales – textbooks $2,020.32 Sales – other books $1,089.99 Sales – paper and printing $715.67 Sales – miscellaneous $900.02

Day 2 Cash $4,023.44 Drawing – owner $300.11 Sales returns $50.09 Sales tax payable $188.06 Sales – textbooks $1,570.21 Sales – other books $615.02 Sales – paper and printing $1,220.27 Sales – miscellaneous $780.08

Day 3 Cash $4,808.95 Store expense $215.23 Sales returns $445.55 Sales tax payable $235.77 Sales – textbooks $2,845.12 Sales – other books $810.03 Sales – paper and printing $890.01 Sales – miscellaneous $688.80

Day 4 Cash $4,533.86 Freight-in expense $65.01 Sales returns $100.87 Sales tax payable $202.12 Sales – textbooks $1,460.67 Sales – other books $900.92 Sales – paper and printing $1,020.78 Sales – miscellaneous $1,115.25

Answer 1

The Design of Cash Sales Journal book of Campus Bookstore is given below

CAMPUS BOOKSTORE
Cash Sales Journal
Particulars	Cash In $	Sales in $	Total Sales in $	Sales Returns in $	Net Sales in $	Sales Tax Payable in $	Postage Expenses in $	Store Expenses in $	Freightin Expenses in $	Miscelleneous Debit in $	Miscelleneous Credit in $	Total Expenses in $	Drawing to Owner in $	Net Cash Balance in $
Days	Opening Balance	Textbooks	Other books	Paper and Printings	Miscelleneous
	A	B	C	D	E	F= (B+C+D+E)	G	H = (F-G)	I	J	K	L	M	N	O = (I+J+K+L+M-N)	P	Q = (A+H) - (O)- (P)
Day 1	4687.52	2020.32	1089.99	715.67	900.02	4726	200.88	4525.12	212.52	50.12			4926.56	0	5189.2	0	4023.44
Day 2	4023.44	1570.21	615.02	1220.27	780.08	4185.58	50.09	4135.49	188.06	0			2861.81	0	3049.87	300.11	4808.95
Day 3	4808.95	2845.12	810.03	890.01	688.8	5233.96	445.55	4788.41	235.77	0	215.23	0	4612.5	0	5063.50	0	4533.86
Day 4	4533.86	1460.67	900.92	1020.78	1115.25	4497.62	100.87	4396.75	202.12	0	0	65.01	0	0	267.13	0	8663.48