Skip to content
TurbobullsDocs
DocsSettings

Import your accounts, categories, tags or brokers from a file

Each list in Settings has an Import button that reads a CSV file: match its columns, name the kinds and currencies, check the review, then import.

A guide4 minutes
Before you start. A CSV file whose first line names its columns, one account, category, tag or broker on each line after it. A file saved with Download as CSV from the same list works as it is. Your transactions come in another way: Import a bank statement.

Press Import on a list

In Settings, open the list you want to fill, Accounts, Categories, Tags or Brokers, and press Import at the top of it. A panel opens over the page, with the step you are on at the top, such as Step 1 of 6 and Upload for accounts. With no account yet, Or import them from a file on Accounts opens it too.

SettingsAccountsImport

Add your file

The first step says Add your CSV file: Any CSV with a header row: you match its columns next. Drop the file on Drop your CSV file here, or click there to choose it. It is read on your device and never uploaded: Processed locally on your device. Press Continue to go on to the columns. Nothing is saved yet.

Match the columns, kinds, currencies and tags

Match your file's columns shows each field with the column of your file it reads, picked by the column's name when it looks alike. A field on Select column reads nothing yet: pick its column there. Accounts need Name, Kind and Currency, with Tag and Notes if you like. Next goes on, and Back returns.

Accounts then ask about each value your file uses. Match the kinds of account lists each type your file writes, such as Checking, with the app's kinds to pick from: Current account, Savings, Cash, Credit card, Retirement, Loan, Mortgage and Other. Match the currencies does the same for currencies. Match the tags matches each tag your file names to one of your tags: New tag adds one you do not have yet, and every tag in the file needs a match. A value that already reads like a kind, a currency or a tag you have is picked for you. Brokers ask about currencies only. Categories and tags go straight to the review.

Check the review, then import

The last step, Review, starts with a Summary. Lines in your file counts every line, and the rows under it say what becomes of them:

  • New accounts: the ones that come in, with how many of each kind under it. Categories also show New groups, named under it.
  • Already here: the ones you have (left out, so nothing doubles).
  • Repeated in the file: lines your file lists more than once (each comes in once).

Below the summary, a card lists the new ones with their kind, currency, tags and notes. Nothing is saved until you import.

Leave out lines repeated in the file, at the foot of the summary, is on at first. Turn it off to bring in every line, repeats included. Categories have no such switch: they always leave a repeat out.

Press the button named for what comes in, such as Import 4 accounts. A message says how many came in, such as Added 4 accounts., and they join the list. When the file adds nothing, the button reads Close instead. Back goes back a step.

Leave out lines repeated in the fileImport 4 accounts

What each list reads

ListStepsColumnsLeft out as a duplicate
AccountsUpload, Columns, Kinds, Currency, Tags, ReviewName, Kind and Currency. Tag and Notes if you likeAn account with the same name, kind and currency as one you have, or as an earlier line
BrokersUpload, Columns, Currency, ReviewName and currency. Notes if you likeA line with the same name and currency as an earlier line. The brokers you already have are not checked, so Already here stays 0: leave them out of the file
CategoriesUpload, Columns, ReviewName. Group and Notes if you likeA name you already have, upper or lower case alike, built-in ones included, or one an earlier line took
TagsUpload, Columns, ReviewNameA tag with the same name as one you have, or as an earlier line

A kind cannot change once the account is added, so pick it with care on Kinds.

If the import stops

A red Errors box at the top of the panel lists what stopped it, three at a time, with a line such as + 4 other errors not shown when there are more. A file too big for your plan is refused by a message at the bottom of the screen instead, with See plans.

MessageWhat to do
Don't forget to upload import fileDrop a file before you press Continue.
We could not process column names from your fileThe first line must name the columns. Add a line such as Name,Type,Currency at the top.
File exceeds 10,000 row limitSplit the file in two and import each.
Name is empty on row 3 for selected type column NameThat line has no name. Fill it in, or delete the line, and upload the file again. The same goes for a line with no kind or no currency.
Only 2 more accounts fit on your plan (3 total). Upgrade to add more.The file holds more than your plan has room for, so nothing is added. Take lines out of the file, or see Plans and limits.

Good to know

Imported accounts start at zero

An account from a file has no starting balance. It starts counting on the day you imported it, or on its first transaction if that is earlier. Open each one to set its Starting balance and Opening date: see The opening date.

Categories and their groups

With a Group column, each new category goes into the group its line names, and a group you do not have yet is made. A category you already have is left out and keeps its group, as the review says: left out, and it keeps its group. The file never moves it.

Round trips

Download as CSV saves a file each list can import back. The categories download has names and notes but no group, so add a Group column before you import it elsewhere. Tags come back by name only: their notes stay behind.

All or nothing

If the file does not fit your plan, the import adds none of it, so you never end up with half a list.

Worked example

Your workspace on the Free plan, which holds 3 accounts, has one already: Savings pot, savings, in EUR. Your file has five lines:

NameTypeCurrencyWhat happens to it
EverydayCurrentEURComes in, as a current account
Savings potSavingsEURLeft out: you have it
Visa cardCredit cardEURComes in, as a credit card
Dollar accountCheckingUSDComes in, once you pick Current account for Checking on Kinds
EverydayCurrentEURLeft out: the file repeats it
5Lines in your file
3New accounts: 5 lines, less 1 Already here and 1 Repeated in the file
RefusedOn the Free plan, 1 + 3 is more than 3, so Import 3 accounts says Only 2 more accounts fit on your plan (3 total). Upgrade to add more.

Take one line out, such as Dollar account, and the other two come in, each at a starting balance of 0.

Something missing, or not what you see in the app?Tell us in the community