Finance
Invoicing & Receivables
“Who owes us money, what's overdue, and what came in this week?”
Invoices, payments and who still owes you. Made for finance admins and service businesses.
- Tables
- 3
- Fields
- 36
- Links
- 2
14-day free trial. Pick “Invoicing & Receivables” when you create your first database.
Invoice no. Customer Issue date Subtotal Status
INV-2026-0041 Nusantara Logistics 8 Oct 2026 $15,200.00 Overdue
INV-2026-0042 Kopi Senja Group 28 Oct 2026 $3,400.00 Sent
INV-2026-0043 Meridian Hospital 13 Oct 2026 $2,500.00 Paid
INV-2026-0044 Arcadia Fintech 15 Nov 2026 $4,800.00 Sent
INV-2026-0045 Kopi Senja Group 17 Nov 2026 $13,250.00 Draft
How the tables connect
How the tables connect
- Invoices · Customer → Customers
- Payments · Invoice → Invoices
Calculated for you: Tax (Invoices), Total (Invoices), Balance due (Invoices), Days overdue (Invoices), Total billed (Customers), Outstanding (Customers).
Every table and field
Every table and field
Invoices
17 fields · 5 sample rows| Field | Type | Options |
|---|---|---|
| Invoice no.primary | Text | |
| Customer | Link | Links to Customers |
| Issue date | Date | |
| Due date | Date | |
| Description | Text | |
| Subtotal | Currency | USD, 2 decimals |
| Tax rate | Percent | |
| Tax | Formula | ROUND({Subtotal} * {Tax rate}, 2) |
| Withholding tax | Currency | USD, 2 decimals |
| Total | Formula | {Subtotal} + {Tax} - {Withholding tax} |
| Amount paid | Currency | USD, 2 decimals |
| Status | Single select | DraftSentPartially paidPaidOverdueVoid |
| Paid on | Date | |
| Tax invoice no. | Text | |
| Notes | Long text | |
| Balance due | Formula | {Total} - {Amount paid} |
| Days overdue | Formula | IF(AND({Balance due} > 0, TODAY() > {Due date}), TODAY() - {Due date}, 0) |
Customers
11 fields · 4 sample rows| Field | Type | Options |
|---|---|---|
| Customerprimary | Text | |
| Billing email | ||
| Phone | Phone | |
| Billing address | Long text | |
| Tax ID | Text | |
| VAT registered | Checkbox | |
| Payment terms | Single select | Due on receiptNet 7Net 14Net 30Net 45Net 6050% upfront |
| Credit limit | Currency | USD, 0 decimals |
| Notes | Long text | |
| Total billed | Rollup | Sum of Total via Customer |
| Outstanding | Rollup | Sum of Balance due via Customer |
Payments
8 fields · 2 sample rows| Field | Type | Options |
|---|---|---|
| Referenceprimary | Text | |
| Invoice | Link | Links to Invoices |
| Date | Date | |
| Amount | Currency | USD, 2 decimals |
| Method | Single select | Bank transferVirtual accountCardQR / e-walletCashCheckPayPal |
| Bank / account | Text | |
| Withholding slip received | Checkbox | |
| Notes | Long text |
Ask your AI to keep it up to date.
Connect Claude, ChatGPT or Cursor and ask in plain words. For example:
“Who owes us money, what's overdue, and what came in this week? Give me the list, then update anything that's out of date.”
More templates
Run your Invoicing & Receivables on Laras.
No card needed. Set up in a minute.