Skip to main content


Simple book keeping basics

There are tons of jargon on accounting. But a lot of them are rubbish that used for categorizing the incomes, expenses and Tax.

What really matters are Balance Sheet and P&L (profit & loss) statement. If you really knows to read and understand these two then you know the
basic language in business. 

I'll go deeper on these if you guys interest or else please Google and read about these two.

Let me share a real world example of what I am talking about. Here is the Access Engineering PLC / Annual Report 2015/16

Please go to page 149 of the report and you will see the Statement of Profit or Loss.

And on page 150 of the report you see the Balance sheet (they call it as Statement of Financial Position).
And you can see it is balanced (of cause it is balance sheet)
Total Assets = Total Equity and Liabilities

Basically these are the things that people are supposed look at before investing on a busines…
Recent posts

My two cents on new year resolution

What is the plan for the new year ?

- need to think on what are we trying achieve during next year 2018
- basically the life goals
- may be personal or professional
- and also it should be realistic (not something like going to Mars ;))

Why we need a plan for the new year ?

- basically a goal without a plan is a DREAM
- And also should be able to measure (what you cannot measure, you cannot manage)

How to prepare a new Year resolution/plan ?

- Leave some buffer time
- Make changes during the year (life is changing/evolving)
- Plan is only for you (do not share it)
- When a milestone is achieved, celebrate
- Try to stick to the plan - otherwise no point of planing

Assets and Liabilities as Rich Dad, Poor Dad explains

I was reading "The rich dad poor dad by Robert Kiyosaki" here is a one point that he mentions on that.

Basically Asset as he says is little bit different than on books. If something puts money in your pocket it is a asset.
And Liabilities are the ones that takes money out of your pocket. OK for example a house or a car may seems like an Asset but it takes
money out of you pocket to maintain them. But if you rent them or make them to make money at the end of the day you can convert it
to a asset.
Basically that what rich people do. They buy assets.
Middle class buy liabilities (thinking those are assets) and stuff (a lot of them that not used or that not needed).
Lower class buy to consume (basic needs like foods).

11 Rules from Bill Gates

I watched a youtube video and thought to share with you all.

Bill Gates recently gave a speech at High School about 11 things they did not and will not learn in school. He talked about how to feel-good. Politically correct teachings have created a generation of kids with no concept of reality and how this concept set them up for failure in the real world.

Rule 1 : Life is not fair - get used to it!

Rule 2 : The world doesn't care about your self-esteem. The world will except you to accomplish something BEFORE you feel good about yourself.

Rule 3 : You will NOT make $60,000 a year right out of high school. You won't be a vice-president with a car, phone until you earn both.

Rule 4 : If you think your teacher is tough, wait till you get a boss.

Rule 5 : Flipping burgers is not beneath your dignity. Your Grandparents had a different word for burger flipping: they called in opportunity.

Rule 6 : If you messed up, it's not your parents' fault, so don't whine about your mistak…

Time Management by Brian Tracy

Was lucky to have a chance to watch a video done by Brian Tracy on Time Management. It was great and thought to do a short note on that. Here is the note and the video.

Here is the note I took by listening to it.

Goals - what is it you want to accomplish ? personal/family goalsbusiness/financial goalsself development goalsPlans of Action - put it in writing Analysis - Make a list (make the list of day before evening - to do list) Set Priorities - what is relevant and irrelevant ? what is the most valuable use of my time ? Concentration - Learn how ! - work on single task at time until it is completed Deadlines and Rewards - positive logical consequences. Time Log - where is all your time going ? Procrastination - positive or negative - Do it now! Do it now! Do it now! - get the job done fast Delegate - delegate everything you can - Clarity Think what you want done - write it downPick the right person to do itCrystal clear on what you want done and when you want doneCheck, Review, I…

Safari is randomly switching images on ios 5

Developed a Facebook app for mobiles and it was loading a lot of images through several AJAX requests. And was working fine on simulators tried and was given to Client for testing. But suddenly was receiving screenshots of the app that appears sooo wired.
With the details of the versions and devise he was testing I just Googled regarding this and found it is an error or a bug or a mistake or something that happens on Safari on iOS 5.
Best result found on this matter,

Successfully tested on latest iOS versions and also on few android devices and they were fine. My suggestion is please update your OS if you still got iOS 5.

Concat columns on GROUP BY in MySQL by Using GROUP_CONCAT

I was asked to give a report on the Invitations table as follows. What I wanted to give as the result is the invitee details per inviter. So simply I do not want to repeat the "inviter".

gayan         345        4654
kosala         345        7655
chamara         567        7653
nilanka         567        1236

So basic query for the demanding result is

"SELECT * FROM Invitations GROUP BY inviter;"

 But then what happens is some results are omitted. So I need to concat the "invitee" and "invitee_name" columns when grouping by 'inviter'.

For this MySQL simply gives a function as “GROUP_CONCAT”. Details can be seen on

So for this example what I have to do is

SELECT GROUP_CONCAT(invitee_name SEPARATOR ' || ') AS inviteeName, inviter, GROUP_CONCAT(invitee SEPARATOR ' || ') AS inviteeID FROM Invitations GR…