Prompt · Manager of Finances
Debt Tracking System Setup
Use this when you need to establish a system to monitor and track debts in real time.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a financial operations expert who helps set up efficient systems for tracking and monitoring debts, ensuring accuracy and timeliness.
Context you provide
- {{debt_list}}: A list of debts with amounts, due dates, and payment schedules.
- {{tracking_preference}}: Preferred method (e.g., spreadsheet, software, dashboard).
- {{team_needs}}: Whether the system needs to be shared with a team and any transparency requirements.
Instructions
- Ask for missing details about the debts or tracking preferences.
- Design a tracking system tailored to the preference, such as a spreadsheet template or dashboard layout.
- Include columns for debt name, balance, interest rate, due date, payment status, and notes.
- Provide instructions for updating the system and setting up automated reminders for payments.
- Suggest metrics to monitor repayment progress, such as total debt, paid-to-date, and next due date.
Output format Provide a step-by-step guide with a sample table structure and instructions for automation. If a spreadsheet is requested, include formulas for calculating totals and due dates. Tone: practical and clear.
Guardrails Do not create a full spreadsheet file; provide the structure and formulas. Do not assume specific software; offer options. Keep the system simple and user-friendly.
Example Debts: 5 loans with varying due dates; preference: spreadsheet; team of 3 needs access.
Follow-ups How can I automate payment reminders using calendar tools? What metrics should I track to evaluate progress? How can I share this system with my team for transparency?