Cash Flow Management for Sole Proprietors with Automated Spreadsheet

Create a complete cash flow management system for [BUSINESS NAME], a sole proprietor in the [INDUSTRY] sector with estimated monthly revenue of R$[AMOUNT].

**Business Context:**
- Type of service/product: [DESCRIPTION]
- Payment methods: [PIX/CASH/CARD/INVOICE]
- Payment frequency: [DAILY/WEEKLY/PER PROJECT]
- Main fixed expenses: [LIST]
- Main variable expenses: [LIST]
- Estimated annual revenue: R$[AMOUNT] (sole proprietor limit: R$144,900)
- Currently uses app or spreadsheet: [YES which one / NO]

**PART 1 — DAILY TRACKING SYSTEM:**

*Daily logging (5 minutes per day):*

Each day, record:
1. Previous day's balance (carry over from previous day)
2. Today's income (each payment received)
3. Today's expenses (each payment made)
4. Today's balance (automatic: previous + income - expenses)
5. Notes (client, supplier, or important note)

*Income categories:*
- Service [TYPE 1] — received
- Service [TYPE 2] — received
- Project deposit (down payment)
- Material sales
- Other

*Expense categories (adapted to business):*

**Business costs (variable):**
- Materials/supplies
- Fuel / transportation
- Tools and equipment
- Subcontracted labor
- Equipment maintenance

**Monthly fixed costs:**
- Sole proprietor monthly tax (DAS — due by the 20th of following month)
- Rent (if commercial space or warehouse)
- Business phone plan
- Internet
- Accountant (if applicable)
- Software / apps

**Personal (separate from business):**
- Owner draw (what the entrepreneur pays themselves)
- NEVER mix personal expenses with business expenses

**PART 2 — SPREADSHEET STRUCTURE (Google Sheets):**

Tab 1 — DAILY CASH:

| Column | Type | Formula |
|--------|------|---------|
| Date | Text/Date | Manual |
| Description | Text | Manual |
| Category | Drop-down | Data validation |
| Income (R$) | Number | Manual |
| Expense (R$) | Number | Manual |
| Daily Balance (R$) | Formula | =Previous balance + Income - Expense |

Month starting balance: [balance on 1st — pulled from summary tab]

Conditional formatting:
- Positive balance: light green background
- Zero balance: yellow background
- Negative balance: red background (alert)

Tab 2 — MONTHLY SUMMARY:

Auto-generated with SUMIF:

| Metric | Formula | Result |
|--------|---------|--------|
| Total monthly income | =SUMIF(Category,Income,Amount) | R$[AMOUNT] |
| Total monthly expenses | =SUMIF(Category,Expense,Amount) | R$[AMOUNT] |
| Monthly result | = Income - Expenses | R$[AMOUNT] |
| Cash balance | = Starting balance + Result | R$[AMOUNT] |
| Year-to-date revenue | = Sum of monthly results | R$[AMOUNT] |
| Available revenue until sole proprietor limit | = R$144,900 - YTD | R$[AMOUNT] |

Auto-generated pie chart: expense distribution by category

Tab 3 — SOLE PROPRIETOR LIMIT TRACKING:

| Month | Revenue | YTD Total | Available Limit | Alert |
|-------|---------|-----------|-----------------|-------|
| January | R$[AMOUNT] | R$[AMOUNT] | R$[AMOUNT] | ✅ |
| ... | | | | |
| Total | R$[AMOUNT] | | | |

Alert thresholds:
- Green: below 80% of limit
- Yellow: 80-95% — consult accountant about regular company structure
- Red: above 95% — URGENT: stop issuing invoices as sole proprietor, register a regular company immediately

**PART 3 — HEALTHY SEPARATION: BUSINESS vs. PERSONAL:**

Most common sole proprietor mistake: mixing business cash with personal account.

Practical solution:
- Separate business bank account (free digital banks: Mercado Pago, PicPay, Nubank Business)
- Set fixed monthly owner draw: what the sole proprietor pays themselves
- Owner draw transfer: every [DAY] of the month
- Never pay personal expenses with business card

Healthy owner draw calculation:
```
Owner draw = Average revenue - Business costs - Monthly tax (DAS) - Emergency reserve (20%)
Owner draw = R$[AMOUNT] - R$[AMOUNT] - R$[AMOUNT] - R$[AMOUNT] = R$[AMOUNT]
```

**PART 4 — SOLE PROPRIETOR MONTHLY TAX (DAS) TRACKING:**

The DAS is the mandatory monthly payment for sole proprietors including:
- INSS: for retirement and benefits (equivalent to 5% of minimum wage)
- ISS: for service providers (fixed R$5.00)
- ICMS: for retail/manufacturing (fixed R$1.00)

DAS amount in [YEAR]: R$[AMOUNT] (services) or R$[AMOUNT] (retail)
Due date: 20th of the following month

Auto-alert in spreadsheet:
- If it's the 15th and DAS is not marked as paid → send reminder (Google Sheets + Google Apps Script)

**PART 5 — 30-DAY CASH FLOW PROJECTION:**

This tab should be updated weekly:

| Week | Expected Income | Expected Expenses | Projected Balance |
|------|-----------------|-------------------|-------------------|
| Week 1 | R$[AMOUNT] | R$[AMOUNT] | R$[AMOUNT] |
| Week 2 | R$[AMOUNT] | R$[AMOUNT] | R$[AMOUNT] |
| Week 3 | R$[AMOUNT] | R$[AMOUNT] | R$[AMOUNT] |
| Week 4 | R$[AMOUNT] | R$[AMOUNT] | R$[AMOUNT] |

If projected balance falls below R$[AMOUNT] (minimum safety balance):
- Activate emergency plan:
  1. Offer discount for early payment
  2. Delay non-urgent purchases
  3. Seek advance payments from clients (deposit for upcoming project)
  4. Use emergency reserve (do not take on debt first)

**PART 6 — MONTHLY REPORT (completed in 30 minutes):**

Complete on the 1st of each month for the previous month:

1. Total monthly revenue: R$[AMOUNT]
2. Compared to previous month: [+X% / -X%]
3. Compared to same month last year: [+X% / -X%]
4. Top revenue sources: [LIST TOP 3 CLIENTS OR SERVICES]
5. Top expenses: [LIST TOP 3]
6. Net margin for the month: [PERCENTAGE]%
7. Available balance on the 1st: R$[AMOUNT]
8. Unpaid invoices from clients: R$[AMOUNT] — collection plan
9. My goal for next month: R$[AMOUNT]
10. What I will do differently: [ACTION]

**Recommended Free Tools:**
- Spreadsheet: Google Sheets (free, mobile accessible)
- Invoicing: MEI App (Receita Federal — free)
- Business banking: Nubank Business, Mercado Pago, C6 Bank Business (free)
- DAS payments: Entrepreneur Portal (das.sebrae.com.br)
- Annual filing: DASN-SIMEI (January through May each year)

**Quick Access Templates:** Create shortcut links on your phone for the 3 most-used tabs (Daily Cash, Summary, Limit Tracker).