---
title: "Import Invoices"
description: "Easily transfer all your invoice to Juan by using the Import Invoices function to import invoices in bulk."
url: https://help.juan.ac/en/articles/9094454-import-invoices
collection: "Invoices"
updated: 2026-10-25
language: en
---

# Import Invoices

Easily transfer all your invoice to Juan by using the Import Invoices function to import invoices in bulk.

## Q1. Can I import multiple invoices in Juan?

-   Yes, you can import invoices in two ways:
    
    -   **Line Items:** Rows with the same invoice reference are grouped into one invoice.
        
    -   **Summary Totals:** Each row is treated as a separate invoice.
        

![](https://staticfiles.gleap.io/gattachments/QsWjGKFdnX0bQpGGqG3zsVK04jh9VPb0lhYdjerbTAcYghUjCu3tOCsuoTY6CQJn1VII6r46swp.png)

![](https://staticfiles.gleap.io/ghelparticle/5DJNQwhRmfJ3qzPXqZdaPNFFBfFYKd3fS5MNGJoaMrNtdaYweiFQaiqM6SZmM7xRBpQOvlwVFNd.png)

![](https://staticfiles.gleap.io/ghelparticle/zVXWhPNjm1i3vbs2aPLOTA8AfsI32EtEZi8Hu4fb8uXdDD90A0Vhk5wFSChEe3RRpaS4lf3YO5j.png)

## Q2. Can I update existing invoices using import?

-   No, you can only create new invoices using the import function.
    

## Q3. What file formats are supported for importing invoices?

-   Only an .xlsx file using our template will be supported for importing invoices.
    

## Q4. Will importing invoices automatically create active invoices?

-   Yes. After finishing the import process, all the created invoices will be converted to active.
    

## **Q5. Will importing invoices affect any existing invoices in Juan?**

-   No, existing invoices in Juan will not be affected.
    

## Q6. How many invoices can I bulk import at once?

-   Each import supports up to 5,000 rows.
    

## Q7. Can I review the invoices before importing them?

-   Yes. After importing the bulk invoice template, you will be shown a list of imported invoice records picked up by Juan from the template.
    

## Q8. What should I do if there are errors or duplicates in the imported invoices? How can I fix them?

-   Use the Review sheet in the template to view possible errors.
    
-   In Juan, a review step highlights issues in the file for validation and correction.
    
-   For example, if the error reads "Item/Description is required to import the invoice" for Row 6, then check if the Item/Description field has been filled in.
    
-   After fixing all the errors presented by Juan, save your template and reimport the template to restart the bulk import process.
    

![](https://staticfiles.gleap.io/ghelparticle/YHahEOdFn7AHm4yVH0tClQAUDv5XaLEnz9o17PWcf4gxzHyuaZzvdh29SZHzAFv83OuREoOCH0r.png)

## Q9. Can I update an invoice created from the import flow?

-   Yes. After the invoice is created from the import flow, you can find it under the **Invoices** **→** **Active tab.**
    

## Q10. Can I create an invoice payment while importing invoices?

-   Yes, you can import a paid invoice by creating a payment for the invoice in the import template.
    

## Q11. Can I add multiple items in a single invoice using import?

-   No, you can only add a single line item while importing invoices. If you wish to add multiple items to an invoice, please use the normal invoice creation flow.
    

## Q12. Why can’t I proceed with my import even though the review shows no errors?

-   If the review shows new records will be created with no errors, but you can’t proceed, you may be encountering a bug.
    
-   Hard refresh your browser (Ctrl+Shift+R on Windows, Cmd+Shift+R on Mac) and try the import again.
    
-   If the issue persists, contact support through in-app chat or email [help@juan.ac](mailto:help@juan.ac).