--- title: Know how much each salesperson needs to hit the target. description: Your AI matches POS sales with the targets spreadsheet, shows who is below and saves what each salesperson still needs, with the source of every number. language: en-US canonical: https://www.siglata.com/en-US/trabalhos/metas-de-vendas --- # Know how much each salesperson needs to hit the target. Canonical: https://www.siglata.com/en-US/trabalhos/metas-de-vendas Your AI reads the POS sales and the targets spreadsheet, and saves how much each salesperson still needs, with the source of every number. ## 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. ## 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. ## 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. 1. 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. 2. Know how much each salesperson needs to hit the target.: Your AI reads the POS sales and the targets spreadsheet, and saves how much each salesperson still needs, with the source of every number. 3. 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. 4. 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. | Salesperson | Store | Target | Sold | % of target | Status | To go | | --- | --- | --- | --- | --- | --- | --- | | Ana Paula | Jardins | R$30,000 | R$24,600 | 82% | Below | R$5,400 | | Bruno Lima | Norte | R$28,000 | R$24,080 | 86% | Below | R$3,920 | | Camila Reis | Jardins | R$32,000 | R$28,480 | 89% | Below | R$3,520 | | Diego Souza | Estação | R$24,000 | R$22,560 | 94% | Below | R$1,440 | | Elaine Costa | Centro | R$36,000 | R$36,360 | 101% | Hit | — | | Fábio Nunes | Centro | R$30,000 | R$30,900 | 103% | Hit | — | | Gisele Prado | Estação | R$28,000 | R$29,120 | 104% | Hit | — | | Hugo Martins | Norte | R$24,000 | R$25,200 | 105% | Hit | — | | Ivone Dias | Centro | R$32,000 | R$34,240 | 107% | Hit | — | | João Pedro | Estação | R$30,000 | R$32,400 | 108% | Hit | — | | Karina Alves | Jardins | R$28,000 | R$30,520 | 109% | Hit | — | | 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 : Metas_lojas_2026.xlsx v13 · Setembro sheet · Row 2 · Salesperson: Ana Paula · Store: Jardins · Target: R$30,000.00 Vendas_PDV_setembro.xlsx : 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.xlsx v13 to v14 ### Bruno 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.xlsx v13: Row 3 · Bruno Lima · Norte · R$28,000 · R$24,080 | | | | Metas_lojas_2026.xlsx v13 to v14 ### 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.xlsx v13: Row 4 · Camila Reis · Jardins · R$32,000 · R$28,480 | | | | Metas_lojas_2026.xlsx v13 to v14 ### 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.xlsx v13: Row 5 · Diego Souza · Estação · R$24,000 · R$22,560 | | | | Metas_lojas_2026.xlsx v13 to v14 [Download the example (.xlsx)](https://www.siglata.com/en-US/trabalhos/metas-de-vendas/planilha.xlsx) Illustrative data. ## 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. ## 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. [Let's talk](https://wa.me/5516991184410?text=Hi!%20I'd%20like%20to%20see%20sales%20targets%20with%20Siglata.)