Monthly Payouts

Within the first calendar days of each month, we will aggregate all interest accrued the previous month on each bank account on your platform. Interest accrued for your users will be paid out directly to your customers' bank accounts, and interest spread accrued for your platform will be paid out to your interest revenue account. Payouts for accrued interest spreads will have related_product_id set to the IDs of customers' bank accounts for which interest is accrued. If payout amounts are positive, payout types will be credit. Otherwise, payout types will be debit.

Since interest accruals are truncated at the 6th decimal digit, monthly aggregated interest will use fractional currency units. We will truncate payout amounts to the smallest unit and carry over fractional amounts to next payout period(s). For example, payout amounts in USD will be truncated to cents and fractional cents will be carried over. You will receive interest.payout.completed webhook events when payouts are credited to or debited from your accounts.

If an account is closed before a monthly payout, interest accrued but not paid will be forfeited.

Simulate Interest Payouts

Instead of waiting for monthly payouts to test your integration with our interest system, you can simulate on-demand interest payouts in Sandbox.

curl https://api.column.com/simulate/interests/payouts \
  -XPOST \
  -u :<YOUR API KEY> \
  -d amount="5000" \
  -d currency_code="USD" \
  -d product_id="bacc_xxx"

Example

Let's use the three bank accounts in the Interest Accrual Example and assume we are paying interest out for the month of May 2025 (31 days).

Account AAccount BAccount C
bank account IDbacc_account_abacc_account_bbacc_account_c
available balance$13,692.57$13,692.57$13,692.57
owner interest rate4.00%5.50%0.00%
interest rate spread1.00%-0.50%5.00%
daily owner accruals$1.500555$2.063263$0.000000
daily spread accruals$0.375139-$0.187569$1.875694
total daily accruals$1.875694$1.875694$1.875694

Interest payouts to customers' bank accounts will be as follows:

Account AAccount BAccount C
product_idbacc_account_abacc_account_bbacc_account_c
related_product_idnullnullnull
typecreditcreditcredit
amount$46.51$63.96$0.00
last_accrued_date2025-05-312025-05-312025-05-31
interest accruals carryover$0.007205$0.001153$0.00

Interest payouts to your interest revenue account (ID: bacc_revenue) will be as follows. debit payouts are claw backs from your interest revenue account:

Account AAccount BAccount C
product_idbacc_revenuebacc_revenuebacc_revenue
related_product_idbacc_account_abacc_account_bbacc_account_c
typecreditdebitcredit
amount$11.62$5.81$58.14
last_accrued_date2025-05-312025-05-312025-05-31
interest accruals carryover$0.009309-$0.004639$0.006514