How to move from spreadsheets to a database
The signs a spreadsheet has outgrown itself, and how to move without losing the flexibility that made it work.
What every invoice must contain, how to number them, and the small details that get you paid faster.
An invoice is a request for payment that also serves as an accounting record. At minimum it needs: the word “Invoice”, a unique number, the date, who is billing whom, what is being charged for, the amount with tax shown separately, the payment terms and the payment details. Miss one of those and you give the client a reason to delay.
Everything else — a logo, a thank-you note — is optional. What genuinely changes how fast you are paid is clarity about the amount, the due date and how to pay.
Ask, once, who handles payments and whether they need a purchase-order number. An invoice missing a PO number is often silently parked until someone chases it.
Ettex Invoices covers the routine part: line items, statuses, PDF export, duplicating last month’s invoice for a recurring client, and a view of what is still unpaid. Amounts use the workspace currency, so the same setting applies across invoices, bookkeeping and the CRM.
Requirements differ by country. In many places an individual can invoice for work, but tax registration thresholds and what must appear on the document vary — check the rules where you are.
Do not edit it quietly. Issue a corrected invoice or a credit note referencing the original number, so the trail stays intact.
Only if the terms were agreed in advance — in the contract or on the invoice before it was due. Adding a penalty afterwards rarely holds up.
Most jurisdictions require several years, commonly five to seven. Keep them as PDFs somewhere you control, not only inside a tool you might stop using.
The signs a spreadsheet has outgrown itself, and how to move without losing the flexibility that made it work.
The five sections that matter, in the order visitors read them — and what to do before you pick a template.
Separate calendars per purpose, the right level of visibility, and how to keep it readable as the team grows.