How much came in by cash, check, card, Zelle…

Bookkeepers often need totals per payment type for a month. Here are two ways to get them.

Who does this: Office staff4 steps

1
Open Insights → Summary
Click "Insights".
Start on Summary.
2
Pick the month
Choose "Custom" and type the first and last day of the month in the two date boxes.
Use your own dates for one month.
3
Group by payment type
Choose "Group by payment type" and press "Run". Each payment type has its own row.
One row per payment type.
4
For a closed month, use the saved totals
If the month is closed, Settings → "Month closing" shows the totals saved at the close, by "How it was given", with refunds and deposits.
The month's totals by payment type.

Tips

The Summary counts gifts by their gift date. Refunds made later reduce the original gift's total.
Month closing counts refunds in the month they were made — so the two can differ slightly.

Cash and checks don't match the bank deposit.

Some may not be marked deposited, or were deposited in another month. Check Giving → Deposits.

Card totals are higher than the processor's deposit.

Processors take fees before depositing. See Insights → Payouts for gross, fees and net.

Was this helpful?