Demo Billing_Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J
1	FC1 3PL MONTHLY BILLING INVOICE								All numbers are fake for the purposes of demo
2	Please scroll down to see different categories of charges
3	Select Billing Month:	October 2025	<<--Change billing month in dropdown			Filter by Client (optional):	All Clients
4

5
6	BILLING SUMMARY
7	Category	Description	Amount	% of Total
8	Fulfillment Charges	See itemized list below	$266.16	100.0%
9	Receiving Charges	See itemized list below	$0.00	0.0%
10	Storage Charges	See itemized list below	$0.00	0.0%
11	Add-On Services	See itemized list below	$0.00	0.0%
12		TOTAL MONTHLY CHARGES	$266.16
13
14	1. FULFILLMENT CHARGES - ITEMIZED
15	Shipment ID	Order ID	Merchant	Transaction Date	Shipping cost	Fulfillment cost	Carrier			Helper column
16	61290381325420	305604808	Merchant 1	10/16/2025 4:22:19 PM	$12.04	$2.25	FedEx			16
17	74890381325420	305604796	Merchant 1	10/16/2025 5:36:35 PM	$9.08	$2.25	FedEx			17
18	9200190396055738	305604804	Merchant 1	10/16/2025 5:37:17 PM	$8.86	$2.25	FedEx			18
19	920019039605573	305604795	Merchant 1	10/16/2025 5:39:09 PM	$9.25	$2.25	USPS			19
20	74890381325420	305604806	Merchant 1	10/16/2025 5:44:42 PM	$9.08	$2.25	FedEx			20
21	92001903960557388	305604810	Merchant 1	10/16/2025 5:45:01 PM	$9.08	$2.25	USPS			21
22	748903813254208	305604798	Merchant 1	10/16/2025 5:45:28 PM	$9.08	$2.25	FedEx			22
23	7489038132542087	305604799	Merchant 1	10/16/2025 5:45:49 PM	$9.08	$2.25	FedEx			23
24	7489038132542087	305604794	Merchant 1	10/16/2025 6:18:03 PM	$9.08	$2.25	FedEx			24
25	92001903960557388	305604801	Merchant 1	10/16/2025 7:01:59 PM	$9.08	$2.25	USPS			25
26	920019039605573942	306937926	Merchant 1	10/17/2025 6:40:05 PM	$7.18	$2.25	USPS			26
27	6129038132542088	307208631	Merchant 1	10/20/2025 2:59:08 PM	$12.04	$2.25	FedEx			27
28	6129038132542089	307081610	Merchant 1	10/21/2025 3:42:26 PM	$12.04	$2.25	FedEx			28
29	6129038132542089	307537621	Merchant 1	10/21/2025 3:45:32 PM	$11.64	$2.25	FedEx			29
30	612903813254208993	307622163	Merchant 1	10/21/2025 3:46:43 PM	$11.64	$2.25	FedEx			30
31	61290381325420899	307851030	Merchant 1	10/21/2025 3:48:33 PM	$12.04	$2.25	FedEx			31
32	61290381325420911	308245055	Merchant 1	10/23/2025 5:52:25 PM	$12.04	$2.25	FedEx			32
33	612903813254209286	309478921	Merchant 1	10/27/2025 6:24:49 PM	$12.93	$2.85	FedEx			33
34	9200190396055745036	309644819	Merchant 1	10/28/2025 5:38:53 PM	$7.45	$2.25	USPS			34
35	61290381325420933	309669818	Merchant 1	10/28/2025 5:44:47 PM	$13.05	$2.25	FedEx			35
36	612903813254233141	309716396	Merchant 1	10/28/2025 5:45:25 PM	$12.56	$2.25	FedEx			36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65				Fulfillment Subtotal:	$266.16
66
67	2. RECEIVING CHARGES - ITEMIZED
68	WRO Number	Merchant/Client	Receiving Date	Units Received	Total Cost					Helper Column
69	Test WRO-001	Merchant 1	2025-10-15	0	$0.00					69
70	Test WRO-002	Merchant 1	2025-10-23	0	$0.00					70
71	Test WRO-003	Merchant 1	2025-10-24	0	$0.00					71
72
73	MONTHLY SUMMARY
74	Total Units Received:	0
75	Total Labor Hours:	0
76	Total Labor Cost:	$0.00
77	Total Case Fees:	$0.00
78	TOTAL RECEIVING CHARGES:	$0.00
79
80
81
82
83
84
85
86
87
88
89				Receiving Subtotal:	$0.00
90
91	3. STORAGE CHARGES - ITEMIZED
92	Client/Merchant	SKU	Storage Type	Quantity/Volume	Rate	Days Stored	Proration	Total Cost
93	Merchant 1	SKU 2	Storage Pick Facings	1	$15.00	0	0.0%	$0.00
94	Merchant 1	#REF!	Pallet	2	$20.00	0	0.0%	$0.00
95	Merchant 1	SKU 3	Pallet	2	$20.00	0	0.0%	$0.00
96
97	MONTHLY STORAGE SUMMARY
98	Total Storage Charges:	$0.00
99
100