Know how much each salesperson needs to hit the target.
Who hasn’t hit the September target yet?
| vendedor | pct_meta | situacao |
|---|---|---|
| "Ana Paula" | 0.82 | abaixo |
| "Bruno Lima" | 0.86 | abaixo |
| "Camila Reis" | 0.89 | abaixo |
| "Diego Souza" | 0.94 | abaixo |
8 of 12 salespeople hit their target. Four are below; I wrote down how much each one still needs and saved v14 of the targets sheet.
Connected apps
| Row | Salesperson | Store | Target | Sold | % of target | Status | To go |
|---|---|---|---|---|---|---|---|
| 1 | Ana Paula | Jardins | R$30,000 | R$24,600 | 82% | Below | —R$5,400 |
| 2 | Bruno Lima | Norte | R$28,000 | R$24,080 | 86% | Below | —R$3,920 |
| 3 | Camila Reis | Jardins | R$32,000 | R$28,480 | 89% | Below | —R$3,520 |
| 4 | Diego Souza | Estação | R$24,000 | R$22,560 | 94% | Below | —R$1,440 |
| 5 | Elaine Costa | Centro | R$36,000 | R$36,360 | 101% | Hit | — |
| 6 | Fábio Nunes | Centro | R$30,000 | R$30,900 | 103% | Hit | — |
| 7 | Gisele Prado | Estação | R$28,000 | R$29,120 | 104% | Hit | — |
| 8 | Hugo Martins | Norte | R$24,000 | R$25,200 | 105% | Hit | — |
| 9 | Ivone Dias | Centro | R$32,000 | R$34,240 | 107% | Hit | — |
| 10 | João Pedro | Estação | R$30,000 | R$32,400 | 108% | Hit | — |
| 11 | Karina Alves | Jardins | R$28,000 | R$30,520 | 109% | Hit | — |
| 12 | Lucas Rocha | Norte | R$36,000 | R$40,320 | 112% | Hit | — |
Below4
Hit8
Illustrative data. Drag the divider to compare.
| Row | Salesperson | Store | Target | Sold | % of target | Status | To go |
|---|---|---|---|---|---|---|---|
| 1 | Ana Paula | Jardins | R$30,000 | R$24,600 | 82% | Below | —R$5,400 |
| 2 | Bruno Lima | Norte | R$28,000 | R$24,080 | 86% | Below | —R$3,920 |
| 3 | Camila Reis | Jardins | R$32,000 | R$28,480 | 89% | Below | —R$3,520 |
| 4 | Diego Souza | Estação | R$24,000 | R$22,560 | 94% | Below | —R$1,440 |
| 5 | Elaine Costa | Centro | R$36,000 | R$36,360 | 101% | Hit | — |
| 6 | Fábio Nunes | Centro | R$30,000 | R$30,900 | 103% | Hit | — |
| 7 | Gisele Prado | Estação | R$28,000 | R$29,120 | 104% | Hit | — |
| 8 | Hugo Martins | Norte | R$24,000 | R$25,200 | 105% | Hit | — |
| 9 | Ivone Dias | Centro | R$32,000 | R$34,240 | 107% | Hit | — |
| 10 | João Pedro | Estação | R$30,000 | R$32,400 | 108% | Hit | — |
| 11 | Karina Alves | Jardins | R$28,000 | R$30,520 | 109% | Hit | — |
| 12 | Lucas Rocha | Norte | R$36,000 | R$40,320 | 112% | Hit | — |
Below4
Hit8
Who hasn’t hit the September target yet?
| vendedor | pct_meta | situacao |
|---|---|---|
| "Ana Paula" | 0.82 | abaixo |
| "Bruno Lima" | 0.86 | abaixo |
| "Camila Reis" | 0.89 | abaixo |
| "Diego Souza" | 0.94 | abaixo |
8 of 12 salespeople hit their target. Four are below; I wrote down how much each one still needs and saved v14 of the targets sheet.
- Store
- Jardins
- % of target
- 82%
- To go
- R$5,400
History
ChatGPT changed To go · 07:05
- Store
- Norte
- % of target
- 86%
- To go
- R$3,920
History
ChatGPT changed To go · 07:05
- Store
- Jardins
- % of target
- 89%
- To go
- R$3,520
History
ChatGPT changed To go · 07:05
- Store
- Estação
- % of target
- 94%
- To go
- R$1,440
History
ChatGPT changed To go · 07:05
- Store
- Centro
- % of target
- 101%
- To go
- —
History
Paula created the record · 09/12
- Store
- Centro
- % of target
- 103%
- To go
- —
History
Paula created the record · 09/12
- Store
- Estação
- % of target
- 104%
- To go
- —
History
Paula created the record · 09/12
- Store
- Norte
- % of target
- 105%
- To go
- —
History
Paula created the record · 09/12
- Store
- Centro
- % of target
- 107%
- To go
- —
History
Paula created the record · 09/12
- Store
- Estação
- % of target
- 108%
- To go
- —
History
Paula created the record · 09/12
- Store
- Jardins
- % of target
- 109%
- To go
- —
History
Paula created the record · 09/12
- Store
- Norte
- % of target
- 112%
- To go
- —
History
Paula created the record · 09/12
The same sum, every month end
Sales come out of the POS as an export, the targets sit in a spreadsheet copied month after month, and someone adds it up salesperson by salesperson. By the time the sum is done, September is over.
One question, the answer per salesperson
You ask who hasn't hit the September target yet. Your AI adds up each salesperson's sales, compares them with the target and saves what's left as a new version of the spreadsheet, with the previous one kept.
Who hasn’t hit the September target yet?
| vendedor | pct_meta | situacao |
|---|---|---|
| "Ana Paula" | 0.82 | abaixo |
| "Bruno Lima" | 0.86 | abaixo |
| "Camila Reis" | 0.89 | abaixo |
| "Diego Souza" | 0.94 | abaixo |
8 of 12 salespeople hit their target. Four are below; I wrote down how much each one still needs and saved v14 of the targets sheet.
| Row | Salesperson | Store | Target | Sold | % of target | Status | To go |
|---|---|---|---|---|---|---|---|
| 1 | Ana Paula | Jardins | R$30,000 | R$24,600 | 82% | Below | —R$5,400 |
| 2 | Bruno Lima | Norte | R$28,000 | R$24,080 | 86% | Below | —R$3,920 |
| 3 | Camila Reis | Jardins | R$32,000 | R$28,480 | 89% | Below | —R$3,520 |
| 4 | Diego Souza | Estação | R$24,000 | R$22,560 | 94% | Below | —R$1,440 |
| 5 | Elaine Costa | Centro | R$36,000 | R$36,360 | 101% | Hit | — |
| 6 | Fábio Nunes | Centro | R$30,000 | R$30,900 | 103% | Hit | — |
| 7 | Gisele Prado | Estação | R$28,000 | R$29,120 | 104% | Hit | — |
| 8 | Hugo Martins | Norte | R$24,000 | R$25,200 | 105% | Hit | — |
| 9 | Ivone Dias | Centro | R$32,000 | R$34,240 | 107% | Hit | — |
| 10 | João Pedro | Estação | R$30,000 | R$32,400 | 108% | Hit | — |
| 11 | Karina Alves | Jardins | R$28,000 | R$30,520 | 109% | Hit | — |
| 12 | Lucas Rocha | Norte | R$36,000 | R$40,320 | 112% | Hit | — |
Every number with its source
Tap a "To go" amount to see the math, the row each number came from and why that salesperson is below.
| Row | Salesperson | Store | Target | Sold | % of target | Status | To go |
|---|---|---|---|---|---|---|---|
| 1 | Ana Paula | Jardins | R$30,000 | R$24,600 | 82% | Below | —R$5,400 |
| 2 | Bruno Lima | Norte | R$28,000 | R$24,080 | 86% | Below | —R$3,920 |
| 3 | Camila Reis | Jardins | R$32,000 | R$28,480 | 89% | Below | —R$3,520 |
| 4 | Diego Souza | Estação | R$24,000 | R$22,560 | 94% | Below | —R$1,440 |
| 5 | Elaine Costa | Centro | R$36,000 | R$36,360 | 101% | Hit | — |
| 6 | Fábio Nunes | Centro | R$30,000 | R$30,900 | 103% | Hit | — |
| 7 | Gisele Prado | Estação | R$28,000 | R$29,120 | 104% | Hit | — |
| 8 | Hugo Martins | Norte | R$24,000 | R$25,200 | 105% | Hit | — |
| 9 | Ivone Dias | Centro | R$32,000 | R$34,240 | 107% | Hit | — |
| 10 | João Pedro | Estação | R$30,000 | R$32,400 | 108% | Hit | — |
| 11 | Karina Alves | Jardins | R$28,000 | R$30,520 | 109% | Hit | — |
| 12 | Lucas Rocha | Norte | R$36,000 | R$40,320 | 112% | Hit | — |
Ana Paula · To go R$5,400.00
- September target: R$30,000.00.
- Sold from Sep 1 to Sep 29: R$24,600.00.
- % of target: 24,600 ÷ 30,000 = 82%.
- To go: 30,000 − 24,600 = R$5,400.00.
- 5,400 + 3,920 + 3,520 + 1,440 = R$14,280.00.
- Metas_lojas_2026.xlsx to · Metas_lojas_2026.xlsx v13 · Setembro sheet · Row 2 · Salesperson: Ana Paula · Store: Jardins · Target: R$30,000.00
- Vendas_PDV_setembro.xlsx to · Vendas_PDV_setembro.xlsx v1 · 64 rows with salesperson Ana Paula, Sep 1 to Sep 29 · sum: R$24,600.00
Below target at 82%, the lowest share on the team. The AI wrote the amount to go on her row and kept the target from the saved version.
Metas_lojas_2026.xlsxv13 to v14SavedBruno Lima · To go R$3,920
- R$24,080 ÷ R$28,000 = 86%
R$28,000 − R$24,080 = R$3,920
- Metas_lojas_2026.xlsxv13 to · Row 3 · Bruno Lima · Norte · R$28,000 · R$24,080
Camila Reis · To go R$3,520
- R$28,480 ÷ R$32,000 = 89%
R$32,000 − R$28,480 = R$3,520
- Metas_lojas_2026.xlsxv13 to · Row 4 · Camila Reis · Jardins · R$32,000 · R$28,480
Diego Souza · To go R$1,440
- R$22,560 ÷ R$24,000 = 94%
R$24,000 − R$22,560 = R$1,440
- Metas_lojas_2026.xlsxv13 to · Row 5 · Diego Souza · Estação · R$24,000 · R$22,560
Illustrative data.
The target rule is written down
What counts as a sale and which target applies each month 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
Metas_lojas_2026.xlsxv14 to- M
8 of 12 salespeople hit their target. Four are below; I wrote down how much each one still needs and saved v14 of the targets sheet.
Frequently asked 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 POS sales export works the same way, as a spreadsheet or CSV.
What if the target changes mid-month?
The revised target goes into the spreadsheet as a new version. Your AI uses the latest saved version and shows which row each target came from, and the earlier versions stay saved.
Who sees each salesperson's targets and sales?
Whoever has access to the targets spreadsheet at the company. Each person's AI works with their access, and every step is logged.
No question matches that term. Let’s talk.
Want to see it with your team's targets?
We'll show it with a sales export from your POS or ERP and your targets spreadsheet, in a WhatsApp conversation.