Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Postage expense Sales returns Sales tax payable Sales - textbooks Sales - other books Sales paper and printing Sales miscellaneous $4,687.52 $50.12 $200.88 $212.52 $2,020.32 $1,089.99 $715.67 $900.02 Day 2 Cash Drawing - owner Sales returns Sales tax payable Sales - textbooks Sales - other books Sales paper and printing Sales - miscellaneous $4,023.44 $300.11 $50.09 $188.06 $1,570.21 $615.02 $1,220.27 $780.08 Day 3 Cash Store expense Sales returns Sales tax payable Sales - textbooks Sales - other books Sales paper and printing Sales - miscellaneous $4,808.95 $215.23 $445.55 $235.77 $2,845.12 $810.03 $890.01 $688.80 Day 4 Cash Freight-in expense Sales returns Sales tax payable Sales - textbooks Sales - other books Sales paper and printing Sales - miscellaneous $4,533.86 $65.01 $100.87 $202.12 $1,460.67 $900.92 $1,020.78 $1,115.25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started