Japan ESL Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
FILL IN THE YELLOW BOXES
2
Enter Your Annual Salary (in yen)Is this your first year in Japan?Sample Items (City)Price
3
¥2,880,000yesFoodEmployment Income Deduction (inhabitant for second year plus)Employment Income Deduction (inhabitant for first year)no. of months of inhabitants tax to be paid for first year teachersNumber of health insurance payments made in previous year for first year teachers
4
Is your teacher contract explictly less than a year? (yes or no)Please enter 0 belowMilk (1 litre)¥180Calculation Intermidiate Cells
5
no0Cheese (1kg)¥1,500
6
N/A, please leave the cell below blankPlease enter 0 belowDozen Eggs¥200
7
0White Bread ¥19065000065000055
8
When did you arrive in Japan? (Jan, Feb, etc.)Rice (1kg)¥450
9
augChicken Breasts¥765
10
Is your contract either 29.5 hours or less, a week?1 packet of cigarettes (Marlboro)¥420//https://www.nenkin.go.jp/n/www/english/detail.jsp?id=45
11
noDomestic Beer (0.5 L)¥250Pension agreements with everyone bar NZ and SA mean you are exempt from pension http://forum.gaijinpot.com/forum/working-in-japan/banking-finance/94566-do-i-absolutely-have-to-pay-the-pension-nenkin/page2
12
13
National Health Insurance¥143,712Official ^Original Lead ^
14
National Pension ¥246,528
15
Taxable Income after Deductions ¥1,065,760
16
Income Tax¥54,407Miscellaneous
17
Local Inhabitant tax¥10,740Gym (per month)¥7,000
18
Movie Ticket (International Release)¥1,700
19
Salary After Tax (Month) ¥202,051Eating Out (Local)¥800
20
Eating Out (Western)¥1,000
21
Monthly Expenses (thousands)153160
22
Rent*¥50,000
23
Utilities (Gas, water, electric)*¥10,000Why all the questions?
24
Internet¥5,000For contracts greater than 29.5 hours a week you're a full time worker and should be signed up to Japan's Social Insurance scheme. If you know you're not signed up then put yes regardless of your contract.
25
Food*¥35,000
26
Travel*¥15,000
27
Mobile Phone¥7,000
28
When you arrive in Japan matters because tax and social security change depending on the date you enter the country on. This is also why it matters if it's your first year.
29
Salary After Expenses (per Month)¥80,051
30
31
Totals for the Year (millions)
32
Yearly Money Earned (Salary)¥2,880,000There's a full explanation of all this stuff in detail and some example calculations over at:
33
Bonus¥240,000
34
Pension Lump Sum*¥394,444.8A Guide to Expat Tax & Social Security in Japan 2014
35
Airfare Costs*¥148,376
36
Airfare Reimbursement¥0Created by teflSearch.com
37
Apartment One Off Costs (Key Money)*100000
38
39
Total Earned¥3,266,069You're free to put this wherever you like, or use it wherever you like as long as you leave the logo and the link on.
40
Total Earned After Expenses¥1,346,682
41
42
43
Notes*
44
Rent is typically subsized by your employer and sub-letted off them.Utility bills are for a single person flat. If you're living with others then by large they'll be smaller, the increased number of people outweighing the extra size. This is also averaged out, gas costs can rocket up in the winter and electricity in summer.If you have any problems or find errors please email me at info@teflsearch.com
45
This includes grocies, not eating out.
46
The pension lump sum has a 20% withholding tax taken off it. By signing up with an insurance agent you can reclaim a chunk of this. (Not calculated in spreadsheet).
47
48
49
There are a number of apartment costs in Japan. You'll also be charged a deposit which you should get back.Travel just includes commuting costs, not weekend trips etc.
50
51
Airfare repayment isn't standard in Japan.
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Example Budget
Create Your Own