Archive | Bookkeeping RSS for this section

Accounts payable controls 


Image from 

I can remember my time working in a manufacturing company as a financial controller and later a systems manager like it was yesterday.  One of the great experiences I had was working with and configuring SAP.


One thing it changed in the company was the Accounts Payable (AP) process. My company at that time was quite good at ensuring only genuine suppliers were created. But that’s been newly 15 years ago now and I know the AP processes have become even more automated.

So this article in the Journal of Accountancy really interested me. It seems proper AP controls evade some companies still, but when managed well add to the bottom line. Have a read of the full article


The charity sector – the accountability conundrum.

Some recent media coverage of problems in the Irish charity sector has been quite detailed. In one case, a charity founder was clearly exerting a lot of control and taking money for personal use. In another, a group of people on social media demanded detailed accounting and controls in a charity with only a single permanent staff member.

In both cases, and there seems to be a lack of accountability as regards to how money was spent. The first case was to me simply fraud, but the second case is probably more typical of the issues faced by smaller charities in Ireland and other countries. That charities be held accountable for what they spend if of course right and proper, but to do so they require accounting and contol systems. These systems do not come free of charge. For example, even to have one qualified accountant in a charity would cost in the region of €70000 per annum. This may a considerable portion of the income of a smallef charity and herein lies the conundrum – the public want accountantability, but they also want administration costs to be minimised. What’s the answer to this conundrum? Well, I am not sure, gut the answer may lie in simple economies of scale – that is, perhaps there are too many smaller charities who could consolidate. Or possible governments or some regulatory agency could provide shared service type accounting arrangements for charities.

Teaching accountants

On a recent research project I read an article from 1914 which was written by an “old” accountant of the time. On testing accounting students knowledge through examinations (s)he notes “we see interesting problems set out in symmetry and order”. This made me think about what has changed today.

Indeed we still use examinations in university and in professional bodies. They are a good tool to test knowledge, and increasingly examinations draw on methods such as case scenarios which are less structured in an effort to imitate real life scenarios. However, no matter what we do as teachers, we cannot replicate the real world. This is of course where professional development and on the job training come in. I do hope we at least provide the basic knowledge to help students hit the ground running when they start their careers. We can only improve the value of this basic knowledge by trying to get students to use their knowledge in an unstructured way. In an examination scenario, this means we need to use fresh ideas and new ways to ask standard material – this can be tricky sometimes, but it helps both students and us teachers to apply ourselves in a more real world fashion.

Anglo Irish Bank – the circular transaction explained.

My colleague Michael Farrell has written a nice post explaining the dodgy accounting transactions at Anglo Irish Bank – the bank that was a big part of the Irish financial crisis in recent years.



Former executives from Anglo Irish Bank (“Anglo”) and Irish Life and Permanent (“ILP”) are alleged to have conspired to mislead investors by setting up a €7.2bn circular transaction scheme to bolster Anglo’s balance sheet in 2008.

The simplified debits and credits (from Anglo’s perspective) for the “circular transaction” as it’s being called are as follows:

1) Amount put on deposit with Anglo by ILP: 

Dr Cash €7.2bn

Cr Customer Deposits €7.2bn (shown as a liability)

2) Amount “lent” to ILP by Anglo:

Dr Loans and Advances to Banks €7.2bn (shown as an asset)

Cr Cash €7.2bn

Per the above, the transaction is cash neutral, so what’s the big deal? The issue is that the €7.2bn recorded as a customer deposit with the bank would be (and was) incorrectly interpreted by the bank’s wider stakeholders as a measure of customer confidence in the bank.

So where do the accounting rules stand on…

View original post 252 more words

Movies featuring accountants/accounting

Image from IMDB

Image from IMDB

A few weeks ago, the annual Academy Awards took place. At some point in the run up to the awards, I found a nice post by Cheryl Meyer in the Journal of Accountancy. The post “5 films to inspire CPAs” was not only a reminder of some great movies, but also a reminder of the varying and broad role accounting and accountants play in society.

On favourite on the list is The Shawshank Redemption. If you have never seen it, do. The lead character Andy Dufresne (Tim Robbins) makes life a little more comfortable for himself while serving time through doing tax returns for prison officers and keeping accounts of the Warden’s corrupt dealings. The good accounting allows Andy to take all the corrupt cash for himself on his escape from prison.

My second favourite is The Untouchables. The model used to imprison Al Capone in this movie is still widely used today – get the criminals on tax laws or “lack” of earning to match their lifestyle. For example, the Irish Criminal Assets Bureau uses this concept quite effectively. I’m a big Sean Connery fan too!




The versatility of gross profit margin



You may know the gross profit margin ratio, which is:

Gross Profit  x 100



Gross profit is: Sales – Cost of Sales


Cost of Sales = Opening inventory + Purchases/cost of production – Closing Inventory.

In this short post I would just like to share some of my experiences on the versatility of this simple ratio. If we look at the elements of the ratio, it is easy to see that if each element remain stable, the answer should also be stable. So for example, if I buy something for €40, sell it for €100, then my GP margin is 60%. If my sales price or purchase price changes, then the GP margin changes. Then, if we think about inventory levels, if these fluctuate the GP margin changes too. Taking all this together, it’s easy enough to see how any business typically knows what its GP margin should be. Thus, if it varies considerably, there may be something wrong.

Here are two things I know the GP margin is used for. One, from my own experience, is in pubs/bars.  Most pubs/bars are susceptible to fraud and controls typically put in place by owners. One such control is monthly stock-takes and monthly accounts. A fall in the GP margin could indicate “lost” stock or unrecorded cash receipts – which further controls may reveal. Another use is to spot inflated revenues. Businesses may want to make their profits look better and thus do things like invoice for goods early, before the end of a financial year. These good may not even be bought/made yet. Thus, the GP margin may be lower. Again further investigation is needed to find the issue.

There may of course be more simple reasons for changes in the GP margin – costs and sales prices may simply change and affect the ratio. But once these have been ruled out, it is a useful indicator.


Accounting for Bitcoin 


 We have probably all heard of the digital currency Bitcoin – there are some others but Bitcoin is the best known I think. I read a nice article on the Bitcoin magazine website recently which reminded me of the basic things us accountants need to consider if dealing in foreign currency or if a new currency comes along – it is not that long ago since the Euro came our way.

The article summarises well the three steps I experienced when operationalising the Euro more than a decade ago now. Like Bitcoin, the Euro was for me then a non-physical currency to begin with. The first “step” with the Euro and actually happening now with Bitcoin is use as a payment method. With the Euro, we had the ECU as a payment method first. In this case, the accounting entry is the same as any other payment method – such as a credit card or PayPal – all amounts are in local currency.  Step 2 would be to treat Bitcoin as a foreign currency. In my experience this typically happens when volumes of payments to/from customers/suppliers become larger. For example, many Irish SME treat GBP as a foreign currency in their accounting systems, but treat the USD more like a payment method. As the articles notes, if Bitcoin is treated as a foreign currency then exchange gains and losses need to be accounted for. Step 3 is adoption as a base currency. This may not happen of course, only time will tell. Let’s assume it does happen, then the accounting system works pretty much the same as in step 2. The would also be some work in translating assets and liabilities to the new currency. With the Euro this was relatively simple as fixed exchange rates were agreed and then it was matter of running a routine within the accounting software to do the calculations.

As the article suggests, more businesses are accepting Bitcoin (as its stabilises in value) and thus are at step 1.

Accounting can be bad for your health!

The bookkeeping end of accounting can certainly be a bit dull – even if it is the source of much accounting data. Dealing with invoices, receipts and other bits of paper is an absolutely necessity – the promised paperless office is still awaited.

An article in Forbes recently surprised me though. Apparently the thermal paper used in many till and other receipts can be quite harmful to your health. Have full read here


Incomplete records

Sometimes a business does not keep (or have) proper records. Most countries require a business to keep accounting records by law, so in my experience the only time a business does not have records is when there is something like a fire, or records are lost or destroyed. When this happens, there are several techniques which can be used to help “build” a set of accounts. Here is a nice article from CPA Ireland which details some of these.

Taxing bitcoin

You may have heard of bitcoin, the online “currency” causing quite a stir in recent times. Unlike many other online payment systems, bitcoin is outside the normal banking and currency systems – see more here about its history etc.

Being outside the normal banking and currency systems means the value of a bitcoin is difficult to determine. And, without going into too much detail here, speculators have caused the value of bitcoin to rise.

So now for the tax bit. An article from the Wall Street Journal last December noted some difficulties the IRS (and other tax authorities I’m sure) are facing. First, is a holding of bitcoin an asset which might be subject to capital gains taxes? It may be, but the first thing one needs to value an asset is a value ideally based on a market or cost basis. This might be tricky with bitcoin, given that it is not a real currency and the market is unregulated. Second, could gains or losses be treated as income? This is probably workable, as a gain or loss could be recorded on sale of bitcoins. But normally, marginal income taxes are higher than capital taxes. This would be fine for the tax authority I am sure, but holders of bitcoins might argue for the asset option – and so might their tax advisors. Only time will tell which option will be used.


Artificial intelligence in Accounting


In the latter part of 2013, I noticed several new developments in cloud accounting software. I suppose one of the key advantages of cloud accounting software is that it allows the software provider to concentrate on what they do well, while at the same time allow other software providers to integrate with their products. And, some of these products include some level of artificial intelligence.

To give an example of a non-cloud product first, Irish firm OCRex use optical character recognition to help accounting practices do bank reconciliations when smaller clients don’t do this – see This software reads scanned bank statements and reconciles opening and closing closing balances, and leaving the accountant with the job of checking for missing items only. Thus, this product is intelligent in that it matches items on the bank statement using amounts and other information like to a reference.

Now let’s take this idea to the cloud. Several accounting software products can now scan emails., faxes and scanned documents to determine not only the amount of a business transaction, but also determine what kind of transaction it is. For example, xero software offers an add-on which reads transactions and posts automatically to the correct expense account. From my understanding of the xero add-on, it also learns as it goes, learning what supplier is posted to which expenses account etc. This certainly has a lot of potential for small businesses, reducing processing time and storing documents in the cloud.

Cash accounting – an alternative to accruals accounting? And what about accounting software?

English: Accounting machine from UK manufactur...

English: Accounting machine from UK manufacturer Powers-Samas. (Norwegian Technology Museum, Oslo.) (Photo credit: Wikipedia)

In Ireland and the United Kingdom (and maybe come other countries) it has always been possible for smaller business to pay VAT based on cash received rather than on an accruals basis.  You probably know what the accruals concept is, but if not click here. When I teach accounting or prepare accounts, the accruals concept is used almost without exception. The profit & loss account (income statement) and balance sheet (statement of financial position) will definitely use the accruals concept. In fact, these  financial statement often take a different name and format when prepared for a cash-based business. For example, when I teach how to prepare the financial statement of not-for-profit organisations such as clubs, we often refer to a “Receipts and Payments Account” and a “Statement of Affairs”. The former is like an income statement, but is based on cash records; the latter is a list of assets and liabilities and will normally draw on the accruals concept.

From April 1st 2013, the UK tax authorities permits smaller unincorporated businesses to use a cash based accounting scheme where the turnover is less than £77,000 (see here for more detail). I’m not a UK tax expert, but from my reading about the topic on the web, the “income” of a small business will be the cash received, and the “expenses” will be cash paid for business expenses. This sounds like a reasonable effort to simplify the tax system for the smallest of businesses. The accruals concept may not be that relevant to many of these businesses as, for example, they may have few assets (to depreciate) and receive payment for most work as soon as it is done. So all fine? Well apparently, many accountants protested this new scheme, and that’s not surprising given how the accruals concept is engrained not only in the teaching of accounting, but also in accounting regulations. As a management accountant, I would always encourage the smallest of businesses to think in cash terms – it is easier for business owners with little accounting skills to understand. But I do see one big problem with this scheme in the UK. It centres around what happens when turnover exceeds £77,000. Once this happens, the business must revert to accruals accounting. This would cause much confusion if a business is using accounting software.  Normally, accounting software incorporates accruals accounting, but some also support cash accounting  in the way described here. I’m not 100% sure, but I would imagine if you set up software to work in one method, it may not be that easy to switch. So even though this cash scheme is easier and optional for small UK business, if they use accounting software (and more and more do) then it is probably best to stick to accruals accounting.

What is depreciation?

English: Assets Español: Activo diferido

Okay, the last two posts were about assets, and now I’d like to give a brief introduction to depreciation. As you may know the accruals concept (also known as the matching concept) sets out how revenues and expenditures should be matched against each other – when cash is paid/received is nots relevant. When a business buys a non-current asset, the accruals concept kicks-in. The asset itself is typically used by the business for several years, and thus generates revenue. So applying the accruals/matching concept, the cost of an asset needs to be matched against revenue over several years. How do we do this? Well, we depreciate the asset. This means the cost of the asset is spread over several years.

This raise two questions 1) how much per year and 2) over how many years? This is where certain assumptions are made. First, an estimated useful life of an asset is determined, for example from previous experience of a similar asset. Second, then business will attempt to assume whether the assets contributes to revenue earned equally over time, or more in earlier years for example. In the former case, the business might use what is termed the straight-line method – which charges an equal amount each year. For example, is an asset cost €10,000 and it’s useful life is 5 years, then the depreciation expense in the income statement each year is €2,000. On the statement of financial position, the asset value falls by €2,000 each year. If an asset is assumed to earn more revenue in earlier years, for example a motor van or truck, then the reducing balance method can be used. This method charges more depreciation in the earlier years. For example, if we assume an asset costs €10,000 and is depreciated at 10% reducing balance, here is what will happen:

Cost       €10,000

Year 1      (1,000) x 10%

Balance   9,000

Year 2      (900) x 10%

and so on…

Thus, using the reducing balance method, the asset will still have a value in the accounts for many years, but the depreciation charge will be smaller each year. If you think about the total costs of owning a car/van/truck, the repairs tend to get higher as it gets older, so the reducing balance method reflect this too.

How are assets classified in accounting?

Deutsch: Goldbarren mit einem Gewicht von 12,5...

In my previous post, I introduced assets. Now let’s see how assets are classified in accounting.

There are two major asset classifications 1) non-current and current, 2) tangible and intangible. Let’s have a brief look at each.

Non-current versus current assets

A non-current assets is one which typically cannot be converted into cash within one year. The classic example of a non-current asset is plant, property and equipment. Current assets normally convert into cash within one year e.g. receivables from customers, inventories. This non-current and current classification is used in the financial statements of most organisations.

Tangible versus intangible assets

This one is a little more tricky to understand, and it is something not normally seen on financial statements. As you might guess, a tangible asset is one which you can see and touch i.e it physically exists. Typically examples are again, plant, property and equipment, but also inventories are a tangible asset. Money due from customers is also arguably a tangible asset, as it does exist as money albeit somewhere outside the business. Intangible assets are those which do not physically exist, but yet have a value. This value may arise from intellectual or legal rights. For example, trademarks, patents, in-house software or knowledge built up through research and development are intangible assets. The accounting standard which governs intangible assets is IAS 38, and it gives some examples:

  • computer software
  • patents
  • copyrights
  • motion picture films
  • customer lists
  • mortgage servicing rights
  • licenses
  • import quotas
  • franchises
  • customer and supplier relationships
  • marketing rights.


What is an asset?

Economic tablet with numeric signs and Proto-E...

The next few posts will provide some basic accounting terms and definitions – concentrating mainly on assets.

So what is an asset? If I look at a dictionary, I might see something like “a useful thing” or a “desirable quality”. This may be correct in a general sense, but in accounting we need to get a bit more specific. But before we do that, would you regard something which is useful or desirable as having some value to you? I’ d hope you say yes. Now keep that in mind.

If I look to some accounting rules such as the IASB Framework I get the following:

” An asset is a resource controlled by the entity as a result of past events and from which future economic benefits are expected to flow to the entity”

Let’s break that down:

  • It is controlled –  does this mean you must own an asset. Simply, no, as you can control something, but not legally own it
  • It as a result of past events – this means you bought it or somehow acquired it or rights to use it in the past
  • Future economic benefits  will flow – this means it will be something which directly or indirectly allows the business to make money. For example, an office building does not sell anything (usually) or deliver goods, but without on the business cannot carry on its work to bring in those economic benefits i.e. cash and profits.

So, going back to the general idea I introduced at the start, if you want a very basic tip to identify an asset, think of it as something of value to a business – a truck, a machine, a building, customers you owe money etc,


%d bloggers like this: