[GNC] How to count transactions for time period

Patrick James patrickjames14 at comcast.net
Mon May 18 11:55:35 EDT 2026


There are many ways to do this. I am going to provide the path that I would take.

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"

Step 3: Count the unique transaction IDs. A spreadsheet formula that would work is something like =COUNTA(UNIQUE(B2:BXXX)) where XXX is the end of the range. If you go over on the range, meaning XXX is too large, then you'll pick up a blank line that is unique.

> On 05/18/2026 8:35 AM PDT gnucash_2022 at michaelaltfield.net wrote:
> 
>  
> How can I get the total number of transactions in a GNU Cash DB for a given time period?
> 
> I need to determine the total number of transaction entries in my GNU Cash DB for the last accounting year. I don't want to manually count them.
> 
> I couldn't find a built-in GNU Cash report that includes the count of the transactions for the selected accounts for the selected time range.
> 
> Is there some report (or python script) that I can use to sum the total number of transactions for all accounts for a given time range in GNU Cash?
> _______________________________________________
> 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.


More information about the gnucash-user mailing list