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
Access databases that started as a small tool often end up with many users, slow shared files and corruption scares, and the next step is SQL Server or MySQL with Access kept as the front end or replaced. Send screenshots of your tables, relationships and key queries, or exported table lists, and we write a migration plan: a table-by-table map of Access data types to the target, keys and indexes, queries and VBA that need rewriting, and the order of steps for moving data and relinking. You get the CREATE TABLE scripts for the target as text, ready to run and adjust.
What is included
- What you getA migration plan as text on the order page: a table map with Access and target data types, keys and indexes, a list of queries and VBA to rewrite with notes, step order for data transfer and linking, and CREATE TABLE scripts for SQL Server or MySQL.
- Type mapEvery field to its target data type
- Keys and indexesAutoNumber, unique keys, indexes
- Rewrite listQueries and VBA that will not work as is
- Step orderSchema, data, relink, test
- CREATE TABLE scriptsFor SQL Server or MySQL
How it works
- 1StructureYou send tables, queries and target
- 2PlanWe map types and list rewrites
- 3DeliveryYou get the plan and scripts
What we need from you
Screenshots of each table in design view and of the relationships window (or table and field lists typed out or exported to Excel), the SQL of your main queries, the VBA modules that touch data, your target (SQL Server, Azure SQL or MySQL) and whether Access stays as the front end.
We will ask you:
- Which target do you plan: SQL Server, Azure SQL or MySQL?
- Will Access stay as the front end?
- How many tables and users does the database have?
- Which queries or VBA modules are critical?
Compare packages
| Packages | BasicUp to 10 tables$15 | StandardUp to 25 tables$29 | PremiumUp to 40 tables$55 |
|---|---|---|---|
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Tables mapped | up to 10 | up to 25 | up to 40 |
| Queries reviewed | up to 10 | up to 25 | up to 50 |
| VBA modules reviewed | none | up to 3 | up to 8 |
| 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
Can I send my .accdb file?
No, database files cannot be opened here. Send screenshots of the table design and relationships window, or export tables or queries to Excel and attach them (hide personal data first).
Will you move the data for me?
No, we do not connect to your servers or files. You run the scripts and transfer steps yourself or with your IT team, following the plan.
Will the plan cover hosting and licences?
We note what each target needs in general terms, but we do not compare hosting prices or licence costs. Check those with your provider.