[GNC] How to count transactions for time period

[Stan Brown (using GC 4.14)]

Re-sending to get it to the list.

On 2026-05-18 10:58, Patrick James wrote:
> Stan,
> 
> The wording must have changed sometime between your version and v5.15. I went through your suggested process, which exported splits, and then I went back and read the screen. I am using GnuCash v5.15.
> 
> In v5.15 the wording is the same and the results are the same for both Register export and Transaction export with the same one account and dates the same. I didn't compare character-by-character, but both exports had the same number of rows with the same unique transaction IDs.

Thanks for checking, Patrick.

In my naivete :-) I failed to consider the possibility that the wizard
text (screenshot provided in my previous) might not describe correctly
what it does, so I didn't try it. When I did try it, just now, I found
one split per row. The first split of each transaction contains
transaction-level information in the first seven columns, and the other
splits of a transaction have blanks in those columns.

That sounds consistent with what you described, so I'm guessing that the
export used to work as described in my screenshot, and then sometime
before 4.14 the export was changed to the present format but the text of
the wizard wasn't updated till later.

It would still be possible with this format to find the number of
transactions by counting the number of cells in the date column that
contain numerics: =COUNT(A1:A1242) in Excel, and presumably something
similar in other spreadsheet programs. Alternatively, if I just
highlight that column Excel displays a numerical count in the status line.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com


>> On 05/18/2026 10:14 AM PDT Stan Brown (using GC 4.14) <stan+gc at fastmail.fm> wrote:
>>
>>  
>>>> On 05/18/2026 8:55 AM PDT Stan Brown (using GC 4.14)  wrote:
>>>>
>>>> File » Export » Export Transactions to CSV
>>>>
>>>> The wizard that opens says there will be one row for each 
>>>> transaction, so all you have to do is open the exported file and
>>>> look at the number of the last row used.>>
>>>> It also says "While a transaction may have splits in several of the
>>>> selected accounts it will only be exported once" so you don't have to
>>>> worry about double counting.
>>
>> On 2026-05-18 08:55, Patrick James via gnucash-user wrote:
>>>> Step 1: I would filter the register to the dates that I want. "Filter
>>>> by" is found under the view menu.
>>>> Step 2: Export the register. This is found under "File -> Export ->
>>>> Export Active Register to CSV"
>>
>> On 2026-05-18 09:14, Patrick James via gnucash-user wrote:
>>> The wording is: "There will be multiple rows for each transaction
>>> with each row representing one split.">
>>> The only time a "transaction" appears on a single line, and this
>>> term "transaction" is a bit of a challenge here, is when the
>>> "transaction" is only a memo entry [zero value and only one
>>> account, and thus the difficulty with the word "transaction," but
>>> the memo entries do export].
>> Different menu items. Patrick is talking about "Export Active Register
>> to CSV"; I'm talking about "Export Transactions to CSV". The attached
>> screenshot confirms what I said; I've outlined the relevant text in
>> blue. (I'm using GC 4.14, so I suppose it's possible the working of
>> "Export Transactions to CSV" was changed for 5.x, but I'd be surprised.)
>>
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com