Skip to main content

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:

  • If you know how to modify the CSV file, you can adapt it by following the CSV format guide below.
  • Alternatively, send this CSV file to info@sesterce.io for assistance.

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 (an operation 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.

Amount

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

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 PierrePaid by SophiePaid for PierrePaid for Sophie
200515

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.

TotalWho paidPierreSophie
20Pierre515

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.

TotalPierreSophie
2015-15

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

Additional fields

NameHeaderValue
Date (required)dateA date in the format AAAA-MM-JJ (2023-03-24) or AAAA/MM/JJ (2023/03/24) or AAAAMMJJ (20230324)
Title (required)title ou descriptionName of the operation
Category (optional)categoryName of the category
Currency (optional)currencyOperations's currency
Exchange rates (optional)exchange rateConversion of operation amount into group currency

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:

DateTitlePaid by PierrePaid by SophiePaid by BradPaid for PierrePaid for SophiePaid for BradCurrencyCategory
2023-07-22Hotel aBis358.00.00.00.0169.0189.0EURHosting