> ## Documentation Index
> Fetch the complete documentation index at: https://docs.overflow.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Reconciliation

> Review deposits, match contributions, and mark deposits as reconciled.

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

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

### Mark a deposit as unreconciled

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

### Filter deposits

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

### Open a deposit and review its details

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

### Export deposits

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

### Export a deposit's contributions

1. Open **Reconciliation**.
2. Click a deposit row.
3. Select **Export** on the deposit detail page.
4. The export uses the current deposit ID.

### Export funds allocation

1. Open **Reconciliation**.
2. Click a deposit row.
3. Go to **Funds Allocation**.
4. Select **Export Funds**.
5. The funds allocation CSV downloads for the current deposit.

### Open contribution details from a deposit

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

## Related

* [Contributions](/overflow-for-nonprofits/nonprofit-dashboard/contributions): The deposit detail page reuses contribution search, filters, table behavior, export behavior, and the contribution details side panel.
* [Reporting](/overflow-for-nonprofits/nonprofit-dashboard/reporting): Funds allocation reporting is related to how deposits are broken down by campaign, subcampaign, and location.
* [Integrations](/overflow-for-nonprofits/nonprofit-dashboard/integrations): Deposit records can include processor IDs, statement descriptors, payment methods, and bank account details.