Introducing Reports

Overview

Sellercloud’s Financial Reporting Suite is a rich data source for you to analyze your business performance effectively. Thanks to various reports, Sellercloud offers an easy way to track profit and loss, orders, transactions, product inventory, and more.

Check out this short video introduction to the Financial Reporting Suite.


Reports Basics

These are the basics you need to know about Sellercloud reports:

  • Sellercloud offers ten unique categories of reports. Each category includes multiple reports. Some categories also include visual dashboards. 
  • Reports and dashboards offer easy-to-set-up filters to get the specific data you need.
  • You can customize the reports by changing how your data is sorted and displayed.
  • You can export your filtered or unfiltered report data to an Excel or a CSV file, unlocking many possibilities for further data manipulation and analysis.
  • You can contact Sellercloud Support to request a custom-made report.
For answers to common questions, see the Reports FAQ.

Get Started

To access the reports section, select Reports in the navigation menu on the left.

Next, select a category and choose the report you want to run.


Reports Categories

Sellercloud offers over sixty reports broken down into the following categories:

The following sections briefly introduce you to each category, explain what it is for, and list the available reports. Click the links for step-by-step instructions on using a specific report. All Reports that include Payment Information and Taxes, such as P&LOrder, and Sales Reports, use a special calculation for Split Orders. Instead of displaying the 100% discount on the Child Orders, they will factor in exactly how the Orders were split and distribute the payments accordingly, giving you a precise breakdown and the most accurate results.

Reports marked with an asterisk (*) can run automatically on a regular basis with Scheduled Tasks. Simply select the Task Type: Reports and configure the dropdown options in the Details panel.

Profit & Loss

Profit and Loss (P&L) reports are essential to financial management. These reports allow you to clearly understand your profit and loss, broken by product, order, time range, and more. They provide insight into revenue, expenses, and overall profitability, allowing you to track progress and make better decisions.

  • Profit & Loss Dashboard* – a dashboard that helps you summarize and analyze the company’s profit and loss.
  • P&L Order Summary* – summarizes the profit and loss for orders in a specific period.
  • P&L Order Details* – shows individual orders’ profit and loss details based on transactions made on a specific date or date range.
  • Product Profit Summary* – shows each product’s profit and loss information by summarizing the order and non-order transactions within a specific period.
  • Product Profit Details* – details profit and loss for each product’s order and non-order transactions within a specific period.
  • Manage P&L – easily manage your profit and loss reports and perform various related actions.

 

Sales

The Sales reports category provides valuable information and insights into your sales performance. These reports offer a comprehensive view of various aspects of sales, including order history, product performance, and sales trends.

 

Orders

Orders reports provide valuable insights into order activity. You can track how many orders you received, how much you made from the orders, see your top-ordered and most profitable products, and so much more. These reports help you understand your performance and make better choices about your future business operations.

 

Returns & Refunds

Returns and Refunds reports provide information on orders’ returns, refunds, and reimbursements. These reports help you identify problematic products and effectively manage returns, refunds, and rebates.

  • Returns Dashboard* – helps you analyze and monitor returns, refunds, and reimbursements for orders in a specific time range.
  • Refund Summary* – provides an overview of all refunds processed in a specific period. It includes information about the refund, the original order, and the customer.
  • Refund Details* – provides details about all refunds processed in a specific period. It includes information about all refunds, refunded products, and order details.
  • Returns Details* – provides a detailed overview of all returns that have been processed in the specified date range.
  • Returns & Reimb. Summary (FBA)* – provides an overview of FBA returns and reimbursements for a specific period. 
  • Returns & Reimb. Details (FBA)* – provides detailed information about FBA returns and reimbursements for a specific period.

 

Shipping

If there is one thing customers genuinely enjoy, it is timely shipping. Therefore, shipping reports are crucial in streamlining the shipping process and optimizing delivery times. These reports provide valuable insights into shipping operations, allowing you to improve your shipping strategies and enhance your customers’ experience.

  • Fulfillment Dashboard* – shows the total quantity of fulfilled orders and provides details about fulfillment performance – early, on time, or late.
  • Fill Rate Dashboard – focuses on the order fill rate – the percentage of orders filled versus the percentage canceled. 
  • Shipping Dashboard – focuses on shipping costs, shows total shipping costs, and per carrier method breakdown for a selected date range.
  • Shipping Report* – tracks the shipping costs, methods, and fulfillment of your orders. Filtering by fulfillment performance can help ensure that orders are shipped and delivered promptly and accurately.
  • Tracking Report* – view shipping information, track orders, and ensure they were delivered on time. It provides more detailed package data, whereas the Shipping report provides exact cost and performance data.

 

Inventory

Inventory reports are vital in managing your inventory and ensuring the optimal utilization of resources. These reports provide a comprehensive overview of inventory quantities, values, costs, sales, and historical data to help you stay on top of inventory management. 

 

Products By Component

Products by Component reports provide valuable insights into the performance of products. They are most helpful for tracking sales of products as components of kits, but you will also see the quantity sold as regular products. The reports also include sales of components in independent kits.

 

Transaction

Transaction reports are product-based reports showing transaction details, such as payments and refunds. You can track revenue and expenses, learn about the cost of returns and reimbursements, check the tax per transaction, see vendor invoice details, and more.

  • Transaction Summary* – a monthly report that summarizes revenue and expense transactions.
  • Transaction Details by Date* – provides a detailed overview of all transactions made in the specified date range and shows the financial performance of your business.
  • Transactional COGS For Returns* – provides information about the cost of all returns and reimbursements for a specific period.
  • Vendor Invoice by Date* – provides an overview of vendor invoices, including invoice number, date, and financial information.
  • Tax Collected by Transaction* – shows the tax collected on debits (sales and payments) and the tax refunded on credits (refunds) for order transactions within your chosen filing period or date range.

 

Settlement

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. Settlement reports contain information about a channel’s order-related fees, commissions, and taxes.

Reconciliation reports are intended to match the transactions recorded in an online store’s financial records to those processed by payment gateways and banks to ensure the reliability and accuracy of financial reporting. These reports help ensure that all financial transactions have been recorded accurately and identify and resolve any discrepancies between the online store’s records and the records of the payment gateway and banks.

 

Customers & Receivables

Accounts receivable aging is a method used to track and manage unpaid invoices from customers. It involves organizing unpaid invoices by the time they have been outstanding. These reports help you identify overdue invoices and which customers are most likely to pay or not pay.


Was this article helpful?

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