[GNC] Automatic Text in Scheduled Transaction Memo Fields

[Patrick James]

Paul,

My personal strategy to accomplish what you desire is to use multi-split CSV imports. I use a variety of strategies when it comes to have to crafting the CSV file for import, but many people find the formulas in spreadsheets to be sufficient, including lookup tables if appropriate. For example, although it's possible to get "Jul" from a date field [=TEXT(A1, "mmm")], it's also possible to use lookup tables. Almost any spreadsheet will have sufficient text formulas to craft 'complex' notes and/or memos for GnuCash import. After the multi-split is crafted in the spreadsheet, export to CSV, use a preset in GnuCash's import module, and the process can be automated so that it's quick and easy.

I suggest multi-split CSV because I often import many transactions where the import accounts are not related.

> On 06/29/2026 9:34 AM PDT Paul Kroitor <paul at kroitor.ca> wrote:
> 
> My specific questions are related to a batch of about 10 transactions I 
> want to schedule of the first of every month. I want all the memo 
> entries to have the three-character month abbreviation (eg. "Jul" for 
> the upcoming ones).
> 
> 3. Is there a better way to achieve this?
> 
> Thanks as always for all help,
> 
> Paul
>