Income and expense
Income and expense are critical for an organisation.
The expense register contains all details of incoming invoices and expense claims.
An aggregated yearly report is a mandatory part of the financial statements.
Provisions for future income and expense can be materialized in the balance sheet.
Process
[edit]- Budget and grants
- Expense register
- Gather the electronic bank statements in Excel
- Split debit and credit
- Allocate
- Aggregate
- Reconcile
Reporting
[edit]- Sources: bank transactions in Excel format (per year), expense register
- Split into tables: debit (negative) and credit (positive)
- Allocate by transaction type (code)
- Pivot by (activity) type
- Aggregate by source / destination
- Expense register (and cost based reporting pivot tables)
Rules
[edit]- For the transaction types, be as specific as possible:
- membership fee, gift, grants, contributions, (outgoing) invoices, credit note
- admin, mobile data, web sites, telecom, publications, activities, room, food, drinks, travel, hotel, material, provisions