Cashflow (Monetary Flow)
The int_finance__cashflow table represents monetary movements between Pass Culture's bank account and an offerer's bank account.
Business Context
Cashflows are generated by the generate_cashflows_and_payment_files cron that runs at 5:00 UTC on the 1st and 16th of each month. They group valorisations by bank account to determine the total reimbursement amount for each wire transfer.
Cashflow Status Lifecycle
| Status | Description |
|--------|-------------|
| PENDING | After cashflow creation |
| UNDER_REVIEW | After payment files generation |
| ACCEPTED | After reimbursement receipt generation |
Prerequisites for Reimbursement
For a venue's bookings to be reimbursed, it must: 1. Have a pricing point (for valorisation) 2. Be linked to a validated bank account (for cashflow generation)
A structure can have multiple bank accounts. A bank account can be referenced by multiple venues.
Table description
| name | data_type | description |
|---|---|---|
| id | Unique identifier for a cashflow (monetary flow). | |
| creationDate | Date when the cashflow was created. | |
| status | Status of the cashflow: PENDING (created), UNDER_REVIEW (files generated), or ACCEPTED (invoice generated). | |
| batchId | Identifier of the cashflow batch. | |
| amount | Total amount of the cashflow in euro cents. |