Workflow Template
Bank Reconciliation Workflow
Reconciles a bank statement to the general ledger: collects statement and ledger balances, calculates the variance, routes through matching, journal posting or investigation depending on the type of difference found, and cycles through a review/return loop until the reconciliation is approved.
When a bank reconciliation lives in spreadsheets and email threads, finance teams lose track of which variances still need investigation, which journals were posted, and whether a reviewer actually signed off before month-end close. This workflow captures the statement and ledger balances, calculates the difference automatically, and routes the reconciliation through matching, journal posting or investigation based on what type of difference was found. The result is a single record with a reference number and timeline showing exactly where every reconciliation stands, and a review loop that keeps cycling until it's approved.
Business Outcomes
- Reduces time spent tracking reconciliation status across spreadsheets and email
- Helps standardize how bank fees, outstanding items and unexplained variances are handled
- Makes it easier to see which reconciliations are stuck in review or awaiting correction
- Supports faster handoff between finance officers, senior reviewers and reviewers
- Improves visibility into journal numbers and investigation notes tied to each reconciliation
Workflow Steps
Steps
- 1Create reconciliation recordcreate record
Creates the bank reconciliation record from the submitted form data.
- 2Set status to Openupdate record
Sets the reconciliation status to Open at intake.
- 3Calculate differenceupdate record
Calculates the difference as the statement closing balance minus the ledger balance and saves it to the record.
- 4Email acknowledgementsend email
Emails the finance officer an acknowledgement with their reference number.
- 5Set status to Reconcilingupdate record
Sets the reconciliation status to Reconciling before matching begins.
- 6Finance officer: match transactionscreate task
Finance officer matches bank statement transactions to the general ledger and records findings.
- 7Save matching resultsupdate record
Persists the matching notes, difference type and details to the record.
- 8Route on type of difference
Routes the workflow based on the type of difference found during matching.
difference_type: "Bank fees or adjustments"→Finance officer: post journaldifference_type: "Unexplained variance"→Senior reviewer: investigate variancedifference_type: "Outstanding items"→Set status to Reviewdifference_type: "None"→Set status to ReviewDefault→Set status to Review - 9Finance officer: post journalcreate task
Finance officer posts the journal entry for bank fees or adjustments and records the journal number.
- 10Save journal numberupdate record
Persists the posted journal number to the record.
- 11Senior reviewer: investigate variancecreate task
Senior reviewer investigates the unexplained variance and records the investigation and resolution.
- 12Save investigation notesupdate record
Persists the investigation and resolution notes to the record.
- 13Set status to Reviewupdate record
Sets the reconciliation status to Review before the reviewer task is created.
- 14Reviewer: review reconciliationcreate task
Reviewer reviews the reconciliation and records the result and comments.
- 15Save review resultupdate record
Persists the review result and comments to the record.
- 16Route on review result
Routes the workflow based on whether the reviewer approved or returned the reconciliation.
review_result: "Approved"→Set status to Reconciledreview_result: "Returned"→Finance officer: make correctionsDefault→End - 17Finance officer: make correctionscreate task
Finance officer makes the corrections requested by the reviewer and records what was corrected.
- 18Save correctionsupdate record
Persists the corrections made to the record.
- 19Return to reviewrestart from step
Restarts the workflow from the reviewer task so the corrected reconciliation can be reviewed again.
- 20Set status to Reconciledupdate record
Sets the reconciliation status to Reconciled once approved.
- 21Email approval confirmationsend email
Emails the finance officer that the reconciliation has been approved.
Fields
Show all 16 fieldsShow fewer fields
FormBank Reconciliation Intake
- Finance Officer Name*· Text
- Finance Officer Email*· Email
- Bank Account*· Text
- Statement Period*· Text
- Statement Closing Balance*· Number
- Ledger Balance*· Number
TaskFinance officer: match transactions
- Matching Notes· Long text
- Type of Difference Found· Choice
- Difference Details· Long text
TaskFinance officer: post journal
- Journal Number· Text
TaskSenior reviewer: investigate variance
- Investigation and Resolution· Long text
TaskReviewer: review reconciliation
- Review Result· Choice
- Review Comments· Long text
TaskFinance officer: make corrections
- Corrections Made· Long text
Other fields
- Reconciliation Status· Choice
- Difference· Number
- Finance Officer Name*
- Finance Officer Email*
- Bank Account*
- Statement Period*
- Statement Closing Balance*
- Ledger Balance*
Forms
Bank Reconciliation Intake
6 fields
Data Views
Bank Reconciliations
bank_account, statement_period, difference, reconciliation_status
Dashboard Widgets
Recommended integrations
Setup the following integrations to extend workflow capability.
Send email in the workflow
AWS SES
Similar Categories
FAQs
What happens if the statement and ledger balances match exactly?
When the finance officer records the type of difference found as 'None' during matching, the workflow routes past the journal posting and investigation steps and moves straight to the reviewer stage. The reconciliation record still captures the matching notes before it proceeds. This keeps clean reconciliations moving quickly to sign-off without unnecessary steps.
Can this handle a variance that doesn't fit bank fees, outstanding items or an unexplained variance?
Yes. The routing step includes an 'otherwise' path for any type of difference that doesn't match the defined categories, so the reconciliation still progresses through the workflow rather than getting stuck. A workspace can adjust the routing logic in the workflow editor to add more specific categories if needed.
What happens if the reviewer returns the reconciliation instead of approving it?
The reconciliation status stays in Review, and a task is created for the finance officer to make the corrections requested, recording what was corrected on the record. The workflow then returns to the reviewer task automatically so the corrected reconciliation gets reviewed again. This loop repeats until the reviewer records an Approved result.
Who is responsible for investigating an unexplained variance?
A senior reviewer is assigned the task when the type of difference found is routed as an unexplained variance. They record their investigation and resolution directly on the reconciliation record, and the workflow waits for that task before continuing. This keeps the more complex variance types with a more senior team member while routine matching stays with the finance officer.
What if bank fees or adjustments need a journal entry posted?
When the type of difference is routed as bank fees or adjustments, a task is assigned to the finance officer to post the journal entry and record the journal number. The workflow waits for that task, then saves the journal number to the record before the reconciliation moves to the Review status. This keeps a record of exactly which journal corrected the variance.
Can we customise which fields are collected on the request form?
Yes. A workspace can edit the workflow's steps in the workflow editor or describe the change in plain English, including adjusting the fields on the request form or the tasks assigned to finance officers and reviewers. Earlier versions of the workflow are kept, so changes can be reviewed or rolled back.
How does the finance officer know the reconciliation was submitted or approved?
The finance officer receives an emailed acknowledgement with their reference number as soon as the reconciliation record is created. Once the reviewer approves the reconciliation and its status is set to Reconciled, the finance officer receives a second email confirming the approval.
What does the reconciliation record show at any point in the process?
Each reconciliation is a record with a reference number, a current status such as Open, Reconciling, Review or Reconciled, and a timeline of what happened at each step. Table views and dashboards show reconciliations grouped by status, so teams can see which ones are awaiting matching, review or correction. Each business should confirm what level of detail it needs to retain for its own record-keeping obligations.
Can multiple finance officers or reviewers use this workflow at once?
Yes. Tasks such as matching transactions, posting journals or reviewing the reconciliation are assigned to the relevant team member, and each reconciliation record moves independently through its own steps. Workspace users, whether admins or members, can pick up their assigned tasks without affecting other reconciliations in progress.
Ready to use this workflow?
Create a free account and customise this workflow for your business.
