An accounting aggregator that bridges the gap between spreadsheets and bookkeeping software
Gear up slick spreadsheet office suites for next-level efficiency!
-
For non-accountants. Anyone who learns about bookkeeping principles or has basic understanding how accounting works can find it ideal for trial & error accounting.
-
A no-brainer tool designed to reconcile trial accounts with spreadsheets of transactions. It enables to create a trial Balance Sheet and a Profit & Loss Statement locally with almost unlimited flexibility in virtually no time: no need to worry about connectivity, upload transactions and store any data in the cloud.
-
Kitri aggregates amounts of recorded transactions by accounts in accordance with a user-defined structure
-
Kitri streamlines the part that is tricky in Microsoft Excel, LibreOffice Calc or Google Sheets
-
Kitri in the blink of an eye aggregates transactions and returns a worksheet with balance and profit-loss amounts split by user-defined categories. It takes tables of categories (i.e. the Chart of Accounts) and records of transactions as input.
Kitri returns results in the form convenient for use in Microsoft Excel, LibreOffice Calc or Google Sheets
Categories and records are accepted in CSV files (Comma Separated Values). Any single spreadsheet from MS Excel, Google Spreadsheets or LibreOffice Calc may be saved as a CSV file. The CSV format preserves cell values and the structure of columns and rows. Formulas are omitted, although the number formatting remains as is. So please make sure that the number format is set to General / Automatic before saving data as CSV.
The following column order must be respected:
Category
- character string, a category identificator (ID) that must be uniqueName
- character string, a descriptive category nameBalance
- general number (no thousand separators!), a starting balance per category
The other columns are ignored by the calculator.
It is assumed that the first row of data contains column titles. The first row is ignored by the calculator. So, all columns may be given any names.
The following column order must be respected:
Amount
- general number (no thousand separators!), the monetary value of transactionSource
- character string, category ID; it is where the money goes from, or is debited fromPurpose
- character string, category ID; it is where the money goes to, or is credited to
The other columns may contain any comments, notes or explanations. They are ignored by the calculator.
It is assumed that the first row of data contains column titles. The first row is ignored by the calculator. So, all columns may be given any names.
The structure of input files and configuration templates can be considered on examples
Windows (amd64):
Download Kitri.exe for Windows
macOS:
Linux:
Download Kitri.tar.gz for Linux
$ tar -xzf Kitri.tar.gz
$ make
$ sudo make install
Examples:
- Clone the repository
git clone https://github.com/serdug/kitri.git
- Compile from source
go install github.com/serdug/kitri
-
Create folders for settings, input and output files
-
Copy example files in the folders
-
Update the working directory path in the config file accordingly
-
Run a compiled package
$GOPATH/bin/kitri
You will need a C compiler to compile the application from source and an up-to-date graphics driver to run it.
- Go 1.10
- Fyne 1.3 for UI
- golang.org/x/text 0.3