Import

Sesterce lets you import expenses you've created elsewhere.

From Sesterce

Join a group

See join a group

Import a Sesterce's CSV export

Operations created in Sesterce can be exported.

This CSV file can be re-imported from Sesterce's Android and iOS applications in the "Import" screen.

From another application

Whether you're coming from a competing app, such as Splitwise or Tricount, or doing your accounts on an Excel or Google Sheet, you have the option of exporting a CSV file that can then be imported into Sesterce's Android and iOS apps, in the "Import" screen.

If the import does not work try to modify the CSV file by following the CSV format guide below. If you need more help, we might be able to provide more insight about the error you are facing: send us your CSV file to info@sesterce.io.

CSV format

Comma-separated values, also known as CSV, is an open text format representing tabular data as comma-separated values. It's the most widely used format for exporting data from applications such as Microsoft Office, Google Sheet, Sesterce, Splitwise, Tricount and others.

Each line corresponds to an entry (a transaction in the case of account management applications such as Sesterce).

The separator is usually a comma (,), but can also be a semicolon (;), a tab ( ) ou a pipe (|).

To create a CSV file compatible with Sesterce, the CSV file header (the first line) is very important, as it determines how the file is defined.

Below you'll find a description of the CSV file fields supported by Sesterce. Please note that this list is not exhaustive.

Full exemple

Here's an example of a CSV file you can use to import your data into Sesterce:

Date,Title,Paid by Pierre,Paid by Sophie,Paid by Brad,Paid for Pierre,Paid for Sophie,Paid for Brad,Currency,Category
20230722,Hotel aBis,358.0,0.0,0.0,0.0,169.0,189.0,EUR,Hosting

This gives the following table:

Date	Title	Paid by Pierre	Paid by Sophie	Paid by Brad	Paid for Pierre	Paid for Sophie	Paid for Brad	Currency	Category
2023-07-22	Hotel aBis	358.0	0.0	0.0	0.0	169.0	189.0	EUR	Hosting

Amount fields

There are several ways of representing the amount of the operation and how it is divided between the members. Choose one of them.

Method 1: Paid by and paid for (recommended)

With the headers Paid by X for the amount advanced by each member, and Paid for X for the amount they should have paid. There are two fields for each member (one "by" and one "for"). X represents the member's name.

Example: Pierre paid 20 euros for the groceries, and 15 euros of it was for Sophie.

Paid by Pierre	Paid by Sophie	Paid for Pierre	Paid for Sophie
20	0	5	15

This is the method used for exporting Sesterce and Tricount, for example.

Method 2: Amount, name of the person who advanced the money and impact for each person

With the headings Cost (or Total or Amount) for the total amount of the operation, Who paid for who financed this operation, and a column for each member's name for how much they should have paid.

The sum of the amounts for each member is equal to the total amount of the operation. The amount is positive in the case of expense, negative in the case of income.

Example: Pierre paid 20 euros for the groceries, and 15 euros of it was for Sophie.

Total	Who paid	Pierre	Sophie
20	Pierre	5	15

This is the method used by SettleUp export, for example.

Method 3: Total amount and impact for each

This method should be avoided, as it does not provide a precise description of the operation.

With Cost (or Total or Amount) headers for the total amount of the operation, and a column for each member's name for how much they have to pay (if negative) or recover (if positive).

The sum of all members' amounts is 0.

Example: Pierre paid 20 euros for the groceries, and 15 euros of it was for Sophie.

Total	Pierre	Sophie
20	15	-15

This is the method used by Splitwise export, for example.

Additional fields

Name	Header	Value
Date (required)	date	A date in the format AAAA-MM-JJ (2023-03-24) or AAAA/MM/JJ (2023/03/24) or AAAAMMJJ (20230324)
Title (required)	title ou description	Name of the operation
Category (optional)	category	Name of the category
Currency (optional)	currency	Operations's currency
Exchange rates (optional)	exchange rate	Conversion of operation amount into group currency