Sales Tax Reporting Methodology?
TxTortoise
Registered Users Posts: 46 Big grins
Anyone have an easy answer for summarizing gross sales and shipping cost from the SmugMug sales spreadsheet. The total sales by quarter can be captured reasonably easy by date within the spreadsheet, but since shipping and tax is replicated for each line item, rather than by order, that column is useless.
Since I have to charge tax on shipping also, I have to manually split the spreadsheet into unique orders to get my shipping total to add to the purchase total. Since I can't get Sales Tax by quarter/month on the sales history screen I can't back into the number either.
The easy answer, for me, would be a mod to the sales history screen adding the following:
New Filter - By Prior Quarter (or selected time frame)
New Line Item - Total Gross Sales
New Line Item - Total Shipping
New Line Item - Total Sales Tax
Thoughts?
Since I have to charge tax on shipping also, I have to manually split the spreadsheet into unique orders to get my shipping total to add to the purchase total. Since I can't get Sales Tax by quarter/month on the sales history screen I can't back into the number either.
The easy answer, for me, would be a mod to the sales history screen adding the following:
New Filter - By Prior Quarter (or selected time frame)
New Line Item - Total Gross Sales
New Line Item - Total Shipping
New Line Item - Total Sales Tax
Thoughts?
0