Free tools & templates

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.

Newest to Oldest
Sort By
An image of a Lease Liability and ROU (Right-of-Use) Asset Calculator within the NetLease software by Netgain. The image shows a section of an Excel spreadsheet with input fields for incremental borrowing rate, lease payments, direct costs, and other variables. A table below calculates the period payments and their present value over a twelve-month period, with totals for lease liability and ROU asset at the bottom. The NetLease logo is displayed in the top right corner, emphasizing the brand's presence in the interface.

ROU asset & lease liability calculator

Download the free ROU Asset and Lease Liability Calculator. Calculate the Net Present Value of your Lease Payments quickly and dynamically in Excel.

Lease accounting
April 1, 2024
A graphic depicting the usage of a fixed asset accounting checklist

Fixed asset accounting checklist

Fixed asset accounting can be complex. To help you navigate the challenges, we’ve created a comprehensive fixed asset accounting compliance checklist.

Fixed asset management
October 1, 2024
Spreadsheet template for managing short-term leases, detailing transactions for a lease classified as 'SHORT-TERM'. The table lists transaction types with period numbers and dates, lease payments, lease expenses, amounts allocated to deferred rent, and the deferred rent balance. Below, sample journal entries for 'Prepaid Lease Payment', 'Rent Abatement', and 'Monthly Lease Payment' show debit and credit columns with specified amounts. This template is designed to aid in the financial management and reporting of leases, with clearly defined categories and amounts to ensure accuracy and facilitate compliance with accounting standards.

Short-term & low-value lease tool

This workbook will help you calculate the schedule for lease payment, lease expense, and deferred rent using short-term and low-value lease exemptions.

Closing the books
Loan management
A financial spreadsheet with tables showing income statements, balance sheets, and journal entries for operating and finance leases across two years. Key figures include revenue, expenses, assets, and liabilities, with various monetary values listed.

Operating vs finance lease journal entries examples

Understand typical journal entries for operating and finance leases under ASC 842 and explore their financial statement impact with this comprehensive tool.

Lease accounting
August 1, 2024
A screenshot of a table from the monthly close checklist. It lists various financial tasks like verifying expenses, preparing payroll accruals, and reviewing credit card statements, categorized under "Accruals" and "Accounts Payable." Columns include frequency and preparer.

Monthly close checklist

Streamline your month-end close process with our free checklist template. Ensure accuracy, reduce errors, and speed up your close each month.

Closing the books
June 1, 2024
An image of a lease accounting schedule. It shows lease details including start and end dates, borrowing rate, and initial costs. The monthly journal entries and amortization schedule from 11/1/2020 to 1/1/2022 are listed with debits and credits for lease liabilities and expenses.

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.

Lease accounting
Loan management
Comprehensive spreadsheet detailing a financial lease schedule and guide, split between Finance and Capital lease classifications. The table includes various entries for lease terms, commencement dates, interest rates, monthly journal entries, and a series of procedures for lease payment, expense, and interest accretion. It provides a detailed lease liability balance and depreciation expense over multiple periods. The spreadsheet is part of Netgain's lease accounting tools, showcasing an in-depth approach to complying with accounting standards such as ASC 842. Color coding helps distinguish different sections for clarity and ease of reference.

Financing leases schedule and guide

Download the free Financing eases Schedule and Guide. This auditor-style workbook helps you transition financing leases from ASC 840 to 842.

Lease accounting
October 11, 2023
An image of a 'Risk Free Rate Calculator' spreadsheet. This financial tool is designed to compute the appropriate risk-free rate for leases. The calculator features fields for entering the 'Lease Name', 'Lease Term in Months', and the 'Date' for which the rate is to be calculated. The calculated risk-free rate is prominently displayed. A note explains that the tool pulls rates from U.S. Treasury bond terms to find the appropriate rate for lease terms not covered by standard periods. The layout is simple and user-friendly, with a clear focus on functionality and ease of data input for financial analysis.

Discount rate calculator‍

Download this free tool to determine the applicable risk-free rate and view the formulas used to calculate it. Gain insights into the calculation process.

No items found.
December 1, 2023
Silhouette of a person from behind, gazing at a large projected graph displaying a rising trend with a prominent red arrow. The setting suggests a business or academic environment, with the individual possibly analyzing financial data or market trends. The focus on the upward trend implies a positive outlook or increase in the context being studied.

Accounting policy memo example

Download this free template to document the method used to calculate your discount rate, providing additional support for your auditors and ensuring compliance.

No items found.
August 1, 2023
Document titled 'ASC 842 Disclosure Report Example' providing a detailed guide on lease reporting requirements. The background section states that under ASC 842, lessees must disclose both quantitative and qualitative information about their leases. This document serves as an example of the required quantitative disclosure calculations for lease portfolios, with sections explaining how to navigate the workbook. It includes instructions for supplemental balance sheet information, an undiscounted lease maturity waterfall, supplemental cash flow information, components of lease costs & impairments, short-term lease census, and weighted average calculations. Each section has a brief description of the report it provides, all aimed at supporting financial disclosures and compliance with the new lease accounting standards.

ASC 842 disclosure report example‍

Download a free ASC 842 disclosure report. This workbook includes quantitative calculations for your lease portfolio, featuring operating and financing leases.

Lease accounting
May 27, 2024
No results were found.
Unfortunately, we couldn't find any matches for your search. To help you find what you're looking for, try refining filters!

See why Netgain is trusted by thousands of accounting teams

Say goodbye to your insane workload.
Say hello to fearless financials. Meet Netgain.