Official blog

LearnDoubleEntry.org official blog

Saturday, September 29, 2018

Group journal entries in sections

It is now possible to create several sections of journal entries, and assign each journal entry to a particular section.
Each section has a name, a color, and an assigned status of visibility. Of course, when a section is set to invisible, none of the journal entries belonging to it will be shown, either in the journal or in the statements or ledger.

Here some screenshots:
The journal now has a new column, for the section.
In the sections page, you can set the color and toggle the visibility of each section.
When you prepare or edit a journal entry, you can decide to which section it belongs to.
Possible uses of this new feature:
  1. you can group journal entries by category, and have therefore an instant view of what the statements would be if none of the journal entries belonging to the "extraordinary events" group were present;
  2. students working together on the same firm could make it clear who did what (when each student uses a different section);
  3. with the same firm, you can have the journal entries of different years - instead of forking the firm.
This is still an experimental feature: if you happen to experience a bug or want to suggest an improvement, please let us know.

Tuesday, January 16, 2018

Export data to an SQLite database, and play with it

Do you want to try to execute an SQL query on the database of your firm?
Now you can: it is possible to export the data of a firm you own into a SQLite database.

You can easily manage the database offline with a program that manages SQLite databases, like, for instance, SQLiteBrowser, available as free / open source software and working for most platforms.



Possible exercises

  1. Analyze the structure of the tables to find out the meaning of the fields.
  2. Create an SQL SELECT query that shows the journal entries, with date, description, names of the accounts, and amounts.
  3. Create an SQL SELECT query that shows the ledger of a specific account.
  4. Create an SQL SELECT query that shows the trial balance.

Sunday, January 14, 2018

Subchoices

In some cases, when you prepare a journal entry, you need to specify better some information concerning an account that is too generic. Think of Accounts Payable, for instance: if you have several customers, how could you keep track of the amount you owe to each of them?

Welcome subchoices, a new feature of LearnDoubleEntry.org.

Whenever you are editing a journal entry, you can add a @ symbol after the name of the account. If you do so, when you press the tab key you'll be offered a field where to write a subchoice.


In the ledger, you will find the subchoices listed for each posting:

... and you can get a report with all the postings matching a specific subchoice: