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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.