Workflow Template
Bank Reconciliation Workflow
Guides a finance officer through reconciling a bank statement to the general ledger for a period: capturing balances, classifying differences (outstanding items, bank fees/adjustments, unexplained variances), routing unexplained variances to a senior reviewer for investigation, journaling fees/adjustments, and obtaining reviewer sign-off before closing the period with outcome notification to the officer.
Finance teams lose hours every period hunting for who's investigating a variance, whether a journal entry was posted, and whether the reviewer actually signed off before the books closed. This workflow captures balances, automatically classifies differences into outstanding items, fee adjustments, or unexplained variances, and routes each one to the right person with a clear status at every stage. The result is a traceable reconciliation trail that helps finance officers close periods with fewer follow-up emails and less end-of-month scrambling.
Business Outcomes
- Helps reduce time spent tracking down unexplained variances
- Supports faster period close with clear status visibility at each stage
- Reduces manual follow-up emails between officers and reviewers
- Improves audit trail quality for outstanding items and journal adjustments
- Helps standardise sign-off and rework steps across reconciliation cycles
Workflow Steps
Steps
- 1Create Reconciliation Recordcreate record
Creates the bank reconciliation record for the period.
- 2Set Status: Openupdate record
Marks the reconciliation as open at intake.
- 3Match Transactions & Record Differencecreate task
Officer matches bank statement transactions to the ledger and records any difference and its classification.
- 4Set Status: Matching in Progressupdate record
Persists matching notes and difference details to the record.
- 5Route on Difference Classification
Routes handling based on how the difference was classified.
difference_classification: "Outstanding Item"→Record Outstanding Item for Carry-Forwarddifference_classification: "Bank Fee or Adjustment"→Prepare Journal Entry for Fee/Adjustmentdifference_classification: "Unexplained Variance"→Assign Senior Reviewer to Investigate Variancedifference_classification: "No Difference"→Set Status: Pending ReviewDefault→Set Status: Pending Review - 6Record Outstanding Item for Carry-Forwardsimulate action
Routes to capture outstanding item details for carry-forward to the next period's reconciliation.
- 7Document Outstanding Item Detailcreate task
Officer records details of the outstanding item to carry forward.
- 8Persist Outstanding Item Detailsupdate record
Saves outstanding item details to the record.
- 9Prepare Journal Entry for Fee/Adjustmentcreate task
Officer prepares and records the journal entry needed to clear the bank fee or adjustment.
- 10Set Status: Pending Journal Entry / Persist Journal Detailsupdate record
Records journal entry reference and notes on the reconciliation.
- 11Assign Senior Reviewer to Investigate Varianceassign user
Assigns the unexplained variance to a senior reviewer for investigation.
- 12Set Status: Under Investigationupdate record
Marks the reconciliation as under investigation.
- 13Investigate Unexplained Variancecreate task
Senior reviewer investigates the unexplained variance and records findings and resolution before sign-off.
- 14Persist Variance Investigation Findingsupdate record
Saves the investigation notes and resolution to the record.
- 15Route on Variance Resolution
Routes the investigated variance to journal entry, outstanding item carry-forward, or escalated sign-off.
variance_resolution: "Resolved - Journal Required"→Prepare Journal Entry for Fee/Adjustmentvariance_resolution: "Resolved - Outstanding Item"→Record Outstanding Item for Carry-Forwardvariance_resolution: "Unresolved - Escalate"→Set Status: Pending ReviewDefault→Set Status: Pending Review - 16Request Reviewer Sign-Offrequest approvalrequires approval
Sends the completed reconciliation to a reviewer for approval or return for correction.
- 17Route on Sign-Off Outcome
Branches based on whether the reviewer approved the reconciliation or returned it for correction.
approval_status: "approved"→Set Status: Approvedapproval_status: "rejected"→Set Status: Returned for CorrectionDefault→End - 18Set Status: Returned for Correctionupdate record
Marks the reconciliation as returned for correction and notifies the officer.
- 19Notify Officer: Returned for Correctionsend email
Emails the finance officer that the reconciliation was returned for correction.
- 20Loop Back for Reworkrestart from step
Restarts the matching/classification process so the officer can correct the reconciliation.
- 21Set Status: Approvedupdate record
Marks the reconciliation as approved and complete.
- 22Notify Officer: Approvedsend email
Emails the finance officer confirming the reconciliation was approved.
- 23Set Status: Pending Reviewupdate record
Marks the reconciliation as pending reviewer sign-off.
Fields
- Finance Officer Email*
- Bank Account*
- Statement Period (e.g. Mar 2025)*
- Statement Closing Balance*
- General Ledger Balance*
- Reconciliation Status
- +8 more fields
Forms
Bank Reconciliation Intake
5 fields
Data Views
All Bank Reconciliations
bank_account, statement_period, statement_closing_balance, ledger_balance +3 more
Dashboard Widgets
Recommended integrations
Setup the following integrations to extend workflow capability.
Send email in the workflow
AWS SES
Similar Workflows
Similar Categories
FAQs
What happens if a variance can't be explained during investigation?
The workflow routes unexplained variances to a senior reviewer through the 'Assign Senior Reviewer to Investigate Variance' step, and the record moves to 'Under Investigation' status. Findings are persisted in the workflow so the officer and reviewer both have visibility into what's been checked and what's still open. If the variance remains unresolved, the reviewer can keep the item open rather than force a premature sign-off.
Can this handle outstanding items that carry forward across multiple periods?
Yes, the 'Record Outstanding Item for Carry-Forward' and 'Document Outstanding Item Detail' steps are built for this. Details persist in the platform so the same outstanding item can be tracked and referenced in the next reconciliation cycle instead of being re-entered manually.
What if the reviewer rejects the sign-off?
The 'Route on Sign-Off Outcome' step checks the reviewer's decision, and a rejection triggers the 'Set Status: Returned for Correction' and 'Notify Officer: Returned for Correction' steps. The officer then reworks the reconciliation through the 'Loop Back for Rework' step, which sends it back into the matching and classification stages rather than starting a new record.
How long does it take to get this workflow up and running?
The template is ready to use, so a finance lead can review the steps, adjust roles or approval logic, and publish it in minutes. Once published, the finance officer can start the first reconciliation immediately — there's no separate implementation project or software installation required.
Who needs access to this workflow?
At minimum, the finance officer running the reconciliation and the senior reviewer handling sign-off and variance investigation need access. Additional stakeholders, such as a controller who wants visibility into outstanding items, can be added as viewers or approvers depending on how the roles are configured in assess.one.
Can we customise how differences are classified?
Yes, the 'Route on Difference Classification' step and its downstream branches can be edited directly in assess.one to match your chart of accounts or internal categorisation rules. You can add, remove, or relabel classification paths without needing developer support.
What if fee adjustments need a journal entry before sign-off?
The 'Prepare Journal Entry for Fee/Adjustment' step captures the entry, and the record moves to 'Pending Journal Entry' status until it's persisted. Only after the journal details are recorded does the workflow proceed toward the reviewer sign-off request, so adjustments aren't skipped.
Does this workflow support compliance or audit requirements?
The workflow maintains status history, documented outstanding items, journal entry details, and investigation findings at each step, which supports a traceable audit record. Reviewer sign-off is a required decision point before period close, helping enforce segregation of duties between the preparer and reviewer.
Can notifications be routed to a team instead of one officer?
Notification steps like 'Notify Officer: Returned for Correction' can be configured inside assess.one to route to a specific person, a team channel, or an email distribution list. This is set up directly in the platform's notification settings without needing external integration work.
What if we need to reconcile multiple bank accounts in parallel?
Each reconciliation runs as its own record starting from 'Create Reconciliation Record,' so multiple accounts can be reconciled at the same time without interfering with each other. Officers and reviewers can track each record's status independently through the same workflow template.
Ready to use this workflow?
Create a free account and customise this workflow for your business.
