SQL for producing csv tables that can be used to produce pivot tables for analysis in the spreadsheet of your choice.
The main difference to GnuCash's Transaction Report is that it exposes any Tag matched by a Regular Expression as well as the TagLocation so these can be pivoted on.
I think about vibecoding a webinterface for gnucash.
Something like firefly III but without the limitations of firefly III
and compatible to the gnucash Desktop App.
Before I start: Is there already something like that?
€dit:
Decided to let make something new
https://github.com/Simon0Harms/gnubook
This year, I'm moving from Quicken to GnuCash. This is in connection with ditching Windows for Ubuntu Linux. No Windows, no Quicken...
The software helps me track my multiple multifamily investments and do my taxes.
Some of my tenants pay me in cash. The bank charges a hefty fee when I deposit cash into my business checking. So I don't do that. I deposit the cash into my *personal* checking instead. To make it right for taxes, I book the money in, and then book it out as owner profit.
This worked well in Quicken. So far, however, I don't have a handle on how to do it in GC.
I have income accounts for all the possible sources of income - such as "rents". And a single account for "Owner Profit". To make the owner profit work, I put in a transaction that increases Owner Profit and decreases "rents". That doesn't seem quite right.
When somebody pays me by check, I subtract it from "rents" and add it to "main business checking". That seems to work, but shouldn't there be an event where the money appears magically in "rents", and then gets transferred?
Last year, I did all the accounting both in Quicken and in GC, and gave the Quicken one to my CPA. But this year, there is no Quicken, and the GC version has got to be right.
New to the program and trying to learn a less awkward way to enter in a split transaction with multiple entries to an asset bank account where I don't know the total and want gnu cash to auto tally, without having to delete an auto-tally in the deposit field with each new line. I found this thread and agree with the poster that it's a bit awkward but it's the same and only way i've found thus far: https://lists.gnucash.org/pipermail/gnucash-user/2011-March/038959.html
I understand that split transactions are the way to do this but it seems odd that I have to keep deleting an auto tally.