Managing personal finance with Grisbi

In Practice

Once configured, you can begin to use the software. In the main view, you see the task on the left and details on the right. The window shows lines of entries for each transaction, including any notes (Figure  3).

Figure 3: In entering a transaction, you can see the details (including any notes) in the right pane.

After you've set up your accounts, you generally begin by entering transactions. If, when adding a transaction, you find that an account is missing, you can create the new account at that time, either manually with Edit | New transaction or by importing it from files exported by another financial package. Grisbi provides keyboard shortcuts for certain actions (Table 1).

In the second case, you can use File | Import file to start a wizard that leads you through the steps. The program supports four formats: GnuCash (Gnucash), Open Financial Exchange (OFX), the popular Quicken Interchange Format (QIF) [4], and the general CSV (Comma-Separated Value) format used for spreadsheets. These distributed entries are found in the Properties tab of a transaction. Importing spreadsheet formats with CSV files works well as long as the internal format matches. With File  | Export accounts as QIF/CSV file , you can export a CSV file from Grisbi to get an idea of the sequence of columns.

If needed, you can sort the data in the spreadsheet. Columns that you don't have in the table, but that Grisbi requires, can be set aside with empty comma-separated entries. If the formats match, export the data. Use semicolons as delimiters instead of commas.

If you don't want to work with existing data but still want to try the program, you can use Grisbi's sample files  [5], although the content is in French throughout.

Because the software does not as yet support online banking, you need to enter all transactions manually. Grisbi recognizes the formats from various banks to evaluate the transactions. Income and expenses are entered through the New transaction button.

The first line has the Payee for the transaction, the second has the Category , and the third can contain descriptive Notes . Enter the Debit or Credit amount (in the currency you choose) of the transaction in one of two boxes to the right of the first line.

To be exact, compare the transaction with an actual bank statement  [6]. If the transactions match, you can select the transaction and click the Reconcile button at the top (or press Alt+R).

The program is also set up for recurring transactions. The Scheduler lets you enter these transactions and set a frequency in a modified format (Figure  4). If your account turns to a negative balance, a warning appears (Figure  5).

Figure 4: The scheduler allows for periodic recurring transactions.

Figure 5: A balance in the red automatically displays a warning.

As of version 0.8.9, Grisbi provides a Credit Simulator for credit calculations. To begin, you enter the desired sum and other properties. The main window then shows a table with the credit line data (Figure  6). Note that you can enter the credit timeframes in three different stages in the right-hand corner (e.g., Between 1 and 15 years ).

Figure 6: Grisbi simulates credit transactions. The timeframes fell out of the dialog box in this example.

Grisbi provides reports for income and expense balances over time. Choose Reports on the left, and a new set of buttons will appear on the right, including New report . Creating a new report opens another wizard (Figure  7). The application supports various report formats – among them, LaTeX. Unfortunately, although translation of source code currently works for PDFLaTeX, XeLaTex returns the error !  Package utf8x Error: MalformedUTF-8sequence .

Figure 7: Grisbi reports summarize transactions for freely defined or predefined timeframes.

Conclusion

One of the big advantages of Grisbi is automatic data backup. You can set the backup interval and create encrypted files. Unfortunately, the program doesn't support online banking, but it's a great help with simple transaction entries. Although entering categories and amounts leaves some room for improvement, auto-completion makes the work easier.

A downside of Grisbi is its minimal flexibility. Users can't add functions that developers have not anticipated or that weren't implemented, which is possible in a spreadsheet application. If you want double-entry bookkeeping, GnuCash  [7] might be a more viable alternative.