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/9b90c718-7e96-49b1-8035-546726b1e560n%40googlegroups.com.
