Accounting Report
Report that shows accounting and payout reconciliation information.
Description
The Accounting Report provides a reconciliation-focused view of revenue-affecting transactions, payout statuses, and deposit activity. It combines high-level financial metrics with transaction-level and payout-level detail to support daily and monthly reconciliation, exception handling, and audit review.
You can only view data associated with locations and accounts you are permitted to access. If you do not have access to all locations related to a transaction, report information is limited accordingly. Payment Administrators only see data related to accounts they own.
For details about required privileges to view the report, see Predefined Payment Groups and Privileges.
Report Navigation
- Navigate to Payment Cloud Service and click Accounting in the navigation menu.
- Click Actions > Help to open a pop-up window with documentation that explains how to interpret, filter, customize, and download the report.
- The Accounting Report Summary Metrics Banner appears at the top of the page.
- Below the metrics banner, select one of the following tabs:
- Transaction Summary
- Deposits
- Choose one of the available modes:
- Daily View to reconcile activity for a business day
- Monthly View to review accounting activity for a business month and drill down into individual business days
- Use Actions to filter the report, customize columns, and download the report data.
Accounting Report Summary Metrics Banner
The metrics banner provides a high-level financial summary for the selected reporting period.
| Metric | Description |
|---|---|
| Total Sales Amount | Total sales amount in the selected period. Includes sales only. |
| Total Refund Amount | Total refunded amount in the selected period. Includes successful refunds only. |
| Net Sales | Total sales amount minus total refund amount. |
| Total Chargeback Amount | Total amount of disputed transactions initiated through the card issuer. |
| Total Chargeback Reversals | Total amount of resolved chargebacks where funds are returned to the merchant. |
| Total Processing Fees | Sum of fixed and variable processing fees in the selected period. |
| Net Proceeds | Expected net proceeds for the selected period after refunds, fees, and chargeback-related activity are applied. |
| Total Paid Out | Actual amount settled to the merchant’s bank account. |
| Total Variance | Difference between Total Paid Out and Net Proceeds. |
Transaction Summary Tab
The Transaction Summary tab shows transaction-level accounting data for the selected business day or month.
This tab uses the Transaction Summary Report as its base. For definitions of shared fields such as payment reference, POS and tender references, transaction amount, currencies, payout reference, payout date, exchange rate, payment method, location details, card details, and account details, see Transaction Summary Report. The current Transaction Summary page already defines those shared fields in detail.
In addition to the shared Transaction Summary fields, the Accounting Report includes the following accounting-specific or reconciliation-specific columns:
| Column | Description |
|---|---|
| Payout Status | Status of the transaction for payout reconciliation. Values include Paid Out, Not Paid Out, and Partially Paid Out. |
| Aging | Number of days since the transaction was fulfilled when the transaction remains unpaid or partially paid out. |
Some operational columns are available in the report but are not displayed by default. Use Actions to add optional columns as needed.
Deposits Tab
The Deposits tab provides the Net Deposit Breakdown for the selected business day or month. Use it to reconcile payout records to the business day activity that contributed to each deposit. Select the expand caret on a payout row to view the transaction-to-payout mapping for that deposit.
| Column | Description |
|---|---|
| Payout Date | Date when the payout was made. This is the deposit date. |
| Payout Amount from Business Day Transactions | Portion of the total payout amount attributable to transactions from the selected business day. |
| Payout Reference | Unique reference for the payout. |
| Total Payout Amount | Total amount paid out in the payout. |
Predefined Views
Use predefined views to quickly analyze accounting data for common operational timeframes. Available views include:
- Last 30 Days
- Yesterday
- Last 7 Days
- Last Month
- Custom date or business day range
Note: Access to specific data and functions depends on your assigned role and permission group. All report actions, filters, and exports are logged for audit and support purposes.
Related topics: Transaction Summary Report, Reconciling OPERA PMS Transactions with Oracle Payment Cloud Service