Official blog

LearnDoubleEntry.org official blog
Showing posts with label accounts. Show all posts
Showing posts with label accounts. Show all posts

Sunday, February 1, 2015

Smart comments for accounts

For each account, you can set some comments that could help to understand how to use it or to find some extra information.


The format of the comment is free, so you can just type what you need. But, to stay organized, it is better to use some keywords to express special meanings (keywords are at the beginning of the line, prefixed with a '@' symbol).

In some of our system-provided firms, we used these keywords for ordinary accounts:

  • @aka, which stands for "also known as", for accounts that could have given other names in other chart of accounts, but with the same meaning;
  • @href, for URLs of web sites that explain the meaning of the account or provide examples on how to use it;
  • @example, to provide an example of a situation where the account could be used, or to better explain the meaning;
  • @meaning, to express the meaning of the account in a short sentence;
  • @see, when we want to point to another related account (mainly to consider the difference);
  • @check, when we are not sure of the name or of other information (help us to improve the chart of accounts if you can answer our doubts).

When you choose an account using the tree view window, you can check whether the meaning of the account is correct for the transaction you are recording:



Also, when you look at the ledger page of a single account, the comments are shown, so you can better evaluate if you did the correct job:


Some kewyords, if used, are specially interpreted by the application. For instance, @href makes the text afterwards a link, as you might have noticed.

Keywords and comments play a special role in the Financial Statement Configuration, where instead of accounts we have items that keep accounts organized and let us fine-tune how the Financial Statement gets prepared.

In a previous post we discussed the use of the following keywords:
  • @caption, to specify the description that is shown after the title of the statement;
  • @strip, to tell the application which part of the description of the journal entries has to be stripped away when analyzing accounts (for the Statement of Changes in Equity);
  • @analyze, to tell the application which accounts have to be analyzed.
Here, we introduce a new one:
  • @closing, that you might want to set to "no" if you don't want for the related accounts to be proposed a closing entry.
Other keywords for our smart comments could be introduced in the future. Meanwhile, you can safely play with the above ones.




Wednesday, July 17, 2013

Sample exercise 03

In this third sample exercise, we are going to illustrate some other features of LearnDoubleEntry.org. The example is taken, with authorization, from AccountingCoach.com. We won't get into details about the why's of things (that you'll find on their website, with a deep explanation), but we'll concentrate on how to do this kind of exercises with a virtual firm that you "own" on LearnDoubleEntry.org.

Let's begin. We are given the following preliminary balance sheet, which reports the account balances prior to any adjusting entries:
Preliminary Balance Sheet - courtesy AccountingCoach.com
To start the exercise, you need to:
  1. login to LearnDoubleEntry.org
  2. go to the Bookkeeping and Accountancy page
  3. click on "Fork an existing firm" menu item
  4. click on "Standard Firm"
  5. choose to duplicate the Chart of Accounts
  6. click on the "Yes, fork this firm" button
  7. set a name and a description for the firm
  8. click on the "Save" button, and you are done.
After firm creation, you can click on the "Journal" menu item, and then choose to create a new "journal post" (aka journal entry, aka transaction). You will be shown a form like the following:


Instead of writing the single lines here, you can:
1. switch to raw input mode

2. load all accounts from the chart of accounts

3. copy the account names to a spreadsheet (first select the whole text of the box, then copy, then paste on the spreadsheet)


4. find the accounts in the spreadsheet, and write the amounts of debits and credits (if you don't find an account with exactly the same name, choose a one that has the same meaning and don't worry: you can edit the name later; but if you really don't find an account, just add a line with the missing name with an exclamation mark at the end, like we did here for Prepaid insurance); pay attention to the fact that the totals of debits and credits must balance; you can, if you want, delete the lines of unused accounts


5. copy the selection from the spreadsheet back to the web form, and click on the "Switch to text fields mode" icon


6. since you probably want the accounts with the debits first, just click on the "Sort postings, debits first" icon


7. save the journal entry, and you are done. Easier done than said, isn't it?
If you look at the journal now, it looks ok. We used Supplies Inventory instead of Supplies, Bank Checking Account instead of Cash, Bills Payable instead of Notes Payable, Payments on Account from Customers instead of Unearned Revenues, Employment Expenses Payable instead of Wages Payable, and Common Stock instead of Mary Smith, Capital.

If this is fine for you, well. Otherwise, you can edit the Chart of Accounts with the names that you prefer.  The Trial Balance looks like this now:


As you can see, the Prepaid Insurance account has been added on the fly, and you find it marked in yellow at the bottom of the table. To fix the problem, you just have to assign a correct code to the account. Since you already have a Prepaid Expenses account, you can choose to add another account as its sibling with a code like 00.03.06.03. This way, the account will be a child of the Accrued Income and Prepaid Expenses account, which has code 00.03.06.

Other choices would be possible. For instance, you can make Prepaid Insurance a child of Prepaid Expense, by entering a code like 00.03.06.02.01. This way, Prepaid Expense would not be usable as such, because it would have some children.

It's up to you how to organize your Chart of Accounts, and which names to give to the accounts themselves. Just consider that:

  • once you edited the Chart of Accounts of one firm, you can use it in other firms that are forked from it;
  • if you spot any problem in the Chart of Accounts provided for the system-provided Standard Firm, you can add a comment in this blog or drop us a message, and we'll try to fix it.

Edit the account names as you like. We only changed Common Stock to Mary Smith, Capital.

When you are done, you can start entering the journal entries of the example exercise provided by AccountingCoach.com. (We added an extra journal entry with some amounts for Income Statement accounts at the beginning.)

For each journal entry, you can click on the "Analyze the Transaction" icon, that shows a little explanation of what is going on. For instance, when you make the adjusting entry about bad debts valutation, you can see that you have an increase in Expense (Bad Debt Expense) and an increase in an Asset Contra Account (Allowance for Doubtful Debts).


When you want, you can have a look at the T-Account (called Ledger in the application) of any account. It's not actually T-shaped, but the meaning should be obvious anyway.

You can find the complete exercise in its public page, and you can fork the firm by using the slug "sample-exercise-03".


Wednesday, July 10, 2013

Any advice for our multilingual chart of accounts?

We just upgraded the code LearnDoubleEntry.org is based on, in order to show to non-authenticated users the chart of accounts of system-provided firms.

You can have a look at the chart of accounts of our "Standard Firm" at the URL http://learndoubleentry.org/firms/standard-en/coa. Please note that some of the names of the accounts have to be checked, and we would love it if you can send advice and comments on how to improve it.

The names are currently expressed in US English and Italian. Of course, other languages can be added. Also, we are not sure about the differences between American English and British English, or other flavo(u)rs of English, for what concerns the names.

Legenda
Position: BS (Balance Sheet) or IS (Income Statement)
Outstanding Balance: Dr. (Debit), Cr. (Credit), or "/" (unset) -- this is the "typical" outstanding balance that one could expect for an account (e.g., Debit for Cash, Credit for Sales, etc.), and it is used to show some warnings in case of doubtful journal entries...

Friday, June 14, 2013

Internationalized names of accounts

Just noticed that the interface for giving names to the accounts is was not clear enough. We will work on that, and fix the problem.

An account may have names in different languages, but you must write the names just after the appropriate locale string, like in the following example:

en_US: Depreciation of Buildings
it_IT: Ammortamento fabbricati

You shouldn't remove the locale, but, of course, you are not enforced to write the names in all the languages.



What does it happen if the firm's language is set to, say, English, and there's no name in English for an account? Well, another language is chosen, but an asterisk is added.

What if no name is provided? Well, only the asterisk comes up, like here:


Please be patient, a fix is coming soon...
The bug has been fixed in version 1.0.5. Now the names are correctly checked on saving.