
💡For PmWiki fans ±
The administrator of this website welcomes you.
Here’s an example of using FoxCSV: a simple cash book, for personal use only, of course. Everything is contained on this page (except CSS). Below you’ll see the code, frozen at a specific time.
The table is sorted by date, and this is fixed because the „sortable“ feature only works with simple tables and not with „rowspan“ cells. However, „filterable“ provides a good search and selection option.
With a single wiki line, you can create an extract from the data, as shown for Mrs. Eloquendi and for „Donation.“ (Because if I use „filterable“, I can no longer see the totals.)
The numbering in the first column is only rendered and not embedded in the data. Alternatively, FoxCSV offers an „Index“ column, but this requires maintenance and updates.
The „Receipt No.“ column is only intended for use with paper receipts if you need numbering. It’s generated from the date and the first three letters of „booking text.“ As you can see, this is not sufficient for professional accounting: the abbreviations are not guaranteed to be unique.You could easily add a button to dismiss this column, just like the edit column on the far right. And of course, you can define which elements shouldn’t be printed.
What I haven’t yet managed to do is have a balance in every row (like you used to have on paper). In principle, FoxCSV can also access the value of a specific cell. But incorporating this into a template might not be possible.
Naturally, with FoxCSV, you can distribute the data and displays (extracts) across different pages, as needed. You can also see that you edit the original data from within an extract.
Feel free to try it out. Here you can see the PmWiki Code.
See my profile page on pmwiki.org for more information.
| # | Datum | Beleg-Nr. | Buchungstext | Einnahme | Ausgabe | Saldo | |
|---|---|---|---|---|---|---|---|
| 1 | 16.01.2026 | 0116-spe | Spende anonyme | 80,00 | -0,00 | ||
| 2 | 03.02.2026 | 0203-elo | Eloquendi Klassenkasse | 70,00 | -0,00 | ||
| 3 | 18.02.2026 | 0218-kaf | Kaffeefilter Nr.4 | 0,00 | -1,29 | ||
| 4 | 18.02.2026 | 0218-mil | Milch | 0,00 | -12,55 | ||
| 5 | 18.02.2026 | 0218-zuc | Zucker | 0,00 | -5,45 | ||
| 6 | 19.02.2026 | 0219-bri | Briefmarken | 0,00 | -15,75 | ||
| 7 | 19.02.2026 | 0219-bri | Briefmarken | 0,00 | -160,20 | ||
| 8 | 19.02.2026 | 0219-han | Hanuta Großpackung | 0,00 | -20,45 | ||
| 9 | 19.02.2026 | 0219-kaf | Kaffeefilter | 0,00 | -0,89 | ||
| 10 | 19.02.2026 | 0219-lak | Lakritz-Schnecken | 0,00 | -2,59 | ||
| 11 | 19.02.2026 | 0219-spe | Spende Karin Spechta | 150,00 | -0,00 | ||
| 12 | 19.02.2026 | 0219-spe | Spende Opa Vielmann | 50,00 | -0,00 | ||
| 13 | 20.02.2026 | 0220-mül | Müll | 0,00 | -123,45 | ||
| 14 | 21.02.2026 | 0221-kaf | Kaffee | 0,00 | -15,00 | ||
| 15 | 21.02.2026 | 0221-sch | Schokolade | 0,00 | -2,89 | ||
| 16 | 10.03.2026 | 0310-per | Perlenböck Klassenkasse | 75,00 | -0,00 | ||
| 17 | 14.03.2026 | 0314-aus | Ausflug Tierpark: Eintritt | 0,00 | -36,20 | ||
| 18 | 17.03.2026 | 0317-lak | Lakritzstangen | 0,00 | -20,00 | ||
| 19 | 07.04.2026 | 0407-elo | Eloquendi Klassenkasse | 150,00 | -0,00 | ||
| 20 | 28.04.2026 | 0428-sch | Schokoladen-Maikäfer | 0,00 | -19,25 | ||
| 21 | 04.06.2026 | 0604-spe | Spende Oma Scharlatan | 100,00 | -0,00 | ||
| 675,00 | -435,96 | 239,00 | |||||
| # | Datum | Beleg-Nr. | Buchungstext | Einnahme | Ausgabe | Saldo | |
|---|---|---|---|---|---|---|---|
| 1 | 03.02.2026 | 0203-elo | Eloquendi Klassenkasse | 70,00 | -0,00 | ||
| 2 | 07.04.2026 | 0407-elo | Eloquendi Klassenkasse | 150,00 | -0,00 | ||
| 220,00 | -0,00 | 220,00 | |||||
| # | Datum | Beleg-Nr. | Buchungstext | Einnahme | Ausgabe | Saldo | |
|---|---|---|---|---|---|---|---|
| 1 | 16.01.2026 | 0116-spe | Spende anonyme | 80,00 | -0,00 | ||
| 2 | 19.02.2026 | 0219-spe | Spende Karin Spechta | 150,00 | -0,00 | ||
| 3 | 19.02.2026 | 0219-spe | Spende Opa Vielmann | 50,00 | -0,00 | ||
| 4 | 04.06.2026 | 0604-spe | Spende Oma Scharlatan | 100,00 | -0,00 | ||
| 380,00 | -0,00 | 380,00 | |||||