Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing A Modern Approach

Authors: Sanjay Basotia

1st Edition

938092903X, 978-9380929033

More Books

Students also viewed these Accounting questions