Payout breakdown reports - Transactions
- Payout breakdown - Transactions associated with a single Payout
- Payout breakdown - Transactions associated with multiple Payouts
Payout breakdown - Transactions associated with a single Payout
From the Payouts page in the dashboard, you can click on any of the Payout records to drill down into the individual transactions (i.e. credits and debits) that contributed to the lump sum payout amount.
You can export Payout transactions data from the dashboard by navigating to the Payments Payouts page, opening the desired Payout, and selecting Payout breakdown Export Transactions in the top right corner.
| COLUMN | DATA | DESCRIPTION |
|---|---|---|
|
A |
customers.id |
Customer ID |
|
B |
customers.given_name |
Customer first name |
|
C |
customers.family_name |
Customer surname |
|
D |
customers.company_name |
Customer company name (if applicable) |
|
E |
customers.email |
Customer email address |
|
F |
resources.type |
The type of resource, for example payment or refund |
|
G |
resources.description |
Description attached to the resource |
|
H |
resources.created_at |
Date the resource was created |
|
I |
resources.charge_date |
Date the payment was collected from the customer (if applicable) |
|
J |
resources.status |
Current status of the resource |
|
K |
resources.reference |
Reference attached to the resource (if applicable) |
|
L |
gross_amount |
Resource gross amount (for example this could be the amount of a payment collected) |
|
M |
gocardless_fees |
Fees deducted from the resource |
|
N |
app_fees |
App fees deducted from the resource (if applicable) |
|
O |
net_amount |
The net amount of the resource |
|
P |
currency |
Currency |
|
Q |
payouts.id |
Payout ID |
|
R |
payouts.arrival_date |
Date the payout arrived in the payout bank account |
|
S |
creditors.id |
Creditor ID |
|
T |
payments.id |
Individual Payment ID |
|
U |
refunds.id |
Refund ID (if applicable) |
|
V |
mandates.id |
Mandate ID |
|
W |
subscriptions.id |
Subscription linked to the resource (if applicable) |
|
X |
surcharge_fees |
Surcharge fees collected (if applicable) |
|
Y |
tax_amount |
Tax amount collected from the resource |
|
Z |
payouts.reference |
Payout reference |
|
AA |
resources.fx_amount |
Payout amount if payout contains payments collected with International Payments with FX |
|
AB |
resources.fx_rate |
Rate at which the resource was converted to the home currency (if applicable) |
|
AC |
payouts.fx_currency |
Home currency |
|
AD onwards |
customers.metadata.county (example) |
Metadata (if applicable) |
The Payout - Transactions export contains data from the following APIs:
Customers
Payments
Refunds
Payouts
Payout Items
Payout breakdown - Transactions associated with multiple Payouts
In addition to exporting the Transactions associated with a single Payout, you can also export the Transactions associated with multiple Payouts using the Payout Reconciliation option on the Payments Payouts page.
| COLUMN | DATA | DESCRIPTION |
|---|---|---|
|
A |
customers.id |
Customer ID |
|
B |
customers.given_name |
Customer first name |
|
C |
customers.family_name |
Customer surname |
|
D |
customers.company_name |
Customer company name (if applicable) |
|
E |
customers.email |
Customer email address |
|
F |
resources.type |
The type of resource, for example payment or refund |
|
G |
resources.description |
Description attached to the resource |
|
H |
resources.created_at |
Date the resource was created |
|
I |
resources.charge_date |
Date the payment was collected from the customer (if applicable) |
|
J |
resources.status |
Current status of the resource |
|
K |
resources.reference |
Reference attached to the resource (if applicable) |
|
L |
gross_amount |
Resource gross amount (for example this could be the amount of a payment collected) |
|
M |
gocardless_fees |
Fees deducted from the resource |
|
N |
app_fees |
App fees deducted from the resource (if applicable) |
|
O |
net_amount |
The net amount of the resource |
|
P |
currency |
Currency |
|
Q |
payouts.id |
Payout ID |
|
R |
payouts.arrival_date |
Date the payout arrived in the payout bank account |
|
S |
creditors.id |
Creditor ID |
|
T |
payments.id |
Individual Payment ID |
|
U |
refunds.id |
Refund ID |
|
V |
mandates.id |
Mandate ID |
|
W |
subscriptions.id |
Subscription linked to the resource (if applicable) |
|
X |
surcharge_fees |
Surcharge fees collected (if applicable) |
|
Y |
tax_amount |
Tax amount collected from the resource |
|
Z |
payouts.reference |
Payout reference |
|
AA |
resources.fx_amount |
Payout amount if payout contains payments collected with International Payments with FX |
|
AB |
resources.fx_rate |
Rate at which the resource was converted to the home currency (if applicable) |
|
AC |
payouts.fx_currency |
Home currency |
|
AD onwards |
customers.metadata.BCCUSTOMERID |
Metadata (if applicable) |
The Payout Reconciliation - Transactions export contains data from the following APIs:
Customers
Payments
Refunds
Payouts
Payout Items