---
title: "How to Generate YTD_ All (Excel)?"
description: "Generate YTD_ All (Excel)"
url: https://helpdesk.aanyahr.com/tl/articles/280-how-to-generate-ytd_-all-excel
collection: "How to Generate YTD_ All (Excel)?"
updated: 2024-06-24
language: tl
alternates: [en]
---

# How to Generate YTD_ All (Excel)?

Generate YTD_ All (Excel)

Please follow the outlined steps below for guidance on **How to generate the YTD \_ All (Excel)**.

1.  Go to **Payroll** and select **Reports**.
    
2.  After selecting **Reports**, proceed to section **Annual Reports**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/Q3oa6uFQ94crjuWsNFfIRUpDOQB6A7o8dQfkn0Xcp2RyzAKbCPKKQEHNugccowyUudFvwP10eOA.png)
3.  After choosing the **Annual Reports** option, you will be presented with all the relevant Specific Reports.
    
    ![](https://staticfiles.gleap.io/ghelparticle/ho5OtPsDEtMQ5zHXxADOEa6dwMM39kdNoqFJQyDj0PIPuGUP3KHHiC8OALEHqDLWKUimcB7WGle.png)
4.  If you select the **YTD \_ All (Excel)**, go ahead and click on it.
    
    ![](https://staticfiles.gleap.io/ghelparticle/0OjS8dVdUHV0K6cenpiWshMRep0uWFFBOBwvEXayv9yLwKJJO9wz3f3sUKnCK3El5GtWhu77Nyr.png)
5.  Fill out the needed details.
    
    ![](https://staticfiles.gleap.io/ghelparticle/Bpn3g6GfYwx4lg21KFTcxWbhljJc2CnLcNH6nl7fOVoweSVaVE0WrOwLVQ20EbcC4uyuz7zoLsS.png)
    -   **Year** - Choose the **year** for which you wish to generate the Alpha List DAT from the dropdown menu.
        
    -   **Company** - From the dropdown menu, select the **company** for which you want to create the Alpha List DAT.
        
    -   **Branch** \- select the specific branch or you have the option to select **ALL**.
        
    -   **Employee -** select the specific employee or you have the option to select **ALL**.
        
    -   **Export Icon** - the button to be clicked to start downloading the file or report.
        
6.  Once the details have been completed, click the export button.
    
    ![](https://staticfiles.gleap.io/ghelparticle/5E8wOdEWbDwlla53HMDdeh52LyagFRKsagOzobushPVcuUlcl5n3z101kCBn1gxTQm89HhbU5hZ.png)
7.  After the download is complete, the report will be created automatically. To view the report, simply click on it.
    
    ![](https://staticfiles.gleap.io/ghelparticle/joBJVG3Wt7EXEjERaXB5BkjAzn3iOQiqh7cNMUEQ1TzHGCXIftrnsayCzbhqNxYIz4PalekQ8ef.png)

Go back to:

[How to Generate Annual Reports?](https://helpdesk.aanyahr.com/en/articles/276-how-to-generate-annual-reports.md)