Crunchafi

Quick Tips: Reporting

Crunchafi Lease Accounting allows users to export comprehensive Excel reports—including Journal Entries, Amortization Schedules, and Footnote Disclosures—for leases in Complete status, each containing detailed data, criteria, and lease information tabs, with customizable columns and options like "Include Data by Lease" to facilitate accounting integration and compliance with lease accounting standards.

Exporting Entered Leases

Once your lease is entered and complete, you can begin pulling reports at the bottom of the My Leases screen. Amortization Schedules, Journal Entries, Footnote Disclosures, and a collection of all data are readily available with the push of a button.

Reporting 101

Crunchafi Lease Accounting offers multiple reports for leases in Complete status. Every report is exported into Excel and includes 3 tabs:

  • The Data tab includes the details of each report run: Journal Entries, Amortization Schedule, or Footnote.
  • The Criteria tab includes the criteria used to run the report.
  • The Leases tab includes all lease data for the leases selected when the report was exported, along with a hyperlinked lease ID that links back to the lease in the software.

Tips on Journal Entries

Columns are customized each time a report is exported to ease importing into accounting systems. This report exports data monthly and can be quickly pivoted to create aggregate entries.

The Journal Entries report is also run with Data by Lease by clicking the "Include Data by Lease" checkbox.

This report includes a tab called Data by Lease with values for each lease selected.

If you are interested in learning how to set up a pivot table, please reference the Knowledge Base.

Tips on Amortization Schedule

This report is used to see the entries and balances for a lease or group of leases.

The Amortization Schedule is also run with Data by Lease by clicking the "Include Data by Lease" checkbox.

This report includes an additional tab in the export called Data by Lease with values for each lease selected. The columns to the right include the Lease Name and additional lease information.

Tips on the Footnote

The Footnote reporting automatically includes quantitative disclosures as required by the lease accounting standards, reducing the burden on accounting teams. This report includes additional calculations such as:

  • Finance lease amortization and interest expense
  • Operating lease expense
  • Weighted averages

Reminder: Deleted leases are not included in the footnote, so make sure the timing of the deleted leases is taken into account. Please see our Knowledge Base article "When Should Leases be Deleted?" for more information.