assess.one – AI-powered business operations platform

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

  1. 1
    Create Reconciliation Recordcreate record

    Creates the bank reconciliation record for the period.

  2. 2
    Set Status: Openupdate record

    Marks the reconciliation as open at intake.

  3. 3
    Match Transactions & Record Differencecreate task

    Officer matches bank statement transactions to the ledger and records any difference and its classification.

  4. 4
    Set Status: Matching in Progressupdate record

    Persists matching notes and difference details to the record.

  5. 5
    Route on Difference Classification

    Routes handling based on how the difference was classified.

    difference_classification: "Outstanding Item"Record Outstanding Item for Carry-Forward
    difference_classification: "Bank Fee or Adjustment"Prepare Journal Entry for Fee/Adjustment
    difference_classification: "Unexplained Variance"Assign Senior Reviewer to Investigate Variance
    difference_classification: "No Difference"Set Status: Pending Review
    DefaultSet Status: Pending Review
  6. 6
    Record Outstanding Item for Carry-Forwardsimulate action

    Routes to capture outstanding item details for carry-forward to the next period's reconciliation.

  7. 7
    Document Outstanding Item Detailcreate task

    Officer records details of the outstanding item to carry forward.

  8. 8
    Persist Outstanding Item Detailsupdate record

    Saves outstanding item details to the record.

  9. 9
    Prepare Journal Entry for Fee/Adjustmentcreate task

    Officer prepares and records the journal entry needed to clear the bank fee or adjustment.

  10. 10
    Set Status: Pending Journal Entry / Persist Journal Detailsupdate record

    Records journal entry reference and notes on the reconciliation.

  11. 11
    Assign Senior Reviewer to Investigate Varianceassign user

    Assigns the unexplained variance to a senior reviewer for investigation.

  12. 12
    Set Status: Under Investigationupdate record

    Marks the reconciliation as under investigation.

  13. 13
    Investigate Unexplained Variancecreate task

    Senior reviewer investigates the unexplained variance and records findings and resolution before sign-off.

  14. 14
    Persist Variance Investigation Findingsupdate record

    Saves the investigation notes and resolution to the record.

  15. 15
    Route 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/Adjustment
    variance_resolution: "Resolved - Outstanding Item"Record Outstanding Item for Carry-Forward
    variance_resolution: "Unresolved - Escalate"Set Status: Pending Review
    DefaultSet Status: Pending Review
  16. 16
    Request Reviewer Sign-Offrequest approvalrequires approval

    Sends the completed reconciliation to a reviewer for approval or return for correction.

  17. 17
    Route on Sign-Off Outcome

    Branches based on whether the reviewer approved the reconciliation or returned it for correction.

    approval_status: "approved"Set Status: Approved
    approval_status: "rejected"Set Status: Returned for Correction
    DefaultEnd
  18. 18
    Set Status: Returned for Correctionupdate record

    Marks the reconciliation as returned for correction and notifies the officer.

  19. 19
    Notify Officer: Returned for Correctionsend email

    Emails the finance officer that the reconciliation was returned for correction.

  20. 20
    Loop Back for Reworkrestart from step

    Restarts the matching/classification process so the officer can correct the reconciliation.

  21. 21
    Set Status: Approvedupdate record

    Marks the reconciliation as approved and complete.

  22. 22
    Notify Officer: Approvedsend email

    Emails the finance officer confirming the reconciliation was approved.

  23. 23
    Set 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

Reconciliations by StatusReconciliation OverviewDifferences by Classification

Recommended integrations

Setup the following integrations to extend workflow capability.

  • Send email in the workflow

    AWS SES logoAWS SES
bank reconciliationaccount reconciliationfinance closecash reconciliationgeneral ledger

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.

Bank Reconciliation Workflow | assess.one