Contents x
      Automatic Reconciliation Reports
      • 19 Mar 2025
      • 1 Minute to read
      • Print
      • Dark
        Light
      Contents

      Automatic Reconciliation Reports

      • Updated on 19 Mar 2025
      • 1 Minute to read
      • Print
      • Dark
        Light
      Article summary

      After reconciling a CSV bank statement with the proper formatting, you should receive a reconciliation report (two CSV files) within 48 hours. If the format is incorrect, support will reach out to you with the formatted CSV file for you to reconcile again.

      The “Reconciled” file will contain your original transactions with data enriched from Easy Expense. It will match up the saved receipts in Easy Expense to your bank statement.

      The “Unmatched” file will contain expenses that were in the bank statement’s date range, but could not be matched to a transaction in the bank statement.

      Formatting the CSV file

      The date format of the date column should be MM/DD/YYYY (e.g., 10/31/2025 or 1/25/2025)

      The total format must be positive values only (e.g., 1000, 1000.00, or 1,000.00)

      Remove any rows above the “Date” and “Total” header rows.

      Examples of accepted formats

      The date and total are formatted correctly in both images, and there is no extra rows above the header row.

      Examples of bad formats

      The date and total is formatted correctly, but it has additional rows above them. Deleting all rows above the “Date”, “Description”, and “Total” header row would fix the issue.

      The date is formatted incorrectly and the total has negative values in them.

      How to reconcile a CSV

      To reconcile a CSV, click the “Reconcile” tab and drag the CSV from your computer to the upload zone, or click the “Drag & drop credit card statement” and select the CSV file you want to reconcile.

      Was this article helpful?
      What's Next