Hi, welcome to beancount!
Yes, it is a great tool! This query shall work for you: select payee, narration, leaf(account) as Category, position where 'Assets:Banking:Checking:BofA' in other_accounts Result: payee ! narration ! category ! position (USD) ------------------------------------------------------------------ Joe Smith Venmo for lunch Restaurants 10 Chase Bank Mortgage Payment 123-Main-St 1200 Chase Bank Mortgage Payment Mortgage-Interest 800 Chase Bank Mortgage Payment Mortgage-Interest 800 You can check it here: https://colab.research.google.com/drive/1BzdrUmWAd_0oxPqZ1G_rl3hD6RLWsVNH?usp=sharing P.S. please let us now now you got on with Red's importer framework, i still haven't got a time to get my head around it On Monday, November 17, 2025 at 3:23:17 PM UTC+1 [email protected] wrote: > Hi all - I'm new to Beancount. I did a one-time translation from Quicken > for Mac to Beancount with all transactions since 2024. I'm slowly > onboarding to some of Red's features like the importer framework and a few > plugins (shoutout effective_date and zerosum). I'm loving this tool so far! > > Coming from a Quicken for Mac background, I'm used to single-entry > accounting and viewing registers in respect to the physical account. This > might be an issue of not having found the correct docs or thread on this > Group yet, but I'm having trouble creating reports using BQL that recreate > the register from Quicken. > > My specific use case is CSV exports for import into Actual Budget (a great > FOSS envelope style budgeting tool), where each CSV needs to be aligned to > the physical account it came from, e.g. "Tim's Chase Card". > > This is my attempt to explain the feature I'm looking for: > *When generating reports, I want the ability to create a table of every > posting from every transaction which contains the account I care about, but > I want to exclude the specific posting of the account itself. For example:* > 2025-11-15 * "Joe Smith" "Venmo for lunch" > Assets:Banking:Checking:BofA -10.00 USD > Expenses:Dining:Restaurants > > 2025-11-15 * "Chase Bank" "Mortgage Payment" > Assets:Banking:Checking:BofA -2000.00 USD > Liabilities:Loans:Mortgage:123-Main-St 1200.00 USD > Expenses:House:Mortgage-Interest > *Should generate 3 lines like the following:* > Payee Narration Category Amount > --------------|---------------------|-----------------------|---------- > Joe Smith Venmo for lunch Restaurants 10.00 > Chase Bank Mortgage Payment Mortgage-Interest 800.00 > Chase Bank Mortgage Payment 123-Main-St 1200.00 > > I know I will probably need to massage the final data to correct > categories into their Actual Budget equivalents. > > This is the closest I've gotten to a query that would work, where I dump > that to CSV or a DataFrame, and remove any posting with the account for > which I'm interested. > JOURNAL FROM HAS_ACCOUNT('Assets:Banking:Checking:BofA') > > Am I on the right track? Is there a magic bullet here? > > Also, how can I get tags and links in that JOURNAL query? > > Thanks in advance! > Tim > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/beancount/3368197c-7861-4fc2-983a-0a07cee74b47n%40googlegroups.com.
