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