Filter payout reconciliation reports by balance movement

What's new?

You can now filter the payout reconciliation report by balance_movement_date and balance_movement_type when you generate it using the API.

This builds on our previous update, which added these as columns in the report. They're now also filters, so you can scope an export to a payout period or to specific movement categories without filtering the full report by hand.

How it works

Reports in Paddle let you export information from your account to import into accounting software, ERPs, and other business intelligence tools. Each filter you pass has a name and a value, and date filters have an optional operator.

Today we added two new filters to the payout reconciliation report:

• balance_movement_date filters by the date a balance movement actually occurred, rather than when a transaction was last updated. Use it to align an export to a payout period or remittance-advice window. It's a date filter, so it supports the lt and gte operators for date ranges.
• balance_movement_type filters to specific movement categories. For example, only chargeback or swift_fee rows.

remittance_reference, transaction_updated_at, and balance_movement_date are mutually exclusive. This means that for each report, you can only apply one of these filters. balance_movement_type is optional and combines with whichever primary filter you choose.

Next steps

This change is available now in version 1 of the Paddle API and in the dashboard. It's a non-breaking change.

If you omit filters, reports still default to the last 30 days by transaction_updated_at, so existing integrations aren't impacted.

Check out the payout reconciliation report reference for the full list of filters and movement types, and the create a report endpoint for the request format.