Do you need to know if a week of sales still beats what you spent?

List only money you already received and costs you already paid or must pay this period. Leave out account numbers and supplier IDs. Paste the prompt into ChatGPT, Claude or Gemini. In Google Sheets you can click Ask Gemini instead, then insert the table. Read the leftover amount. If a cost is marked "To confirm", find the original receipt or chat before you restock. Keep the table in Sheets or Notion and add the next week the same way. Do not let AI invent extra customers or savings. Before you use it: AI can add the numbers wrongly. Recheck the totals with a calculator. This is not tax, BIR or loan advice. Google says not to rely on Gemini in Sheets as financial advice.

See if a small job still covers its costs

Listen to this guide

AI narration · English · Prompt text stays on the page

Try ElevenLabs ↗ · Affiliate link

A market scale, vegetables, and a coin dish on a stall table, shown in Pinoy AI Works artwork

What to do

List only money you already received and costs you already paid or must pay this period. Leave out account numbers and supplier IDs.
Paste the prompt into ChatGPT, Claude or Gemini. In Google Sheets you can click Ask Gemini instead, then insert the table.
Read the leftover amount. If a cost is marked "To confirm", find the original receipt or chat before you restock.
Keep the table in Sheets or Notion and add the next week the same way. Do not let AI invent extra customers or savings.

Try this prompt

Paste this into ChatGPT, Claude or Gemini. In Sheets, use Ask Gemini and insert the table if you like the result.

Check whether this small job covers the costs I provide. Show the arithmetic and keep cash costs, my time and uncertain costs separate.

JOB
Quoted/expected client payment: ₱[AMOUNT]
Probability/payment uncertainty I want noted: [NONE / DETAILS]
Direct materials: [ITEM + AMOUNT]
Transport/delivery: ₱[AMOUNT]
Platform/payment fees: [AMOUNT OR % + BASIS / NONE]
Subcontractor/help: ₱[AMOUNT / NONE]
Other cash costs: [ITEM + AMOUNT / NONE]
Hours I expect to spend: [HOURS / TO CONFIRM]
Value/rate I choose for my own time: ₱[PER HOUR / DO NOT PRICE MY TIME]
Taxes/withholding or other deductions I know: [DETAILS / NONE / TO CONFIRM]

VALIDATE
- Do not invent a fee, tax, transport cost, hourly rate, materials cost or payment probability.
- Do not treat my chosen hourly value as cash already spent; show it separately.
- If a percentage fee lacks a calculation base, mark To confirm.
- Flag missing or duplicate costs.

OUTPUT
1. Revenue supplied.
2. Cash-cost table and total.
3. Cash left after supplied cash costs.
4. Time-cost estimate separately, only if I supplied an hourly value.
5. Amount left after cash + chosen time value.
6. Effective hourly return based on supplied figures, when calculable.
7. Break-even quote only if inputs are sufficient.
8. Unknown costs that could change the result.

Show formula → numbers → result and recompute once. Call it an estimate, not guaranteed profit. Do not tell me whether to accept the job; show the trade-offs so I can decide.

See a sample result

Illustrative example. Your answer may differ.

Input (illustrative): Income: 12 prepaid loads ₱100 each. Costs: load wallet top-up ₱1,000; plastic bags ₱80. Result (illustrative): Income ₱1,200. Costs ₱1,080. Left ₱120. Largest costs: wallet top-up, bags. Question: “Did the ₱1,000 top-up include a promo, or is that the full cost?”

Before you use it: AI can add the numbers wrongly. Recheck the totals with a calculator. This is not tax, BIR or loan advice. Google says not to rely on Gemini in Sheets as financial advice.

Track bills and income for this month Gemini in Sheets Gemini accuracy

More everyday guides

Browse all 70 guides →