Free accounting tools

Simplify & automate
your accounting

These spreadsheet tools, designed by our team of accountants, auditors and CPAs, help you transition, close and calculate. These tools can get you started—for fully-featured solutions, see our software.

Free accounting tools

Lessee transition guides

ASC 842 Transition Blueprint & Workbook

This auditor-style workbook helps you transition from ASC 840 to 842. This guide helps accountants understand the formula-driven calculations, step-by-step procedures and day 1 journal entries required.

ASC 842 Lease Amortization Schedule

Using spreadsheets to comply with FASB’s ASC 842 and IFRS 16 is complex and difficult to manage, but if you only have a few leases, it is possible with this template

Financing Leases Workbook and Guide

This auditor-style workbook helps you transition financing leases from ASC 840 to 842. The transition for financing leases is much simpler than that of operating leases.

ASC 842 Transition Disclosure Template

The transition for lessors and lessees from ASC 840 to ASC 842 is considered a change in accounting principle and requires a transition disclosure. Start with this template.

Lessee accounting consideration tools

Operating vs. Finance Lease Journal Entries Examples

Better understand the typical journal entries found with an operating lease and a finance lease under ASC 842, as well as the financial statement impact of those journal entries with this tool.

Embedded Lease Test

Don’t be surprised by embedded leases under ASC 842. This tool takes you through the guidance to determine if a contract has an embedded lease.

ROU Asset and Lease Liability Calculator

Calculate the Net Present Value of your Lease Payments quickly and dynamically, including any prepayments, initial direct costs, or lease incentives.

Short-Term & Low-Value Lease Tool

Calculate the schedule for lease payment, lease expense, and deferred rent for leases using short-term/low-value lease exemptions.

Lease and asset tools

Lease vs Buy Calculator

Change the assumptions in this spreadsheet and see the accounting impact your leases/loans have on your financial statements.

Lease vs. Loan Calculator (Seller's Perspective)

Explore leases vs. loans under ASC 842 with this workbook. Change assumptions to see the financial implications from the lessor’s perspective.

Discount Rate Calculator

Find the appropriate risk-free rates for leases, especially for lease terms that fall in between the standard treasury bond terms.

Accounting Policy Memo Example

Document the method used to calculate your discount rate as additional support for your auditors.

Closing tools

Monthly Closing Checklist

This template checklist of procedures that must happen each month helps accounting teams close efficiently and accurately. Consistency month after month speeds up close and reduces errors of omission.

Trusted by thousands of public and
private organizations world-wide

Netgain accounting software customer logos