设计债务偿还跟踪表
规划债务、付款记录和汇总工作表,编写余额与还款日期公式,并建立每月维护流程。
完整提示词
<context>
A debt tracker keeps people going because it shows progress the bank statements hide. Home-made trackers break in predictable ways: balances typed over each month so history is lost, interest estimated once and never updated, payoff dates that ignore the interest, minimum payments that silently cover less than the interest, and a "snowball" order that is not updated when a debt is cleared and its payment should roll to the next. A robust design keeps one Debts tab (one row per debt, never deleted, with a status), one long Payments log (date, debt, amount, type), and a Summary that calculates current balance from the starting balance, payments and statement interest, then projects the payoff month with NPER at the current payment. Real interest should come from statements, entered as its own row, because lenders compute it daily and apply fees.
Tool: {{tool}}
</context>
<task>
Debts:
<debts>
{{debts}}
</debts>
{{#needs}}
How they will use it:
<needs>
{{needs}}
</needs>
{{/needs}}
1. Workbook layout: four tabs at most (Debts, Payments, Summary, optional Plan for the snowball or avalanche order) and what each holds.
2. Tab by tab: columns with header names, data types and validation (debt name as a drop-down from the Debts tab, entry type as a drop-down: payment, interest, fee, new charge, adjustment; real dates).
3. Formulas for {{tool}}, written for the column letters you defined: current balance per debt (start balance plus interest, fees and new charges minus payments, with SUMIFS), total paid and total interest paid to date, monthly interest estimate, projected months to payoff and payoff date with NPER and EDATE, a warning when the payment does not cover the monthly interest, percentage paid off, and the next debt in the chosen order. Prefer whole-column or table references. One line explaining each formula.
4. A simple progress view: total debt over time from the Payments log (a monthly summary table that a line chart can sit on), and a debt-free date.
5. Starter rows from their debts, clearly marked as examples to replace.
6. Monthly routine: enter statement interest and payments, check the balance against the statement and add an adjustment row for any difference, roll the freed-up payment to the next debt.
7. Mistakes to avoid.
</task>
<constraints>
{{> guardrails/professional-limits}}
- Formulas must be valid in {{tool}} and match the column layout you gave; do not mix Excel-only and Sheets-only functions.
- Say clearly that projected payoff dates are estimates and that the lender's statement balance is the authority.
- Do not link to templates or add-ons; describe how to build it.
- Never include account numbers or personal identifiers in examples.
- Keep it to what they will maintain; offer extras separately.
{{> output/uncertainty}}
</constraints>
<output_format>
## Workbook layout
Table: tab | purpose.
## Tab by tab
For each tab, a table: column | header | type or validation.
## Formulas
Code blocks with a one-line note each.
## Starter rows
Small tables.
## Monthly routine
Numbered steps.
## Mistakes to avoid
Bullets.
</output_format>可替换内容
- {{tool}}
- {{debts}}
- {{#needs}}
- {{needs}}
- {{/needs}}
- {{> guardrails/professional-limits}}
- {{> output/uncertainty}}
分类与标签
财务理财、债务管理、还款计划、电子表格、财务跟踪