---
title: "How to Generate Bank File – BPI (Excel)"
description: "This article walks you through generating a BPI-compatible bank file using Excel, including all the steps and data requirements for proper formatting."
url: https://helpdesk.aanyahr.com/tl/articles/366-how-to-generate-bank-file-bpi-excel
collection: "Custom Report"
updated: 2024-08-20
language: tl
alternates: [en]
---

# How to Generate Bank File – BPI (Excel)

This article walks you through generating a BPI-compatible bank file using Excel, including all the steps and data requirements for proper formatting.

Learn how to structure your data correctly, input the required fields, and generate a file that meets BPI’s specifications for smooth financial transactions. This guide simplifies the process of creating accurate and compliant bank files.

1.  Go to **AanyaHR** and Login to your account.
    
2.  From the **Payroll** menu, navigate to the **Custom Report** section, then click on **"Bank File"** and select **"BPI (Excel)".**
    
    ![](https://staticfiles.gleap.io/ghelparticle/7xtAstWdlz8byezXrx9EQAhvYfutC1g2n29Z3fe4P0aMdxQcdsJ7epFYJk8XljJkDbKsNGwkUBV.jpg)
3.  Select a **value** from the dropdown list provided.
    
    ![](https://staticfiles.gleap.io/ghelparticle/9BMc8NvhkGTT7LLBfqMZlIwJVDryxbDurM5mrYI2zENyrzyPiKndTEPjDV1TXRmq0yqXxS04wGy.jpg)
    
    **Month**: Choose the month for which the bank file is applicable.
    
    **Cutoff**: Select the cutoff period relevant to the bank file.
    
    **Year**: Choose the year in which the payroll was processed for the bank file corresponding to the selected month.
    
    **Payout Type**: Choose the appropriate payout type required for the bank file you want to generate.
    
4.  Click **"View Report"** to display the selected report.
    
    ![](https://staticfiles.gleap.io/ghelparticle/4cNgxF5OpvWMQOrGKqeAgesgE2cJjZQJreoItbfqJzmKvX4oDLU0uFCstho2xkvB36OAF2JCwnQ.jpg)
5.  Click the **“downward arrow”** in the box to choose the file format for export.
    
    ![](https://staticfiles.gleap.io/ghelparticle/TQgW82rm2e6dz2KdG1NbHbRN3JJWKQAYV0Uvb80f2E3Gp13WtkWDP6ajylOKR3wttSTheyiQAR2.jpg)
6.  Select **"Excel"** to export the file in Excel format.
    
    ![](https://staticfiles.gleap.io/ghelparticle/GfuAY0Xfpzaphwr2yx4Q3PNE0WccfaFchMYbhbrKzR9gKk21G2YOWKdHb8eeOIHwxn9qz3g3KkO.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/21XmpbT5zueJQnkUYHyexMroQhNGjWcFCEVd6ZSsOsbX2ZsHKy5b24rcTAwb3mRa0S79SGyxLtR.jpg)