2018-01-22

Tax Diary >> Term employee, sole proprietorship or incorporate?

It's the begining of tax season again. A co-worker came to me and shared his worries.  We are alike that he is also hired by an agency. Looks like the agency and him got some misunderstanding. On his pay stab, the CPP and EI were deducted, but not for federal and provincial tax.  He received a portion of GST/HST.

He was confused...

The 1st question I asked was whether he registered as  term employee,  sole-proprietorship or incorporate when signing the contract with agency.

Below pros and cons should be considered for these three scenarios.

>> Term employee:
- Pros
Easy to deal with, as agency will do the admin work mostly, including the source deduction of CPP, EI, federal and provincial tax remittance, and issue T4 on time
- Cons
However, agency will deduct admin fee from the earning, sometime cost about $3 -  $5 / hour earning depends on the party

>> Sole proprietorship
- Pros
It's a type of low cost business setup, good for small start-up and easy to handle. The owner can claim certain amount of business expenses depends on the nature of the business against the revenue and recover some GST/HST. it lowers personal income tax rate  under proper planning and common practices.
- Cons
Has unlimited liability, taxation income are reported via personal income tax return. Tax rate grows high when income reaches certain level

>> Incorporate
- Pros
The most income tax advantage and limited liability. As long as there is finance management set up at the beginning and followed well, not much issue expected at the year end
- Cons
Cost of setting up and administrative expenses

To sum up, if there is higher net income expected for the business, it's recommended to go incorporate instead of proprietorship and term employee.

~~~~~~




2018-01-19

Excel Excel - Numbers in icon format -

To increase the visual impact, turn the % or # format into a picture and catch attention, I use the conditional format...Home .... > Conditional formatting...> Icon sets

Useful, eye catching and visual management...




Read and share ~ Challenge

Like the quotes:

~ When you can't control what is happening around you, challenge yourself to control the way in which you respond...that is your true power lies

~ But at some point you have stop being so angry, you have to stop being so sad, you have to start being gentle with yourself.

~ At some point you have to just let it all go and be happy, you have to spread love instead of being afraid of it.

~ You have to love yourself and everyone around you before it's too late.

~ Don't waste away being unhappy over trivial things.

~ Don't do it, don't do it to yourself and don't let other people do it to you.

2018-01-18

Excel Excel - Display a sheet name in a cell -

* While I was organizing a audit file, there are over 55 samples need to group into one file. Want to get Excel to show the sheet name automatically in a cell so avoid to type the sample# for every sheet...*

How to display a sheet name in a cell:

- Location of the cell is B1

- Then the formula:

=MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255)



Excel Excel - Date and Julian Date format -

* Helped a co-worker to solve his questions, and make my own notes *

How to transfer between Date and Julian Date format 


Date: May 1, 2017 (A6)

Julian: 2017121  (B6=YEAR(A6)&TEXT(A6-DATE(YEAR(A6),1,0),"000")

Reversed back  (C6=DATE(LEFT(B6,4),1,RIGHT(B6,3))

Coffee to start ~

最近这几年, 一天的开始通常是一杯黑咖啡, 接着的时间里是绿茶, 再后面就是柠檬水了~

这样, 我可以一整天做事, 不会觉得太疲倦

原来, 和数字有关的工作, 大有乐趣

也是这几年, 觉得自己也可以一整天, 一整天从处理, 分析, 运算中, 感到平静与快乐

很大的改变

2012-02-03

Welcome back!

Rabbit told me to continue my blog life ~
"Welcome back!". I like this sentence, since it maybe my boss or one of my co-workers resume to their work after the long and happy vacation. They talk about the funny stories during their journeys and that reminds me a lot, I used to travel different places, but now I've settled down.
Who knows, maybe one day we will go for an adventure somewhere again.

Followers