Skip to content

simonmichael/hledger_finance

Repository files navigation

hledger finance repo

Here we track the hledger project's finances, for clarity, dogfooding, and as a real-world example of FOSS project accounting with hledger. (shortcut: https://finance.hledger.org)

See also the FINANCE section on the hledger website, eg Sponsor hledger, Regression bounty and FINANCE notes.

In this directory:

  • Justfile - maintenance and reporting scripts. just to see help.
  • hledger.conf - local hledger config
  • main.journal - top-level journal file
  • accounts.journal - account declarations
  • oc.* - hledger open collective CSV, conversion rules, journal
  • other.journal - other transactions, manually recorded

The rest of this README is reports, intended to be somewhat readable on Github. These are regenerated semi-automatically, and may improve as data and scripts are cleaned up.

Update process:

  1. View latest OC transactions with all kinds selected: https://opencollective.com/hledger/transactions?kind=CONTRIBUTION%2CEXPENSE%2CHOST_FEE%2CPAYMENT_PROCESSOR_FEE%2CPAYMENT_PROCESSOR_COVER
  2. click Download CSV; click Export CSV (settings: Date range: All time, or whatever; Timezone: Local or UTC, doesn't matter; Exported Fields: Platform Default; Separate transactions compatibility: off )
  3. just update to gather the csv, regenerate and check journals, and update reports
  4. Review changes, investigate/resolve any issues, commit
  5. Check that the latest net asset balance matches https://opencollective.com/hledger#category-BUDGET > TODAY'S BALANCE
  6. git push to update https://github.com/simonmichael/hledger_finance

Reports

Yearly Assets & Liabilities

accountassets:opencollectiveTotal:
commodityUSDUSD
2017100.92100.92
2018290.99290.99
2019372.66372.66
20201437.231437.23
20214689.884689.88
20226863.666863.66
20237465.737465.73
20247388.467388.46
total

Yearly Revenues & Expenses

accountrevenues:donationsexpenses:bountiesexpenses:feesexpenses:miscTotal:
commodityUSDUSDUSDUSDUSD
2017120.000-19.080100.92
2018225.000-34.930190.07
2019105.000-23.33081.67
20201254.380-189.8101064.57
20214721.00-760.01-708.3403252.65
20223744.00-400.00-592.10-578.122173.78
20231868.00-862.00-303.93-100.00602.07
20241232.00-1148.93-160.340-77.27
total13269.38-3170.94-2031.86-678.127388.46

This Year's Revenues & Expenses

Income Statement 2024-01-01..2024-11-18

Commodity2024-01-01..2024-11-18
Revenues
donationsUSD1232.00
  October SwimmerUSD290.00
  Joyful SystemsUSD160.00
  Bas van DijkUSD100.00
  MarcUSD100.00
  usaAmchUSD100.00
  Jack TodaroUSD55.00
  GLakovnikUSD50.00
  akanshaG42USD50.00
  incognitoUSD50.00
  ishmaelavilaUSD50.00
  markokocicUSD50.00
  Brandon BarkerUSD22.00
  FrankUSD22.00
  James BlachlyUSD22.00
  Ken EwingUSD22.00
  Rishi HyankiUSD22.00
  Samim PezeshkiUSD22.00
  GuestUSD20.00
  Richard KellyUSD20.00
  doppy1988USD5.00
Total:USD1232.00
 
Expenses
bountiesUSD1148.93
  Simon MichaelUSD400.00
  ThielemannUSD149.16
  Bas van DijkUSD100.00
  usaAmchUSD100.00
  GLakovnikUSD50.00
  Pranesh PrakashUSD50.00
  William PierceUSD50.00
  akanshaG42USD50.00
  ishmaelavilaUSD50.00
  lakshaygUSD50.00
  markokocicUSD50.00
  Ivan PopovychUSD49.77
feesUSD160.34
  Open Source CollectiveUSD82.04
  STRIPEUSD54.35
  PAYPALUSD20.24
  WISEUSD3.71
Total:USD1309.27
 
Net:USD-77.27

Yearly Net Income

2017	       101 
2018	       190 +
2019	        82 
2020	      1065 +++++++
2021	      3253 +++++++++++++++++++++
2022	      2174 ++++++++++++++
2023	       602 ++++
2024	       -77 

Yearly Net Assets

2017	       101 
2018	       291 +
2019	       373 ++
2020	      1437 +++++++++
2021	      4690 +++++++++++++++++++++++++++++++
2022	      6864 +++++++++++++++++++++++++++++++++++++++++++++
2023	      7466 +++++++++++++++++++++++++++++++++++++++++++++++++
2024	      7388 +++++++++++++++++++++++++++++++++++++++++++++++++

Assets Over Time

                                               hledger assets


                                        bal --depth=1 ^assets --historical
        ⢰⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⢒⣒⣒⣒⣒⣒⣒⣒⡒⠒⠒⠒⠒⠒⢲
  8000  ⢸ ⠠⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤                                                                   ⢀⣀  ⣀⡤⠴⠒⠳⠤⠦⠏⠉⠉⠉⠉⠉⠁  ⠹⠤    ⢸
        ⢸             assets                                                      ⣀⣀⣠⠴⠶⠚⠉⠈⠉⠉⠁                     ⢸
        ⢸                                                                    ⢀ ⢀⡴⠊⠁⠁                              ⢸
  6000  ⢸                                                                   ⡰⠻⠞⠉                                  ⢸
        ⢸                                                                 ⡰⠊                                      ⢸
        ⢸                                                              ⣀⡴⠎                                        ⢸
  4000  ⢸                                                           ⣀⣤⡔⠁                                          ⢸
[USD]   ⢸                                                         ⢀⡖⠁                                             ⢸
        ⢸                                                       ⣠⠖⠃                                               ⢸
  2000  ⢸                                                   ⢀⣠⠖⠋⠁                                                 ⢸
        ⢸                                             ⣀⣠⠤⠖⠒⠋⠉                                                     ⢸
        ⢸    ⢀⣀⣀⣀⣀⣀⣠⣤⣤⣤⣤⣤⣤⠤⠤⠤⠤⠤⠤⠤⠤⠴⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠚⠓⠋⠉⠉⠁                                                           ⢸
      0 ⠘⠂⠒⠒⠲⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠲⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠶⠐⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠐⠒⠘


        2017        2018        2019         2020        2021        2022         2023        2024        2025

Revenues Over Time

                                        hledger monthly revenues


                                      bal --depth=1 ^revenues --monthly
       ⢰⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⣒⡒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⢲
       ⢸                                                               ⢸ ⡇  ⡖⡆             ⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤            ⢸
       ⢸                                                             ⢠⢶⠘ ⡇⡶⡄⡇⡇                         revenues   ⢸
       ⢸                                                         ⢠⠤⠤⠴⠋⠈⠒ ⠓⠃⡇⡇⠧⡄                                   ⢸
  400  ⢺                                                         ⢸        ⠐⡇⡇ ⡇ ⡤⡄                ⢀⡤⡀             ⢸
       ⢸                                                     ⢠⢤⢠⢤⢸         ⠧⠇ ⠧⠤⠇⡇                ⢸⡇⡇             ⢸
       ⢸                                                     ⢸⢸⢸⢸⢸               ⡇                ⢸⡇⡇             ⢸
       ⢸                                                    ⢰⠚⢸⢸⠸⡼               ⣇⡀               ⢸⡇⡇      ⡤⡄     ⢸
[USD]  ⢼                                                    ⢸ ⢸⢸                  ⡇   ⢼⢳          ⢸⡧⡇      ⡇⡇     ⢸
       ⢸                                             ⢀⡀     ⣸ ⢸⣸                  ⠓⠒⠚⠓⠚⠸⠤⠤⠤⠞⠹⠼⢹  ⢰⠉⢸⣇      ⡇⣇⡀    ⢸
       ⢸                                            ⡖⠃⠑⠒⠒⠒⠊⠉⠁  ⠁                              ⠈⠉⠉⠉  ⠈⡇     ⡇ ⣇    ⢸
       ⢸                           ⢰⢲               ⡇                                                ⣇⣀⣀⣀⣀⣀⡇      ⢸
       ⣸    ⠠⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠖⠒⠒⠒⠒⠢⠤⠤⠤⠼⠸⠤⢤⣀⣤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤⠇                                                             ⢸
    0  ⠘⠒⠒⠒⠂⠶⠐⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠐⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠲⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠐⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠘


       2017         2018        2019        2020         2021        2022         2023        2024         2025

Expenses Over Time

                                        hledger monthly expenses


                                      bal --depth=1 ^expenses --monthly
       ⢰⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⣒⡒⠒⠒⠒⠒⢲
  600  ⢹ ⠠⠤⠤⠤⠤⠤⠤⠤⠤⠤⠤                                                         ⣠⡀                             ⡇⡇    ⢸
       ⢸             expenses                                                ⡇⡇                             ⡇⡇    ⢸
       ⢸                                                                     ⡇⡇                             ⡇⡇    ⢸
       ⢸                                                                     ⡇⡇                             ⡇⡇    ⢸
  400  ⢹                                                            ⢰⢲       ⡇⡇                             ⡇⡇    ⢸
       ⢸                                                            ⢸⢸       ⡇⡇                ⢠⢶          ⡤⠇⡇    ⢸
       ⢸                                                            ⢸⢸ ⢰⠛⡆   ⡇⡇                ⢸⢸          ⡇ ⡇    ⢸
[USD]  ⣸                                                           ⢠⠼⢸ ⢸⡀⡇   ⡇⡇   ⡖⡆     ⣰⢲    ⢸⢸          ⡇ ⡇    ⢸
  200  ⢸                                                           ⢸ ⢸⢠⠼ ⡇⡖⡆ ⡇⡇   ⡇⡇     ⢸⢸    ⢸⢸⢠⠶⡄       ⡇ ⡇    ⢸
       ⢸                                                           ⢸ ⢸⢸  ⡇⡇⡇ ⡇⠙⡆  ⡇⡇ ⡔⢲ ⢰⠊⠘⢲   ⢸⠘⠚⠠⣇⡀⢀⡤⡀   ⡇ ⠧    ⢸
       ⢸                                                     ⢀⣄⢀⣀⢠⠤⠼ ⠘⠚  ⠲⠃⣇⠏⠁ ⠧⠤⡄⡇⡇ ⠇⢸⡀⢸  ⢸   ⢸   ⢸⡇⢸ ⡇   ⡇      ⢸
       ⣸    ⣠⣀⣀⣀⣀⣀⣀⣀⣀⣀⣀⣀⣠⣀⣀⣀⣀⣀⣀⣀⣀⣀⣀⣠⢤⣄⣀⣀⣀⣀⣀⣀⣀⣀⣀⣀⣀⣠⣀⣀⡴⠒⠒⠒⠒⠒⠒⠒⠚⠁⠘⠚⠈⠉               ⠈⠁⠑⠚⠉ ⠙⠊  ⠈⠓⠒⠓⠚   ⠈⠓⠼ ⠧⠤⠤⠤⠇      ⢸
    0  ⠘⠒⠒⠒⠂⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠲⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠲⠖⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠲⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠂⠶⠐⠒⠒⠒⠒⠒⠒⠒⠒⠒⠒⠰⠆⠒⠘


       2017         2018        2019        2020         2021        2022         2023        2024         2025