Accounting System
A professional double-entry accounting database schema following GAAP/IFRS principles. Features a hierarchical chart of accounts (assets, liabilities, equity, revenue, expenses), journal entries with balanced debit/credit lines, invoice generation with line items, and full audit trail. Suitable for building accounting software like QuickBooks or Xero, ERP financial modules, or bookkeeping platforms.
Created with ERD Studio
Tables in this template
accountsChart of Accounts
8 colsaccount_categoriesAccount Categories
4 colsjournal_entriesJournal Entries
9 colsjournal_linesJournal Lines
6 colscustomersCustomers
7 colsvendorsVendors
7 colsinvoicesInvoices
9 colsinvoice_itemsInvoice Items
7 colstax_ratesTax Rates
5 colsfiscal_periodsFiscal Periods
7 cols