Skip to main content

Finance Total

Provides summarized TikTok Shop financial totals by shop, including sales, refunds, discounts, shipping, fees, commissions, taxes, and settlement amounts.

Select Account

Allows you to select the TikTok Shop account from where data will be retrieved.

  • Reload Accounts & Marketplaces:

    • Use this to refresh the connection list if you have recently added or updated in the app.gorillaroi.com

  • Click here to connect additional accounts:

    • Click here to open the Gorilla ROI app, where you can add, update, or manage your account connections.

Period

Select the time range for your report using one of these options:

  • Predefined ranges (e.g., Today, Yesterday, Last 7 Days, Last 30 Days, This Year, Last Month, Last 12 Months, etc.) for quick selection.

  • Custom to choose a specific start and end date.

  • Last X Daily Values to get day-wise historical data for the selected number of past days (e.g., Number of days --> 22).

Metrics

  • Shop Id

  • Gross Sales Amount

  • Gross Sales Refund Amount

  • Net Sales Amount

  • Revenue Amount

  • After Seller Discounts Subtotal Amount

  • Customer Payment Amount

  • Customer Refund Amount

  • Customer Order Refund Amount

  • Settlement Amount

  • Seller Discount Amount

  • Seller Discount Refund Amount

  • Platform Discount Amount

  • Platform Discount Refund Amount

  • Platform Refund Subsidy Amount

  • Customer Shipping Fee Amount

  • Customer Shipping Fee Offset Amount

  • Customer Paid Shipping Fee Amount

  • Customer Paid Shipping Fee Refund Amount

  • Actual Shipping Fee Amount

  • Actual Return Shipping Fee Amount

  • Return Shipping Fee Amount

  • Shipping Fee Amount

  • Shipping Cost Amount

  • Shipping Cost Discount Amount

  • Shipping Fee Subsidy Amount

  • Shipping Insurance Fee Amount

  • Signature Confirmation Fee Amount

  • Platform Shipping Fee Discount Amount

  • Promo Shipping Incentive Amount

  • Refund Shipping Cost Discount Amount

  • Fbm Shipping Cost Amount

  • Fbt Shipping Cost Amount

  • Fbt Fulfillment Fee Amount

  • Fbt Fulfillment Fee Reimbursement Amount

  • Fee Amount

  • Referral Fee Amount

  • Transaction Fee Amount

  • Refund Administration Fee Amount

  • Platform Commission Amount

  • Sales Tax Amount

  • Sales Tax Payment Amount

  • Sales Tax Refund Amount

  • Isr Income Tax Amount

  • Iva Vat Amount

  • Retail Delivery Fee Amount

  • Retail Delivery Fee Payment Amount

  • Retail Delivery Fee Refund Amount

  • Affiliate Commission Amount

  • Affiliate Ads Commission Amount

  • Affiliate Partner Commission Amount

  • Affiliate Commission Before Pit

  • Pit Amount

  • Adjustment Amount

Group by

  • Period: Shows all datapoints grouped under one time range (e.g., Last 30 Days, Last 60 Days, etc.).

  • Datapoint: Shows each metric separately, with the time range shown for each.

Filter

Results per Query: Select the maximum number of records (rows) returned in the output (e.g., 5, 10, 50, 100, 500, 1000, 50,000).

Field filters are not available for the Finance Total dataset.

Options

Replace Blank Values with 0 or N/A: Replaces empty or missing values with 0 or N/A (where applicable).

No Header Row: Removes the header row from the output.

Products with Data Only: Displays only products that have data, hiding those with no data or activity.

Sample output (partial view) showing selected datapoints

Did this answer your question?