From Wiki
Jump to: navigation, search

Accounting deals with tracking expenses and income, past and future. Its knowledge could be used to produce bugget reports (Budgeting page), btu that is usually done before accounting comes into play. The accounting team is not yet involved in authorization or actual money movement, though we can probably help you figure out how to do that.

Past/current ledgers can be found here:

Current balances are at .

Reimbursement forms: FFIS (international), FFIS (german account), FFIS (interactive), SPI

We need your help!
When any money moves, it needs to be updated in our ledger! For things directly from bank accounts, we can follow up with the bank's records, but for other things (most on-site things), we need *you* to mail us at

For each transaction, what we need to know is:

  • Date
  • Description / what it's for
  • Amount and currency
  • Who it is from and who it is to. (example: to: the ISP. from: my bank account)

Examples of things to send us:

  • You bought something and need to be reimbursed.
  • An invoice is paid.
  • Someone is paying debconf in cash on-site.
  • Any other cash transactions.
  • Money is transferred overseas.
  • We are using your bank account to transfer money, and you got a deposit, you spent something, and so on.
  • Anything involving money!
  • Anything in the past involving money that we don't know about.


[edit] Summary

  • Since DebConf is so chaotic, we use a pragmatic approach: make the best budget possible (usually some spreadsheet in debconf-data), but realize this will be out of date and inaccurate in the end.
  • budget.ods in debconf-data lists predictions of expenses, before the conference.
    • budget.ods has only estimated total expenses in it.
  • ledger-dcNN` and ledger-dcNN-onsite (if we have a separate onside ledger) are the ledgers. This records actual money movement by transaction (links above).
    • These are in `apt-cache show ledger` format.
    • After the conference, ledger-dc11 should be our actual conference budget. Practically speaking, by this time budget.ods will probably be out of date.
    • ledger-dc11 is *public*, in debconf-data. As such, the transaction descriptions there should not include sponsor or attendee names. This may make tracking a little bit harder, but richard considers the transparency worth the extra effort. The sponsor and attendee details are in two spreadsheets listed below.

Are we using cash or accrual accounting? Basically, cash. For example, attendee payments are not considered income until they hit our banks - since many professional registrants just register accidentally and never intend to pay. Similarly, other expenses are considered when money actually moves, not when it is authorized, since this is DebConf and we can't plan that far in advance. Some things, like sponsor income, in some years, is tracked in an accrual kind of way (assets:receivable:sponsor). Other fixed, non-adjustable things (mainly reimbursements) can be listed as such when they are known, instead of when money moves. Mixing systems may not be ideal, but this is what realistically works for DebConf.

You can find current balances at . `incomes` is (negative) incomes so far. `expenses` is expenses so far. Current account balances should be in `assets`

[edit] How it works

This section isn't important except if you want to join the accounting team.

The ledger is a double-entry general ledger. It can be examined with the `ledger` program (in Debian) or `hledger` program (not in Debian yet). These programs can generate all types of useful reports, and are scripted to do so at the links above. The `ledger` manual, in particular, is a good introduction to double-entry accounting. `ledger-dcNN` is designed to be public. If you want to add something to it, here are sample entries:

 2011/03/19 Name tags
     expenses:misc        $+150
     assets:spi           $-150
 2011/03/19 SPI->FFIS transfer
     assets:spi            -$1000
     assets:ffis              790 EUR
     expenses:exchangefee    $10

`hledger add` provides a nice tab-completing interface to appending new transactions. Note that euros are "EUR", not "€", due to a unicode bug in some vty library.

The attendee payments and sponsor payments are kept as sub-accounts in spreadsheets. This allows the ledger itself to be public. Occasionally, the `income:attendee` and `income:sponsors` accounts are updated in the ledger from the spreadsheets.

The `assets:` accounts list current assets. SPI, FFIS, and ISIC balances (as seen online) should match the ledger balances at all times. Run a "ledger bal" command after any update involving these and make sure that it matches the amount in the bank view.

Anything dealing with attendee-payments, travel sponsorship, or sponsors should also be recorded in the spreadsheets in debconf-team. The spreadsheets should include names, dates that match with here, and total balances should always reconcile. Run "ledger bal" after updating these and make sure the ledger matches the total balances in the respective "actual amounts" (as opposed to future) columns of the respective spreadsheets.

If someone is due a reimbursement, record it in liabilities:<nickname>.

`receivable:` can be used to record money due us. Attendee payments are generally *not* worth putting under `receivable`, since they are too fluid. Half the expected paying attendees will happen not come/not pay, and we don't want to have to be keeping things that crazy up to date in the ledger.

Ledger can take comments starting with ";". Liberally use them in any weird cases (again, no private info) so that someone else reading can figure out what is going on.

This section will be updated with more information as procedures are developed.

[edit] List of accounts

Historical accounts ledgers have used. Try to use these when possible, ore ones in analogy to them depending on the specific conference.

income:sponsor        - sponsors, should always match sponsors.ods
income:attendee:prof  - attendee payments, this and below should always match attendees.ods
income:donation       - donations from attendees or other non-"sponsors"
expenses:travel   - attendee travel, should always match travel.ods
expenses:conf     - general conference expenses (e.g. name tags)
expenses:venue    - venue and venue furnishings, etc.
assets:spi        - our actual current bank account balances.
assets:receivable:{<nickname>|sponsor} - money due us, *if* it is firm.
equity:debconf*   - surpluses rolled over from debconf to debconf
equity:debian:{spi|ffis} - amounts taken from / returned to Debian (in which organization).
liabilities:<nickname> - money due someone.

[edit] References

message-id: talks about FFIS reimbursement process

Personal tools