Reconciliation - Overflow Documentation

Reconciliation is where you review deposits and the contributions that make up each deposit. From one place you can see deposit amounts, bank account details, payment methods, fund allocations, fees, and contribution line items, and you can mark each deposit as reconciled once you have verified it against your bank.

Key terms

Deposit: A payout record. Each deposit has a date, amount, bank account, deposit ID, payment method, statement descriptor, and reconciliation status.
Deposit ID: The unique identifier for a deposit. Use it in the search bar at the top of the Reconciliation list.
Statement Descriptor: The descriptor that appears on the bank statement for the deposit. A dash means no descriptor is available.
Bank Account: The bank name and last four digits of the account that received the deposit, shown as Bank Name ...1234. A dash means no bank account is on file.
Payment Method: One or more tags that show how donors paid, such as Card, ACH, Google Pay, Apple Pay, Stock, Crypto, or DAF. A dash means no payment method is on file.
Reconciled: The deposit has been marked complete. It shows a green filled check icon and a tooltip with the date it was reconciled.
Unreconciled: The deposit has not yet been marked complete. It shows a yellow outlined check icon.
Gross Total: The amount before fees are subtracted.
Fees: The fees tied to the deposit, summary row, contribution, or allocation row. In summary and funds allocation tables, fees appear in parentheses.
Net Total: The amount after fees are subtracted.
Starting Balance: The balance at the beginning of the period before any transactions.
Ending Balance: The balance at the end of the period after all transactions have been processed.
Funds Allocation: The section of a deposit that breaks the total down by campaign, optional subcampaign, and optional location, with gross total, fees, and net total for each row.
Contribution: A gift included in a deposit. Contributions are listed on the deposit detail page and can be opened in a side panel.
Fund Reversal: A refund, chargeback, or adjustment tied to a deposit. This section appears only when those records exist.
Credit Allocation: The positive side of the funds allocation. It is the default view.
Debit Allocation: The negative side of the funds allocation. It appears only when the deposit has both credit and debit data.

How it works

Open Reconciliation from the left navigation in the nonprofit dashboard. The page opens to a list of deposits with search, filters, an export button, and a sortable table.

The deposits list

Each row in the deposits list shows the deposit date, statement descriptor, amount, bank account, deposit ID, payment method, and reconciliation status. Click any row to open the deposit detail page. You can:

Search by deposit ID.
Filter by Payment Method, Deposit Date, Deposit Type, Amount, or Status. Applied filters show as pills above the table and can be cleared with Clear filters.
Sort by Date, Statement Descriptor, Amount, Bank Account, Deposit ID, or Status. The list is sorted by newest deposit first by default.
Mark a deposit as reconciled or unreconciled from the row action menu.
Export deposit contribution rows to CSV.

The deposit detail page

The deposit detail page opens with the deposit amount as the title and a status icon next to it. Above the title is a breadcrumb back to the Reconciliation list. Below the title is a timestamp: a deposit that has not been reconciled shows the deposited date and time, and a reconciled deposit shows the date and time it was completed. The detail page is broken into four sections: Summary A table that lists Starting Balance, Contributions, Refunds, Chargebacks, Adjustments, Deposit, and Ending Balance. Each row shows count, gross total, fees, and net total. If the ending balance is negative, a help note explains that refunds, chargebacks, and adjustments were greater than contributions in the deposit. Details A card on the right that shows Deposit Date, Deposit ID, Statement Descriptor, Processor ID, Payment Method, Fees, Amount, and Contributions. Funds Allocation A breakdown of the deposit by campaign, and by subcampaign or location when those are turned on. Each row shows gross total, fees, and net total. If the deposit has both credit and debit data, Credit and Debit tabs appear, with Credit selected by default. The Export Funds button downloads the funds allocation as a CSV file. Contributions The contributions included in the deposit. You can search by donor name or email, filter contributions, and export the deposit’s contributions. Clicking a contribution row opens a side panel with Details and History tabs. If the deposit has refunds, chargebacks, or adjustments, a Fund Reversals section also appears.

Marking a deposit as reconciled or unreconciled

The action button at the top of the detail page changes based on the current status. An unreconciled deposit shows Mark as Reconciled, and a reconciled deposit shows Mark as Unreconciled. Selecting the action opens a confirmation modal before the status is updated. The same actions are also available on each row in the deposits list through the row action menu.

Reference

Screens and views

Screen or view	What it shows
Reconciliation deposits list	Search by deposit ID, Filter button, applied filter pills, Export button, deposits table, status icon, row action menu.
Deposit detail	Breadcrumb, deposit amount title, status icon, deposited or completed timestamp, Export button, Mark as Reconciled or Mark as Unreconciled button, Summary, Details, Funds Allocation, and Contributions.
Export deposits modal	Modal titled Export Multiple Deposit Contributions as CSV File with a Rows field and an Export Row(s) button.
Mark deposit modal	Confirmation modal that appears when you mark a deposit as reconciled or unreconciled.
Funds Allocation	Campaign allocation table, with optional subcampaign or location breakdown, gross total, fees, net total, optional Credit and Debit tabs, and Export Funds.
Fund Reversals	Conditional section for Refunds, Chargebacks, and Adjustments. Appears only when one or more of those records exist.
Contribution details side panel	Right-side panel opened from a contribution row. Shows contribution details and, for cash or stock contributions, a History tab.

Deposits list columns

Column	What it shows	Format and behavior
Date	Deposit arrival date and time.	`MM/DD/YYYY h:mm A z`. Sortable. Sorted newest first by default.
Statement Descriptor	Statement descriptor for the deposit.	Shows a dash when empty. Sortable.
Amount	Deposit amount.	Currency format. Sortable.
Bank Account	Bank name and last four digits.	`Bank Name ...1234`. Shows a dash when empty. Sortable.
Deposit ID	Unique deposit ID.	Sortable.
Payment Method	One or more payment method tags.	Tags such as Google Pay, Card, ACH, Apple Pay. Shows a dash when empty.
Status	Reconciliation status icon.	Green filled check for reconciled, yellow outlined check for unreconciled. Sortable.
Row actions	Per-deposit action menu.	Mark as reconciled or Mark as unreconciled.

Deposit detail header fields

Field	What it shows	Format and behavior
Breadcrumb	Return path and current deposit.	`Reconciliation / $amount - date`.
Deposit title	Current deposit amount.	`Deposit $amount`.
Status icon	Reconciled or unreconciled state.	Tooltip explains whether and when the deposit was reconciled.
Subtitle	Deposit or reconciliation timestamp.	`Deposited on M/D/YY h:mm A` when unreconciled, `Completed M/D/YY h:mm A` when reconciled.
Export button	Exports deposit contribution line items.	Uses the current deposit ID.
Status button	Opens the status confirmation modal.	Mark as Reconciled or Mark as Unreconciled.

Summary fields

Row	What it shows
Starting Balance	Balance at the beginning of the period before transactions.
Contributions	Contributions included in the deposit.
Refunds	Refunds included in the deposit summary.
Chargebacks	Chargebacks included in the deposit summary.
Adjustments	Adjustments included in the deposit summary.
Deposit	Deposit total amount.
Ending Balance	Balance at the end of the period after transactions.

Column	What it shows
Count	Number of items for that summary row. Balance and deposit rows show a dash.
Gross Total	Total before fees.
Fees	Fees for the row, shown in parentheses when present.
Net Total	Total after fees.

Details card fields

Field	What it shows
Deposit Date	Deposit arrival date.
Deposit ID	Unique deposit ID.
Statement Descriptor	Statement descriptor for the deposit.
Processor ID	Payout ID assigned by the payment processor.
Payment Method	One or more payment method tags.
Fees	Sum of fees from adjustments, contributions, chargebacks, and refunds in the deposit summary.
Amount	Deposit amount.
Contributions	Number of contributions in the summary.

Funds Allocation fields

Field or column	What it shows	Behavior
Campaign	Campaign or fund name.	Label follows your configured campaign display name.
Subcampaign	Subcampaign or subfund name.	Appears only when subfunds are active. Label follows your configured subcampaign display name.
Location or Campus	Location-level breakdown.	Appears when locations are active. Rows can be expanded by clicking. Label follows your configured location display name.
Gross Total	Amount before fees for the allocation row.	Debit amounts are shown in parentheses.
Fees	Fees for the allocation row.	Shown in parentheses.
Net Total	Amount after fees for the allocation row.	Debit amounts are shown in parentheses.
Total row	Total for the allocation table.	Appears when allocation data exists.
Credit tab	Positive allocation side.	Default tab when Credit and Debit tabs appear.
Debit tab	Negative allocation side.	Appears only when both credit and debit allocation data exist.

The Funds Allocation table shows six rows per page.

Contributions table fields on the deposit detail

Column	What it shows	Behavior
Donor	Donor name.	Uses the donor profile name when available.
Contribution ID	Unique contribution ID.	Shown when viewing contributions for a deposit.
Gross Amount	Contribution amount before fees.	Currency format.
Fees	Contribution fees.	Currency format.
Net Amount	Contribution amount after fees.	Currency format.
Date	Contribution date.	`MM/DD/YYYY hh:mm A`.
Location	Contribution location.	Appears only when locations are active. Label follows your configured location display name.
Campaign	Contribution campaign.	Label follows your configured campaign display name.
Subcampaign	Contribution subcampaign.	Appears only when subfunds are active. Label follows your configured subcampaign display name.

If the deposit includes non-cash contributions, the table can use the non-cash columns from the shared Contributions table configuration.

Fund Reversal fields

Column	What it shows
Donor	Donor name, or Anonymous Donor when the donor name is empty.
Contribution ID	Contribution ID tied to the reversal.
Gross Amount	Gross reversal amount.
Fees	Fees tied to the reversal.
Net Amount	Net reversal amount.
Date	Reversal creation date.
Campaign	Campaign name.
Subcampaign	Subcampaign name, when subfunds are active.

Filters

Filter	Options	Default	Behavior
Payment Method	ACH, Card, Apple Pay, Google Pay, Stock, Crypto, DAF.	All payment methods.	Filters deposits by payment method type.
Deposit Date	Last 30 Days, Last Month, Custom Range.	Custom Range with no start or end date.	Last 30 Days uses 30 days ago through today. Last Month uses the previous calendar month. Custom Range uses the start and end dates you select.
Deposit Type	Overflow, Import.	Overflow and Import deposits.	Overflow covers automated deposits. Manual deposits are not included in the deposit type filter.
Amount	Greater than, Less than, Equal to, Between.	No amount filter.	Filters deposit amount using minimum and maximum values.
Status	All, Reconciled, Unreconciled.	All.	Reconciled deposits have been marked complete. Unreconciled deposits have not been marked complete.

Applied filters appear as pills above the table. Clear filters resets the filters to their defaults.

Statuses

Status	Meaning	How it looks
Reconciled	The deposit has been marked complete.	Green filled check icon. Tooltip shows the date the deposit was reconciled.
Unreconciled	The deposit has not been marked complete.	Yellow outlined check icon. Tooltip says the deposit has not been marked as reconciled.

Actions

Action	Where	What it does	When it is available
Search by Deposit Id	Deposits list	Filters the list by deposit ID.	Always available.
Filter	Deposits list	Opens the filter menu.	Always available.
Clear filters	Deposits list	Resets deposit filters to defaults.	At least one filter is applied.
Sort table	Deposits list	Sorts by a sortable column.	The column supports sorting.
Open deposit	Deposits list	Opens the deposit detail page.	Click a deposit row.
Export	Deposits list	Opens the export modal and exports deposit contribution rows to CSV.	The Export button appears when there are deposit results.
Export Row(s)	Export modal	Starts the selected export.	A row option is selected.
Mark as Reconciled	List row menu or deposit detail	Opens a confirmation modal, then marks the deposit as reconciled.	The deposit is currently unreconciled and you have write access to payouts.
Mark as Unreconciled	List row menu or deposit detail	Opens a confirmation modal, then removes the reconciliation timestamp.	The deposit is currently reconciled and you have write access to payouts.
Export Funds	Deposit detail Funds Allocation	Exports the funds allocation as a CSV for the current deposit.	The deposit detail is loaded.
Search by Donor name or email	Deposit detail Contributions	Searches contributions in the current deposit.	The deposit detail is loaded.
Contribution filters	Deposit detail Contributions	Opens the filters for the contribution table.	The deposit detail is loaded.
Export deposit contributions	Deposit detail header	Exports contribution line items for the current deposit.	The deposit detail is loaded.
Open contribution side panel	Contributions or Fund Reversals table	Opens the right-side contribution details panel.	Click a row with a contribution ID.

Export details

Deposit list exports produce a CSV of deposit contribution line items. Smaller exports of 30 or fewer matching deposit items download immediately. Larger exports are queued, and a progress modal appears while the export is being prepared. Export row options

Option	Behavior	Default
All Filtered Rows	Exports the rows that match the current filters.	Default when filters are applied.
All Rows	Exports all rows while preserving the current status and deposit type values.	Default when no filters are applied.

Deposit item CSV columns

Deposit ID
Contribution ID
Type
Payment Method Type
Transaction Date
Deposit Date
Deposit Amount
Gross Amount
Fees
Net Amount
Bank Account
Reconciled
Donor Name
Donor Email
Location, when locations are active
Campaign
Subcampaign, when included by your fund settings

Funds allocation exports produce a CSV of the funds allocation for the current deposit. The default file name is funds_allocation_export.csv.

How-to walkthroughs

Reconcile a deposit

Open Reconciliation from the left navigation.
Find the deposit in the table, or use Search by Deposit Id.
Open the row action menu for the deposit, or click the deposit row to open the detail page.
Select Mark as reconciled from the row action menu, or select Mark as Reconciled on the detail page.
In the confirmation modal, select Mark as reconciled.
The deposit status updates to the reconciled icon.

Mark a deposit as unreconciled

Open Reconciliation.
Find a reconciled deposit.
Open the row action menu, or open the deposit detail page.
Select Mark as unreconciled from the row action menu, or select Mark as Unreconciled on the detail page.
In the confirmation modal, select Mark as unreconciled.
The deposit status updates to the unreconciled icon.

Filter deposits

Open Reconciliation.
Select Filter.
Choose a filter group: Payment Method, Deposit Date, Deposit Type, Amount, or Status.
Select the filter values.
Select Apply if the filter menu shows an Apply button.
Review the applied filter pills above the table.
Select Clear filters to reset the list.

Open a deposit and review its details

Open Reconciliation.
Click a deposit row.
Review the Summary table for starting balance, contributions, refunds, chargebacks, adjustments, deposit, and ending balance.
Review the Details card for Deposit Date, Deposit ID, Statement Descriptor, Processor ID, Payment Method, Fees, Amount, and Contributions.
Review Funds Allocation for campaign, subcampaign or location breakdown, gross total, fees, and net total.
Review Contributions for the contributions included in the deposit.

Export deposits

Open Reconciliation.
Apply filters if needed.
Select Export.
In Export Multiple Deposit Contributions as CSV File, choose All Filtered Rows or All Rows.
Select Export Row(s).
The CSV downloads immediately for smaller exports. Larger exports are queued.

Export a deposit’s contributions

Open Reconciliation.
Click a deposit row.
Select Export on the deposit detail page.
The export uses the current deposit ID.

Export funds allocation

Open Reconciliation.
Click a deposit row.
Go to Funds Allocation.
Select Export Funds.
The funds allocation CSV downloads for the current deposit.

Open contribution details from a deposit

Open a deposit detail page.
Go to Contributions.
Use Search by Donor name or email or filters if needed.
Click a contribution row.
Review the right-side contribution details panel.
Use the Details and History tabs when they are available.

Contributions: The deposit detail page reuses contribution search, filters, table behavior, export behavior, and the contribution details side panel.
Reporting: Funds allocation reporting is related to how deposits are broken down by campaign, subcampaign, and location.
Integrations: Deposit records can include processor IDs, statement descriptors, payment methods, and bank account details.

​Key terms

​How it works

​The deposits list

​The deposit detail page

​Marking a deposit as reconciled or unreconciled

​Reference

​Screens and views

​Deposits list columns

​Deposit detail header fields

​Summary fields

​Details card fields

​Funds Allocation fields

​Contributions table fields on the deposit detail

​Fund Reversal fields

​Filters

​Statuses

​Actions

​Export details

​How-to walkthroughs

​Reconcile a deposit

​Mark a deposit as unreconciled

​Filter deposits

​Open a deposit and review its details

​Export deposits

​Export a deposit’s contributions

​Export funds allocation

​Open contribution details from a deposit

​Related