---
title: How to mass upload bills?
description: Get more things done by mass-uploading bills! Table of Contents Start by downloading a copy of this mass upload bills template Once you've downloaded the template, start filling all the columns with t
---
[Skip to content](https://help.peakflo.co/how-to-mass-upload-bills#main-content)
[](https://peakflo.co/)
- [Go to Customer Portal](https://help.peakflo.co/tickets-view)
- [Go to peakflo.co](https://peakflo.co/)
Open main navigation
Close main navigation
- [Go to Customer Portal](https://help.peakflo.co/tickets-view)
- [Go to peakflo.co](https://peakflo.co/)
Hello! How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://help.peakflo.co/?hsLang=en)
2. [Accounts Payable](https://help.peakflo.co/accounts-payable?hsLang=en)
3. [Bill Management](https://help.peakflo.co/accounts-payable?hsLang=en#bill-management)
# How to mass upload bills?
Get more things done by mass-uploading bills!
**Table of Contents**
- [Mass Upload Bills](https://help.peakflo.co/how-to-mass-upload-bills#bill)
- [Mass Upload Bill Line Items ](https://help.peakflo.co/how-to-mass-upload-bills#line-item)
---
### **Mass Upload Bills**
**[Start by downloading a copy of this mass upload bills template](https://docs.google.com/spreadsheets/d/1FJ1s1LcDTPHLvQpg5_ouoGDRJQloI_Gf/edit?usp=sharing&ouid=103972408069231459074&rtpof=true&sd=true)**
Once you've downloaded the template, start filling all the columns with the bill details that you want to be uploaded.
Here are some important things to keep in mind when entering the details into the template.
- **Vendor Type** - Choose only between individual and company.
- **Bank Country and SWIFT codes** - Must be in alpha-2 code. You can find country codes along with the SWIFT codes in the alpha-2 code [here](https://docs.google.com/spreadsheets/d/1QSiRab-RjmBFa8tXR7YT4aMEJ8XzvLQFlPU_gpYPju0/edit#gid=0).
- **SourceCurrency & TargetCurrency -** Must be in 3 letters. You can find country currency codes [here](https://www.iban.com/currency-codes).
**Note:**
- When bills are uploaded, if the vendor referenced in the bill already has a default **Purpose of Transfer** assigned, this default will automatically be applied to the bill.
- When bills are uploaded, if the beneficiary account currency, base tenant currency, wallet currency, and bill currency are matched, the system will automatically designate the **Payment Channel** as “LOCAL”.
Once your mass upload bill sheet is ready, go to **"Settings"** and under the **"Import"** section, click on **"Mass upload bills"**
Now you will be redirected to the **'Upload a file'** page. Here drag and drop the Excel file that contains all the bill details to be uploaded.
In the next section, select the header row of your sheet to ensure the data is accurately represented and click **'next'**.
In the Map template columns section, ensure the CSV column and template column are the same. If not, you can change it by selecting from the dropdown list. You can also delete particular columns by selecting the checkbox under delete. Once you've verified all the templates, click **'next'** to proceed to the last section.
**'Clean and Finalize'** is the last section where you'll have to check all the details before reviewing. If any formatting errors are shown, click **'Fix all formatting errors'** or **'Fix formatting errors'** to clear any errors found.
Once there are no errors, click **'Import'**.
.png?width=688&name=Mass%20Upload%20Bills_Clean%20and%20Finalize(2).png)
After clicking **'Import'**, you will see notifications on your screen that the bills were successfully imported.
If you go back to the **'Bills'** section, you will find the recently imported bills.
---
### Mass Upload Bill Line Items
[**Start by downloading a copy of this mass upload bill line items template.**](https://docs.google.com/spreadsheets/d/17LgYqVJ_5EIyeH2krO-ehBUX6zs1QSQP6VGY2850Twk/edit?usp=sharing)
Once you've downloaded the template, start filling all the columns with the bill and bill line item details that you want to be uploaded.
If your Excel file includes multiple rows with the same **Bill Number** and **Bill Issue Date**, the system will consolidate this information into a single bill, which will encompass multiple line items associated with that Bill Number.
Once your mass upload bill sheet is ready, go to **"Settings"** and under the **"Import"** section, click on **"Mass upload bills"**. Click on **"Upload Bills"**.
Now you will pop-up page. Here drag and drop the Excel file that contains all the the bill and bill line item details to be uploaded.
In the next section, select the header row of your sheet to ensure the data is accurately represented and click **'Next'**.
Map the Columns in your file with the Template Fields. Once done, click on "**Next**".
Then verify your data. The system-identified anomalies will be highlighted in red.
Recheck and edit the data, then click "**Submit**". Peakflo will process and upload the payment details in a few minutes.
If the upload was successful, the status will show as **Completed**. Else, it will show **Failed**.
If an upload fails, please click on the upload to review the reason for the failure. After addressing the identified issue, you can follow the same steps to re-upload the file.
- [New to Peakflo?](https://help.peakflo.co/new-to-peakflo?hsLang=en)
- [Accounts Payable](https://help.peakflo.co/accounts-payable?hsLang=en#main-content)
- [Getting Started](https://help.peakflo.co/accounts-payable?hsLang=en#getting-started)
- [Rules](https://help.peakflo.co/accounts-payable?hsLang=en#rules)
- [Approval Workflow](https://help.peakflo.co/accounts-payable?hsLang=en#approval-workflow)
- [Custom Fields](https://help.peakflo.co/accounts-payable?hsLang=en#custom-fields)
- [Vendors](https://help.peakflo.co/accounts-payable?hsLang=en#vendors)
- [Purchase Requests](https://help.peakflo.co/accounts-payable?hsLang=en#purchase-requests)
- [Purchase Quotes](https://help.peakflo.co/accounts-payable?hsLang=en#purchase-quotes)
- [Purchase Orders](https://help.peakflo.co/accounts-payable?hsLang=en#purchase-orders)
- [OCR](https://help.peakflo.co/accounts-payable?hsLang=en#ocr)
- [Bill Management](https://help.peakflo.co/accounts-payable?hsLang=en#bill-management)
- [My Approvals](https://help.peakflo.co/accounts-payable?hsLang=en#my-approvals)
- [Goods Receipt Notes & Service Receipt Notess](https://help.peakflo.co/accounts-payable?hsLang=en#goods-receipt-notes-service-receipt-notess)
- [Budget](https://help.peakflo.co/accounts-payable?hsLang=en#budget)
- [Reconciliation](https://help.peakflo.co/accounts-payable?hsLang=en#reconciliation)
- [Reports](https://help.peakflo.co/accounts-payable?hsLang=en#reports)
- [Wallet & Transactions](https://help.peakflo.co/accounts-payable?hsLang=en#wallet-transactions)
- [Payments](https://help.peakflo.co/accounts-payable?hsLang=en#payments)
- [Vendor Onboarding Management](https://help.peakflo.co/accounts-payable?hsLang=en#vendor-onboarding-management)
- [Vendor Portal](https://help.peakflo.co/accounts-payable?hsLang=en#vendor-portal)
- [WhatsApp Vendor Portal](https://help.peakflo.co/accounts-payable?hsLang=en#whatsapp-vendor-portal)
- [Three-way Matching](https://help.peakflo.co/accounts-payable?hsLang=en#three-way-matching)
- [Accounts Receivable](https://help.peakflo.co/accounts-receivable?hsLang=en#main-content)
- [Getting Started](https://help.peakflo.co/accounts-receivable?hsLang=en#getting-started)
- [Invoice Management](https://help.peakflo.co/accounts-receivable?hsLang=en#invoice-management)
- [Workflow Management](https://help.peakflo.co/accounts-receivable?hsLang=en#workflow-management)
- [Actions](https://help.peakflo.co/accounts-receivable?hsLang=en#actions)
- [Customer Management](https://help.peakflo.co/accounts-receivable?hsLang=en#customer-management)
- [Customer Portal](https://help.peakflo.co/accounts-receivable?hsLang=en#customer-portal)
- [Collections](https://help.peakflo.co/accounts-receivable?hsLang=en#collections)
- [Reports](https://help.peakflo.co/accounts-receivable?hsLang=en#reports)
- [Credit Notes](https://help.peakflo.co/accounts-receivable?hsLang=en#credit-notes)
- [Integrations Page](https://help.peakflo.co/integrations-page?hsLang=en#main-content)
- [Basics](https://help.peakflo.co/integrations-page?hsLang=en#basics)
- [Peakflo API](https://help.peakflo.co/integrations-page?hsLang=en#peakflo-api)
- [Xero](https://help.peakflo.co/integrations-page?hsLang=en#xero)
- [NetSuite](https://help.peakflo.co/integrations-page?hsLang=en#netsuite)
- [Jurnal](https://help.peakflo.co/integrations-page?hsLang=en#jurnal)
- [Quickbooks](https://help.peakflo.co/integrations-page?hsLang=en#quickbooks)
- [Microsoft Dynamics 365 Business Central](https://help.peakflo.co/integrations-page?hsLang=en#microsoft-dynamics-365-business-central)
- [Microsoft Dynamics 365 Finance & Operations](https://help.peakflo.co/integrations-page?hsLang=en#microsoft-dynamics-365-finance-operations)
- [Zalo](https://help.peakflo.co/integrations-page?hsLang=en#zalo)
- [SFTP](https://help.peakflo.co/integrations-page?hsLang=en#sftp)
- [SAP](https://help.peakflo.co/integrations-page?hsLang=en#sap)
- [Travel & Expense Management](https://help.peakflo.co/travel-expense-management?hsLang=en)
- [Payment Automation](https://help.peakflo.co/payment-automation?hsLang=en)
- [Reports](https://help.peakflo.co/reports?hsLang=en)
- [Legal Notes](https://help.peakflo.co/legal-notes?hsLang=en)
- [General Questions](https://help.peakflo.co/general-questions?hsLang=en)
- [Guides for Partners](https://help.peakflo.co/guides-for-partners?hsLang=en)
- [Latest Releases](https://help.peakflo.co/latest-releases?hsLang=en)
- [Offboarding](https://help.peakflo.co/offboarding?hsLang=en)
- [Peakflo Ticket Portal](https://help.peakflo.co/peakflo-ticket-portal?hsLang=en)
- [Peakflo 20X](https://help.peakflo.co/peakflo-20x?hsLang=en)
[](http://peakflo.co)
peakflo.co Help Center
Copyright © 2026, Peakflo