The Reporting tab in your left side menu has the sales, tax, cost, and inventory numbers you'll need at tax time. This section shows you where to find each one and how to pull it for a full tax year.
⚠️ Important
CommentSold can't give tax advice. Talk to your accountant or tax professional about which figures to report and how to report them. The reports below are a starting point for that conversation.
Before You Start
- Ask your accountant which figures they need. Most of them ask for sales tax collected, gross sales, refunds, cost of goods sold, and year-end inventory value.
- If you'll report inventory value, plan to capture it on or close to the last day of your tax year. Inventory values are real-time, so you can't look them up for a past date later.
Steps
Set the date range to your tax year
Select Reporting in the side menu. Enter the first day of your tax year as the Start date and the last day as the End date, then select Retrieve. The date range carries over when you switch between the Overview, Revenue, Orders & Returns, Customers, and Inventory tabs.
If the tax year isn't over yet, set the End date to yesterday. Today can't be included in a historical date range.
Review sales tax collected
Open the Revenue tab and expand the Revenue section. Total Tax is all the tax applied to orders, and you'll also see State Tax, County Tax, and Municipal Tax listed separately.
Review revenue and costs
In the same Revenue section, write down the figures your accountant asked for. See the table below for what each one includes.
Review refunds and returns
Open the Orders & Returns tab and expand Returns and Refunds. Check the Date filter applies to toggle first. Return date counts refunds by when the return was processed, and Orders date counts them by when the original order was placed. Ask your accountant which one they want, then note Total Refunded Amount and COGS of Returns.
Capture year-end inventory value
Open the Inventory tab. Inventory Retail Value and Inventory Cost show what you have on hand right now, broken out by warehouse. Record them at the end of your tax year, or generate an Inventory Snapshots CSV (step 6) so you have a saved copy.
Download supporting CSVs
Open the CSV tab, find each report you need, and select Generate. Select View All Columns on a report card to see what it includes before you generate it. Keep these files with your tax records.
Where to Find Each Figure
| What You Need | Where to Find It | Good to Know |
|---|---|---|
| Sales tax collected | Revenue tab > Total Tax; CSV tab > Sales Tax by Location | Total Tax includes state, county, and municipal tax where applicable. Use the CSV for a breakdown by location. |
| Total collected from customers | Revenue tab > Total Payments | Amount charged after coupons and credit, including shipping, tax, and order fees. Same as Net Receipts in Insights. |
| Product sales | Revenue tab > Product Revenue | Retail price of products sold. Doesn't include coupons, credit, shipping, tax, or order fees. |
| Discounts | Revenue tab > Coupons Applied, Credit Applied | Credit Applied includes both discount credit and payment credit. |
| Shipping charged and paid | Revenue tab > Shipping Revenue, Shipping Cost | Shipping Cost only includes labels bought and created on the CommentSold Shipping Platform. Add any labels you bought elsewhere yourself. |
| Cost of goods sold | Revenue tab > Cost of Goods Sold | Cost of products sold in the date range. |
| Gross profit | Revenue tab > Gross Profit | Total Payments minus tax, cost of goods, and shipping cost. |
| Refunds | Orders & Returns tab > Total Refunded Amount, COGS of Returns; CSV tab > Returns Report | Includes refunds issued as account credit and to the original payment method. Check the Date filter applies to setting. |
| Year-end inventory | Inventory tab > Inventory Cost, Inventory Retail Value; CSV tab > Inventory Snapshots | Real-time values, not date-filtered. Received items on hand only; deleted and archived products aren't included. |
| Store credit and gift cards | Customers tab > Customer Credits; CSV tab > Store Credit Activity, Gift Cards Report | Remaining credit and gift card balances are lifetime values, not date-filtered. Credit movement during the time period does use your date range. |
💡 Tip
Don't wait until year-end. Pulling these reports each month or quarter, especially Sales Tax by Location, makes sales tax filing easier, and you'll have inventory snapshots on hand if you ever need them.
📘 Note
Use the figures above for your totals. Revenue by Order Source and Sell Through are useful for planning, but they're calculated differently and shouldn't be used as tax totals. Sell Through, for example, only includes products posted during the date range.