Payments & Refunds by Date

Updated 5 months ago

This report shows order payment and refund transactions made on a specific date, or range of dates, regardless of whether the order was created on that date or in that date range. From here, you can click each order to open its details.

This differs from the sales Payments & Refunds report that shows the sum of payments and refunds for each order number.   

To access this report in SellerCloud, click Reports > Transaction Reports > Payments & Refunds by Date.

Take a look at a sample grid report:

For answers to general questions about using SellerCloud's Financial Reporting Suite, see the Reports FAQs.

Choose your filters

There are numerous filters to include the data you want in your report. (Most filters offer single-choice and multiple-choice fields. See a typical example of both.)

After clicking Run Report, you can see which filters you applied (if a filter is not shown, you left it blank or chose All). Here's a common report filter.

The table below defines each of these filters:

FILTER

DESCRIPTION

Company

Include only the orders from one or more companies, or include orders from all companies.

Company Groups*

Include only the orders from one group of companies, or include orders from all companies.

*Only shown if you enabled the company group setting and grouped companies together. Here's how.

Channel

Include only the orders from one or more sales channels, or include orders from all channels.

Date Range

  • Custom (default) - Enter the Start and End Dates. For a single date, choose the same Start and End Date.
  • Date ranges (presets) - There are 22 choices from Yesterday to the Last Year to Date.

Start Date and End Date

If you chose a custom date range, choose the starting and ending date. (If you chose a default date range, these auto-populate.)

Transaction Type

Include only payments or refunds, or include all transactions.

Payment Method

Include only payments made by one specific method (e.g., Credit Card), or include all payment methods.

Currency

Include only transactions in one specific currency, or include all transactions.

Order #

Include orders by order number. This field has 3 options:

  • For one order number - Enter the number and click Run Report.
  • For all order numbers in your date range - Leave this field blank and click Run Report.
  • For multiple order numbers - Click Order # List, then enter or copy/paste multiple order numbers on separate lines, then click Select Orders to populate the Order# box, and Run Report.

Reference #

Include an order transaction with a specific payment reference number. ​


About the grid data

Take a look at a sample grid report:

You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon. For spreadsheet details, see About the spreadsheet data.

The table below defines each of the columns:

COLUMN

DESCRIPTION

Transaction Type

Payment or refund.

Transaction Date

When the payment or refund transaction occurred.

Payment Method

Form of payment (e.g., Cash).

Reference #

The order transaction's payment reference number. (This will be the check number if the payment method was by check.)

Amount

Transaction amount (shown in its order's currency).

Currency

The transaction amount's monetary unit.

Order #

The unique order identification number in SellerCloud. Click to open the order's Payment tab.


About the spreadsheet data

Exported spreadsheets include more data than the grid report. Spreadsheets also let you manipulate data, such as filter within a column, sort with advanced parameters, etc.

Take a look at a sample spreadsheet report (click image to enlarge):

The table below defines each of its columns:

COLUMN

DESCRIPTION

Transaction Type

Payment or refund.

Transaction Date

When the payment or refund transaction occurred.

Payment Method

Form of payment (e.g., Cash).

Reference #

The order transaction's payment reference number. (This will be the check number if the payment method was by check.)

Unique Transaction Reference No

The unique internal identifier for the transaction.

Amount

Transaction amount (shown in the order's currency).

Currency

The transaction amount's monetary unit. 

Order Date

Date of the order.

Order #

The unique order identification number in SellerCloud.

Channel Order #

The unique order number from the channel.

Channel Order # (2)

The second unique order number from the channel.

Bill To First Name

Note: This is the same as the "Sold To" customer on the order.

Bill To Last Name

Note: This is the same as the "Sold To" customer on the order.

Bill To Company

Note: This is the same as the "Sold To" company name on the order.


How did we do?