Accounting

Basic Bookkeeping System

A simple double-entry bookkeeping system designed for small businesses, freelancers and startups. Includes accounts, journals, invoices, supplier bills, payments and bank transactions, providing the core functionality required to record income and expenses and produce basic financial reports.

13 tables
Tables included
13
Template type
Accounting
Setup
Ready to customise

Template structure

Included tables

These tables will be created when you use this template.

Table
Accounts
Code: Account

Chart of accounts used for income, expenses, assets, liabilities and equity.

Table
Journals
Code: Journal

Accounting transaction headers containing transaction date, reference and description.

Table
Journal Entries
Code: JournalEntry

Individual debit and credit lines linked to a journal.

Table
Customers
Code: Customer

Customers who purchase goods or services.

Table
Suppliers
Code: Supplier

Suppliers and vendors used by the business.

Table
Customer Invoices
Code: Invoice

Sales invoices issued to customers.

Table
Invoice Items
Code: InvoiceItem

Individual line items appearing on customer invoices.

Table
Supplier Bills
Code: Bill

Supplier invoices and accounts payable records.

Table
Bill Items
Code: BillItem

Individual line items appearing on supplier bills.

Table
Payments
Code: Payment

Money received from customers or paid to suppliers.

Table
Bank Accounts
Code: BankAccount

Business bank accounts and account balances.

Table
Bank Transactions
Code: BankTransaction

Deposits, withdrawals and bank reconciliation entries.

Table
Tax Codes
Code: TaxCode

Tax rates such as VAT and other tax classifications.