Skip to main content
When your bank does not sync, or when you want history from before you connected it, you can bring the movements in from the CSV statement you download from your bank’s site. It works on any account, including ones already connected to the bank.

​
Import the statement

1

Open the account

Under Accounts in the sidebar, click the account that will receive the movements.
2

Choose Import statement

It sits in the ⋯ menu at the top of the account page.
3

Pick the file

CSV or TSV, up to 10 MB and 10,000 rows. You don’t have to tidy the columns: guito reads each bank’s format the way the bank exports it.
4

Answer the balance question, if you get one

On credit cards guito always asks. On other accounts you only have to type this number when the file carries no balance column, or a balance guito cannot read, because then there is nowhere to read it from. That number is what lets guito rebuild the balance for every day in the imported period.
5

Review and confirm

The list shows everything about to come in. You can untick rows and fix descriptions before confirming.

​
Movements already in guito

In the review, a row marked Duplicate is a movement guito already has in this account: the same amount on the same day. The description doesn’t have to match, because the bank and the file usually word the same movement differently (for example “TNL Coaching” in the file and “Received money from TNL Coaching” from the sync). Under the row, guito says what it found: “Already came from your bank”, with the bank’s own wording, “Already added by hand”, or “Already imported”, with the day and time of that import. The row is left unticked: confirm without touching it and it won’t come in twice. Each movement already in the account answers for one row of the file only. If the file has two identical purchases on the same day and the account has one, only one is marked Duplicate and the other comes in. If you tick a Duplicate row and confirm, guito stores a second copy. The movement then counts twice in your income, spending and budgets. Only do it when you are sure they are two different movements.
On an account connected to its bank, you don’t need to import the period the sync already covers. Import only the months before the first movement the sync brought in.

​
Credit-card statements

A card statement is written from the bank’s side: purchases carry a positive sign, because that is what the bank charged you, and paying the bill carries a negative one. In guito it is the other way round, because the account is yours: a purchase is money going out, and paying the bill is debt going down. guito recognises these statements and turns the signs for you. Reviewing a card, you always see the option The movements in this file are inverted, switched on when guito spotted the inversion, and the amounts in the list are the ones that will be stored: purchases negative, payments positive. If your file already came that way, switch the option off.
If purchases show up in the list as money received, guito warns you above the table and tells you which way to move the option. With it switched off, switch it on; with it already switched on, switch it off, because the file came in correct to begin with. Do it before confirming, or a month of spending comes in as a month of income.

​
How much you owe on the card

On a card, guito always asks how much you owe, not what the balance is. That is the total still to be paid to the bank, on the date of the last movement in the file. The number that stands out on the statement is usually a different one: the available credit, meaning how much you can still spend up to the card’s limit. On a card with a €5,000 limit and €4,908.56 available, the debt is €91.44. Enter the available credit and you end up with a debt you don’t have.
Always enter the amount owed. You don’t need the minus sign: guito already stores card debt as a negative value.

Accounts

Account types, manual accounts and balance reconciliation.

Transactions

See, categorise and fix movements once they’re in.

Bank sync

Connect the bank and get movements without files.

Import and export data

Broker imports and a copy of your data.