Official blog

LearnDoubleEntry.org official blog

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: