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.
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
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
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.
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
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.
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.
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.
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.
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.
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:
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.
Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.
The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed.
When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.
