Tax Collected by Settlement

Overview

In this article, you will learn about Sellercloud’s Tax Collected by Settlement report. This report provides a summary of the tax collected for all settlements. It includes transactional, financial, and location information.

Settlement is the process of transferring funds from a payment processor or acquiring bank to a merchant’s bank account. The settlement process reconciles the transactions and ensures that the funds from the customer’s payment are accurately credited to the merchant’s account. Settlements contain information about a channel’s order-related fees, commissions, and taxes.

You can see the following:

  • Transaction Information: Transaction Type, Order Number, Order Date, Transaction Date, and Channel.
  • Financial Information: Gross Sales, Tax, Marketplace Facilitator Tax, Tax Due, and Grand Total.
  • Location Information: State, Zip, and County.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the report, follow these steps:

  1. Navigate to Reports > Settlement > Tax Collected by Settlement.
  2. Set up the Default and Custom filters to have the report show precisely what you need.
  3. Click Search. Each filter you apply gets highlighted in a different color. If a filter is gray or not displayed at all, it’s not active.
  4. To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. You can:
    1. Reorder columns by dragging them up or down in the list;
    2. Hide columns by clicking the Trash icons;
    3. Add columns by clicking Add column.
  5. To sort the data differently, use the Sort by menu.
  6. To save your filtering and sorting options, click Save view, type a Name and click Save.
  7. To export the full report to a spreadsheet, click Actions on the bottom right and select Export to Excel. Spreadsheets include all columns, including those hidden in the report.

Filter and Column Definitions

Click the drop-downs below for filter and column descriptions.

Default Filters
FILTERDESCRIPTION
CompanyInclude only one or more companies.
ChannelInclude only one or more sales channels.
Filing PeriodInclude only orders with collected or refunded taxes reported in one of four specific quarters, or include orders with taxes reported within a custom filing period (choose start and end dates below).

Note: Use a custom filing period if your fiscal year does not run from January to December.

DateEnter the Start and End dates. For a single date, choose the same Start and End date.
Custom Filters
FILTERDESCRIPTION
Company GroupsInclude only orders from one or more company groups.
CountyInclude only orders from specific counties.
Order NumberInclude only one or more specific orders by order number.
Paid Orders OnlyInclude only paid orders.
Settlement ID Include only orders with specific settlement IDs. This filter works only for Amazon/FBA, Jet, eBay, Newegg, and Walmart Marketplace settlements.
Show Orders Without TaxInclude or exclude orders without tax.
StateInclude only orders from specific states.
Report Data
COLUMNDESCRIPTION
Transaction TypeShows the type of transaction, order or non-order.
StateShows the customer’s state.
ZipShows the customer’s zip code.
Order NumberShows the Sellercloud order number.
Transaction DateShows the date when the transaction occurred.
Order DateShows the date when the order came in.
ChannelShows the order’s sales channel.
Grand TotalShows the total amount of the order, calculated as such: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).
Gross SalesShows the total amount of the items before any discounts, tax, shipping, etc.
TaxShows the amount paid for tax for the order.
Marketplace Facilitator TaxShows the marketplace facilitator tax.
Tax DueShows the tax due: (Tax Collected – Paid by Channel).
StateShows the customer’s county.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support