16. Deposits and bank reconciliation

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

Deposits and bank reconciliation

Steward: giving · Lesson 16 of 26

Group posted sessions into a deposit, and match it to the bank to the cent.

Read it in the guide

Transcript

In this lesson, you'll put posted sessions into a bank deposit, then match that deposit against the bank to the cent, and see what happens when it doesn't match.

After posting comes the bank. Deposits are for Finance Admins and Super Admins only. The Lead Pastor and the counters don't see this page.

The line under the title sums up the year: how many deposits, and how much has been matched to the bank. The chips count them by status: discrepancies, pending, which are waiting for the bank to confirm, and reconciled. Click one to see only those.

Each row is one deposit: its number, the date, the sessions in it, the sessions' total, what the bank received, the variance, and the status. Export gives you a spreadsheet or a printout.

New Deposit. Only posted sessions that aren't on a deposit yet are listed, from your campus. Tick the ones going to the bank together, or Select all. The summary adds them up, in cents.

Then the details: the deposit date, which is the church's calendar day, the bank account, which is required, and the deposit slip number. Until a session is ticked and an account chosen, the panel says what's missing. Create Deposit.

The deposit gets the next number for the year, from a counter that never repeats. It's Pending: the sessions' total is what the bank should receive. Nothing has been reconciled yet.

While it's pending, you can change what's in it. Unlink takes a session out. Link Session puts a posted one back in, and the expected figure follows. A reconciled deposit can't be changed at all.

When the bank statement arrives, reconcile it. Type what the bank actually received. Say the statement shows eleven hundred and forty dollars. The line under it says the variance straight away: ten dollars short.

Save Reconciliation. Because it doesn't match, you're asked first: amounts do not match, and the deposit will be marked as a discrepancy. Click Save again to confirm.

It's now a Discrepancy, and the page asks how you want to resolve it. Did you type the bank amount wrong? Correct it. Is a session's total wrong? Open the session and correct its gifts first. Or is the difference real? Accept it with a note. Accepting keeps the deposit in Discrepancy, with your note: it doesn't lock anything.

Here, we typed it wrong: the bank got eleven fifty. Correct amount. A discrepancy can be reconciled again with a new figure. Balanced: it matches the sessions total. Save.

Reconciled, and every session in it is now locked. Balanced means within half a cent. A reconciled deposit can't be reconciled again, and its sessions take no correction until a Super Admin unlocks one, which sends the deposit back to Pending.

One thing to know. If you correct a gift in a session that's already on a pending deposit, the session's total changes, but the deposit's expected figure is only worked out again when a session is linked or unlinked. So unlink that session, and link it again.

That's the bank side done. Next, your donors, and everything on one donor's page.