PANOTAS.

File import

Bring OFX and CSV statements into the app, review what came in and categorize in bulk.

In the app:MenuFile ImportImport Files
In short

Importing means bringing your bank or credit-card statement into the app instead of typing everything. The app reads OFX and CSV files, shows you what it found before writing anything, and then offers a bulk categorization flow with suggestions based on what you have categorized before.

The formats accepted

You can add one file at a time or point to a whole folder. During pre-processing the app already discards duplicates, so re-importing a statement that overlaps the previous one does not create repeated entries.

Presets: the shortcut that pays for itself

A preset stores how a given file should be interpreted: which descriptions to fill and which category the entries go to by default. They live under Menu › File Import › Presets.

Create one per source — "Bank X card", "Bank Y checking account" — and the next month boils down to picking the file, picking the preset and confirming. On the import screen, selecting a preset fills the description fields and the category for you.

The full path of an import

  1. Choose the files. A file or a folder. The app reads them and builds a summary with the entry count and total amount before writing anything.
  2. Review before confirming. The confirmation screen lets you filter by text, dates, minimum and maximum amount, and even by text the description must not contain. Use it to review suspicious blocks without leaving the screen.
  3. Confirm and import. Only here do the entries come into existence. For credit-card statements, the app adjusts the date and appends the installment description when it identifies installment purchases.
  4. Categorize. Whatever came in without a category goes to "Unclassified Entries", and that is where the work continues.

Categorizing what came in

Under Unclassified Entries the app goes through the list and proposes a category for each item by comparing the description with what you have categorized before. You can load the suggestions, review them and apply them in bulk — or select a group of similar entries and categorize them all at once, setting shared descriptions for the whole group.

On the other side, "Classified Entries" lets you undo: filter, select and send items back to the unclassified state. Nothing is lost — the entry still exists, it just goes back into the queue.

Suggestions get better with use

The quality of the suggestions comes from your own history. It pays to invest attention in the first imports: every entry you categorize by hand today becomes an accurate suggestion in the months that follow.

Checking the result

When in doubt, test first

The first import of a file with an unfamiliar layout is the best moment to use Test Mode: you see exactly what would come in, adjust the preset, and only then repeat it on your real database.

Next steps