Overview
The ProfitStars Settlement report template provides settlement batch details and breaks down transactions deposited into a checking account. This report helps you reconcile deposits from ProfitStars with corresponding ACH and Mobile Check payments, ensuring accurate financial tracking and reconciliation.
Who uses this feature
Administrators and office employees
Applies to all business types
Feature configuration
Account configuration is required to use this feature. Please contact Technical Support for details.
Creating custom reports is available only to contractors on the Works package or Legacy/Non-Packaged contractors. Contractors on the Starter and Essentials packages have access to built-in reports.
Things to know
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:
If you’re unsure which columns you want to include in your report, use the Reporting Dictionary to search for appropriate data fields.
You can use this template to create as many custom reports as you need. Each report created from the template is independent and can be run or scheduled without needing to recreate it from the original template.
Report examples
Create a Daily ACH Settlement Reconciliation report that shows only ACH transactions for the previous date. This helps you quickly verify the total ACH payments processed and deposited for a given day against your internal records, helping to identify any discrepancies early.
Create a Batch Status Monitoring report to help you monitor the current processing status of your batches. This allows you to proactively identify any batches that are still pending or have encountered issues, allowing you to follow up on outstanding deposits and troubleshoot potential problems.
Create a ProfitStars Settlement report
Follow the steps to create a custom report based on the ProfitStars Settlement template and select the columns to include in your report.
The template has the following columns selected by default:
Effective Date: The date and time the transactions were batched into a settlement batch
Status: The current status of the batch
Batch Number: The batch number
Description: Describes the type of batch. ACH transactions show as Settlement, and mobile check deposits show as Remote Deposit
Item Count: The number of transactions in the batch
Debits: The amount of debits in the batch
Credits: The total amount of credits in the batch
You can customize the report by adding the following column:
Merchant ID: The ProfitStars merchant ID associated with this settlement batch
Tip: Hover over the name of the column to see a short description. If you’re unsure what each column means, search for it in the Reporting Dictionary.
Run the ProfitStars Settlement report
Click the From - To field to set date filters. 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.
Click the Batch Number field to filter for a specific batch number. Enter the batch number in the text box.
When you’re finished, click Run Report.
Tip: Click Edit Columns to add and remove columns. You can arrange report columns and apply filters for further customization.
Want to learn more?