How-to guides · Your data

Import a CSV, or check a statement

Switching from YNAB, Goodbudget or Monarch, or bringing in a bank statement? Granary reads a CSV file, matches its columns, and shows you every entry before anything is added. No bank login.

  1. Export a CSV

    In the other app, your bank's website or a spreadsheet, export your transactions as a CSV file and save it to Files or iCloud Drive. Want to see the shape first? Here's a sample file.

  2. Open Import CSV

    In Granary, open Settings › Import and Export › Import CSV… and choose the file. Setting up for the first time? Choose Import from another app on the first screen, under Or start another way.

  3. Review

    Under Columns, check that Date, Amount, Description and Category point at the right columns; Granary works out the dates and which way money goes. Categories that aren't bins yet can become new bins with Create New Bins. Scroll down to check each entry.

  4. Add

    Tap Add 3, or however many there are. Budget says “Added 3 entries”, with Undo to take the whole import back. New savings bins get a Set Goals banner to give each one a goal.

Check a statement

  1. Open Check a Statement

    Settings › Import and Export › Check a Statement…, and choose your bank's CSV. Import CSV… offers the same when a short file covers days you've already logged: “Check this file against what you logged?” Tap Check Against What You Logged.

  2. Go through what's different

    Not Logged lists what's on the statement but not in Granary; Check These, near matches; Logged, Not on the Statement, the other way round. Tap Add the New Ones, or decide each one: Add, Later or Don't Add, and Use $… or Keep Mine for a different amount.

  3. Done

    Nothing changes until you choose. Tap Done when you've been through it.

On a Mac: choose File › Import CSV… (⇧⌘I), or drop the file on the window. A statement opens in Statement Review (⌘6), with New, Check these, Refund and Handled. Add the New Ones adds what's missing; Import as Entries Instead or Cancel Review leaves it.

Taking your spending out? Export Spending CSV… saves every entry as a spreadsheet; it's part of Plus.

On iPhone: a small test file, reviewed and added.