---
title: "How to Generate JE - Cost Allocation (Excel)?"
description: "Generate JE - Cost Allocation (Excel)"
url: https://helpdesk.aanyahr.com/tl/articles/286-how-to-generate-je-cost-allocation-excel
collection: "How to Generate JE - Cost Allocation (Excel)?"
updated: 2024-06-25
language: tl
alternates: [en]
---

# How to Generate JE - Cost Allocation (Excel)?

Generate JE - Cost Allocation (Excel)

A **Journal Entry for Cost Allocation** is an accounting record that reflects the distribution of costs to various cost objects, such as products, services, departments, or projects. It's a crucial part of managerial accounting, aiding in measuring profitability and performance across different business activities.

To produce this report in AanyaHR, one would normally adhere to the following steps and procedures.

1.  Go to **Payroll** and select **Reports**.
    
2.  After selecting **Reports**, proceed to section **Accounting**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/H4Zd3JhHfp3OirVA9ArhPej6eq6ZLgjHoqpHBUuj9s1jbkcddFS830kz79zftOBsdKc4xqJvwiX.png)
3.  Upon selecting the **Accounting** option, all pertinent Specific Reports will be displayed for you.
    
    ![](https://staticfiles.gleap.io/ghelparticle/tQb9IVeLFkgf3tpVoKVbMlTGAUwN84noZQmc6aX8NnPamydXiLF877o6lSYJVgM7YW47CWq6Bcu.png)
4.  You may select **JE - Cost Allocation (Excel)**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/DW0DxzK4eqmABJRWQr6J1AsHRF7IWJLxG0Uce8ZBkSX2XjXfZ1ZnoOnT53Y1VHX6peU3Ue24oQw.png)
5.  If you opt for it, select the **JE - Cost Allocation (Excel)** option. Fill out the needed details.
    
    -   **Start Date** -Denotes the start of the report’s coverage period.
        
    -   **End Date** - Denotes the end of the report’s coverage period.
        
    -   **Pay out Type ID - It's either Regular, Final, SSS Mat, Special, 13th Month Pay**
        
    -   **View report** - this is to preview the report to be generated.
        
        ![](https://staticfiles.gleap.io/ghelparticle/YUo0vjELMnve9JXmwlXvE5sfM6fWIJ7Hupw4qKujsW3ZdJ4TxC296PA1p1tNdhTzvAS6OGJ412C.png)
6.  Once you have entered all the necessary information, select the **View Report** option to generate a preview of the **JE - Cost Allocation (Excel)**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/dnSAilNiYb9bqG57tFxJC5j2InDo9jB33gxE8cwf78uWHDgWvbhhoG7GMWDleThGqsUDEi6Qzcm.png)
    
7.  You will find the details displayed at the bottom section of the interface.
    
    ![](https://staticfiles.gleap.io/ghelparticle/3cXrZ0l0ZdeVBbeSt7dfNSQh6BKVgGJedwDkFT1A2MeX9YkjaHr0yrSZnCKRpt8eaXFh01Z0vyM.png)
8.  If you wish to generate the file, click the **export** button.
    
    ![](https://staticfiles.gleap.io/ghelparticle/4DKAyg8VSzK0QdYacgZ3zmls6F8gDu3mkcHRcRI5KgpcmDMavUC0RIM5ymsfBI4Mfrw04AlhsXX.png)
9.  Choose the file format you wish to use for generating the **JE - Cost Allocation (Excel)**.
    
    ![](https://staticfiles.gleap.io/ghelparticle/vwFd5vbZ39cu5rQY2pz0zvq6Qvv10YCVEU9ZJLW216QnnSRBe5rnAzPZK2ze9Gk4wHIggUry8Cm.png)
10.  To choose the Excel file, simply click on the corresponding option. The file will then begin to generate.
     
     ![](https://staticfiles.gleap.io/ghelparticle/twvGnz9vxmraIBE2AiwTrzXnN17kos8Bca0ck63rr3no67TjREY3TehTF9z6HfWPNkhcFi7O4L6.png)![](https://staticfiles.gleap.io/ghelparticle/vGCmqXwOENUYs72RcxVmJSU8I5BJ84pA4hutl1F7H8rkACS4kWg1IBzqg4YurpndcJFTVaNKs2D.png)
     
     A zip file will be created and saved to your downloads folder automatically. You can then open the file to check its contents.
     
     ![](https://staticfiles.gleap.io/ghelparticle/aR5vrMWBhSOUTfElMz91K79h2f0u2SHbALJtCYvrPdZjU3JrgToCwf4sl96FAIUjOOvcu94kgtx.png)

Go back to:

[How to Generate Acounting Reports?](https://helpdesk.aanyahr.com/en/articles/282-how-to-generate-acounting-reports.md)