25. Reports, imports and event revenue

Video Courses

All Courses

Steward: giving

About this course1. The Steward dashboard2. Sessions, and the life of a session3. Starting a session4. The entry grid and the keyboard5. Who gave it: envelopes, names and anonymous gifts6. A new donor in the middle of counting7. Payment methods, cheques and split gifts8. The counted total and the live difference9. Possible duplicates10. Saving, refreshing and two laptops11. Counters, the review and Submit12. Posting a session13. Correcting a posted gift14. Gifts in kind15. Interac e-Transfers16. Deposits and bank reconciliation17. Donors and the donor profile18. Merging duplicate donors19. Pledge campaigns20. Recurring gifts21. Online giving22. Refunds and card disputes23. Year-end CRA receipts24. Fixing and sending receipts25. Reports, imports and event revenue26. Who sees giving

Gather: services and attendance

About this course1. Gather at a glance2. Service Schedules and the calendar3. Children's rooms and who counts as a child4. Building an Order of Service5. Starting, completing and cancelling a Service6. Opening check-in7. Lookup mode: finding people fast8. New visitors and first-time visitors9. People with no date of birth10. Person Categories: who counts as a child, and the attendance breakdown11. Printing labels12. Checking in children13. Allergy and medical alerts14. Children's Pickup15. Member QR codes and Scan mode16. The family check-in code17. Express Check-in18. Clicker headcounts and Roster mode19. Many devices, and finishing check-in20. Self check-in kiosks21. Attendance records and corrections22. Absence alerts23. Attendance reports24. Events and the public calendar25. Registrations and paid events
Video Courses

Reports, imports and event revenue

Steward: giving · Lesson 25 of 26

The gift ledger, the report builder, importing history, and event revenue.

Read it in the guide

Transcript

In this lesson, you'll find any gift in the transaction ledger, build a report for the board, bring giving history in from another system, and see event revenue, which is never giving.

Steward Reports opens on the Transaction Ledger: every gift, one line each. Pick a period: today, this week, this month, last month, this quarter, the year to date, or last year. Search by donor, envelope, session or cheque number.

Narrow it by dates, by a minimum or maximum amount, by payment method, and by session status. The status starts at posted and locked: exactly the gifts that count, online gifts included. A Stripe refund shows as a red refund line.

For a CRA question, pick Last Year: your tax year, by fund and method. Export it as a spreadsheet, or print it.

Report Builder makes summaries. Start from a preset: monthly giving, fund performance, payment methods, a quarterly summary, giving tiers, or the board report.

Or build your own. Group by month, week, quarter, year, fund, payment method, day of the week or giving tier. Measure total given, gift count, unique donors, average gift or largest gift. Compare with the prior period, or the same period last year. Run Report, then export it. Save Report keeps it on this computer only.

Kevin, with Reporting Only, gets the same ledger and builder, read-only. There's no New Session and no e-Transfers for him.

Moving from another system? Import Giving takes an Excel or CSV file, up to fifty megabytes. It's for Super Admins and Finance Admins.

First, where it goes. Link to a Service Window creates a draft session you review and post like any other. Import to Ledger posts history straight in: each date becomes its own locked session, counted in reports and receipts, and it can't be undone in bulk. Either way, an amount with a third decimal is refused, never rounded.

Drop the file in. Tell it how names appear, last name first or first name first, a payment method for every row if the file has none, which row holds the headers, and the last row of data, so a totals row is left out. Then you map each column, match each name to a donor or create one, and review before anything is written.

Last, Event Revenue: card payments for paid events. A ticket to the youth retreat isn't a donation. It has its own ledger: never a gift, never on a tax receipt, in no giving total. Payments, refunds and lost disputes are listed, with an export. Super Admins, the Lead Pastor and Finance Admins can refund one.

That's reports. Last, who sees giving at all.