--- title: Know what is overdue and who to remind today. description: Your AI checks the ERP's receivables against the bank statement, separates what is overdue and what is due today, and writes each customer's reminder. language: en-US canonical: https://www.siglata.com/en-US/trabalhos/contas-a-receber --- # Know what is overdue and who to remind today. Canonical: https://www.siglata.com/en-US/trabalhos/contas-a-receber Your AI reads the ERP's receivables, the bank statement and the invoices, and saves what is still unpaid, with the source of every number. ## Every Monday, the statement against the spreadsheet Invoices come out of the ERP, payments show up in two banks' statements, and someone colors the paid ones blue, row by row. What is overdue only shows once that check is done. ## One question, the open invoices You ask what is still unpaid. Your AI checks each invoice against the statement, marks what is overdue and writes each customer's reminder as a new version of the spreadsheet, with the previous one kept. ## Every number with its source Tap a status to see the math, the invoice's row in the ERP export and what the statement shows. ## The collection rule is written down When an invoice counts as overdue and what each reminder says 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. Every Monday, the statement against the spreadsheet: Invoices come out of the ERP, payments show up in two banks' statements, and someone colors the paid ones blue, row by row. What is overdue only shows once that check is done. 2. Know what is overdue and who to remind today.: Your AI reads the ERP's receivables, the bank statement and the invoices, and saves what is still unpaid, with the source of every number. 3. One question, the open invoices: You ask what is still unpaid. Your AI checks each invoice against the statement, marks what is overdue and writes each customer's reminder as a new version of the spreadsheet, with the previous one kept. 4. Every number with its source: Tap a status to see the math, the invoice's row in the ERP export and what the statement shows. | Customer | Invoice | Due | Amount | Paid on | Status | Reminder | | --- | --- | --- | --- | --- | --- | --- | | Mercado Aurora Azul | 1042 | 09/22 | R$8,400 | — | Overdue | Olá! A nota 1042, de R$ 8.400,00, venceu em 22/09. Pode nos passar a previsão de pagamento? | | Empório Lumara | 1086 | 09/25 | R$3,200 | — | Overdue | Olá! A nota 1086, de R$ 3.200,00, venceu em 25/09. Pode nos passar a previsão de pagamento? | | Padaria Trigo Bom | 1103 | 09/30 | R$5,600 | — | Due today | Olá! A nota 1103, de R$ 5.600,00, vence hoje, 30/09. Se o pagamento já foi feito, pode desconsiderar esta mensagem. | | Padaria Sol | 1110 | 10/02 | R$1,400 | — | Upcoming | — | | Mercado Vila Nova | 1113 | 10/05 | R$2,900 | — | Upcoming | — | | Casa do Grão | 1071 | 09/20 | R$4,100 | 09/19 | Paid | — | | Empório Serra | 1075 | 09/21 | R$6,300 | 09/21 | Paid | — | | Atacado Rio | 1079 | 09/23 | R$9,800 | 09/22 | Paid | — | | Hortifrúti Bom Dia | 1082 | 09/24 | R$1,900 | 09/24 | Paid | — | | Adega Central | 1090 | 09/26 | R$3,700 | 09/25 | Paid | — | | Quitanda Verde | 1094 | 09/27 | R$2,200 | 09/27 | Paid | — | | Café da Praça | 1098 | 09/28 | R$5,100 | 09/28 | Paid | — | ### invoice 1042 · Mercado Aurora Azul · Overdue Due: Sep 22, 2026. Today: Sep 30, 2026. Days late: 30 − 22 = 8. Invoice amount: R$8,400.00. Statement from Sep 22 to Sep 30: no R$8,400.00 credit with the customer's CNPJ. "Paid on" stays empty. Status: Overdue. 8,400 + 3,200 = R$11,600.00 11,600 + 5,600 = R$17,200.00 Contas_a_receber_semana_40.xlsx : Contas_a_receber_semana_40.xlsx v4 · Row 2 · Invoice: 1042 · Due: Sep 22 · Amount: R$8,400.00 NFe_1042.xml : NFe_1042.xml v1 · Total: R$8,400.00 · Recipient CNPJ: 23.456.789/0001-10 Extrato_Itau_setembro.ofx : Extrato_Itau_setembro.ofx v1 and Extrato_Bradesco_setembro.ofx v1 · Sep 1 to Sep 30 · no R$8,400.00 credit from that CNPJ | | | | The invoice is 8 days overdue and the payment shows in neither statement. The collection rule asks for a reminder the same day, with the invoice number, the amount and the due date. Olá! A nota 1042, de R$ 8.400,00, venceu em 22/09. Pode nos passar a previsão de pagamento? Olá! A nota 1086, de R$ 3.200,00, venceu em 25/09. Pode nos passar a previsão de pagamento? Olá! A nota 1103, de R$ 5.600,00, vence hoje, 30/09. Se o pagamento já foi feito, pode desconsiderar esta mensagem. Contas_a_receber_semana_40.xlsx v4 to v5 [Download the example (.xlsx)](https://www.siglata.com/en-US/trabalhos/contas-a-receber/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. ### Does the AI send the reminder to the customer? No. Your AI writes each reminder's text in the spreadsheet, with the invoice, the amount and the due date. Your team sends it. ### How does it know the customer already paid? It looks in the bank statement for a credit with the invoice's amount and the customer's CNPJ. When it finds one, it writes the date in "Paid on" and shows the statement line it came from. ## Want to see it with your company's invoices? We'll show it with your ERP's receivables export and a bank statement, in a WhatsApp conversation. [Let's talk](https://wa.me/5516991184410?text=Hi!%20I'd%20like%20to%20see%20receivables%20with%20Siglata.)