Packing list and commercial invoice for export

PACKING LIST
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.

Exporter			Sunrise Coconut Products Inc. (sample), Davao City, Philippines					Invoice No.	SCP-EX-2026-031	Invoice date	2026-10-15	Buyer PO No.	NP-PO-7781
Consignee (buyer)			Nordic Pantry AB (sample), Gothenburg, Sweden					Incoterms 2020	FOB	Port of loading	Davao, PH	Port of discharge	Gothenburg, SE
Notify party			Same as consignee					Vessel / voyage	MV Example 042E	Container No.	ABCU 123456-7	Country of origin	Philippines
Marks & numbers			NORDIC PANTRY / GOTHENBURG / C/NO. 1-UP / MADE IN PHILIPPINES

Carton from	Carton to	Cartons	Description of goods	HS code	Qty per carton	Total qty	Net wt/ctn (kg)	Gross wt/ctn (kg)	Total net (kg)	Total gross (kg)	L (cm)	W (cm)	H (cm)	CBM
1	400	400	Virgin coconut oil, 500 ml glass bottle	1,513.11	12	C10*N(F10)	6.60	8.40	C10*N(H10)	C10*N(I10)	40	30	25	ROUND(C10N(L10)N(M10)*N(N10)/1000000,3)
401	700	300	Desiccated coconut, fine, 1 kg pouch	801.11	10	C11*N(F11)	10.00	10.60	C11*N(H11)	C11*N(I11)	50	35	30	ROUND(C11N(L11)N(M11)*N(N11)/1000000,3)
701	820	120	Coconut sugar, 500 g pouch	1,702.90	20	C12*N(F12)	10.00	10.50	C12*N(H12)	C12*N(I12)	45	35	25	ROUND(C12N(L12)N(M12)*N(N12)/1000000,3)
		-				C13*N(F13)			C13*N(H13)	C13*N(I13)				ROUND(C13N(L13)N(M13)*N(N13)/1000000,3)
		-				C14*N(F14)			C14*N(H14)	C14*N(I14)				ROUND(C14N(L14)N(M14)*N(N14)/1000000,3)
		-				C15*N(F15)			C15*N(H15)	C15*N(I15)				ROUND(C15N(L15)N(M15)*N(N15)/1000000,3)
		-				C16*N(F16)			C16*N(H16)	C16*N(I16)				ROUND(C16N(L16)N(M16)*N(N16)/1000000,3)
		-				C17*N(F17)			C17*N(H17)	C17*N(I17)				ROUND(C17N(L17)N(M17)*N(N17)/1000000,3)
		-				C18*N(F18)			C18*N(H18)	C18*N(I18)				ROUND(C18N(L18)N(M18)*N(N18)/1000000,3)
		-				C19*N(F19)			C19*N(H19)	C19*N(I19)				ROUND(C19N(L19)N(M19)*N(N19)/1000000,3)
		-				C20*N(F20)			C20*N(H20)	C20*N(I20)				ROUND(C20N(L20)N(M20)*N(N20)/1000000,3)
		-				C21*N(F21)			C21*N(H21)	C21*N(I21)				ROUND(C21N(L21)N(M21)*N(N21)/1000000,3)
		-				C22*N(F22)			C22*N(H22)	C22*N(I22)				ROUND(C22N(L22)N(M22)*N(N22)/1000000,3)
		-				C23*N(F23)			C23*N(H23)	C23*N(I23)				ROUND(C23N(L23)N(M23)*N(N23)/1000000,3)
		-				C24*N(F24)			C24*N(H24)	C24*N(I24)				ROUND(C24N(L24)N(M24)*N(N24)/1000000,3)
		-				C25*N(F25)			C25*N(H25)	C25*N(I25)				ROUND(C25N(L25)N(M25)*N(N25)/1000000,3)
		-				C26*N(F26)			C26*N(H26)	C26*N(I26)				ROUND(C26N(L26)N(M26)*N(N26)/1000000,3)
		-				C27*N(F27)			C27*N(H27)	C27*N(I27)				ROUND(C27N(L27)N(M27)*N(N27)/1000000,3)
		-				C28*N(F28)			C28*N(H28)	C28*N(I28)				ROUND(C28N(L28)N(M28)*N(N28)/1000000,3)
		-				C29*N(F29)			C29*N(H29)	C29*N(I29)				ROUND(C29N(L29)N(M29)*N(N29)/1000000,3)
TOTAL		820				SUM(G10:G29)			SUM(J10:J29)	SUM(K10:K29)				SUM(O10:O29)
TEXT(C30,"#,##0")&" cartons · net "&TEXT(J30,"#,##0.00")&" kg · gross "&TEXT(K30,"#,##0.00")&" kg · "&TEXT(O30,"0.000")&" m³"
IF(SUMPRODUCT((C10:C29>0)*(K10:K29<J10:J29))>0,"CHECK: gross weight below net weight on a line","Weights OK")

Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.
© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

COMMERCIAL INVOICE
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.

Exporter	Sunrise Coconut Products Inc. (sample), Davao City, Philippines				Currency	USD
Consignee	Nordic Pantry AB (sample), Gothenburg, Sweden				Payment terms	T/T 30 days
Invoice No.	SCP-EX-2026-031
Invoice date	2026-10-15
Incoterms	FOB Davao, PH
Buyer PO No.	NP-PO-7781
Country of origin	Philippines

#	Description of goods	HS code	Quantity	Unit	Unit price	Amount
1	Virgin coconut oil, 500 ml glass bottle	1,513.11	'Packing list'!G10	pcs	7.20	ROUND(N(D13)*N(F13),2)
2	Desiccated coconut, fine, 1 kg pouch	801.11	'Packing list'!G11	pcs	3.90	ROUND(N(D14)*N(F14),2)
3	Coconut sugar, 500 g pouch	1,702.90	'Packing list'!G12	pcs	2.60	ROUND(N(D15)*N(F15),2)
			'Packing list'!G13			ROUND(N(D16)*N(F16),2)
			'Packing list'!G14			ROUND(N(D17)*N(F17),2)
			'Packing list'!G15			ROUND(N(D18)*N(F18),2)
			'Packing list'!G16			ROUND(N(D19)*N(F19),2)
			'Packing list'!G17			ROUND(N(D20)*N(F20),2)
			'Packing list'!G18			ROUND(N(D21)*N(F21),2)
			'Packing list'!G19			ROUND(N(D22)*N(F22),2)
			'Packing list'!G20			ROUND(N(D23)*N(F23),2)
			'Packing list'!G21			ROUND(N(D24)*N(F24),2)
			'Packing list'!G22			ROUND(N(D25)*N(F25),2)
			'Packing list'!G23			ROUND(N(D26)*N(F26),2)
			'Packing list'!G24			ROUND(N(D27)*N(F27),2)
			'Packing list'!G25			ROUND(N(D28)*N(F28),2)
			'Packing list'!G26			ROUND(N(D29)*N(F29),2)
			'Packing list'!G27			ROUND(N(D30)*N(F30),2)
			'Packing list'!G28			ROUND(N(D31)*N(F31),2)
			'Packing list'!G29			ROUND(N(D32)*N(F32),2)
"Packages: "&TEXT('Packing list'!C30,"#,##0")&" cartons · net "&TEXT('Packing list'!J30,"#,##0.00")&" kg · gross "&TEXT('Packing list'!K30,"#,##0.00")&" kg"			Total goods value			SUM(G13:G32)
			Freight (if in the price)			-
			Insurance (if in the price)			-
			TOTAL INVOICE VALUE			G33+G34+G35

We certify that this invoice is true and correct and that the goods are of Philippine origin.


				Authorised signature, name, date

© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.

STATEMENT OF SHIPMENTS AND PAYMENTS — for the buyer
Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them.
Buyer	Nordic Pantry AB (sample), Gothenburg, Sweden				Statement date	2026-10-19

Date	Document	B/L or AWB	Invoiced	Paid	Balance	Due date	Days overdue	Status
2026-07-20	SCP-EX-2026-019	BL DVO-55102	21,840.00	-	21,840.00	2026-08-19	IF(I6="Overdue",$G$3-G6,"")	IF(N(D6)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D6)-0.005,"Paid",IF(AND(G6<>"",G6<$G$3),"Overdue","Open")))
2026-08-18	Payment T/T		-	21,840.00	-		IF(I7="Overdue",$G$3-G7,"")	IF(N(D7)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D7)-0.005,"Paid",IF(AND(G7<>"",G7<$G$3),"Overdue","Open")))
2026-09-10	SCP-EX-2026-026	BL DVO-55870	18,920.00	-	18,920.00	2026-10-10	IF(I8="Overdue",$G$3-G8,"")	IF(N(D8)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D8)-0.005,"Paid",IF(AND(G8<>"",G8<$G$3),"Overdue","Open")))
2026-10-02	Payment T/T (part)		-	10,000.00	8,920.00		IF(I9="Overdue",$G$3-G9,"")	IF(N(D9)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D9)-0.005,"Paid",IF(AND(G9<>"",G9<$G$3),"Overdue","Open")))
2026-10-15	SCP-EX-2026-031	BL DVO-56311	'Commercial invoice'!G36	-	IF(AND(D10="",E10=""),"",SUM($D$6:D10)-SUM($E$6:E10))	2026-11-14	IF(I10="Overdue",$G$3-G10,"")	IF(N(D10)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D10)-0.005,"Paid",IF(AND(G10<>"",G10<$G$3),"Overdue","Open")))
							IF(I11="Overdue",$G$3-G11,"")	IF(N(D11)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D11)-0.005,"Paid",IF(AND(G11<>"",G11<$G$3),"Overdue","Open")))
							IF(I12="Overdue",$G$3-G12,"")	IF(N(D12)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D12)-0.005,"Paid",IF(AND(G12<>"",G12<$G$3),"Overdue","Open")))
							IF(I13="Overdue",$G$3-G13,"")	IF(N(D13)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D13)-0.005,"Paid",IF(AND(G13<>"",G13<$G$3),"Overdue","Open")))
							IF(I14="Overdue",$G$3-G14,"")	IF(N(D14)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D14)-0.005,"Paid",IF(AND(G14<>"",G14<$G$3),"Overdue","Open")))
							IF(I15="Overdue",$G$3-G15,"")	IF(N(D15)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D15)-0.005,"Paid",IF(AND(G15<>"",G15<$G$3),"Overdue","Open")))
							IF(I16="Overdue",$G$3-G16,"")	IF(N(D16)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D16)-0.005,"Paid",IF(AND(G16<>"",G16<$G$3),"Overdue","Open")))
							IF(I17="Overdue",$G$3-G17,"")	IF(N(D17)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D17)-0.005,"Paid",IF(AND(G17<>"",G17<$G$3),"Overdue","Open")))
							IF(I18="Overdue",$G$3-G18,"")	IF(N(D18)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D18)-0.005,"Paid",IF(AND(G18<>"",G18<$G$3),"Overdue","Open")))
							IF(I19="Overdue",$G$3-G19,"")	IF(N(D19)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D19)-0.005,"Paid",IF(AND(G19<>"",G19<$G$3),"Overdue","Open")))
							IF(I20="Overdue",$G$3-G20,"")	IF(N(D20)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D20)-0.005,"Paid",IF(AND(G20<>"",G20<$G$3),"Overdue","Open")))
							IF(I21="Overdue",$G$3-G21,"")	IF(N(D21)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D21)-0.005,"Paid",IF(AND(G21<>"",G21<$G$3),"Overdue","Open")))
							IF(I22="Overdue",$G$3-G22,"")	IF(N(D22)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D22)-0.005,"Paid",IF(AND(G22<>"",G22<$G$3),"Overdue","Open")))
							IF(I23="Overdue",$G$3-G23,"")	IF(N(D23)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D23)-0.005,"Paid",IF(AND(G23<>"",G23<$G$3),"Overdue","Open")))
							IF(I24="Overdue",$G$3-G24,"")	IF(N(D24)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D24)-0.005,"Paid",IF(AND(G24<>"",G24<$G$3),"Overdue","Open")))
							IF(I25="Overdue",$G$3-G25,"")	IF(N(D25)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D25)-0.005,"Paid",IF(AND(G25<>"",G25<$G$3),"Overdue","Open")))
							IF(I26="Overdue",$G$3-G26,"")	IF(N(D26)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D26)-0.005,"Paid",IF(AND(G26<>"",G26<$G$3),"Overdue","Open")))
							IF(I27="Overdue",$G$3-G27,"")	IF(N(D27)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D27)-0.005,"Paid",IF(AND(G27<>"",G27<$G$3),"Overdue","Open")))
							IF(I28="Overdue",$G$3-G28,"")	IF(N(D28)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D28)-0.005,"Paid",IF(AND(G28<>"",G28<$G$3),"Overdue","Open")))
							IF(I29="Overdue",$G$3-G29,"")	IF(N(D29)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D29)-0.005,"Paid",IF(AND(G29<>"",G29<$G$3),"Overdue","Open")))
							IF(I30="Overdue",$G$3-G30,"")	IF(N(D30)=0,"",IF(SUM($E$6:$E$30)>=SUM($D$6:D30)-0.005,"Paid",IF(AND(G30<>"",G30<$G$3),"Overdue","Open")))

Total balance due					SUM(D6:D30)-SUM(E6:E30)
Note: payments are applied to the oldest invoice first; "Days overdue" counts from the due date to the statement date.

© Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers.