What goes into each box -Colombia VAT report

Note:

Nondeductible tax codes created by checking the 100% Non-deductible box on the Tax Code page is not supported. If you want to create nondeductible tax codes that will work with International Tax Reports SuiteApp, see Setting Up Nondeductible Input Tax.

The following table shows how NetSuite uses the tax codes to get the values for the Colombia VAT report.

Note:

This table is for the 2013 Colombia VAT Form 300.

Box	Description	Content
	Income
27	For operations taxed at 5%	Net amount of sales S5-CO +Net amount of sales journal S5-CO
28	For operations taxed at the general rate	Net amount of sales S-CO +Net amount of sales journal S-CO
29	Overhead, contingencies, and profit(s) for taxed operations (special tax base)	Editable field
30	For the export of goods	Net amount of sales X-CO +Net amount of sales journal X-CO
31	For the export of services	Net amount of sales XS-CO +Net amount of sales journal XS-CO
32	For sales to international trading companies	Editable field
33	For sales to Free Zones	Editable field
34	For gambling and games of chance	Net amount of sales SG-CO. Zero if there is no sale.
35	For exempt operations (Articles 477, 478, and 481 of the Tax Code)	Net amount of sales E-CO +Net amount of sales journal E-CO
36	For the sale of national or imported beer	Net amount of sales SB-CO. Zero if there is no sale.
37	For excluded operations	Net amount of sales NT-CO +Net amount of sales Journal NT-CO
38	For untaxed operations	Net amount of sales N-CO +Net amount of sales journal N-CO
39	Total gross income (Sum of 27 to 38)	Sum of boxes 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, and 38
40	Returns on voided, rescinded or resolved sales	Net amount of sales returns/credit memos S-CO, SG-CO, SB-CO, E-CO, X-CO, XS-CO, S5-CO. Zero if there is no return.
41	Total net income for the period (39 – 40)	39 – 40
	Purchases
	Imported
42	Of goods taxed at 5% rate	Net amount of purchases I5-CO
43	Of goods taxed at the general rate	Net amount of purchases I-CO +Net amount of purchase journal I-CO
44	Of taxed goods and services from Free Zones	Editable field
45	Of untaxed goods	Net amount of purchases NI-CO IN-CO+Net amount of purchase journal IN-CO
46	Of untaxed goods and services from Free Zones	Editable field
47	Of Services	Net amount of purchases IS-CO +Net amount of purchase journal IS-CO
	National
48	Of goods taxed at 5% rate	Net amount of purchases r-co +Net amount of purchase journal R-CO
49	Of goods taxed at the general rate	Net amount of purchases S-CO +Net amount of purchase journal S-CO
50	Of services taxed at 5% rate	Net amount of purchases S5S-CO
51	Of services taxed at the general rate	Net amount of purchases SS-CO +Net amount of purchase journal SS-CO
52	Of untaxed goods and services	Net amount of purchases N-CO +Net amount of purchase journal N-CO
53	Total purchases and gross imports (Sum of 42 to 52)	Sum of boxes 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, and 52
54	Returns on voided, rescinded, or resolved purchases in this period	Net amount of purchase returns S-CO, SS-CO, I-CO, I5-CO, IS-CO, S5-CO, S5S-CO, N-CO
55	Total net purchases made during the period (53 – 54)	53 – 54
	Private liquidation
	Generated tax
56	At 5% rate	Sales tax amount S5-CO +Sales journal tax amount of S5-CO +Sales adjustment tax amount box56, S5-CO Zero if there is no sale.
57	At the general rate	Sales tax amount S-CO +Sales journal tax amount S-CO +Sales adjustment tax amountbox57, S-CO Zero if there is no sale.
58	Over overhead, contingencies, and profit(s) on taxed operations (special tax base)	Editable field. Zero if there is no value.
59	On gambling and games of chance	Sales tax amount SG-CO. Zero if there is no value.
60	On the sale of national or imported beer	Sales tax amount SB-CO. Zero if there is no value.
61	On removal from inventory for fixed assets, consumption, free samples or donations	Editable field
62	VAT recovered through refunds of voided, rescinded or resolved purchases	Tax amount of purchase returns from box 54
63	Total tax generated through taxed operations (Sum of 56 to 62)	Sum of boxes 56, 57, 58, 59, 60, 61, and 62
	Deductible tax
64	For imports taxed at 5% rate	Purchase tax amount I5-CO +Purchase journal tax amount I5-CO +Purchase adjustment tax amount box64, I5-CO
65	For imports taxed at the general rate	Purchase tax amount I-CO +Purchase journal tax amount I-CO +Purchase adjustment tax amount box65, I-CO
66	Of taxed goods and services from Free Zones	Editable field
67	For purchases of goods taxed at 5% rate	Purchase tax amount S5-CO +Purchase journal tax amount S5-CO +Purchase adjustment tax amount box67, S5-CO
68	For purchases of goods taxed at the general rate	Purchase tax amount S-CO +Purchase journal tax amount S-CO +Purchase adjustment tax amount box68, S-CO
69	For services taxed at 5% rate	Purchase tax amount S5S-CO +Purchase journal tax amount S5S-CO +Purchase adjustment tax amount box69, S5S-CO
70	For services taxed at the general rate	Purchase tax amount SS-CO and IS-CO +Purchase journal tax amount SS-CO, IS-CO +Purchase adjustment tax amount box70, SS-CO, IS-CO
71	Total tax paid or billed (Sum of 64 to 70)	Sum of boxes 64, 65, 66, 67, 68, 69, and 70
72	VAT retained on simplified regime operations	Editable field
73	VAT retained for serviced rendered in Colombia by non-resident or non-domiciled persons	Editable field
74	VAT resulting from returns on voided, rescinded, or resolved sales	Sales tax amount of sales returns (sale transactions from box 40)
75	Deductible VAT for National Fuel Tax and Motor Fuel Oil Tax	Editable field
76	Deductible tax adjustment (loss, theft, or inventory write-offs)	Editable field
77	Total deductible taxes (71 + 72 + 73 + 74 + 75 – 76)	Sum of boxes 71, 72, 73, 74, 75, minus 76
78	Balance payable for the tax period (63 – 77, if the result is less than zero, please write 0)	63 – 77 Zero if the result is less than zero.
79	Balance in favor for the tax period (77 – 63, if the result is less than zero, please write 0)	77 – 63 Zero if the result is less than zero.
80	Balance in favor for the previous tax period	Editable field
81	VAT withholdings made	Editable field
82	Balance payable for tax (78 – 80 – 81, if the result is less than zero, please write 0)	78 – 80 – 81 Zero if the result is less than zero.
83	Penalties	Editable field
84	Total balance payable for this period (78 – 79 – 80 – 81 + 83), if the result is zero, please write 0)	78 – 79 – 80 – 81 + 83 Zero if the result is less than zero
85	or Total balance in favor for this period (79 + 80 + 81 – 78 – 83, if the result is less than zero, please write 0)	79 + 80 + 81 – 78 – 83 Zero if the result is less than zero
	Deductible excess
86	Due to a difference in the rate for this period if you have a balance in favor	Editable field
87	Due to a difference in the rate accumulated in previous periods awaiting application	Editable field
88	Due to a difference in the rate to be applied in the following period (86 +87)	86 +87
	VAT withholding
89	Made in this period but not applied	Editable field
90	Made in previous periods not applied	Editable field
91	To be applied in the following period (89 +90)	89 +90
92	Deductible for sales in the period	Editable field
93	Deductible previous periods over the sales for the period	Editable field
94	Excess deductible tax not eligible to be offset and/or returned (85 – 88 – 91)	85 – 88 – 91
980	Total payment $	Editable field

Box

Description

Content

Income

For operations taxed at 5%

Net amount of sales S5-CO +Net amount of sales journal S5-CO

For operations taxed at the general rate

Net amount of sales S-CO +Net amount of sales journal S-CO

Overhead, contingencies, and profit(s) for taxed operations (special tax base)

Editable field

For the export of goods

Net amount of sales X-CO +Net amount of sales journal X-CO

For the export of services

Net amount of sales XS-CO +Net amount of sales journal XS-CO

For sales to international trading companies

Editable field

For sales to Free Zones

Editable field

For gambling and games of chance

Net amount of sales SG-CO.

Zero if there is no sale.

For exempt operations (Articles 477, 478, and 481 of the Tax Code)

Net amount of sales E-CO +Net amount of sales journal E-CO

For the sale of national or imported beer

Net amount of sales SB-CO.

Zero if there is no sale.

For excluded operations

Net amount of sales NT-CO +Net amount of sales Journal NT-CO

For untaxed operations

Net amount of sales N-CO +Net amount of sales journal N-CO

Total gross income (Sum of 27 to 38)

Sum of boxes 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, and 38

Returns on voided, rescinded or resolved

sales

Net amount of sales returns/credit memos S-CO, SG-CO, SB-CO, E-CO, X-CO, XS-CO, S5-CO.

Zero if there is no return.

Total net income for the period (39 – 40)

39 – 40

Purchases

Imported

Of goods taxed at 5% rate

Net amount of purchases I5-CO

Of goods taxed at the general rate

Net amount of purchases I-CO +Net amount of purchase journal I-CO

Of taxed goods and services from Free Zones

Editable field

Of untaxed goods

Net amount of purchases NI-CO IN-CO+Net amount of purchase journal IN-CO

Of untaxed goods and services from Free Zones

Editable field

Of Services

Net amount of purchases IS-CO +Net amount of purchase journal IS-CO

National

Of goods taxed at 5% rate

Net amount of purchases r-co +Net amount of purchase journal R-CO

Of goods taxed at the general rate

Net amount of purchases S-CO +Net amount of purchase journal S-CO

Of services taxed at 5% rate

Net amount of purchases S5S-CO

Of services taxed at the general rate

Net amount of purchases SS-CO +Net amount of purchase journal SS-CO

Of untaxed goods and services

Net amount of purchases N-CO +Net amount of purchase journal N-CO

Total purchases and gross imports (Sum of 42 to 52)

Sum of boxes 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, and 52

Returns on voided, rescinded, or resolved purchases in this period

Net amount of purchase returns S-CO, SS-CO, I-CO, I5-CO, IS-CO, S5-CO, S5S-CO, N-CO

Total net purchases made during the period (53 – 54)

53 – 54

Private liquidation

Generated tax

At 5% rate

Sales tax amount S5-CO +Sales journal tax amount of S5-CO +Sales adjustment tax amount box56, S5-CO

Zero if there is no sale.

At the general rate

Sales tax amount S-CO +Sales journal tax amount S-CO +Sales adjustment tax amountbox57, S-CO

Zero if there is no sale.

Over overhead, contingencies, and profit(s) on taxed operations (special tax base)

Editable field.

Zero if there is no value.

On gambling and games of chance

Sales tax amount SG-CO.

Zero if there is no value.

On the sale of national or imported beer

Sales tax amount SB-CO.

Zero if there is no value.

On removal from inventory for fixed assets, consumption, free samples or donations

Editable field

VAT recovered through refunds of voided, rescinded or resolved purchases

Tax amount of purchase returns from box 54

Total tax generated through taxed operations (Sum of 56 to 62)

Sum of boxes 56, 57, 58, 59, 60, 61, and 62

Deductible tax

For imports taxed at 5% rate

Purchase tax amount I5-CO +Purchase journal tax amount I5-CO +Purchase adjustment tax amount box64, I5-CO

For imports taxed at the general rate

Purchase tax amount I-CO +Purchase journal tax amount I-CO +Purchase adjustment tax amount box65, I-CO

Of taxed goods and services from Free Zones

Editable field

For purchases of goods taxed at 5% rate

Purchase tax amount S5-CO +Purchase journal tax amount S5-CO +Purchase adjustment tax amount box67, S5-CO

For purchases of goods taxed at the general rate

Purchase tax amount S-CO +Purchase journal tax amount S-CO +Purchase adjustment tax amount box68, S-CO

For services taxed at 5% rate

Purchase tax amount S5S-CO +Purchase journal tax amount S5S-CO +Purchase adjustment tax amount box69, S5S-CO

For services taxed at the general rate

Purchase tax amount SS-CO and IS-CO +Purchase journal tax amount SS-CO, IS-CO +Purchase adjustment tax amount box70, SS-CO, IS-CO

Total tax paid or billed (Sum of 64 to 70)

Sum of boxes 64, 65, 66, 67, 68, 69, and 70

VAT retained on simplified regime operations

Editable field

VAT retained for serviced rendered in Colombia by non-resident or non-domiciled persons

Editable field

VAT resulting from returns on voided, rescinded, or resolved sales

Sales tax amount of sales returns (sale transactions from box 40)

Deductible VAT for National Fuel Tax and Motor Fuel Oil Tax

Editable field

Deductible tax adjustment (loss, theft, or inventory write-offs)

Editable field

Total deductible taxes (71 + 72 + 73 + 74 + 75 – 76)

Sum of boxes 71, 72, 73, 74, 75, minus 76

Balance payable for the tax period (63 – 77, if the result is less than zero, please write 0)

63 – 77

Zero if the result is less than zero.

Balance in favor for the tax period (77 – 63, if the result is less than zero, please write 0)

77 – 63

Zero if the result is less than zero.

Balance in favor for the previous tax period

Editable field

VAT withholdings made

Editable field

Balance payable for tax (78 – 80 – 81, if the result is less than zero, please write 0)

78 – 80 – 81

Zero if the result is less than zero.

Penalties

Editable field

Total balance payable for this period (78 – 79 – 80 – 81 + 83), if the result is zero, please write 0)

78 – 79 – 80 – 81 + 83

Zero if the result is less than zero

or Total balance in favor for this period (79 + 80 + 81 – 78 – 83, if the result is less than zero, please write 0)

79 + 80 + 81 – 78 – 83

Zero if the result is less than zero

Deductible excess

Due to a difference in the rate for this period if you have a balance in favor

Editable field

Due to a difference in the rate accumulated in previous periods awaiting application

Editable field

Due to a difference in the rate to be applied in the following period (86 +87)

86 +87

VAT withholding

Made in this period but not applied

Editable field

Made in previous periods

not applied

Editable field

To be applied in the following period (89 +90)

89 +90

Deductible for sales in the period

Editable field

Deductible previous periods over the sales for the period

Editable field

Excess deductible tax not eligible to be offset and/or returned (85 – 88 – 91)

85 – 88 – 91

980

Total payment $

Editable field

Related Topics