Reconciliation is the process for ensuring the accuracy and completeness of your business’s financial transactions.
Stronghold provides a Settlement Detail Report and Activity Detail Report that allow you to reconcile transactions at a granular level. These reports provide line-item level detail for the Settlement Report.
Settlement and Activity Detail Reports
The reports exhibit the same events, but permit filtering based on different date ranges.
Use the Settlement Detail Report to filter and view settlement details based on a specific Settlement Date
Use the Activity Detail Report to filter and view activity details based on a specific Activity Date
The Settlement Detail Report and Activity Detail Report both contain the following fields:
A. Activity Date: the date an activity occurs. For example when a charge settles.
B. Intended Merchant Settlement Date: the expected date funds will reach the merchant’s bank account. Please note: this date is a projection and may be subject to slight variations.
C. ID Internal: Stronghold internal ID for an event
D. ID External: the External ID for an event, if applicable. For example: the order ID that corresponds with the POS or E-commerce software provider integrated into Stronghold.
E. Associated With Internal: used to indicate an event that is internally linked to another event. For example: the original charge for a tip or reversal.
F. Associated With External: External ID for an event that is associated with this event. For example: the original charge for a tip or reversal.
G. Type describes the categories for these events (Column G)
Charge Settlement: these charges settled successfully
Tip Settlement: total tips settled successfully
Charge Collection Settlement: charges previously in “Attempting Collection” that have successfully settled
Tip Collection Settlement: tips previously in “Attempting Collection” that have successfully settled
Charge Reversal: refunds processed back to the customer and returns
Tip Reversal: tips associated with a refunded or returned charge
Adjustment: miscellaneous adjustments
Merchant Financing Disbursement: disbursement of funds for Merchant Financing
Merchant Financing Repayment: repayment of funds for Merchant Financing
Promotional Credit Deduction: merchant contribution to promotional credits
Promotional Credit Stronghold Contribution: Stronghold contribution to promotional credits
PlatformFee: Software subscription fees
H. Gross Amount: the gross amount before any Stronghold fees are taken into account (Total Amount - Convenience Fee = Gross Amount)
I. Net Amount: the amount after Stronghold fees are taken into account (Gross amount - Fee = Net Amount)
J. Fee: the fees Stronghold has taken out from the Gross (Gross Amount - Net Amount = Fee)
K. Convenience Fee: convenience fee charged by the merchant to the customer (end consumer)
L. Related Customer ID: ID of the customer
M. Related Customer First Name: first name of the customer
N. Related Customer Last Name: last name of the customer
O. Settlement ID: ID of the settlement batch
Downloading Settlement Report and Activity Detail Report