Import bank and card statements

Righto has no bank feed. You download statements from your bank and import them. Nothing leaves your Mac.

Formats

• OFX and QFX: the best choice when your bank offers them. They keep the bank’s transaction IDs, and they often include the statement balance, which Righto can use to reconcile.
• CSV: works with almost every bank. You check the column mapping one time for each layout.
• PDF: Righto reads the text in a PDF statement. Check every row, because a PDF layout can be read incorrectly. Righto cannot open a PDF that needs a password. If a page is a scanned picture with no text, the Righto app on your Mac can read it with on-device text recognition (up to 100 scanned pages for each PDF). Nothing leaves your Mac. Righto keeps the recognized text as a separate source, linked to the original PDF. Check every row: Righto marks each line that it read with low confidence as uncertain, and you decide on it with a reason. An agent can start it too, with righto read-scanned <sourceBlobId>, but only while the Righto app runs on the Mac. You can also get a CSV or OFX file for that period, or add those transactions by hand.

Import a file

1. In Transactions, choose Import.
2. Drop your statements, or choose them. You can drop one file or many at once, from any account, up to 25 MB each. Righto finds the account of each statement from the last 4 digits of the account number on it, and shows the files by account. If Righto cannot find the account, choose it. Check that each statement is in the correct account: the same statement in two accounts counts the money twice. If a file does not say which way money moves, Righto asks you one question, and shows real rows from your file with the answer, such as “CLIENT DEPOSIT 500.00 → money in”. Pick the answer that matches your statement.
3. Check the format settings. For a CSV file, check the date column, the description, and the amount columns, and check that money in and money out have the correct sign. Righto suggests a mapping, but the file cannot prove it. Compare one row with your statement.
4. Check the preview. Righto shows the original text next to what it read. It marks rows that need a decision: possible duplicates, unclear amounts or dates, subtotal lines, and rows that conflict with an earlier import.
5. For each marked row, accept it, skip it, correct it, or link it to a line that you already imported.
6. Confirm the import. Righto shows how many rows it accepted, skipped, and corrected.

Nothing changes in your books until you confirm. If you import the same file again, Righto finds no new rows.

After the import

The new lines are in Transactions with the status Needs attention. Next, match or categorize them: Categorize, match, and mark Done. If you have rules, they can categorize some lines for you: Rules.