assess.one – AI-powered business operations platform

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

  1. 1
    Create reconciliation recordcreate record

    Creates the bank reconciliation record from the submitted form data.

  2. 2
    Set status to Openupdate record

    Sets the reconciliation status to Open at intake.

  3. 3
    Calculate differenceupdate record

    Calculates the difference as the statement closing balance minus the ledger balance and saves it to the record.

  4. 4
    Email acknowledgementsend email

    Emails the finance officer an acknowledgement with their reference number.

  5. 5
    Set status to Reconcilingupdate record

    Sets the reconciliation status to Reconciling before matching begins.

  6. 6
    Finance officer: match transactionscreate task

    Finance officer matches bank statement transactions to the general ledger and records findings.

  7. 7
    Save matching resultsupdate record

    Persists the matching notes, difference type and details to the record.

  8. 8
    Route 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 journal
    difference_type: "Unexplained variance"→Senior reviewer: investigate variance
    difference_type: "Outstanding items"→Set status to Review
    difference_type: "None"→Set status to Review
    Default→Set status to Review
  9. 9
    Finance officer: post journalcreate task

    Finance officer posts the journal entry for bank fees or adjustments and records the journal number.

  10. 10
    Save journal numberupdate record

    Persists the posted journal number to the record.

  11. 11
    Senior reviewer: investigate variancecreate task

    Senior reviewer investigates the unexplained variance and records the investigation and resolution.

  12. 12
    Save investigation notesupdate record

    Persists the investigation and resolution notes to the record.

  13. 13
    Set status to Reviewupdate record

    Sets the reconciliation status to Review before the reviewer task is created.

  14. 14
    Reviewer: review reconciliationcreate task

    Reviewer reviews the reconciliation and records the result and comments.

  15. 15
    Save review resultupdate record

    Persists the review result and comments to the record.

  16. 16
    Route on review result

    Routes the workflow based on whether the reviewer approved or returned the reconciliation.

    review_result: "Approved"→Set status to Reconciled
    review_result: "Returned"→Finance officer: make corrections
    Default→End
  17. 17
    Finance officer: make correctionscreate task

    Finance officer makes the corrections requested by the reviewer and records what was corrected.

  18. 18
    Save correctionsupdate record

    Persists the corrections made to the record.

  19. 19
    Return to reviewrestart from step

    Restarts the workflow from the reviewer task so the corrected reconciliation can be reviewed again.

  20. 20
    Set status to Reconciledupdate record

    Sets the reconciliation status to Reconciled once approved.

  21. 21
    Email approval confirmationsend email

    Emails the finance officer that the reconciliation has been approved.

Fields

Show all 16 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

Reconciliations by Reconciliation Status

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

Bank Reconciliation Workflow | assess.one