What is a Transaction report?
A Transaction report is a generated file that lists all settled and unsettled transactions for a selected date range. It can cover one store or all stores in your account, and there is no maximum date range.
Use it when you need reconciliation data for a longer period than a Batch report allows (32 days), or when you need data for several stores in one file.
The report is exported as a CSV or PDF file and includes data such as payment references, capture dates, refunds, payment methods and associated fees.
Common uses include:
Accounting reconciliation
Match transactions and fees against your internal records or bookkeeping system.
Refund verification
Confirm that refunds have been processed and are reflected correctly in your records.
Cash flow monitoring
Identify captured orders that have not yet been settled to stay on top of expected payouts.
Dispute resolution
Look up specific transactions by payment reference to provide supporting details for chargebacks or customer queries.
How to generate a Transaction report
A Transaction report can be generated in the Kustom Portal under the Settlements tab.
Open the Kustom Portal and sign in.
Go to Settlements in the left menu and click Transaction reports.
Click Generate in the top right corner.
Under Stores, choose All stores or a specific store.
Under Format, choose CSV or PDF.
Under Currency, choose All or a specific currency.
Pick a Date range. There is no maximum date range.
Click Generate.
Once the report is ready, you can download it by clicking the download icon to the right of the report row.
Note:
There is no maximum date range when generating a transaction report, but there is a maximum number of lines the report can contain. A transaction report cannot contain more than 3 million lines.
If the report contains a large number of transactions, it may take up to 1 hour to generate.
By default the report uses a standard layout. To choose which columns it includes, enable Use for transaction report in the Report configurator for the stores you report on. Each store has its own configuration, so reports for different stores can look different until you apply the same configuration to all of them.
What is included in a Transaction report
All settled and unsettled captured orders, refunds and their fees for the selected date range. All timestamps are in UTC.
The MID of the store each transaction belongs to. When you generate the report for All stores, use this column to filter or group transactions per store.
Payment reference.
Additional details like payment method, capture date, order creation date and sales country.
If Use for transaction report is enabled, the columns you selected in the Report configurator, such as VAT on Kustom fees and consumer VAT.
When to use the Transaction report
Below are some examples of how you can use the Transaction report:
Reconcile financial records
Match captured orders, fees and settlement dates with your accounting records.
Reconcile a long period or several stores at once
Generate one report for All stores that covers the full period, instead of several Batch reports of 32 days each.
Track outstanding transactions
Identify recent captured orders that have not yet been settled to monitor your cash flow.