Accounting cheat sheet

The Profit and Loss (P&L) report shows the performance of the company over a specific period (usually the current year).

  • The Gross Profit equals the revenues from sales minus the cost of goods sold.

  • Operating Expenses (OPEX) include administration, sales and R&D salaries as well as rent and utilities, miscellaneous costs, insurances, … anything beyond the costs of products sold.

The Balance Sheet is a snapshot of the company’s finances at a specific date (as opposed to the Profit and Loss which is an analysis over a period)

  • Assets represent the company’s wealth, things it owns. Fixed assets includes building and offices, current assets include bank accounts and cash. A client owing money is an asset. An employee is not an asset.

  • Liabilities are obligations from past events that the company will have to pay in the future (utility bills, debts, unpaid suppliers).

  • Equity is the amount of the funds contributed by the owners (founders or shareholders) plus previously retained earnings (or losses).

    Each year, net profits (or losses) are reported to retained earnings.

What is owned (an asset) has been financed through debts to reimburse (liabilities) or equity (profits, capital).

A difference is made between buying an assets (e.g. a building) and expenses (e.g. fuel). Assets have an intrinsic value over time, versus expenses having value in them being consumed for the company to “work”.

Assets = Liabilities + Equity

Grootboekschema

The chart of accounts lists all the accounts, whether they are balance sheet accounts or P&L accounts. Every financial transaction (e.g. a payment, an invoice) impacts accounts by moving value from one account (credit) to an other account (debit).

Balans = Debet - Credit

Boekingen

Every financial document of the company (e.g. an invoice, a bank statement, a pay slip, a capital increase contract) is recorded as a journal entry, impacting several accounts.

For a journal entry to be balanced, the sum of all its debits must be equal to the sum of all its credits.

voorbeelden van boekhoudkundige boekingen voor verschillende transacties. Bijvoorbeeld:

Voorbeeld 1: Factuur klant:

Uitleg:

  • U genereert een omzet van $1,000

  • U moet voor $90 aan belastingen betalen

  • De klant is u $1,090 verschuldigd

Configuratie:

  • Income: defined on the product, or the product category

  • Account Receivable: defined on the customer

  • Belasting: gedefinieerd op de belasting ingesteld op de factuurlijn

The fiscal position used on the invoice may have a rule that replaces the Income Account or the tax defined on the product by another one.

Voorbeeld 2: Klantbetaling:

Uitleg:

  • Uw klant is u $1,090 minder schuldig

  • U ontvangt $1,090 op uw bankrekening

Configuratie:

  • Bank Account: defined on the related bank journal

  • Account Receivable: defined on the customer

Aflettering

Reconciliation is the process of linking journal items of a specific account, matching credits and debits.

Its primary purpose is to link payments to their related invoices in order to mark invoices that are paid and clear the customer statement. This is done by doing a reconciliation on the Accounts Receivable account.

An invoice is marked as paid when its Accounts Receivable journal items are reconciled with the related payment journal items.

Afletteren gebeurd automatisch door het systeem wanneer:

  • de betaling is rechtstreekt op e factuur geregistreerd.

  • the links between the payments and the invoices are detected at the bank matching process

Rekeningoverzicht voorbeeld

Debiteuren rekeningen

Debet

Credit

Factuur 1

100

Betaling 1.1

70

Factuur 2

65

Betaling 1.2

30

Betaling 2

65

Factuur 3

50

Totaal te betalen

50

Bank afletteren

Bank reconciliation is the matching of bank statement lines (provided by your bank) with transactions recorded internally (payments to suppliers or from customers). For each line in a bank statement, it can be:

overeenkomst met een vorige geregistreerde betaling:

a payment is registered when a check is received from a customer, then matched when checking the bank statement

geregistreerd als een nieuwe betaling:

the payment’s journal entry is created and reconciled with the related invoice when processing the bank statement

geregistreerd als een andere transactie:

bankoverschrijving, direct afrekening, enz.

Odoo should automatically reconcile most transactions, only a few of them should need manual review. When the bank reconciliation process is finished, the balance on the bank account in Odoo should match the bank statement’s balance.

Checks Handling

There are two approaches to manage checks and internal wire transfer:

  • Two journal entries and a reconciliation

  • One journal entry and a bank reconciliation

The first journal entry is created by registering the payment on the invoice. The second one is created when registering the bank statement.

Rekening

Debet

Credit

Aflettering

Debiteurenrekening

100

Factuur ABC

Undeposited funds

100

Cheque 0123

Rekening

Debet

Credit

Aflettering

Undeposited funds

100

Cheque 0123

Bank

100

A journal entry is created by registering the payment on the invoice. When reconciling the bank statement, the statement line is linked to the existing journal entry.

Rekening

Debet

Credit

Aflettering

Bankafschrift

Debiteurenrekening

100

Factuur ABC

Bank

100

Afschrift XYZ