Which ChatGPT does it work in?

ChatGPT Business and Enterprise: an admin enables Siglata once for the team. On Pro, Siglata is read-only, in developer mode. On Plus and Free, it doesn't work in ChatGPT on the web. In Codex, each person connects it, on every plan that includes Codex.

Does it work with my ERP?

Two ways: with the ERP's exports, as spreadsheets or CSV, and in the ERP's own pages, like Bling: your AI signs in to the portal with the login you or the company connected, reads lists and tables, clicks, fills in and posts, without seeing the password. The stock position, the incoming invoices and sales by product come in the same way, as a spreadsheet or CSV.

How do I calculate COGS without a closing stock?

The formula can't do it. Without the closing stock, whatever is left on the shelf counts as sold. There are two ways. Count the stock on the month's last day, or export the ERP's balance on that date if the ERP tracks stock. Or add up, product by product, the quantity sold times the unit cost. That number leaves out losses and breakage. Your AI says which way it used and shows the row behind each value.

What is the COGS formula?

COGS = opening stock + purchases − closing stock, with both stocks at the same cost. As a percentage, divide COGS by the same month's revenue. In this page's example, 107,700 + 204,800 − 103,500 = R$209,000.00, and 209,000 ÷ 319,000 = 65.5%.

Know what the goods you sold cost you this month.

Your AI reads the ERP's stock at the start and end of the month, the purchases and the sales, and saves each category's COGS, with the source of every number.

Let's talk

Calculate September's COGS.

SiglataSeptember COGS11 of 11 records

categoria	faturamento	inicial
"Beverages"	52300	18400
"Dry grocery"	61800	26900
"Deli and dairy"	41600	9800
"Produce"	27400	3200
"Bakery"	24900	1600
"Meat"	44200	5400
"Wine"	26700	22500
"Coffee and tea"	17900	6700
"Cleaning"	11900	7300
"Personal care"	10300	5900
"Total"	319000	107700

Using Siglata · saving COGS and COGS %Used Siglata · saved COGS and COGS % in 11 records

September's COGS was R$209,000.00, 65.5% of R$319,000.00 in revenue. Produce has the highest, 73.4%. I filled in the September sheet and saved v9 of the COGS spreadsheet.

v8v9SavedPrevious version kept

Siglata

In SiglataSeptember COGS11 records

—0

The September COGS table in Siglata, 11 records.
Row	Category	Opening stock	Purchases	Closing stock	COGS	Revenue	COGS %
1	Beverages	18,400	32,600	16,800	—34,200	52,300	—65.4%
2	Dry grocery	26,900	41,200	27,500	—40,600	61,800	—65.7%
3	Deli and dairy	9,800	28,400	8,900	—29,300	41,600	—70.4%
4	Produce	3,200	19,600	2,700	—20,100	27,400	—73.4%
5	Bakery	1,600	12,300	1,400	—12,500	24,900	—50.2%
6	Meat	5,400	30,800	4,900	—31,300	44,200	—70.8%
7	Wine	22,500	14,800	21,300	—16,000	26,700	—59.9%
8	Coffee and tea	6,700	9,400	6,200	—9,900	17,900	—55.3%
9	Cleaning	7,300	8,600	7,800	—8,100	11,900	—68.1%
10	Personal care	5,900	7,100	6,000	—7,000	10,300	—68.0%
11	Total	107,700	204,800	103,500	—209,000	319,000	—65.5%

TodayCMV 2026 (cópia de agosto).xlsxCompatibility modeSaved 3 days ago

J7fx

ABCDEFG1CMV 2026 (cópia de agosto).xlsx2Illustrative data.3CategoryOpening stockPurchasesClosing stockCOGSRevenueCOGS %4Beverages18.4kR$326001680052,3005Dry grocery 26900R$41,20027,500R$61,8006 Deli and dairy9,80028,400.00R$8,900R$416007produceR$3,20019.6kR$2700R$27,4008BakeryR$160012300R$1,40024,900.009MEATR$5,40030,8004,900.0044.2k10Wine22,500.00R$14,80021.3k2670011Coffee and tea6.7kR$9400620017,90012Cleaning 7300R$8,6007,800R$11,90013 Personal care5,9007,100.00R$6,000R$1030014totalR$107,700204.8kR$103500R$319,00015161718192021

Sheet1Sheet2 (2)copy of Sheet1DO NOT USE

Illustrative data. Drag the divider to compare.

Every month start, three exports and one sum

Stock comes out of the ERP on two dates, purchases come from the incoming invoices, and someone adds it up category by category in a spreadsheet copied from last month. When the closing stock is missing, the sum stops halfway.

One question, each category's COGS

You ask for September's COGS. Your AI adds each category's opening stock and purchases, subtracts the closing stock, divides by revenue and saves the month as a new version of the COGS spreadsheet, with the previous one kept.

ChatGPT

Calculate September's COGS.

SiglataSeptember COGS11 of 11 records

categoria	faturamento	inicial
"Beverages"	52300	18400
"Dry grocery"	61800	26900
"Deli and dairy"	41600	9800
"Produce"	27400	3200
"Bakery"	24900	1600
"Meat"	44200	5400
"Wine"	26700	22500
"Coffee and tea"	17900	6700
"Cleaning"	11900	7300
"Personal care"	10300	5900
"Total"	319000	107700

Using Siglata · saving COGS and COGS %Used Siglata · saved COGS and COGS % in 11 records

September's COGS was R$209,000.00, 65.5% of R$319,000.00 in revenue. Produce has the highest, 73.4%. I filled in the September sheet and saved v9 of the COGS spreadsheet.

v8v9SavedPrevious version kept

Ask anythingSiglata

The September COGS table in Siglata, 11 records.
Row	Category	Opening stock	Purchases	Closing stock	COGS	Revenue	COGS %
1	Beverages	18,400	32,600	16,800	—34,200	52,300	—65.4%
2	Dry grocery	26,900	41,200	27,500	—40,600	61,800	—65.7%
3	Deli and dairy	9,800	28,400	8,900	—29,300	41,600	—70.4%
4	Produce	3,200	19,600	2,700	—20,100	27,400	—73.4%
5	Bakery	1,600	12,300	1,400	—12,500	24,900	—50.2%
6	Meat	5,400	30,800	4,900	—31,300	44,200	—70.8%
7	Wine	22,500	14,800	21,300	—16,000	26,700	—59.9%
8	Coffee and tea	6,700	9,400	6,200	—9,900	17,900	—55.3%
9	Cleaning	7,300	8,600	7,800	—8,100	11,900	—68.1%
10	Personal care	5,900	7,100	6,000	—7,000	10,300	—68.0%
11	Total	107,700	204,800	103,500	—209,000	319,000	—65.5%

Every number with its source

Tap a COGS amount to see the math, the file behind each part and the company's rule.

The September COGS table in Siglata, 11 records.
Row	Category	Opening stock	Purchases	Closing stock	COGS	Revenue	COGS %
1	Beverages	18,400	32,600	16,800	—34,200	52,300	—65.4%
2	Dry grocery	26,900	41,200	27,500	—40,600	61,800	—65.7%
3	Deli and dairy	9,800	28,400	8,900	—29,300	41,600	—70.4%
4	Produce	3,200	19,600	2,700	—20,100	27,400	—73.4%
5	Bakery	1,600	12,300	1,400	—12,500	24,900	—50.2%
6	Meat	5,400	30,800	4,900	—31,300	44,200	—70.8%
7	Wine	22,500	14,800	21,300	—16,000	26,700	—59.9%
8	Coffee and tea	6,700	9,400	6,200	—9,900	17,900	—55.3%
9	Cleaning	7,300	8,600	7,800	—8,100	11,900	—68.1%
10	Personal care	5,900	7,100	6,000	—7,000	10,300	—68.0%
11	Total	107,700	204,800	103,500	—209,000	319,000	—65.5%

Total · COGS R$209,000.00

: Opening stock on Aug 31: R$107,700.00, the same as the closing stock on v8's August sheet.
: Purchases from Sep 1 to Sep 30: R$204,800.00.
: Closing stock on Sep 30: R$103,500.00.
: COGS: 107,700 + 204,800 − 103,500 = R$209,000.00.
: September revenue: R$319,000.00.
: COGS %: 209,000 ÷ 319,000 = 65.5%.

Estoque_2026-08-31.xlsxv1 to · 486 rows · sum of Value at cost: R$107,700.00
CMV_2026.xlsxv8 to · August sheet · Row 12 · Closing stock: R$107,700.00
Compras_setembro.xlsxv1 to · 1,214 rows from 93 invoices · sum of Total value: R$204,800.00
Estoque_2026-09-30.xlsxv1 to · 479 rows · sum of Value at cost: R$103,500.00
Vendas_setembro.xlsxv1 to · 512 rows · sum of Amount sold: R$319,000.00
CMV_do_mes to · (company skill) · item 1: both stocks at average cost · item 2: purchases from the incoming merchandise invoices, with the invoice's freight · item 3: the share is over the month's sales

Stock fell by R$4,200.00 over the month (107,700 − 103,500), so COGS came out above purchases: 204,800 + 4,200 = 209,000. Produce has the highest COGS, 73.4% of its revenue.

v8v9Saved

Category · Opening + Purchases − Closing = COGS · COGS ÷ Revenue = COGS %
Category	Opening + Purchases − Closing = COGS	COGS ÷ Revenue = COGS %
Beverages	18,400 + 32,600 − 16,800 = 34,200	34,200 ÷ 52,300 = 65.4%
Dry grocery	26,900 + 41,200 − 27,500 = 40,600	40,600 ÷ 61,800 = 65.7%
Deli and dairy	9,800 + 28,400 − 8,900 = 29,300	29,300 ÷ 41,600 = 70.4%
Produce	3,200 + 19,600 − 2,700 = 20,100	20,100 ÷ 27,400 = 73.4%
Bakery	1,600 + 12,300 − 1,400 = 12,500	12,500 ÷ 24,900 = 50.2%
Meat	5,400 + 30,800 − 4,900 = 31,300	31,300 ÷ 44,200 = 70.8%
Wine	22,500 + 14,800 − 21,300 = 16,000	16,000 ÷ 26,700 = 59.9%
Coffee and tea	6,700 + 9,400 − 6,200 = 9,900	9,900 ÷ 17,900 = 55.3%
Cleaning	7,300 + 8,600 − 7,800 = 8,100	8,100 ÷ 11,900 = 68.1%
Personal care	5,900 + 7,100 − 6,000 = 7,000	7,000 ÷ 10,300 = 68.0%
Total	107,700 + 204,800 − 103,500 = 209,000	209,000 ÷ 319,000 = 65.5%

Download the example (.xlsx)

Illustrative data.

The COGS rule is written down

Which cost values the stock, what counts as a purchase and which revenue the share is taken over live in a company skill. Each person works with their own access, and every change stays in the history, with the previous version kept.

Who accesses what

Row	Person	Inventory	Purchasing	Finance
1	You Admin	Can edit	Can edit	Can edit
2	Marcos Purchasing
3	Renata Finance
4	Rodrigo Sales

Click a level to change it. Each person's ChatGPT, Codex or Claude Code follows that person's access.

Today's activity

7:05 AMM
September's COGS was R$209,000.00, 65.5% of R$319,000.00 in revenue. Produce has the highest, 73.4%. I filled in the September sheet and saved v9 of the COGS spreadsheet.

Frequently asked questions

4 questions

Which ChatGPT does it work in?
ChatGPT Business and Enterprise: an admin enables Siglata once for the team. On Pro, Siglata is read-only, in developer mode. On Plus and Free, it doesn't work in ChatGPT on the web. In Codex, each person connects it, on every plan that includes Codex.
Does it work with my ERP?
Two ways: with the ERP's exports, as spreadsheets or CSV, and in the ERP's own pages, like Bling: your AI signs in to the portal with the login you or the company connected, reads lists and tables, clicks, fills in and posts, without seeing the password. The stock position, the incoming invoices and sales by product come in the same way, as a spreadsheet or CSV.
How do I calculate COGS without a closing stock?
The formula can't do it. Without the closing stock, whatever is left on the shelf counts as sold. There are two ways. Count the stock on the month's last day, or export the ERP's balance on that date if the ERP tracks stock. Or add up, product by product, the quantity sold times the unit cost. That number leaves out losses and breakage. Your AI says which way it used and shows the row behind each value.
What is the COGS formula?
COGS = opening stock + purchases − closing stock, with both stocks at the same cost. As a percentage, divide COGS by the same month's revenue. In this page's example, 107,700 + 204,800 − 103,500 = R$209,000.00, and 209,000 ÷ 319,000 = 65.5%.

Want to see it with your company's stock?

We'll show it with the stock position, purchases and sales exported from your ERP, in a WhatsApp conversation.

Let's talk contato@siglata.com