cash-flow-snapshot

To create a 30/60/90-day cash flow forecast, combine ERP exports, bank CSV/OFX files, receivables spreadsheets, and Pix/boleto/card payment reports. The process normalizes Mercado Pago inputs, calculates net position, flags payroll risk, and outputs a single best next action.

Yes, you can use manual CSV exports and pasted data to predict payroll risk and upcoming month cash shortages. The manual-first fallback works without automated connectors by analyzing bank OFX files alongside Pix and boleto collection timing.

Yes, the cash flow snapshot handles Mercado Pago and Asaas export formats. A provided script normalizes Mercado Pago CSV inputs, ensuring card settlement timing and Pix collections align properly within the 30/60/90-day forecast table.

The best way to prepare accountant handoff material is to aggregate overdue receivables, payroll, and DAS/tax obligations into a risk-ranked forecast. This produces management-ready outputs with explicit missing-data disclosure and practical confidence levels.

Your cash flow forecast requires explicit missing-data disclosure and confidence levels because it aggregates messy manual exports. Stating data gaps and assigning practical confidence levels ensures the owner can trust the runway projections and act on the top identified risks.