Multipart article

Free Account Reconciliation Templates

by Andy Marker on Oct 23, 2018

Save time, protect financial assets, and increase accuracy with free bank reconciliation templates. You can customize all of the templates offered below for business use or for reconciling personal accounts. For more financial management tools, download cash flow and other accounting templates.

 

Balance Sheet Template

Balance Sheet Template

Calculate the balance of a company’s assets, liabilities, and equity to get a snapshot of its financial position at any given time. The template includes lines for assets such as cash, accounts receivable, inventory, and investments, along with liabilities, including accounts payable, loans, and payroll. Add your own line items to this Excel sheet, and the template will automatically calculate the totals.

Download Balance Sheet Template

Excel | Smartsheet


Accounts Payable Ledger

Accounts Payable Ledger

Use this template to track accounts payable transactions, including supplier names, invoice numbers, amounts due, and completed payments. This spreadsheet template makes it easy to organize important account information that can then be referenced for accounts payable reconciliation. Customize the template by adding or reducing columns to suit your business needs.

Download Accounts Payable Ledger

Excel | Smartsheet


General Ledger (GL) Reconciliation Template

General Ledger Reconciliation Template

Companies or individuals can use this general ledger (GL) reconciliation template for bank reconciliation. Businesses can also use it for reconciling balance sheet accounts, such as accounts payable, by editing the template to show the appropriate account information. Enter the balance from your bank statement or subledger along with the general ledger balance, and adjust amounts based on outstanding deposits and checks. The template will then reflect any variance between the records. If they are not reconciled, you can examine the records for errors or other discrepancies that need to be resolved.

Download General Ledger (GL) Reconciliation Template — Excel


Monthly Bank Reconciliation Template

Monthly Bank Reconciliation Template

This simple bank reconciliation template is designed for personal or business use, and you can download it as an Excel file or Google Sheets template. Enter your financial details, and the template will automatically calculate totals so that you can quickly see whether your bank statement and accounting journal are reconciled. To create an ongoing record, copy and paste the blank template into a new tab for each month of the year.

Download Monthly Bank Reconciliation Template

Excel | Google Sheets

 

Petty Cash Reconciliation Template

Petty Cash Reconciliation Template

Many businesses use petty cash funds to pay for minor expenditures. You can use this template for reconciling petty cash accounts to help ensure that you’ve accounted for current receipts and that cash amounts are accurate. How often you need to reconcile the account may depend on how frequently it is used.

Download Petty Cash Reconciliation Template — Excel


Credit Card Reconciliation Template

Credit Cash Reconciliation Template

Reconcile a business credit card account with transaction receipts, and create an expense report for documentation. Edit the template to include business expenses that need to be tracked. Then, enter each charge amount along with dates and account numbers. This template can be used for travel, entertaining clients, or other authorized business expenses. Make sure that your credit card statement matches the transactions reported on the reconciliation template.

Download Credit Card Reconciliation Template — Excel


Daily Cash Flow Template

Daily Cash Flow Template

This comprehensive cash flow template allows you to view a breakdown of total receipts, payments, and expenses on a daily basis. Enter the first day of the month, and the template will fill in subsequent dates, providing a detailed look at daily cash flow. The template also shows the ending cash position so that you can quickly see if it reconciles with your balance sheet.

Download Daily Cash Flow Template — Excel


What Is Balance Sheet Reconciliation?

Balance sheet account reconciliation is the process of comparing a company’s general ledger, or primary accounting record, with subsidiary ledgers or bank statements in order to identify and resolve discrepancies. Since you can perform this process with internal subledgers for specific balance sheet accounts or external bank statements, the process is also known as bank reconciliation. This is an important part of monthly accounting in order to ensure accurate records, prepare for internal audits, detect fraud quickly, and manage cash flow. Individuals can also reconcile monthly bank statements with personal records to make sure they know their actual bank account balance and avoid overdrafts.

 

What Is Reconciliation in Accounts Payable?

Reconciling an accounts payable (AP) account involves matching the general ledger balance with the AP subsidiary ledger (or other record showing AP transactions). If the two ledgers match up, the accounts are reconciled. If not, the two ledgers need to be compared closely to identify errors such as missing or incorrect entries.

This process is typically performed monthly for efficiency and to prevent errors from carrying over from one month or year to the next. Accounts payable reconciliation may be done manually or with software, depending on the size of your business and accounting needs.

 

What Is the Accounting Reconciliation Process?

Documentation is important for all aspects of accounting, and organizations typically have reconciliation policies that must be followed, including due dates for submitting completed reconciliations. Here are the basic steps involved and the items to track as you reconcile accounts:

  • Gather and Compare Records: Depending on the accounts you plan to reconcile, inspect and compare bank statements or subsidiary ledgers to a general ledger or personal accounting records. You may need to collect more than one financial report or records of deposits and checks in order to get a complete view of transactions. When comparing a bank statement to an accounting journal, take into account service charges, interest, and other fees. Outstanding checks or deposits won’t appear on the bank statement, so your comparison also needs to consider these factors.
  • Identify Discrepancies: Once you have adjusted your ledger for outstanding transactions as well as fees and other charges, the two records should reconcile. If they don’t, look for any discrepancies between the bank statement and general ledger, which may occur due to bank errors or internal errors on the part of a company or individual.
  • Resolve Discrepancies: Investigate any unusual or missing transactions to find the source of the issue and make corrections. Contact the bank about errors that they appear to be responsible for, and keep an eye out for errors that you or an employee may have made.

Reconciling accounts on a regular basis can help to maintain an efficient process, reduce errors in the long run, and limit the stress of dealing with financial discrepancies.


Improve Account Reconciliation with Real-Time Work Management in Smartsheet

Account reconciliation templates are a critical building block if you want to get your organization’s — or your own — finances in order. Once you’ve established that foundation, take your team to the next step with a powerful tool that helps standardize your process and manage the flow of cash and assets.

Smartsheet is an enterprise work execution platform that is fundamentally changing the way businesses and teams work. Over 74,000 brands and millions of information workers trust Smartsheet to help them accelerate business execution and address the volume and velocity of today's collaborative work.

The familiar Smartsheet interface that is designed for how people actually work leads to rapid and broad adoption across your organization. Use self-service reports and dashboards in Smartsheet to provide real-time visibility into resources, status, and performance, so you can rapidly align operations with strategy.

Discover why millions of professionals around the world use Smartsheet to move from idea to impact fast.

Try Smartsheet for Free


Discover why over 74,000 brands trust Smartsheet to get work done.

Try Smartsheet for Free