Overview
This report provides a list of all the the ProfitStars Settlements. The ProfitStars Settlement report will show your deposits from ProfitStars for ACH transactions and Mobile Check Deposits Transactions. The report can show settlement batches up until the previous day.
Who uses this feature
Administrators and managers
Common uses for this report
Use this report to reconcile deposits from ProfitStars with the corresponding ACH and Mobile Check payments.
How to find this report
To find the ProfitStars Settlement report, complete the following:
Go to the navigation bar and click Reports.
In the search field, enter ProfitStars Settlement to locate the report.
Tip: In the search field, enter a few letters from the report title for quick access.
Report filters
Date Range
Use the date picker to select a date range for the report. You can:
Use the calendar to select a specific date range and then click Apply.
Use the left menu to select a preset date range:
Today: From 12:00 AM to the current time.
Yesterday: Previous day, from 12:00 AM to 11:59 PM.
This Week: From Monday through Sunday of the current week.
Week to Date: From Monday through the current date of the current week.
Last 7 Days: Previous seven days, including today.
Last 14 Days: Previous 14 days, including today.
Last 30 Days: Previous 30 days, including today.
Month to Date: From the first of the current month to the current day.
Last Month: Entire month before the current month. For example, if the date is February 5, the entire month of January.
Last 90 Days: Previous 90 days, including today.
This Quarter: Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.
Last Quarter: Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.
Quarter to Date: From the first day of the current quarter to the current day.
Year to Date: From January 1 of the current year to the current day.
Last 365 Days: Previous 365 days, including today.
Last Year: From January 1 of the previous year to December 31.
Note: This report calls on ProfitStars Reporting API to get the data. There will be an error if the date range is too long. If you see the following error, reduce the date range to only a few days and re-run the report:
Datasource[ProfitStarsMrdc] error: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8)
Batch Number
Filter by batch number. This report can be run by a single batch number.
When you're finished setting filters, click Run Report.
Download the report
You can export your report results to use in spreadsheets and other documents:
Above the report results, click Export. The Export Report pop-up opens.
Under Exporting Format, select the format of your export:
Export to PDF: For printing or use in other documents
Export to XLSX: For use in a spreadsheet application
Select Export only aggregated data to download just the aggregated report data.
Click Export.
The exported report downloads to your computer.
Explanation of report columns
The report includes the following columns:
Effective Date |
Batch date.
|
|---|---|
Status | Batch status.
|
Batch Number | A unique batch number.
|
Description | Describes the type of batch. ACH transactions will show as Settlement and Mobile Check Deposits will show as Remote Deposit. |
Debits | Amount of Debits in this batch.
|
|---|---|
Credits | Amount of Credits in this batch.
|
You can edit the TSYS Settlement report to show additional report fields. The table below contains the report fields you can include in your report.
Merchant ID | The ProfitStars merchant ID associated with this settlement batch.
|
|---|
Explanation of report totals:
You can view total amounts for Net Deposit, Amount of Debts, and Amount of Credits, by scrolling to the bottom of the report.
Total Number of Batch Numbers | Number of batches in the ProfitStars Settlement Report.
|
|---|