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

# “How to Download the YTD_ALL (Excel)”

This article will guide you through the process of downloading the YTD_ALL Excel file.

The Year-to-Date (YTD) Excel file in payroll provides a comprehensive summary of all payroll-related data accumulated from the beginning of the year to the current date, including earnings, deductions, and taxes.

1.  Go to **AanyaHR** and Login to your account.
    
2.  In the Payroll menu, go to “**Reports**”, select “**Annual Reports**”, and then choose **“YTD\_ALL (Excel)”**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/mieuIcMEVBDvyfIlwA1AoADKwu6dBxmRKk9FMxyvBAHStENUEn9YgovGhrfhhXxNTJVRENLUkc4.jpg)
3.  Choose the necessary data from the dropdown list.
    
    ![](https://staticfiles.gleap.io/ghelparticle/XSNE0EPcCAD6CCEZHWwH66jmOjmiNZoB3lBywxN7H63Rf7fsURbsIjCaMggqadTOoOVGV6i8Wti.jpg)
    
    Year – Select the applicable year for which you wish to generate data.
    
    Company – Choose the relevant company or select “**All**” if you wish to include all available options.
    
    Branch – Select the specific branch or choose “**All**” to include every branch.
    
    Employee – Choose the specific employee for whom you wish to generate data or select “**All**” to include everyone.
    
4.  Click the downward arrow icon to download the Excel file.
    
    ![](https://staticfiles.gleap.io/ghelparticle/F2c1bXRhEFA0QQdWfsUcvFrDABy89J5Ko0jGcHiCvJB4r8yWhojr9Khn4asnWrnxWCphSm8H2PX.jpg)
5.  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/muQUo2khCvnxN20YjWpGRc1EPt2dU73Sb5E2SSmDju8gq9Gh8AFRtj64wQRyBnq6dkwQXtdHD16.jpg)