company logo

Help center

Go to Juan Accounting
All collectionsImport & Export DataMagic CSV: Import Cash-ins and Cash-outs from Any CSV File

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.

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.

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.

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.

Did this answer your question?
😞
😐
😁