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

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:

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