Payment protectionDetails
- Revisions within the package are free.
- If you do not respond within 3 days of delivery, the work is accepted automatically.
The money is reserved when you pay and released only once you accept the work.
Example result
Spreadsheet template: invoice tracker for a small agency
Sheet layout — tab "Invoices"
| Column | Header | Filled by |
|---|---|---|
| A | Invoice # | You |
| B | Client | You (drop-down from tab "Clients") |
| C | Issue date | You |
| D | Amount | You |
| E | Payment terms (days) | Formula |
| F | Due date | Formula |
| G | Paid on | You (leave empty until paid) |
| H | Status | Formula |
| I | Days overdue | Formula |
Formulas (excerpt, 6 of 10)
E2 — payment terms from the client list
=IFERROR(VLOOKUP(B2, Clients!A:C, 3, FALSE), 30)
Looks up the client's terms in the "Clients" tab; if the client isn't there, uses 30 days.
F2 — due date
=IF(C2="", "", C2 + E2)
Adds the terms to the issue date. Stays empty for blank rows.
H2 — status
=IF(C2="", "", IF(G2<>"", "Paid", IF(TODAY()>F2, "Overdue", "Open")))
Paid if a payment date is entered; otherwise Overdue after the due date, else Open.
I2 — days overdue
=IF(H2="Overdue", TODAY() - F2, "")
Dashboard!B2 — total outstanding
=SUMIFS(Invoices!D:D, Invoices!H:H, "<>Paid", Invoices!C:C, "<>")
Dashboard!A5 — balance by client (one formula fills the table)
=QUERY(Invoices!B:H, "select B, sum(D) where H <> 'Paid' and B is not null group by B order by sum(D) desc label sum(D) 'Owed'", 1)
Where to paste
- Put E2, F2, H2 and I2 in row 2 of "Invoices", then drag down to row 500
- Paste the two Dashboard formulas once; they update by themselves
- Conditional formatting on H2:H500: text is "Overdue" → light red fill
Edge cases handled
- Partly paid invoice: add a row with the remaining amount and a new number like INV-041b
- Client renamed: change it only in "Clients"; the drop-down keeps rows consistent
- Excel instead of Sheets: all formulas work except QUERY; use a PivotTable on columns B, D, H instead
Check example
Invoice INV-038, client Northside Dental, issued Sep 1, terms 14 days → due Sep 15. Today Oct 20, not paid → Overdue, 35 days.
Client: a 4-person video production studio. Tool: Google Sheets. Task: "We lose track of who has paid. We need one sheet that shows overdue invoices and how much each client owes."
The client and all details are made up.
About this service
Send a screenshot with the formula bar visible and the error it shows, and we find why it breaks. Documents can also be attached as PDF, Word or Excel files. Most errors come from a handful of causes: numbers stored as text, extra spaces, VLOOKUP using approximate match, ranges that stop short of new rows or references lost after a column was deleted. We return the corrected formula and explain the cause so it does not come back.
What is included
- What you getCorrected formulas with the exact cells to paste them into and a short note on what went wrong. Delivered as text on the order page.
- Error explained#N/A, #REF!, #VALUE! and others
- Lookup rebuiltXLOOKUP or INDEX/MATCH where better
- Data cleanupSpaces and text-numbers handled
- Growing rangesNew rows counted without edits
How it works
- 1ScreenshotYou show the error and the formula
- 2DiagnosisWe find the cause and fix it
- 3DeliveryYou paste the fix and check it
What we need from you
A screenshot showing the broken cell, the formula bar and the data it refers to, plus what the formula should return. You can also attach the workbook as an Excel (.xlsx) file.
We will ask you:
- Do you use Excel or Google Sheets, and which version?
- Which cell shows the error, and what does it say?
- What should the formula return in that cell?
- Did it work before, and what changed since then?
Compare packages
| Packages | BasicUp to 3 formulas fixed$10 | StandardUp to 10 formulas fixed$20 | PremiumUp to 20 formulas fixed$39 |
|---|---|---|---|
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Formulas fixed | up to 3 | up to 10 | up to 20 |
| Explanation | short note | for each formula | for each formula, with tips |
| Order Basic | Order Standard | Order Premium |
Payment protection
You pay when you order, but the money is released only for accepted work.
- Fixed priceThe package price does not change after you pay.
- The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
- Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
- Free revisionsAsk for changes within your brief as many times as the package allows.
- Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
- Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
Questions and answers
Why does VLOOKUP give #N/A when the value is clearly there?
Usually one side has a trailing space or a number saved as text. We wrap the lookup so both sides match, or switch to an exact-match lookup.
My Excel has no XLOOKUP. Can you still fix it?
Yes. For Excel 2016 or 2019 we write the same lookup with INDEX and MATCH, which works in every version.
What if the fix still shows an error on my data?
Attach the workbook as an Excel (.xlsx) file or send a new screenshot of the cell and the formula bar, and we fix it within your revisions.