---
title: "Magic CSV: Import Cash-ins and Cash-outs from Any CSV File"
description: "Import cash-ins and cash-outs from any CSV. Juan maps your columns and saves your settings for reuse."
url: https://help.juan.ac/en/articles/9994261-magic-csv-import-cash-ins-and-cash-outs-from-any-csv-file
collection: "Import & Export Data"
updated: 2026-11-17
language: en
---

# Magic CSV: Import Cash-ins and Cash-outs from Any CSV File

Import cash-ins and cash-outs from any CSV. Juan maps your columns and saves your settings for reuse.

## Q1. What is Magic CSV for cash entries?

-   Magic CSV creates cash-ins and cash-outs from a CSV in any layout, such as an export from your point-of-sale system, another platform, or your own spreadsheet.
    
-   You don’t need to convert your file to a predefined template.
    
-   In the app, it appears as **Any CSV File** under **Import Cash-ins/outs**.
    
-   Cash entries imported using Magic CSV are created as active upon import.
    
-   Note: Magic CSV is available for cash-ins and cash-outs only. To import cash transfers, use the Import Cash Transfers template. See [Import Cash Entries](https://help.juan.ac/en/articles/9994232-import-cash-entries.md).
    

## Q2. What does my file need?

-   A .csv file of up to 10 MB and 5,000 rows.
    
-   One row per entry line. Rows with the same reference become one cash entry.
    
-   Columns for Reference and Amount.
    
-   Dates in dd/mm/yyyy or mm/dd/yyyy.
    
-   Juan skips title rows, blank rows, and total rows.
    
-   Notes:
    
    -   If your file has no column for Contact, Date, Bank Account, Currency, or Account, you can set one value for all rows during the import.
        
    -   Dates that start with the year, such as 2026-09-15, aren’t accepted. Convert them to dd/mm/yyyy or mm/dd/yyyy before uploading.
        
    -   If your file has names with ñ or other special characters, save it in Excel as CSV UTF-8 so they import correctly.
        
    -   Transaction limits based on your subscription plan still apply.
        

## Q3. How do I import cash-ins or cash-outs from a CSV file?

-   **Open the import**: go to **Reconciliations → Cashflows**, click the arrow next to **New Direct Entry**, then select **Import Cash-ins/outs → Any CSV File**.
    
-   **Upload your file**: drag and drop your CSV or click to browse.
    
-   **Map columns**: check each suggested field and fill in any missing columns.
    
-   **Resolve values**: match any values marked Needs Attention.
    
-   **Review and finish**: check the entries to be created, then click **Finish**.
    
-   The import runs as a background task. See [Background Task](https://help.juan.ac/en/articles/9994223-background-task.md).
    

## Q4. How do I map my columns?

-   Juan suggests a field for each column it recognizes.
    
-   Check each suggestion and change it from the dropdown if needed.
    
-   Set columns you don’t need to No field.
    
-   Required fields without a column are listed under **Missing columns**. Choose a value for each, and it applies to every row.
    
-   Reference and Amount can’t be set this way. Map a column to each.
    

## Q5. How do I set the date format?

-   Juan detects the date format from each date column.
    
-   If every date in a column can be read both ways, such as 03/04/2026, a red icon appears next to the preview value. Click it and choose dd/mm/yyyy or mm/dd/yyyy.
    

## Q6. Can I import tracking tags, nano classifiers, and custom fields?

-   Yes. In Map Columns, assign your columns to the following fields:
    
    -   **Tracking Tags**: applied to the whole cash entry.
        
    -   **Nano Classifiers**: applied to each entry line.
        
    -   **Custom Fields**: added to the cash entry.
        
-   Note: Tracking tags, nano classifiers, and custom fields must already exist in Juan so you can choose them in Map Columns. See [Transaction Data Enrichments](https://help.juan.ac/en/articles/9994168-transaction-data-enrichments.md).
    

## Q7. How do I resolve values that need attention?

-   Juan matches the values in your file to your contacts, bank accounts, accounts, currencies, and tax profiles.
    
-   Each section is marked Ready or Needs Attention, and each value shows how many rows use it.
    
-   Matching ignores capitals, extra spaces, and punctuation. If two records look alike, the value goes to Needs Attention so you can pick the right one.
    
-   For each value that needs attention, choose one of the following:
    
    -   **Existing record**: select it from Top Suggestions or the full list.
        
    -   **Add as new**: creates the contact.
        
    -   **Skip Rows**: leaves out the entries that use the value.
        
    -   **Leave blank**: imports without the value, for optional fields only.
        
-   Contacts added this way have a name only. Add the TIN and other details after importing.
    
-   Accounts, bank accounts, and tax profiles can’t be created during the import. Add them in Juan first.
    

## Q8. What do I check on the Review step?

-   Review Before Import shows:
    
    -   The total to be imported, in your base currency
        
    -   The number of new contacts
        
    -   The entries to be created, with reference, contact, date, account, and total
        
    -   Any entries with errors, with the column, row, and error
        
-   Entries with errors are left out. You can continue without them, or fix your file and upload it again.
    
-   Row numbers count data rows only, so Row 8 is row 9 in your spreadsheet.
    
-   Dates on Review are shown as mm/dd/yyyy.
    

## Q9. How do I reuse my import settings?

-   Juan saves your column mapping automatically after your first import.
    
-   The next time you upload a file with the same columns, Juan applies the saved mapping so you can skip Map Columns. See Q11.
    
-   Saved settings cover the column mapping only. You still need to match values in Resolve Values for each import.
    

## Q10. What can’t I import with Magic CSV?

-   Cash transfers. Use the Import Cash Transfers template instead.
    
-   Updates to existing cash entries.
    
-   Note: Make sure your references aren’t already in Juan before importing. To reverse an import, void the imported entries.
    

## Q11. What happens if I upload a similar file again?

-   Juan reads the file and checks whether it matches a saved template.
    
-   If the columns are the same, a **Saved Template Found** card appears. Click **Use Template** to apply the saved column mapping and skip Map Columns.
    
-   If some columns have changed, a **Template Changed** card appears. Click **See Changes** to view each column marked as one of the following, then click **Continue**:
    
    -   **New**: the column wasn’t in the template.
        
    -   **Removed**: a template column is missing from this file.
        
    -   **Type Changed**: the column has the same header, but a different kind of data.
        
-   On Review, choose **Update Template** to save the new layout, or **Keep Current Template** for a one-off file.
