[GNC] gnucash-user Digest, Vol 270, Issue 42

Mon Sep 29 08:23:53 EDT 2025

Hi.
Interesting thread.

The autocomplete is a wonderful thing and its ability to "learn" is 
excellent.

At financial year end, I journal every account to zero opposite a 
year-end account otherwise all the autocomplete items disappear (I believe)

Incidentally, Business.amazon.com have an extensive reporting system 
where I have uploaded the Gnucash categories into a mandatory pick list 
on amazon, that are recognized by Gnucash when imported.

Kindest Regards
Mike and Laura Brasler
WhatsApp +507 69797921 <https://wa.me/yourphonenumber>
On 28/09/2025 11:00, gnucash-user-request at gnucash.org wrote:
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
>
> 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
> 	gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
>
> 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<adrien.monteleone at lusfiber.net>
> To:gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Household monthly reporting
> Message-ID:<10b9fpv$6h3$1 at ciao.gmane.io>
> 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<adrien.monteleone at lusfiber.net>
> To:gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Household monthly reporting
> Message-ID:<10b9g05$kk0$1 at ciao.gmane.io>
> 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<adrien.monteleone at lusfiber.net>
> To:gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Household monthly reporting
> Message-ID:<10b9g68$mit$1 at ciao.gmane.io>
> 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<jralls at ceridwen.us>
> To: Ed Greenberg<edg at greenberg.org>
> Cc: GnuCash Users<gnucash-user at gnucash.org>
> Subject: Re: [GNC] Household monthly reporting
> Message-ID:<92D67213-DB66-4C8F-8407-A958F43B1B9A at ceridwen.us>
> Content-Type: text/plain;	charset=utf-8
>
>
>> On Sep 20, 2025, at 11:57?AM, Ed Greenberg<edg at greenberg.org> 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
> gnucash-user at gnucash.org
> 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
> *********************************************