[GNC] How to count transactions for time period
David T.
sunfish62 at yahoo.com
Mon May 18 12:31:22 EDT 2026
Personally, I would save the file in sqlite format and use a database platform to see how many rows are present in the appropriate table. But I'm an old database guy.
David T.
On May 18, 2026 9:44:21 PM GMT+05:30, Patrick James via gnucash-user <gnucash-user at gnucash.org> 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].
>
>Since there is one line for each split, count the unique transaction IDs for the transaction count.
>
>> On 05/18/2026 8:55 AM PDT Stan Brown (using GC 4.14) <stan+gc at fastmail.fm> 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.
>>
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>>
>_______________________________________________
>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