Skip to content

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 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.”

How AI apps connect →

More templates

Run your Invoicing & Receivables on Laras.

No card needed. Set up in a minute.