How to Create a YTD Capital Expense Report

report YTD capital expense

show YTD capital expense

A year-to-date (YTD) capital expense report helps organizations monitor total capital spending against budget or forecast. It supports proactive financial management and aligns with reporting and compliance needs. Furthermore, it allows organizations to make better decisions and set accountability across departments.

To create a YTD capital expense report, do the following:

1. Navigate to Reports.

2. Click the New icon, and then select Dynamic Report.

3. Select the Financial Reporting Area, and then click OK.

4. Drag and drop the following to create the dynamic report structure:

   1. Drag the Company, Scenario, and Time dimensions to the Page axis.

   2. Drag a capital expense report set to the Row axis. To learn more about creating a report set, click here.

   3. Drag the Measures dimension to the Column axis.

   4. Click on each dimension and select members. In this example, a YTD capital expense report is created for Total Company at planned actuals for the year 2018.
      

5. (Optional) Click Show Header & Footer to customize the report header or footer with elements like report name, company, current date, or scenario.

6. Click Run to generate the YTD capital expense report.
   

7. Click Save to store the report in the File Cabinet for future use.

In this example, the Capital Expense Report Set is used to generate the 2018 YTD Capital Expense Report.