---
title: "“How to Download the YTD - (Excel)”"
description: "This article will guide you through the process of downloading the YTD – (Excel) file."
url: https://helpdesk.aanyahr.com/tl/articles/374-how-to-download-the-ytd-excel
collection: "Annual Reports"
updated: 2024-08-20
language: tl
alternates: [en]
---

# “How to Download the YTD - (Excel)”

This article will guide you through the process of downloading the YTD – (Excel) file.

The YTD - (Excel) file provides a summary of all payroll-related data accumulated from the beginning of the year to the current date, similar to the YTD\_All (Excel) file. However, the YTD\_All (Excel) file currently does not include the 2316 details from previous employers, which are available in the YTD - (Excel) file. This feature will be added to the YTD\_All (Excel) file in the future.

1.  Go to **AanyaHR** and Login to your account.
    
2.  In the Payroll menu, go to “**Reports**”, select “**Annual Reports**”, and then choose **“YTD - (Excel)”.**
    
    ![](https://staticfiles.gleap.io/ghelparticle/90XrKDFRqy81trk6lfuB0gQ1RTJPL9kGS2q6RQeF3T65Sg1kihOFpIgVsfjszyR3TNYatOaQRpY.jpg)
3.  Choose the necessary data from the dropdown list.
    
    ![](https://staticfiles.gleap.io/ghelparticle/6729RqtFgfS3xl2HuBSS4L62yZvn8f6FHbAESM6TZiwFVO9uAImcgbACq34l3nG3u3GMBp38pFX.jpg)
    
    **Sub Company:** Choose the specific sub-company you wish to include or click **“Select All”** to include all available options.
    
    **Branch:** Select the specific branch you need or choose **“Select All”** to include every branch.
    
    **Department:** Choose the specific department you want to include or choose **“Select All”** to include all departments.
    
    **Employee Status:** Select the relevant employee status (Regular, Probationary, Terminated, Resigned, On-Hold, Contractual, or Custom), or click **“Select All”** to cover all employee status.
    
    **Employee:** Choose the specific employee for whom you want to generate data or click **“Select All”** to include all employees.
    
    **Year:** Select the applicable year for which you wish to generate data.
    
4.  Click **"View Report"** to display the selected report.
    
    ![](https://staticfiles.gleap.io/ghelparticle/x7iZ82OTTyhlMzhirMSASgw5jCF3alA1y2DwwF6kzYw6LS9bCJ6JSwIiFDxn1Kw3xi1Fvg4kN8y.jpg)
5.  Click the **“downward arrow”** in the box to choose the file format for export.
    
    ![](https://staticfiles.gleap.io/ghelparticle/gy6Wx82MaDncXAkr3yfC4WrgPDrUsuSyp7LY3txoCck0cAMeHW7VaPaC2fIw3HCbPVlbtGUCd0x.jpg)
6.  Select **"Excel"** to export the file in Excel format.
    
    ![](https://staticfiles.gleap.io/ghelparticle/10R5TJzyCyPhe587x78xmX1D9j0TEUg4LY21cZWF0IiIucq96c9ZYSHGFW9cDQm1uEyRAFBkdz4.jpg)
7.  A file will be created and saved automatically to your Downloads folder. You can then open the file to review its contents.
    
    ![](https://staticfiles.gleap.io/ghelparticle/2BvB1hZ8tzcLjO2GcvN1jrH6UOMfybEKCZ7Bptw1X0qrL1s8OTjQYOKi6W6se8s9RUrB5HkfLwP.jpg)