[GNC] Household monthly reporting

[Tom Route-36]

Hi again Ed,

I'm replying to my own email here to apologize.  I just realized that my 
example here doesn't really address the issue of lack of detail in the 
Cash Flow report itself.  So please ignore this explanation.  Hopefully 
someone else has better a better idea.

Tom



On 9/20/2025 2:56 AM, Tom Route-36 wrote:
> 
> Hi Ed,
> 
> 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.
> 
> Tom
> 
> 
> 
> On 9/19/2025 11:23 PM, 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?
>>
>> Thanks,
>>
>> Ed Greenberg
>>
>> _______________________________________________
>> 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.
>