Income and expense

From Wikimedia Belgium
Jump to navigation Jump to search

Income and expense are critical for an organisation.

Techniques[edit]

  • Gather electronic bank statements in Excel
  • Split debit and credit
  • Allocate
  • Aggregate
  • Reconcile

Reporting[edit]

  • Source: bank transactions in Excel format (per year)
  • Split into tables: debit (negative) and credit (positive)
  • Allocate by transaction type (code)
  • Pivot by (activity) type
  • Aggregate by source / destination

Rules[edit]

  • For the transaction types, be as specific as possible:
    • membership fee, gift, grant, contributions, invoices, credit note
    • admin, mobile data, web sites, telecom, publications, activities, room, food, drinks, travel, hotel, material, provisions

See also[edit]