[GNC] How to count transactions for time period

[Patrick James]

Stan,

I suggested COUNTA(UNIQUE(RANGE OF UNIQUE TRANSACTION IDS))

The range is in column B with a header, so B2:BXXX, where XXX is the row of the last transaction ID.

COUNTA to include more than numbers and dates (i.e. capture the transactions IDs).

UNIQUE to only count the transactions, as the splits for a single transaction all have the same transaction ID.

The range must not include any blank lines or the count will overstated by one--an extra blank line.

In any event, there are various ways, and others have suggested using SQL, which would work, but might not be the best solution for the person seeking the information.


I also apologize for not "replying to all" in that last message.

> On 05/18/2026 11:41 AM PDT Stan Brown (using GC 4.14) <stan+gc at fastmail.fm> wrote:
> 
>  
> 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