---
title: "Managing Bank Statements"
description: "Import, configure, and manage bank statements in Juan"
url: https://help.juan.ac/en/articles/9941717-managing-bank-statements
collection: "Bank Reconcilations"
updated: 2026-10-25
language: en
---

# Managing Bank Statements

Import, configure, and manage bank statements in Juan

## Q1. How can I import a bank statement?

-   Select a bank account that you want to import a statement for and import a bank statement.
    
-   Configure the import settings for the import by assigning columns in your bank statements to fields in Juan.
    
    -   Note: The statement date and amount fields must be assigned to a column in your statement.
        
-   You can review the imported statement lines before finishing.
    

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

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

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

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

## Q2. What are Custom Bank Fields?

-   Custom Bank Fields let you set up your own fields to match or assign values from your bank statements when importing.
    
-   Go to **Bank Records → Bank Statements → Manage → Manage Bank Fields**
    

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

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

## Q3. How do I use Custom Bank Fields when importing a statement?

-   During import, assign columns from your bank statement to your Custom Bank Fields.
    

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

## Q4. Can I use Custom Bank Fields in Bank Rules?

-   Yes. Custom Bank Fields can be referenced in Bank Rules.
    
-   Go to **Bank Records → Bank Statements → Manage → Bank Rules → + New Rule**
    
-   Under the Percentage Portion, set an account by and choose to set by bank fields.
    

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

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

## Q5. Can I edit or deactivate a Custom Bank Field?

-   Yes. Custom Bank Fields can be edited, made inactive, and reactivated.
    
-   Note: Custom Bank Fields on controlled bank feeds cannot be edited or changed.
    

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

## Q6. Can I copy a Custom Bank Field from another bank account?

-   Yes. You can copy an existing Custom Bank Field from another bank record instead of creating one from scratch.
    
-   For example, to copy the "Opening Date" field from a Main Bank Account to a Sub-Bank Account:
    
-   Go to the **Sub-Bank Account** → **Manage Bank Fields → Dropdown Button → Copy from Account** → **Choose the Main Bank Account.**
    

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

## Q7. What file formats are compatible with statement uploads?

-   You can upload your statements in CSV, Excel, or PDF.
    
-   Photos and image files (like JPG or PNG) aren’t supported. If you only have a photo of your statement, convert it to PDF before uploading.
    

## Q8. Can I import password protected bank statement PDFs?

-   Yes. To import a password-protected bank statement, include the password in the file name using this format:
    
    -   Filename\_\_pw\_\_password.pdf
        
        -   <filename>+<double underscore>+<pw>+<double underscore>+<file password>
            
            -   Example: bankStam3nt\_\_pw\_\_filepass001.pdf
                
-   Note: Make sure there are two underscores before and after pw and do not include the “<>”  – brackets.
    

## Q9. Will Juan let me configure the columns from the statement PDF file?

-   Yes, Juan will extract the columns from the uploaded PDF file and let you assign them to fields in Juan.
    

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

## Q10. What if there are errors in the uploaded PDF statement file?

-   Juan will extract statement lines from the uploaded PDF file and create a downloadable CSV file for reviewing discrepancies, if any.
    
-   Alternatively, you can still import the statement lines with no errors. Juan will ignore the ones with issues and import the rest.
    

## Q11. Can I import a statement in one currency into a bank account that uses a different currency?

-   The final statement amounts that get recorded in Juan will be in the currency of the bank account in Juan, not the currency of the amounts in the bank statement.
    
-   Juan will not do any automatic conversion between the different currencies, and will solely take the numerical amounts as is.
    
-   For example, a statement line with 50 USD as its amount will be recorded in Juan as 50 USD when importing into a USD bank account, or 50 SGD when importing into an SGD bank account.
    

## Q12. Can I review the statement lines before they are imported into the system?

-   Yes, Juan will let you review all the statement lines before they are imported into your bank account on Juan.
    

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

## Q13. Can I upload multiple bank statements?

-   Yes, you can upload up to 12 files at a time.
    

## Q14. Can I manage my uploaded statements?

-   To manage your uploaded statements, utilize the Overview tab:
    
    -   Pending: configure and review imported statements
        
    -   Imported: view, download, delete statements
        
    -   Empty: uploaded files with no statements
        
    -   Deleted: view and restore deleted files
        
        -   Note: Reconciled files cannot be deleted.
            

## Q15. Can I delete a bank statement line?

-   Yes, you can delete a bank statement line individually via the **3-dot icon** on the statement line, or bulk-delete by selecting multiple statement lines at once from both reconciled and unreconciled tabs.
    

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

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

## Q16. Is it possible to retrieve a deleted statement line?

-   Yes. Under the Deleted tab for the bank account, you will find a list of deleted statement lines.
    
-   Undelete an individual statement line, or bulk undelete, to move it back to the Unreconciled tab.
    

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

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