Ledger

phpMyAdmin Ledger

The phpMyAdmin ledger is stored in the Software Freedom Conservancy SVN repository, any team member can ask for access to it.

The ledger is updated when transactions are processed at Software Freedom Conservancy what usually takes some time:

• The PayPal transactions are typically processed once in a week.
• The bank account transactions tend to be delayed for several weeks or months.

Useful scripts

Figuring out current balance:

ledger -V -f Ledger/phpmyadmin.ledger bal '/^(Income|Expenses).*phpMyAdmin/'

Listing not paid invoices:

ledger -f Ledger/phpmyadmin.ledger --sort d --limit 'tag("Program") =~ /phpMyAdmin.*Sponsor/ and tag("Invoice") !~ /^\s*$/' --group-by 'tag("Invoice")' bal '/^Accrued/'

Listing paid invoices:

ledger -f Ledger/phpmyadmin.ledger -F 'On %d, %(tag("Entity")) paid %t for %(tag("Invoice"))\n' --sort d --limit 'tag("Program") =~ /phpMyAdmin.*Sponsor/ and tag("Invoice") !~ /^\s*$/' reg '/^Assets/'