Databases

Invoicing Schema: Partial Payments and Credit Notes

ER Diagrams · made in Skemio

ER diagram showing invoices, invoice items, payments, and credit notes tables linked by invoice IDs.
ER diagram showing invoices, invoice items, payments, and credit notes tables linked by invoice IDs.
Open it in SkemioMake your own

What it shows

  • Keep issued invoices immutable and apply changes via credit notes.
  • Link multiple payments to an invoice to support installment plans.
  • Calculate balances dynamically or via signed balance transaction logs.

The takeaway

Never mutate an issued invoice. Handle adjustments and split payments with explicit ledger records.

More er diagrams