Small Business Bookkeeping in Excel with ChatGPT

I need an Excel accounts-receivable invoice tracker.

AS-OF DATE
[enter today's/as-of date]

PAYMENT TERMS
Use one of these only if it applies to every invoice:
[e.g. Net 30 / Net 14 / Due on receipt]
If terms vary by invoice, I will provide Due Date per row instead.

OPEN-INVOICE INPUT
Invoice # | Client | Invoice Date | Due Date (if known) | Amount | Paid? (Yes/No)
[Paste rows]

Rules:
1. Do not invent invoice dates, due dates, client names, amounts or payment terms.
2. If Due Date is supplied, use it.
3. If Due Date is blank and a single numeric Net-N term is supplied, calculate:
   Due Date = Invoice Date + N calendar days.
   Do not use EDATE for Net 30 because Net 30 means days, not one calendar month.
4. Calculate BOTH:
   Days Outstanding = MAX(0, AsOfDate - InvoiceDate)
   Days Past Due = MAX(0, AsOfDate - DueDate)
5. Status for unpaid invoices:
   - Seriously overdue: Days Past Due >= 30
   - Overdue: Days Past Due >= 1 and < 30
   - Due soon: Due Date is 0–7 days after AsOfDate
   - Current: Due Date is more than 7 days after AsOfDate
6. Exclude Paid=Yes invoices from outstanding/overdue totals, but do not delete them
   if I supplied them.
7. Add controls:
   - Total outstanding = sum of unpaid invoice amounts
   - Total overdue = sum of unpaid invoices with Days Past Due > 0
   - invoice count by status
   - clients with 2+ unpaid invoices
8. "2+ unpaid invoices" is a workload/collection flag only; do not infer credit risk or
   tell me to contact a client urgently without additional context.

OUTPUT
Invoice # | Client | Invoice Date | Due Date | Amount |
Days Outstanding | Days Past Due | Status
plus summary and exact Excel formulas.

I need a simple monthly profit-and-loss working paper in Excel.

REPORTING SETTINGS
- Period: [month, year]
- Business type: [ ]
- Currency: [ ]
- Accounting basis: [cash / accrual]
- Are the figures below already reviewed/categorized? [yes/no]

REVENUE
[paste category | amount]

COST OF SALES / DIRECT COSTS
[paste category | amount, or write NONE / NOT SEPARATELY IDENTIFIED]

OPERATING EXPENSES
[paste category | amount]

OPTIONAL ACCRUAL-BASIS ADJUSTMENTS
[receivables, payables, accruals, deferrals, depreciation or other reviewed adjustments;
leave blank for a cash-basis summary]

Rules:
1. Do not invent categories, amounts or accounting adjustments.
2. Total Revenue = sum of supplied revenue lines.
3. Gross Profit = Revenue - Cost of Sales ONLY if direct-cost/COGS categories are supplied.
   If COGS is not separately identified, omit Gross Profit and say why.
4. Total Operating Expenses = sum of supplied operating-expense lines.
5. Net Profit = Revenue - COGS - Operating Expenses +/- supplied reviewed adjustments.
6. Net Margin = Net Profit / Revenue; if Revenue = 0, return N/A rather than divide by zero.
7. If the data comes only from bank transactions, label the output "cash-basis / bank-activity
   summary" unless I explicitly provide accrual adjustments.
8. Add control totals showing each input section agrees to the P&L.
9. Do not present the result as filed accounts, tax figures or accountant-approved output.

OUTPUT
A tab-separated P&L working paper plus formulas and control checks.