Share this
Automating the Roll Forward Report
by Matt Waters, CPA on June 8, 2020
Roll forward reports, commonly requested by auditors for each audit, have long been known for being demanding and taxing on company resources. But there’s no need to spend hours each period inputting data manually. With innovative lease accounting software, lease accounting data can automatically merge into a roll forward report so that anytime it is requested, it is available with a touch of a button.
An auditor needs the roll forward report to examine company accounting records. The report displays the beginning balance, all transactions for the selected period, and the ending balance.
The roll forward report presents an organization’s financial balances from the beginning to the end of a period, which could be monthly, quarterly, year-to-date, or annually. Each lease held is listed on the report by row and contains separate columns of categories: scheduled amortizations, additions, terminations, impairments, renewals, adjustments, ROU asset balance closing, and liability balance closing.
Creating the roll forward report each time it’s requested can be challenging to accomplish manually using a spreadsheet application like Excel. For each lease, an accountant would have to input all journal entries that have been posted to an account and then classify them into the previously mentioned categories. However, the entire process can be automated with lease accounting software. The roll forward report automatically captures the beginning and ending balances and tracks changes in real-time, so the report is available at any time with the touch of a button.
Share this
- ASC 842 (80)
- Lease Accounting Software (66)
- Accounting Teams (39)
- Lease Administration Software (20)
- Retail Tenants (14)
- Commercial Real Estate (12)
- Lease Management (10)
- Market Data and Analytics (7)
- Real Estate Teams (7)
- ESG (5)
- Success Stories (5)
- News and Media Coverage (4)
- Transaction Management Software (2)
- Customer Success (1)
- Office Tenants (1)
- October 2024 (4)
- September 2024 (2)
- August 2024 (5)
- July 2024 (3)
- June 2024 (3)
- May 2024 (4)
- April 2024 (1)
- February 2024 (1)
- December 2023 (4)
- November 2023 (6)
- October 2023 (4)
- September 2023 (2)
- August 2023 (2)
- July 2023 (3)
- May 2023 (2)
- March 2023 (1)
- February 2023 (3)
- December 2022 (3)
- November 2022 (4)
- October 2022 (4)
- September 2022 (1)
- August 2022 (4)
- June 2022 (1)
- May 2022 (4)
- April 2022 (8)
- March 2022 (3)
- February 2022 (1)
- October 2021 (2)
- September 2021 (1)
- August 2021 (15)
- July 2021 (3)
- June 2021 (1)
- May 2021 (1)
- April 2021 (3)
- March 2021 (1)
- January 2021 (1)
- December 2020 (3)
- November 2020 (1)
- October 2020 (2)
- September 2020 (2)
- August 2020 (3)
- July 2020 (2)
- June 2020 (3)
- May 2020 (1)
- April 2020 (1)
- March 2020 (1)
- February 2020 (1)
- December 2019 (1)
- October 2019 (1)
- September 2019 (2)
- August 2019 (3)
- July 2019 (2)
- April 2019 (69)
- October 2018 (1)
- August 2018 (1)
- July 2018 (1)
- June 2018 (1)
- May 2018 (1)
- April 2018 (2)
- March 2018 (3)
- February 2018 (2)
- December 2017 (1)
- August 2017 (3)
- June 2017 (2)
- May 2017 (2)
- April 2017 (1)
- March 2017 (2)
- January 2017 (2)
- November 2016 (2)
- July 2016 (1)
- June 2016 (1)
- July 2015 (1)
- March 2015 (1)
- June 2014 (1)
- April 2014 (11)
- October 2011 (1)
You May Also Like
These Related Stories