Skip to content
Systematic home

Documentation

Systematic Invoice

Your data

Where your records live

Systematic Invoice keeps your records in a database you choose when it first opens:

  • On your computer: one file, created where you choose. It works completely offline, and it is all you need on your own.
  • On PostgreSQL: a database server on your network or your own server. Everyone who connects to it works on the same invoices, clients and items at the same time.

You can switch to another database at any time from the app.

Working as a team on PostgreSQL

  1. Create an empty PostgreSQL database (version 12 or later) and a user that can create tables in it.
  2. On each computer, open Systematic Invoice, choose the Server tab, and enter the server address, port, database name, user and password. Test the connection, then connect.
  3. The first computer prepares the database. Everyone else connects to the same one.

Two people can save at the same moment: each save is kept whole, numbers never repeat, and a save that fails leaves nothing half-written behind.

Backups

In Settings, Export saves every record, every invoice with its lines, payments and attachments, and your settings, to one file. Import restores such a file, replacing what the database holds. Backups of any size are written and read back a table at a time, so even a very large database is saved safely.

Keep backups somewhere else than the computer itself, such as a USB drive or a cloud folder. With PostgreSQL, your server's own backups work too.

Large amounts of data

Lists, searches, the dashboard and every report stay fast with hundreds of thousands of invoices: the totals of every invoice are kept with it and added up by the database. The first time a large database opens with a new version, it may take a few minutes to prepare it.

What it sends

  • Nothing about your business. Your invoices, clients and figures never leave your database.
  • No account and no telemetry. The app does not track how you use it.
  • Updates: it asks Systematic's download server whether a new version exists and downloads it. That is the only address it contacts by itself.
  • Links you open: web and email links in the app open in your own browser or email app.