Hopefully someone has a better suggested approach! GROUP BY a2.account_type ,a4.name, a3.name, a2.nameĪnd here's the output. WHERE a2.name 'Property A' # get all the accounts associated with tx in Property A account (but not the actual Property A Bank duplicate entries.ĪND t.post_date BETWEEN CAST('' AS DATE) AND CAST('' AS DATE) LEFT JOIN gnucash.accounts a4 ON a4.guid = a3.parent_guid LEFT JOIN gnucash.accounts a3 ON a3.guid = a2.parent_guid INNER JOIN ansactions t ON t.guid=s2.tx_guid
INNER JOIN gnucash.accounts a2 ON a2.guid=s2.account_guid INNER JOIN gnucash.splits s2 ON x.tx_guid = s2.tx_guid INNER JOIN gnucash.splits AS s1 ON s1.account_guid = a1.guid SUM(ROUND(IF(a2.account_type='EXPENSE',- s2.value_num,ABS(s2.value_num))/s2.value_denom,2)) AS amt SELECT a2.account_type, a4.name, a3.name, a2.name,
Gnucash imbalance generator#
Hopefully someone will point me to a more elegant solution that uses the report generator built into GnuCash.
Gnucash imbalance code#
And modifying for a different rental property requires changing the code (I could pass parameters etc).Īgain, the main "issue" in my mind with GnuCash income/expense report is that there is no filter for which account (rental property) you want income/expenses for, unless you set up account tree so that each rental property has its own defined incomes and expenses (i.e. My main complaint is the output "report" is pretty ugly. Basically it reports the same info as the canned income/expense report, but limits it those income/expenses associated with a particular account (rental property, in my case). Here's a very basic MySQL query I put together that does what I want for income/expense report. It sounds like you're really looking for a way to have each transaction classified in some kind of two-axis system, but the way a general ledger works is that it'sĪ tree, so you need to pick just one "primary" axis to organize your accounts by. You can run the report, and when selecting accounts you have to select all the Gas accounts individually. You mention that you also sometimes want to run a report on "all gas expenses, regardless of property", and that's a bit more annoying to do. Now, when running transaction reports or income/expense reports, you can filter to the accounts (and subaccounts) of each property to get a report specific to that property. Money found in couch cushions of property B Money found in couch cushions of property A You probably want something like this (obviously I'm making up the specifics): It sounds like you primarily think of expenses as each being for a particular property, so I think you want to use that as the basis of your hierarchy.
The idea is that you keep track of where you get money from (the Income accounts), what you have as a result (the Asset accounts), and then track what you spent the money on (the Expense accounts). This gives you a large amount of flexibility to organize your account hierarchy the way you want, but also means that it sometimes can take a while to figure out what account hierarchy you want. It tracks money in accounts, and lets you make transactions to transfer money between the accounts, but it has no inherent concept of things like taxes. Gnucash is first and foremost just a general ledger system.
0 kommentar(er)
