GST 2022 JAN TO DEC.XLS

	A	B	C	D	E	F	G	I	J	K	L	M	N
1
2	SALES - Standard rated		2021 JAN -MARCH					SALES - Zero rated
3
4	Invoice date	Invoice No.	Company Name	Sub total	Standard tax rate	Tax amount	Total amount	Invoice date	Invoice No.	Company Name	Currency	Sub total	Exchange rate
5	28/01/2022	RAA-00132	JAD SOLUTION	10,298.00	7%	720.86	11018.86
6	09-02-22	RAA-00137	RP	44,574.00	7%	3120.18	47694.18
7	28/02/2022	RAA-00138	JAD SOLUTION	16,961.00	7%	1187.27	18148.27
8	28/02/2022	RAA-00139	JAD SOLUTION	7,971.00	7%	557.97	8528.97
9	28/02/2022	RAA-00140	POWEN	60,000.00	7%	4200.00	64200.00
10	29/03/2022	RAA-00141	POWEN	22,737.00	7%	1591.59	24328.59
11	03-04-22	RAA-00144	RP	66,861.00	7%	4680.27	71541.27
12	05-04-22	RAA-00145	JAD SOLUTION	14,544.00	7%	1018.08	15562.08
13	29/03/2022	RAA-00142	POWEN	31,500.00	7%	2205.00	33705.00
14				275,446.00		19,281.22	294,727.22
15
16
17	PURCHASES
18
19	DATE	INVOICE NO	COMPANY NAME	SUB.TOTAL	TAX RATE	TAX AMOUNT	TOTAL AMOUNT
20	28/01/2022	2210300	CHOO CHIANG	722.00	7%	50.54	772.54
21	26/01/2022	MENG	MENG SOON	74.00	7%	5.18	79.18
22	31/01/2022	NCL 00078708	CRESTINDUSTRIAL	2,640.00	7%	184.80	2,824.80
23	44621	A22-000042	WF ACADEMY	520.00	7%	36.40	556.40
24	44588	22000715	ACCISE ASIA	2,206.00	7%	154.42	2,360.42
25	44589	633005	EBM PAPST	6,489.00	7%	454.23	6,943.23
26	44589	633005	EBM PAPST	12,978.00	7%	908.46	13,886.46
27	44581	KIMVIEW	KIM YEW	1,596.00	7%	111.72	1,707.72
28	44588	UBZ	UBZ STEM	122.40	7%	8.57	130.97
29	TOTAL	Jan-22	FEB 22 AND MARCH BILLS	76,159.92	7%	5,331.19	81,491.11
30	LORRY	DESIL	LORRY DIESEL BILLS FOR 3 MONTHS	7,800.00	7%	546.00	8,346.00
31	OTHERS	OVERHEAD	BILLS	1,500.00	7%	105.00	1,605.00
32	15/04/2022	NISSAN	NISSAN GBJ1568X	26,500.00	7%	1,855.00	28,355.00
33
34
35
36
37
38
39
40
41			SUB TOTAL AMOUNTS	139,307.32
42
43
44
45
46
47
48
49
50
51
52
53
54
55	GST Tax Computation
56
57
58
59				TOTAL	TOTAL TAX
60					7%
61	Sales
62	Standard rated			$275,446.00	$19,281.22
63	Zero rated			$-
64	Output tax				$19,281.22
65
66	Purchases
67	Standard rated			$139,307.00	$9,751.49
68	Less: Credit memo			$-	$-
69	Input tax				$9,751.49
70
71
72	Output tax			$19,281.22
73	Less: Input tax			$(9,751.49)
74	GST to be paid to IRAS			$9,529.73
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