Campaigns
Ticketing
Ticketing
Channels
Operations
Forms & Waivers
Forms & Waivers
Settings
Getting Help
Campaign Types
Building a Campaign
Configuring Campaigns

Cash Reconciliation Report

The Offline Reconciliation report shows paid cash and check payments by campaign, so you can check them against the cash and checks you deposited.

In the Admin, this report is called Offline Reconciliation. It shows the cash and check payments you’ve marked as paid, including SnackBar cash sales, totaled by campaign. Use it to check your cash box or bank deposit against what FutureFund recorded.

Payments that are still owed aren’t on this report. You’ll find those on Offline Payments Pending. See Offline Payment Report.

Finding the Report

  1. Go to Orders & Payouts > Reports.
  2. Click Offline Reconciliation.

Filtering

  • Order Date: despite its name, this filter uses the date each payment was received, not the date the order was placed. For a SnackBar cash sale, the two are the same.
  • Organization: the report shows one organization at a time. If you don’t pick one, it uses your first organization alphabetically.

What You’ll See

A summary at the top shows the organization, the transaction type (Cash/Check), the status (Paid), and the date range, along with totals for Charges, Refunds, Fees, Adjustments, and Net. Fees and adjustments are always zero for cash and checks.

Below it, the Campaign Summary table shows each campaign’s totals:

Column Description
Campaign The name of the campaign.
Charge The cash and check payments received.
Refund Any refunds of those payments.
Fee Always zero for cash and checks.
Net Charge minus refunds.

Exporting

Both exports download an Excel (.xlsx) file.

Export Summary gives you one row per campaign: Campaign, Gross, Refund, Fee, and Net.

Export Detail gives you one row per payment:

Column Description
Order Date The date the order was placed.
Order Number The order’s number.
Purchaser First Name The purchaser’s first name.
Purchaser Last Name The purchaser’s last name.
Campaign The name of the campaign.
Quantity Number of units sold (donations are always one).
Charge The amount paid.
Refund Any amount refunded.
Fee Always zero for cash and checks.
Net Charge minus refunds.
Check Number The check number, if one was entered.
To check a SnackBar cash box for one event, set the date filter to the event’s dates and use **Export Detail**. You can sort the spreadsheet by Order Number to find where the event’s sales start.

Was this helpful?