> For the complete documentation index, see [llms.txt](https://developer.paddle.com/llms.txt).
# Payout reconciliation reports
Generate detailed reports that connect your Paddle payouts to the underlying transaction movements for accurate financial reconciliation.
---
Payout reconciliation reports help you reconcile payouts to transactions and adjustments to understand how your payout amounts are calculated.
A payout is the money Paddle sends you from your sales. If your balance meets the minimum threshold, Paddle creates your payout on the 1st and sends the payment by the 15th. You'll receive funds by the payout method you've set in your settings.
## When to use
- **Reconcile payouts to transactions and adjustments**
Verify your payout totals against your remittance advice by summing balance movements to calculate how the payout is formed and close the books.
- **Audit fees and currency exchange**
Review itemized gross, taxes, Paddle, chargeback, and retained fees in both transaction and balance currencies to confirm calculations and investigate variances.
- **Analyze revenue and product performance**
Break down activity by product, price, country, origin, and billing frequency to see mix shifts, cohort patterns, and subscription dynamics affecting payouts.
- **Simplify tax reporting**
Split activity by invoice entity, using United States state and ZIP where applicable, and include tax rates and tax mode to prove local compliance and support accurate indirect tax reporting.
- **Automate financial workflows**
Generate reports via API to feed into accounting and BI systems so monthly reconciliations, checks, and dashboards run on schedule without manual intervention.
{% collapsible title="Diagram of end-to-end usage flow" %}
```mermaid
flowchart TD
A[Receive payout] --> B[Find remittance reference in the dashboard or on your remittance advice]
B --> C[Generate payout reconciliation report via the dashboard or API]
C --> D[Sum balance_movement_in_balance_currency using balance-currency fields only]
D --> E{Does total equal payout amount
on the remittance advice?}
E -->|Yes| F[✓ Reconciled]
E -->|No| G[Regenerate the report and re-check the total]
G --> H[Account for payout-level deductions:
• Bank/SWIFT fees
• Manual adjustments]
H --> I{Still unexplained?}
I -->|No| F
I -->|Yes| J[Contact support with your
remittance reference]
```
{% /collapsible %}
## Report filters
When generating payout reconciliation reports, you can filter by:
| Field | Description | Use case |
|-------|-------------|------------|
| `remittance_reference` | Filter by a specific payout using its remittance reference. This gives you all transactions that contributed to that particular payout. | Reconciling a specific payout to your bank account. |
| `transaction_updated_date` | Filter by the date range when transactions were last updated. Use this to generate reports covering multiple payouts within a time period. | Monthly reconciliation reports or analyzing trends over time. |
## Report columns
The report itemizes how gross sales are reduced by taxes, fees, and adjustments to arrive at your final payout amount. Each deduction has its own column so you can see what impacts your payout:
{% table %}
- Fields
- Description
---
- - `paddle_fee_in_balance_currency`
- `paddle_fee_in_transaction_currency`
- Processing fees charged by Paddle
---
- - `fx_fee_in_balance_currency`
- Currency conversion costs for international transactions
---
- - `chargeback_fee_in_balance_currency`
- `chargeback_fee_in_transaction_currency`
- Fees for dispute handling
---
- - `retained_fee_in_balance_currency`
- `retained_fee_in_transaction_currency`
- Amounts kept by Paddle during refunds to cover gateway costs
---
- - `tax_in_balance_currency`
- `tax_in_transaction_currency`
- Customer taxes
{% /table %}
Column headings on payout reconciliation reports mirror fields in [the Paddle API](https://developer.paddle.com/api-reference/overview.md). Data is provided in the following columns:
```yaml
title: Payout reconciliation report
type: object
properties:
remittance_reference:
type:
- string
- "null"
description: Remittance reference for the payout. Found in the 'Remittance reference' column on the Payouts page or on the remittance advice document. `null` if the balance movement isn't tied to a payout.
transaction_id:
type: string
pattern: ^txn_[a-z\d]{26}$
description: Paddle ID of the transaction this balance movement is for, prefixed with `txn_`.
title: Transaction ID
examples:
- txn_01h04vsbhqc62t8hmd4z3b578c
adjustment_id:
type:
- string
- "null"
pattern: ^adj_[a-z\d]{26}$
description: Paddle ID of the adjustment applied to the transaction this balance movement is for, prefixed with `adj_`. `null` if balance movement isn't tied to an adjustment.
title: Adjustment ID
examples:
- adj_01gya6twkp8y0tv1e19rsgst9m
customer_id:
type: string
pattern: ^ctm_[a-z\d]{26}$
description: Paddle ID of the customer the transaction belongs to, prefixed with `ctm_`.
title: Customer ID
examples:
- ctm_01grnn4zta5a1mf02jjze7y2ys
subscription_id:
type:
- string
- "null"
pattern: ^sub_[a-z\d]{26}$
description: Paddle ID of the subscription the transaction belongs to, prefixed with `sub_`. `null` if the transaction isn't tied to a subscription.
title: Subscription ID
examples:
- sub_01h04vsc0qhwtsbsxh3422wjs4
payout_created_at:
type:
- string
- "null"
format: date-time
description: RFC 3339 datetime string of when the payout was created. `null` if the balance movement isn't tied to a payout.
title: Timestamp
examples:
- "2024-10-12T07:20:50.52Z"
payout_period_starts_at:
type:
- string
- "null"
format: date-time
description: RFC 3339 datetime string of when the payout's period starts. `null` if the balance movement isn't tied to a payout.
title: Timestamp
examples:
- "2024-10-12T07:20:50.52Z"
payout_period_ends_at:
type:
- string
- "null"
format: date-time
description: RFC 3339 datetime string of when the payout's period ends. `null` if the balance movement isn't tied to a payout.
title: Timestamp
examples:
- "2024-10-12T07:20:50.52Z"
transaction_created_at:
type: string
format: date-time
description: RFC 3339 datetime string of when the transaction was created.
title: Created at
examples:
- "2024-10-12T07:20:50.52Z"
readOnly: true
transaction_updated_at:
type: string
format: date-time
description: RFC 3339 datetime string of when the transaction was updated.
title: Updated at
examples:
- "2024-10-13T07:20:50.52Z"
readOnly: true
transaction_completed_at:
type:
- string
- "null"
format: date-time
description: RFC 3339 datetime string of when the transaction was marked as `completed`. `null` for transactions that aren't `completed`.
title: Timestamp
examples:
- "2024-10-12T07:20:50.52Z"
balance_currency_code:
type: string
description: Three-letter ISO 4217 currency code of your balance currency. If your primary currency has changed, this reflects the primary currency at the time the transaction was billed.
payout_currency_code:
type:
- string
- "null"
enum:
- AUD
- CAD
- CHF
- CNY
- CZK
- DKK
- EUR
- GBP
- HUF
- PLN
- SEK
- USD
- ZAR
description: Three-letter ISO 4217 currency code of your payout currency. `null` if the balance movement isn't tied to a payout.
title: Currency code (payouts)
x-enum-descriptions:
AUD:
description: Australian Dollar
CAD:
description: Canadian Dollar
CHF:
description: Swiss Franc
CNY:
description: Chinese Yuan
CZK:
description: Czech Koruna
DKK:
description: Danish Krone
EUR:
description: Euro
GBP:
description: Pound Sterling
HUF:
description: Hungarian Forint
PLN:
description: Polish Zloty
SEK:
description: Swedish Krona
USD:
description: United States Dollar
ZAR:
description: South African Rand
transaction_currency_code:
type: string
enum:
- USD
- EUR
- GBP
- JPY
- AUD
- CAD
- CHF
- HKD
- SGD
- SEK
- ARS
- BRL
- CLP
- CNY
- COP
- CZK
- DKK
- HUF
- ILS
- INR
- KRW
- MXN
- NOK
- NZD
- PEN
- PLN
- RUB
- THB
- TRY
- TWD
- UAH
- VND
- ZAR
description: Supported three-letter ISO 4217 currency code for the transaction or adjustment related to this balance movement.
title: Currency code
x-enum-descriptions:
USD:
description: United States Dollar
EUR:
description: Euro
GBP:
description: Pound Sterling
JPY:
description: Japanese Yen
AUD:
description: Australian Dollar
CAD:
description: Canadian Dollar
CHF:
description: Swiss Franc
HKD:
description: Hong Kong Dollar
SGD:
description: Singapore Dollar
SEK:
description: Swedish Krona
ARS:
description: Argentine Peso
BRL:
description: Brazilian Real
CLP:
description: Chilean Peso
CNY:
description: Chinese Yuan
COP:
description: Colombian Peso
CZK:
description: Czech Koruna
DKK:
description: Danish Krone
HUF:
description: Hungarian Forint
ILS:
description: Israeli Shekel
INR:
description: Indian Rupee
KRW:
description: South Korean Won
MXN:
description: Mexican Peso
NOK:
description: Norwegian Krone
NZD:
description: New Zealand Dollar
PEN:
description: Peruvian Sol
PLN:
description: Polish Zloty
RUB:
description: Russian Ruble
THB:
description: Thai Baht
TRY:
description: Turkish Lira
TWD:
description: New Taiwan Dollar
UAH:
description: Ukrainian Hryvnia
VND:
description: Vietnamese Dong
ZAR:
description: South African Rand
balance_movement_type:
type: string
description: Type of balance movement associated to the transaction or adjustment.
enum:
- chargeback_reversal
- refund
- credit
- vat_refund
- sale
- chargeback
direction:
type: string
enum:
- in
- out
x-enum-descriptions:
in:
description: Funds added to your account balance, like a purchase. Typically related to transactions, but may relate to adjustments for tax refunds or other adjustments that add to your balance.
out:
description: Funds deducted from your account balance, like a refund. Typically related to adjustments.
description: Whether this balance movement added or deducted funds from your balance.
customer_tax_code:
type:
- string
- "null"
description: Tax code of the customer.
customer_zip_code:
type:
- string
- "null"
description: Zip or postal code of the customer.
customer_country_state:
type:
- string
- "null"
description: Two-letter abbreviation of the state where the transaction took place. Only for customers in the USA.
customer_country_code:
oneOf:
- type: string
enum:
- AD
- AE
- AG
- AI
- AL
- AM
- AO
- AR
- AS
- AT
- AU
- AW
- AX
- AZ
- BA
- BB
- BD
- BE
- BF
- BG
- BH
- BI
- BJ
- BL
- BM
- BN
- BO
- BQ
- BR
- BS
- BT
- BV
- BW
- BZ
- CA
- CC
- CG
- CH
- CI
- CK
- CL
- CM
- CN
- CO
- CR
- CV
- CW
- CX
- CY
- CZ
- DE
- DJ
- DK
- DM
- DO
- DZ
- EC
- EE
- EG
- EH
- ER
- ES
- ET
- FI
- FJ
- FK
- FM
- FO
- FR
- GA
- GB
- GD
- GE
- GF
- GG
- GH
- GI
- GL
- GM
- GN
- GP
- GQ
- GR
- GS
- GT
- GU
- GW
- GY
- HK
- HM
- HN
- HR
- HU
- ID
- IE
- IL
- IM
- IN
- IO
- IQ
- IS
- IT
- JE
- JM
- JO
- JP
- KE
- KG
- KH
- KI
- KM
- KN
- KR
- KW
- KY
- KZ
- LA
- LB
- LC
- LI
- LK
- LR
- LS
- LT
- LU
- LV
- MA
- MC
- MD
- ME
- MF
- MG
- MH
- MK
- MN
- MO
- MP
- MQ
- MR
- MS
- MT
- MU
- MV
- MW
- MX
- MY
- MZ
- NA
- NC
- NE
- NF
- NG
- NL
- "NO"
- NP
- NR
- NU
- NZ
- OM
- PA
- PE
- PF
- PG
- PH
- PK
- PL
- PM
- PN
- PR
- PS
- PT
- PW
- PY
- QA
- RE
- RO
- RS
- RW
- SA
- SB
- SC
- SE
- SG
- SH
- SI
- SJ
- SK
- SL
- SM
- SN
- SR
- ST
- SV
- SX
- SZ
- TC
- TD
- TF
- TG
- TH
- TJ
- TK
- TL
- TM
- TN
- TO
- TR
- TT
- TV
- TW
- TZ
- UA
- UG
- UM
- US
- UY
- UZ
- VA
- VC
- VG
- VI
- VN
- VU
- WF
- WS
- XK
- YT
- ZA
- ZM
description: Two-letter ISO 3166-1 alpha-2 representation of a supported country.
x-enum-descriptions:
AD:
description: Andorra
AE:
description: United Arab Emirates
AG:
description: Antigua and Barbuda
AI:
description: Anguilla
AL:
description: Albania
AM:
description: Armenia
AO:
description: Angola
AR:
description: Argentina
AS:
description: American Samoa
AT:
description: Austria
AU:
description: Australia
AW:
description: Aruba
AX:
description: Åland Islands
AZ:
description: Azerbaijan
BA:
description: Bosnia and Herzegovina
BB:
description: Barbados
BD:
description: Bangladesh
BE:
description: Belgium
BF:
description: Burkina Faso
BG:
description: Bulgaria
BH:
description: Bahrain
BI:
description: Burundi
BJ:
description: Benin
BL:
description: Saint Barthélemy
BM:
description: Bermuda
BN:
description: Brunei
BO:
description: Bolivia
BQ:
description: Caribbean Netherlands (Bonaire, Sint Eustatius, and Saba)
BR:
description: Brazil
BS:
description: Bahamas
BT:
description: Bhutan
BV:
description: Bouvet Island
BW:
description: Botswana
BZ:
description: Belize
CA:
description: Canada
CC:
description: Cocos Islands
CG:
description: Republic of Congo
CH:
description: Switzerland
CI:
description: Côte d'Ivoire (Ivory Coast)
CK:
description: Cook Islands
CL:
description: Chile
CM:
description: Cameroon
CN:
description: China
CO:
description: Colombia
CR:
description: Costa Rica
CV:
description: Cape Verde
CW:
description: Curaçao
CX:
description: Christmas Island
CY:
description: Cyprus
CZ:
description: Czechia (Czech Republic)
DE:
description: Germany
DJ:
description: Djibouti
DK:
description: Denmark
DM:
description: Dominica
DO:
description: Dominican Republic
DZ:
description: Algeria
EC:
description: Ecuador
EE:
description: Estonia
EG:
description: Egypt
EH:
description: Western Sahara
ER:
description: Eritrea
ES:
description: Spain
ET:
description: Ethiopia
FI:
description: Finland
FJ:
description: Fiji
FK:
description: Falkland Islands
FM:
description: Micronesia
FO:
description: Faroe Islands
FR:
description: France
GA:
description: Gabon
GB:
description: United Kingdom
GD:
description: Grenada
GE:
description: Georgia
GF:
description: French Guiana
GG:
description: Guernsey
GH:
description: Ghana
GI:
description: Gibraltar
GL:
description: Greenland
GM:
description: Gambia
GN:
description: Guinea
GP:
description: Guadeloupe
GQ:
description: Equatorial Guinea
GR:
description: Greece
GS:
description: South Georgia and the South Sandwich Islands
GT:
description: Guatemala
GU:
description: Guam
GW:
description: Guinea-Bissau
GY:
description: Guyana
HK:
description: Hong Kong
HM:
description: Heard Island and McDonald Islands
HN:
description: Honduras
HR:
description: Croatia
HU:
description: Hungary
ID:
description: Indonesia
IE:
description: Ireland
IL:
description: Israel
IM:
description: Isle of Man
IN:
description: India
IO:
description: British Indian Ocean Territory
IQ:
description: Iraq
IS:
description: Iceland
IT:
description: Italy
JE:
description: Jersey
JM:
description: Jamaica
JO:
description: Jordan
JP:
description: Japan
KE:
description: Kenya
KG:
description: Kyrgyzstan
KH:
description: Cambodia
KI:
description: Kiribati
KM:
description: Comoros
KN:
description: Saint Kitts and Nevis
KR:
description: South Korea
KW:
description: Kuwait
KY:
description: Cayman Islands
KZ:
description: Kazakhstan
LA:
description: Lao People's Democratic Republic (Laos)
LB:
description: Lebanon
LC:
description: Saint Lucia
LI:
description: Liechtenstein
LK:
description: Sri Lanka
LR:
description: Liberia
LS:
description: Lesotho
LT:
description: Lithuania
LU:
description: Luxembourg
LV:
description: Latvia
MA:
description: Morocco
MC:
description: Monaco
MD:
description: Moldova
ME:
description: Montenegro
MF:
description: Saint Martin
MG:
description: Madagascar
MH:
description: Marshall Islands
MK:
description: Macedonia
MN:
description: Mongolia
MO:
description: Macao
MP:
description: Northern Mariana Islands
MQ:
description: Martinique
MR:
description: Mauritania
MS:
description: Montserrat
MT:
description: Malta
MU:
description: Mauritius
MV:
description: Maldives
MW:
description: Malawi
MX:
description: Mexico
MY:
description: Malaysia
MZ:
description: Mozambique
NA:
description: Namibia
NC:
description: New Caledonia
NE:
description: Niger
NF:
description: Norfolk Island
NG:
description: Nigeria
NL:
description: Netherlands
"NO":
description: Norway
NP:
description: Nepal
NR:
description: Nauru
NU:
description: Niue
NZ:
description: New Zealand
OM:
description: Oman
PA:
description: Panama
PE:
description: Peru
PF:
description: French Polynesia
PG:
description: Papua New Guinea
PH:
description: Philippines
PK:
description: Pakistan
PL:
description: Poland
PM:
description: Saint Pierre and Miquelon
PN:
description: Pitcairn
PR:
description: Puerto Rico
PS:
description: Palestinian territories
PT:
description: Portugal
PW:
description: Palau
PY:
description: Paraguay
QA:
description: Qatar
RE:
description: Reunion
RO:
description: Romania
RS:
description: Republic of Serbia
RW:
description: Rwanda
SA:
description: Saudi Arabia
SB:
description: Solomon Islands
SC:
description: Seychelles
SE:
description: Sweden
SG:
description: Singapore
SH:
description: Saint Helena
SI:
description: Slovenia
SJ:
description: Svalbard and Jan Mayen
SK:
description: Slovakia
SL:
description: Sierra Leone
SM:
description: San Marino
SN:
description: Senegal
SR:
description: Suriname
ST:
description: São Tomé and Príncipe
SV:
description: El Salvador
SX:
description: Sint Maarten
SZ:
description: Swaziland
TC:
description: Turks and Caicos Islands
TD:
description: Chad
TF:
description: French Southern and Antarctic Lands
TG:
description: Togo
TH:
description: Thailand
TJ:
description: Tajikistan
TK:
description: Tokelau
TL:
description: Timor-Leste
TM:
description: Turkmenistan
TN:
description: Tunisia
TO:
description: Tonga
TR:
description: Turkey
TT:
description: Trinidad and Tobago
TV:
description: Tuvalu
TW:
description: Taiwan
TZ:
description: Tanzania
UA:
description: Ukraine
UG:
description: Uganda
UM:
description: United States Minor Outlying Islands
US:
description: United States
UY:
description: Uruguay
UZ:
description: Uzbekistan
VA:
description: Holy See (Vatican City)
VC:
description: Saint Vincent and the Grenadines
VG:
description: British Virgin Islands
VI:
description: U.S. Virgin Islands
VN:
description: Vietnam
VU:
description: Vanuatu
WF:
description: Wallis and Futuna
WS:
description: Samoa
XK:
description: Kosovo
YT:
description: Mayotte
ZA:
description: South Africa
ZM:
description: Zambia
description: Supported two-letter ISO 3166-1 alpha-2 country code of the address that the transaction belongs to.
price_tax_mode:
type: string
enum:
- account_setting
- external
- internal
- location
description: Whether the tax mode for the price on the transaction is set as `internal` or `external`.
title: Tax mode
x-enum-descriptions:
account_setting:
description: Prices use the setting from your account.
external:
description: Prices are exclusive of tax.
internal:
description: Prices are inclusive of tax.
location:
description: Prices are inclusive or exclusive of tax, depending on the country of the transaction.
tax_rate_list:
type: string
description: Comma-separated list of tax rates charged for items on the transaction.
origin:
oneOf:
- type: string
enum:
- api
- subscription_charge
- subscription_payment_method_change
- subscription_recurring
- subscription_update
- web
x-enum-descriptions:
api:
description: Transaction created via the Paddle API.
subscription_charge:
description: Transaction created automatically by Paddle as a result of a one-time charge for a subscription.
subscription_payment_method_change:
description: Transaction created automatically as part of updating a payment method. May be a zero value transaction.
subscription_recurring:
description: Transaction created automatically by Paddle as a result of a subscription renewal.
subscription_update:
description: Transaction created automatically by Paddle as a result of an update to a subscription.
web:
description: Transaction created automatically by Paddle.js for a checkout.
description: How the transaction for this balance movement was created.
payment_method:
type:
- string
- "null"
enum:
- alipay
- apple_pay
- bancontact
- blik
- card
- google_pay
- ideal
- kakao_pay
- korea_local
- south_korea_local_card
- mb_way
- naver_pay
- offline
- payco
- paypal
- pix
- samsung_pay
- unknown
- upi
- wechat_pay
- wire_transfer
description: Type of payment method used on the last payment attempt for the transaction.
title: PaymentMethodType
x-enum-descriptions:
alipay:
description: Alipay, popular in China.
apple_pay:
description: Apple Pay on a supported Apple device.
bancontact:
description: Bancontact, popular in Belgium.
blik:
description: BLIK, a popular payment method in Poland.
card:
description: Credit or debit card.
google_pay:
description: Google Pay on a supported Android device, Chromebook, or Google Chrome browser.
ideal:
description: iDEAL, popular in the Netherlands.
kakao_pay:
description: Kakao Pay, a popular payment method in Korea.
korea_local:
description: Korean payment methods, which includes over 20 payment options for the Korean market. Check `underlying_payment_method.korea_local` for information about the Korean payment method used to pay.
deprecated: true
south_korea_local_card:
description: Korean local credit or debit card.
mb_way:
description: MB WAY, a popular payment method in Portugal.
naver_pay:
description: Naver Pay, a popular payment method in Korea.
paypal:
description: PayPal.
offline:
description: Payment recorded offline.
payco:
description: Payco, a popular payment method in Korea.
pix:
description: Pix, popular in Brazil. Available in early access.
samsung_pay:
description: Samsung Pay, a popular payment method in Korea.
unknown:
description: Payment method not known.
upi:
description: Unified Payments Interface (UPI), popular in India. Available in early access.
wechat_pay:
description: WeChat Pay, a popular payment method in China.
wire_transfer:
description: Wire transfer, sometimes called bank transfer.
product_id_list:
type: string
description: Comma-separated list of product IDs on the transaction for this balance movement.
product_name_list:
type: string
description: Comma-separated list of product names on the transaction for this balance movement.
price_id_list:
type: string
description: Comma-separated list of price IDs on the transaction for this balance movement.
product_price_description_list:
type: string
description: Comma-separated list of price descriptions on the transaction for this balance movement.
billing_cycle_frequency:
description: Amount of time for how often the subscription is charged. `null` if the transaction isn't tied to a subscription.
type:
- integer
- "null"
billing_cycle_interval:
description: Unit of time for how often the subscription is charged. `null` if the transaction isn't tied to a subscription.
type:
- string
- "null"
enum:
- day
- week
- month
- year
transaction_to_balance_currency_base_exchange_rate:
type:
- string
- "null"
examples:
- "1.0513135"
description: Base exchange rate used to calculate the exchange rate for the transaction for this balance movement. Combined with `exchange_margin_rate` to give `transaction_to_balance_currency_exchange_rate`. `null` if the currency wasn't converted.
exchange_margin_rate:
type:
- string
- "null"
description: Margin rate for the currency conversion. `null` if the currency wasn't converted.
transaction_to_balance_currency_exchange_rate:
type:
- string
- "null"
examples:
- "1.0513135"
description: Exchange rate used to convert between the transaction currency and your balance currency. `null` if the currency wasn't converted.
invoice_entity:
type: string
enum:
- US
- RoW
x-enum-descriptions:
US:
description: The transaction is attributed to the United States (US).
RoW:
description: The transaction is attributed to the Rest of World (RoW).
description: Whether the transaction is attributed to the United States (US) or the Rest of World (RoW).
total_gross_in_transaction_currency:
type: string
description: Total for the transaction before any fees in the original transaction currency.
total_gross_in_balance_currency:
type: string
description: Total for the transaction before any fees in the balance currency.
tax_in_transaction_currency:
type: string
description: Total tax on the subtotal for the transaction in the transaction currency.
tax_in_balance_currency:
type: string
description: Total tax on the subtotal for the transaction in the balance currency.
paddle_fee_in_transaction_currency:
type:
- string
- "null"
description: Total fee taken by Paddle for the transaction in the transaction currency. `null` until the transaction is `completed` and the fee is processed.
paddle_fee_in_balance_currency:
type:
- string
- "null"
description: Total fee taken by Paddle for the transaction in the balance currency. `null` until the transaction is `completed` and the fee is processed.
fx_fee_in_balance_currency:
type: string
description: Total FX fee charged for the transaction, in the balance currency.
fx_fee_precision_adjustment_in_balance_currency:
type: string
description: Corrective adjustment for the `fx_fee_in_balance_currency` to reconcile discrepancies between the reported fee and the exact amount charged due to precision and rounding calculations.
chargeback_fee_in_transaction_currency:
type:
- string
- "null"
description: Chargeback fee incurred for the adjustment in the transaction currency. Present where the associated adjustment has an `action` of `chargeback` or `chargeback_warning`.
chargeback_fee_in_balance_currency:
type:
- string
- "null"
description: Chargeback fee incurred for the adjustment in the balance currency. Present where the associated adjustment has an `action` of `chargeback` or `chargeback_warning`.
retained_fee_in_transaction_currency:
type: string
description: Fee retained by Paddle during refunds and chargebacks to cover gateway costs, recorded in the transaction currency.
retained_fee_in_balance_currency:
type: string
description: Fee retained by Paddle during refunds and chargebacks to cover gateway costs, recorded in the balance currency.
balance_movement_in_transaction_currency:
type: string
description: Total for this balance movement after all fees (excluding FX fees) and charges, recorded in the transaction currency.
balance_movement_in_balance_currency:
type: string
description: Total for this balance movement after all fees and charges, recorded in the balance currency. Should equal the associated payout amount unless rebates or a SWIFT fee have been applied.
```
## How to reconcile
To reconcile your payout, sum the `balance_movement_in_balance_currency` column. The total should equal the amount shown on your remittance advice document for the payout. Each row's `balance_movement_in_balance_currency` represents the net amount contributed to your payout after all deductions.
Each row's balance movement is calculated using the `_in_balance_currency` fields:
| Field | Description |
|-------|-------------|
| `total_gross_in_balance_currency` | The gross amount of the transaction in the balance currency. |
| `tax_in_balance_currency` | The tax amount of the transaction in the balance currency. |
| `paddle_fee_in_balance_currency` | The Paddle fee amount of the transaction in the balance currency. |
| `retained_fee_in_balance_currency` | The retained fee amount of the transaction in the balance currency. |
| `fx_fee_in_balance_currency` | The FX fee amount of the transaction in the balance currency. |
| `fx_fee_precision_adjustment_in_balance_currency` | The FX fee precision adjustment amount of the transaction in the balance currency. |
| `chargeback_fee_in_balance_currency` | The chargeback fee amount of the transaction in the balance currency. |
The formula shows how gross sales are reduced by fees and taxes to calculate the net amount for each transaction:
```text {% title="Balance movement calculation formula" %}
total_gross_in_balance_currency
- tax_in_balance_currency
- paddle_fee_in_balance_currency
- retained_fee_in_balance_currency
- fx_fee_in_balance_currency
- fx_fee_precision_adjustment_in_balance_currency
- chargeback_fee_in_balance_currency
= balance_movement_in_balance_currency
```
{% callout type="warning" %}
Always use the balance currency fields (ending in `_in_balance_currency`) for reconciliation. While transaction currency fields are useful for analyzing individual transactions, they won't roll up to your payout total because of currency conversion, fees, and rounding adjustments.
{% /callout %}
### Discrepancies in totals
Sometimes your report total won't exactly match the bank payout amount. This is usually due to payout-level deductions that aren't tied to specific transactions:
- **Bank and transfer fees**
Consistent charges applied by your bank, like SWIFT fees for international transfers (typically $/€/£15) and other banking charges, are deducted at payout time and won't appear as line items in the report.
- **Manual adjustments**
Occurs when Paddle corrects invoicing issues. These one-off rebates are deducted directly from payouts rather than being tied to specific transactions.
{% callout type="info" %}
If you see an unexpected discrepancy, regenerate the report first in case recent adjustments weren't included, then [contact support](mailto:support@paddle.com) with your remittance reference.
{% /callout %}