Send gnucash-user mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."
Today's Topics:
1. Re: Household monthly reporting (Adrien Monteleone)
2. Re: Household monthly reporting (Adrien Monteleone)
3. Re: Household monthly reporting (Adrien Monteleone)
4. Re: Household monthly reporting (John Ralls)
----------------------------------------------------------------------
Message: 1
Date: Sat, 27 Sep 2025 15:00:54 -0500
From: Adrien Monteleone<[email protected]>
To:[email protected]
Subject: Re: [GNC] Household monthly reporting
Message-ID:<[email protected]>
Content-Type: text/plain; charset=UTF-8; format=flowed
I concur on this detail point.
Unless you retain physical receipts or scan them (important for most
thermal paper receipts as they deteriorate) you lose all record of line
item details if you don't record them in GnuCash.
I don't combine any line items when I enter receipts. Each one gets its
own split, including tax. (because that would be too difficult and time
wasting to try to pro-rate the tax amount to each line item, especially
if there are differing rates per item)
After 15+ years of using GnuCash, I have several times revised my
Account tree to better reflect how I'm tracking my money. I found out
the first time it was impossible to break up splits I had combined when
I didn't have enough detailed info to do so.
A simple example is that I don't combine 'groceries' all into one
bucket. I wanted to know what 'type' of groceries my money was going to,
so I separated 'prepackaged' and 'prepared' foods from 'raw
ingredients'. A report on that alone, might astonish some. Reducing or
cutting out the first two, shifting instead to 'raw' and cooking with
meal planning has not only drastically lowered my food expenses, but
improved my diet. (And yes, I separated 'alcohol' out too?eye opener!)
With auto-complete and auto-fill the tedious typing is quickly
eliminated so the perceived extra work, really doesn't manifest.
You may never need a certain detail, but if you do, you'll be glad it is
there. And if you record enough detail, you may find use for it at some
point.
Regards,
Adrien
On 9/20/25 3:56 AM, Tom Route-36 wrote:
When you enter transactions into your credit card account or checking
account are you ITEMIZING each transaction IN DETAIL?? For example, if I
have a credit card transaction for repairing a vehicle at a repair shop,
I will have MULTIPLE splits in the ONE transaction that I enter into my
credit card account.? And each of those splits will reference my
vehicle's Expenses:Auto:Repairs account.? One of the Repairs splits
might be the cost of replacing the washer pump. Another of the Repairs
splits might be for lubing the axles.? A third split might be for
replacing a drive belt.? All three of those splits are listed in that
one transaction in my credit card account.? But each of those three
splits are also now recorded against that Repairs account.
So if I go and look at my Expenses:Auto:Repairs account I'll see all
three splits there as well.? And if I want an itemized report of
everything I spent on my vehicle, I just go and print out a Cash Flow
report of my Expenses:Auto:Repairs account.? That will show every item
that I spent money on in detail.? The main point though is that you need
to record ALL that information in detail up front when you record that
single transaction in your credit card account.? Otherwise it won't be
there in detail when you go to look in your Repairs account later.
------------------------------
Message: 2
Date: Sat, 27 Sep 2025 15:04:11 -0500
From: Adrien Monteleone<[email protected]>
To:[email protected]
Subject: Re: [GNC] Household monthly reporting
Message-ID:<[email protected]>
Content-Type: text/plain; charset=UTF-8; format=flowed
Ed,
You can include more than one account in the Cash Flow report, perhaps
add your CreditCard account as well? (assuming you have detailed
transaction data)
I don't know if you can include the mortgage accounts or not, but
there's no harm in trying.
Another option might be the Transaction Report. It is highly
customizable. It may not end up in quite the form you want, but you can
include any accounts and filter according to just about any criteria. If
the final form isn't to your liking, export that result to a spreadsheet
and manipulate further from there. With a little effort, you can
probably set up a bit of automation to massage a future report to your
liking with a few clicks.
Regards,
Adrien
On 9/20/25 12:23 AM, Ed Greenberg wrote:
I'm trying to do a household monthly report. I've considered both the
income statement and the cash flow report. Here are my results:
Income statement: Very good report, but doesn't include the principal
and escrow portions of my mortgage payment. Only the interest. So the
P&L doesn't tell me if I'm overspending.
Cash flow report: I set this for my checking account. The cash flow in
and out shows what I spent out of my checking account, including
mortgage principal, interest and escrow,? but much of my spending was on
a credit card. I pay the entire credit card balance, so it shows up as a
cash flow item, but there is no itemization. If I were carrying a
balance, I'd have more of a problem using this to manage my spending.
So what I want is a report of all my spending: credit card, checking
account, one liability debit (mortgage loan) and one asset debit
(mortgage escrow.) This would show me whether I had overspent my income
or not, and by how much.
Is this even possible?
------------------------------
Message: 3
Date: Sat, 27 Sep 2025 15:07:26 -0500
From: Adrien Monteleone<[email protected]>
To:[email protected]
Subject: Re: [GNC] Household monthly reporting
Message-ID:<[email protected]>
Content-Type: text/plain; charset=UTF-8; format=flowed
Sounds like you found a bug.
(and please disregard my recent reply, it seems you have it sorted out)
Regards,
Adrien
On 9/20/25 1:57 PM, Ed Greenberg wrote:
The only nit is that, at the top, we find this:
???? Cash Flow - 08/01/2025 to 08/31/2025
Selected Accounts
?* 200-Liabilities:Credit Card
?? <gnc-register:acct-guid=2a67c0ea65224d0599e16e34d4f00dd5#>and
?? selected subaccounts
I don't see the checking account or Venmo, even though I can tell that
it's treating them as selected. This was confusing. I kept going back to
see if they were selected, and they are.
------------------------------
Message: 4
Date: Sat, 27 Sep 2025 14:23:42 -0700
From: John Ralls<[email protected]>
To: Ed Greenberg<[email protected]>
Cc: GnuCash Users<[email protected]>
Subject: Re: [GNC] Household monthly reporting
Message-ID:<[email protected]>
Content-Type: text/plain; charset=utf-8
On Sep 20, 2025, at 11:57?AM, Ed Greenberg<[email protected]> wrote:
I don't see the checking account or Venmo, even though I can tell that it's
treating them as selected. This was confusing. I kept going back to see if they
were selected, and they are.
Check the account depth setting on the accounts tab of report options. It
defaults to 2, which will only show one below top-level accounts.
Regards,
John Ralls
------------------------------
Subject: Digest Footer
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
------------------------------
End of gnucash-user Digest, Vol 270, Issue 42
*********************************************
