Importing bank statements

Instead of typing every transaction, you can import the statement your bank exports. Open the account and choose Import, then pick the file.

Supported files

OFX (also QFX): the bank's own format, read as is.
CSV: a table. Moneta asks which column holds what.

Export one account at a time: a file with the statements of several accounts is refused. Import it into the account it came from.

CSV columns

For a CSV file, tell Moneta:

whether the first row names the columns;
which column is the date, the description and, optionally, a memo;
whether amounts are in one column (negative for outflows) or in separate inflow and outflow columns;
the date format and number format the bank uses;
Invert signs, for card statements that list purchases as positive amounts.

The preview shows how the lines read. Moneta remembers these choices for the next import into the same account. Lines with no date or amount are left out, and Moneta says how many.

The columns of a CSV statement: date, description and amount, the date and number formats, and a preview of how the lines read.

Reviewing the lines

Before anything is written, every line is marked:

New: it becomes a new transaction, cleared.
Matches: you already entered this transaction by hand, with the same amount, dated up to four days apart. Importing marks yours as cleared and keeps everything else about it; nothing is doubled.
Possible match: you entered a transaction with the same amount, dated up to ten days apart. The line starts unchecked; Link makes it a match, or check it to import it as new.
Already imported: this line came in before. Importing the same statement twice, or two statements that overlap, adds nothing. Two identical lines in one file are two purchases, and both come in.

The review of an imported statement: a line that matches a transaction entered by hand, two new lines waiting for a category, and a repeated line already imported.

For new lines you can change the payee and the category. Moneta fills in the category from the payee's default category or the one it usually gets. Lines still without one are listed, and you can give them all one category at once.

Import writes it all at once, and it can be undone right after.

Some lines start unchecked, with a note at the top: lines dated more than two years from now, which usually mean the date format is wrong, and lines dated before the account's starting balance, which probably counts them already. Check one to import it anyway.

Making a rule

Bank descriptions are messy: PAG*CORNERMKT 0423 SAO PAULO. On a new line that no rule catches yet, Make a rule sets the payee (and optionally a category) for every description like it, in this import and the next ones. After a card processor's prefix like PAG* or SQ *, the rule starts as Contains the merchant's name. Lines caught by a rule show a Rule badge, and without a category of its own they get the payee's usual one. See Payee rules.