Bank Reconciliation Spreadsheet Template

Matches the company’s accounting records with bank statements to ensure accuracy.

Bank Reconciliation
This document helps reconcile the company's accounting records with the bank statement by matching transactions.

Company Name:	{companyName}
Bank Name:	{bankName}
Statement Date:	{statementDate}
Prepared By:	{preparedBy}
Reconciliation Date:	{reconciliationDate}

Bank Statement Balance	{bankStatementBalance}
Deposits Date	Amount
{#deposits.date}	{#deposits.amount}

Total Deposits in Transit	=SUM(deposits[Amount])

Outstanding Checks Date	Amount
{#outstandingChecks.date}	{#outstandingChecks.amount}

Total Outstanding Checks	=SUM(outstandingChecks[Amount])

Adjusted Bank Balance	=B8 + SUM(deposits[Amount]) - SUM(outstandingChecks[Amount])

This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download

Download Excel Template (.XLSX)

Customize Template

Download the Bank Reconciliation template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).

Upload & Configure

Upload the template to Documentero - Document Generation Service, then map and configure template fields for your automated workflow.

Generate Documents

Populate templates with your data and generate Excel (XLSX) documents using data collected from shareable web Forms, APIs, or Integrations.

Use Cases

Automate Bank Reconciliation Using Forms

collect monthly bank statement data via web form for reconciliation

gather transaction entries from finance team using form to populate bank reconciliation sheet

submit petty cash logs through form to auto-update reconciliation spreadsheet

use web form to collect supporting documents for bank reconciliation report

automate vendor payment reporting through a shareable bank reconciliation form

Generate Bank Reconciliation Using APIs

trigger bank reconciliation excel generation via API from accounting software

auto-generate reconciliation sheet using API when new bank data is synced

generate custom bank reconciliation spreadsheet via CRM webhook and API

use REST API to populate financial data into bank reconciliation template

schedule API-based generation of monthly reconciliation spreadsheets for audit

Integrations / Automations

automatically create bank reconciliation spreadsheet from QuickBooks using Zapier

generate excel reconciliation report from Stripe transactions using Make

auto-populate bank reconciliation sheet from Google Sheets via Zapier integration

create monthly reconciliation spreadsheet triggered by new Xero statement

build reconciliation reports from synced bank feeds in Airtable using Make

Other templates in Finance & Accounting

Job Estimate

DocumentDOCX

Provide cost estimates to clients before project or service delivery.

Inventory Valuation Sheet

DocumentDOCX

Track and calculate the value of stock for accounting and tax reporting.

Balance Sheet

DocumentDOCX

A snapshot of a company's financial position showing assets, liabilities, and equity.

Cash Flow Statement

DocumentDOCX

Monitor cash inflows and outflows across operations, investments, and financing activities.

Finance & Accounting Templates