Skip to content

Reconciliation Report

The reconciliation detail report shows payouts (deposit) from Stripe. For each payout, a campaign summary and order detail is available by clicking on the View button next to the selected payout. This is a live report coming directly from Stripe and is limited to 100 payouts. Change the date range to return fewer results.

This report is primarily used to reconcile accounts.

Filtering

The report is filterable by the following fields:

  • Payout start date
  • Payout end date
  • Fund

Info

The date filter is applied to the date of the deposit.

List View

The report shows one row for each deposit with the following columns:

Column Description
Date Date of the deposit
Payout ID Stripe reference ID for the payout
Destination Account Bank name and the last four of the destination account
Amount Amount of the deposit (negative for withdrawals)

This report is not exportable. Click the View button for and deposit to view the transactions composing the deposit.

Summary View

The summary view shows the summary of transaction by campaign. A sample is included below:

Reconciliation Report Sample

When a non-FutureFund transaction is included in the payout, the amount will be represented in the Adjustments column. FutureFund will not be able to provide additional information on the amount. The report has the following columns:

Column Description
Campaign The name of the campaign in the default language.
Gross The sum of the purchased items of an order. This value does not include payment information (e.g., refunds, installments, failed payments, etc) nor is it affected by canceled order items.
Refund The sum of the refunded transactions. This is always a negative number.
Fee The sum of the fees for a set of transactions. This could be a negative or positive number. Transaction fees are calculated for each campaign with an accuracy ± $0.01. The transaction fee of $0.30 is distributed evenly based on the dollar amount of the items. When a refund occurs, the transaction fee is refunded when the entire amount is refunded. This can result in irregularities in how the fee is distributed to the campaign.
Net Gross - Refunded Amount - Fees

To view the orders for each campaign,

Exported Fields

The following columns are exported when the Export CSV (Summary) button.

Column Description
Campaign The name of the campaign in the default language.
Gross The sum of the purchased items of an order. This value does not include payment information (e.g., refunds, installments, failed payments, etc) nor is it affected by canceled order items.
Refund The sum of the refunded transactions. This is always a negative number.
Fee The sum of the fees for a set of transactions. This could be a negative or positive number. Transaction fees are calculated for each campaign with an accuracy ± $0.01. The transaction fee of $0.30 is distributed evenly based on the dollar amount of the items. When a refund occurs, the transaction fee is refunded when the entire amount is refunded. This can result in irregularities in how the fee is distributed to the campaign.
Net Gross - Refunded Amount - Fees

The following columns are exported when the Export CSV (Detail) button.

Column Description
Order Date The date the order was placed
Order Number The number of the order
Purchaser The name of the person who placed the order
Stripe Payout ID Stripe reference ID for the payout
Stripe Source ID Stripe reference ID for the transaction (charge or refund)
Campaign The name of the campaign in the default language.
Quantity Number of units sold (donations will always be one)
Gross The sum of the purchased items of an order. This value does not include payment information (e.g., refunds, installments, failed payments, etc) nor is it affected by canceled order items.
Refund The sum of the refunded transactions. This is always a negative number.
Fee The sum of the fees for a set of transactions. This could be a negative or positive number. Transaction fees are calculated for each campaign with an accuracy ± $0.01. The transaction fee of $0.30 is distributed evenly based on the dollar amount of the items. When a refund occurs, the transaction fee is refunded when the entire amount is refunded. This can result in irregularities in how the fee is distributed to the campaign.
Net Gross - Refunded Amount - Fees