---
title: "How to Update Loans Using “Update Loan Upload Template”"
description: "This article will guide you on how to update loans in bulk using the update loan upload template."
url: https://helpdesk.aanyahr.com/tl/articles/359-how-to-update-loans-using-update-loan-upload-template
collection: "How to Update Loans"
updated: 2024-08-06
language: tl
alternates: [en]
---

# How to Update Loans Using “Update Loan Upload Template”

This article will guide you on how to update loans in bulk using the update loan upload template.

1.  Go to **AanyaHR** and Login to your account.
    
2.  Go to **Payroll** \> then select "**Loans**".
    
    ![](https://staticfiles.gleap.io/ghelparticle/o2UxB4gXVBVhyBmaafSwSTx92ECmnqVEeGo0jGii07iVIjM8JTCJCHC1zn70y6mTWvtVknqdyyx.jpg)
3.  Click **“Upload”** to proceed on the Data Upload screen. Then click **“Documents”** to see dropdown list and select **“Update Loans Upload”.**
    
    ![](https://staticfiles.gleap.io/ghelparticle/dCNdZanH6eo9vwaquuwzvz3J9OKkVYg6EU5zjjeyABhPtvg6xGGRAqQHTjT8NJBhA4Q2TfrhTvP.jpg)![](https://staticfiles.gleap.io/ghelparticle/pcLi3fdxKToIsc2mOe33p1IHRjhtAvz0Kw0BS5eCmzi2JRF1OiUeMLft3kZ8ECzd7QoFdlLmxmw.jpg)![](https://staticfiles.gleap.io/ghelparticle/e4oGz8q9Eh1NitwI639hatpLB4tbPuh5TAbALxU106vrpjDblxBvTLE2Nn9cp0Ijf0qqXo3TLxE.jpg)
4.  Click the **“Download Template”** icon to display the fields you need to complete before downloading the file.
    
    ![](https://staticfiles.gleap.io/ghelparticle/0RXn37Eq9NkkoMpA3vxBiZzUPLiSQEYEBUrelnArGXlvBs3s2f6PI0JZkiB1pVJ1Bx3ipGc9hz5.jpg)
5.  Fill out all the necessary fields, then click **“View Report”** to see the files.
    
    ![](https://staticfiles.gleap.io/ghelparticle/yIvXPmzRQftyAtEI8v3ZC1VGjR87LcimxQThjQNhhtNcp1SEKzXQkhBaY7xZ6LWtpDlKLK155dF.jpg)
6.  Click the **“Export”** icon and choose “**Excel**” from the dropdown menu to download the file.
    
    ![](https://staticfiles.gleap.io/ghelparticle/e5u9E0vF6NDH7LzQ9NMXQRu6Gn6FUkkg9jEZexAxhovbbrVJiGmsy52uEPLRvPsw2gTmi5heP2Q.jpg)
7.  Click **“Open File”** to access the **“Update Loans Upload Template”.**
    
    ![](https://staticfiles.gleap.io/ghelparticle/YxZPkQaEYq0tm2tsEZsFvtRmPpQJyOHGOUpMRVARPuJMViCc1Ce6NOU7122RHVImNWEw5ZAP2QD.jpg)![](https://staticfiles.gleap.io/ghelparticle/o6tTBONc777eTH0Fs4cxf2SAuVyioku6jU4z8S6Iasp3T4lEBvziPdBGcrHPY0XkXztK3RkMjth.jpg)
    
    _Note:_
    
    **_“ID”_** _in column A is a system unique identifier for each entry. Do not edit or remove._
    
    Once you have entered all the details you want to update, save the file in Excel Workbook (\*.xlsx) format.
    
8.  Click **“Upload File”**, choose the saved **“Update Loans Upload Template”**, and then click the **“Save”** icon.
    
    ![](https://staticfiles.gleap.io/ghelparticle/pVKrxiBDQ95v8pDAEyoNLIRE1QLJLLuJWx6RrGnUjo8La3TO9OWiiBjIwoHzH9YKJFUs6RcIItr.jpg)
    
    _Note:_
    
    _You can check loan balances in Payroll - Loan History (Excel)._
    
    _See the link below for more information:_
    
    [How to Generate Payroll - Loan History (Excel)? | AanyaHRV2](https://helpdesk.aanyahr.com/en/articles/313-how-to-generate-payroll-loan-history-excel.md)