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.
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.
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
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.Â
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.
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.
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.
Calculate the Net Present Value of your Lease Payments quickly and dynamically, including any prepayments, initial direct costs, or lease incentives.
Calculate the schedule for lease payment, lease expense, and deferred rent for leases using short-term/low-value lease exemptions.
Change the assumptions in this spreadsheet and see the accounting impact your leases/loans have on your financial statements.
Explore leases vs. loans under ASC 842 with this workbook. Change assumptions to see the financial implications from the lessor’s perspective.
Find the appropriate risk-free rates for leases, especially for lease terms that fall in between the standard treasury bond terms.
Document the method used to calculate your discount rate as additional support for your auditors.
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.
"*" indicates required fields
"*" indicates required fields
"*" indicates required fields
"*" indicates required fields