Re: Import from email notifications

[Timothy Jesionowski]

So the thing about beancount is that it's just python. It sounds like
you're using a library to parse QIF files, but anything you can parse into
python can be fed into an importer. So just...figure out how to extract the
relevant information from those emails and use whatever importer you think
is the most similar as a starting point.

For example, when I was writing an importer for my credit card statements this
code
<https://github.com/beancount/beancount/blob/v2/examples/ingest/office/importers/utrade/utrade_csv.py>
as a starting point. And the actual parsing is just python's standard csv
library.

As for your specific case with the emails, that looks like some bespoke
string parsing so I'd just throw regexes at the emails until you have the
substrings you want.

That's what I did in my case, and it's what I'd probably do in your case.
But if you want very fast ledger updates
<https://reds-rants.netlify.app/personal-finance/the-five-minute-ledger-update/>,
then you should look into using ofx
<https://reds-rants.netlify.app/personal-finance/a-word-about-input-formats-use-ofx-when-you-can/>
for your imports. It's on my wishlist for my own workflow, I just haven't
gotten around to it yet.

Sincerely,
Timothy Jesionowski


On Sat, Jan 6, 2024 at 2:02 PM 'Patrick Ruckstuhl' via Beancount <
beancount@googlegroups.com> wrote:

> Hi,
>
> not exactly the same case, but related.
>
>
> I created an importer which wrapps around other importers for
> attachments,
> https://tariochbctools.readthedocs.io/en/latest/importers.html#mail-adapter
>
> Maybe you can use some of it as a base for your importer.
>
>
> Regards,
>
> Patrick
>
>
> On 06.01.2024 19:57, 'Aaron Axvig' via Beancount wrote:
> > Hello, new Beancount user of a few weeks here.  I'm cutting over from
> > Quicken as of the first of the year.  The import was a lot of work but
> > I have fiddled my way to a beautiful 61,000 line file of converted
> > data.  Some fixing of QIF parsers and converters, and lots of fixing
> > my old data.  Quicken allows some real garbage!
> >
> > Anyways, as I get ready to do my first import of transactions directly
> > into Beancount, it occurs to me that I get an email of every
> > transaction that occurs on my credit cards.  With some email rules and
> > cron jobs this could potentially keep my credit card accounts
> > perpetually up to date on at least a daily basis if not better.  And
> > it would be verified on a monthly basis with ending balances, etc.
> >
> > Has anyone put some thought into this technique?  Any roadblocks? Are
> > any parts of such a processing flow already built?
> >
> > Some sample data from emails is below.  I think account, amount,
> > merchant, and date is all one needs?
> >
> > Example 1:
> >
> > You made a $5.36 transaction
> > Account Visa (...1234)
> > Date Jan 1, 2024 at 12:00 PM ET
> > Merchant GOOGLE *SomeApp
> > Amount $5.36
> >
> > Example 2:
> >
> > Amount: $16.07
> > Card Ending In 4321
> > Merchant ETSY, INC. 718-8557955 US
> > Date 01/02/2024
> > Time 10:19 AM E
> >
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/f56658f7-92e0-4d2f-8646-a28e6117424a%40tario.org
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWTd1Y0M-%3D-7R7OPJN%3DRVtCRu5uYRtHzcAUX0Jtwkcc6-g%40mail.gmail.com.

Re: Automatically flagging expenses of interest

[Timothy Jesionowski]

Maybe take a page from fraud detection
<https://towardsdatascience.com/anomaly-fraud-detection-a-quick-overview-28641ec49ec1>
and try to annotate each transaction with the hour of the day, day of the
week, day of the month, and accumulated transaction volume/value when the
transaction occurred. Even throw in a biweekly time period if you're
feeling fancy? The best thing would be to include the location if you have
it, but I don't think you do.


Sincerely,
Timothy Jesionowski


On Wed, Jan 24, 2024 at 4:34 PM Red S  wrote:

> Very interesting, thank you all. I wonder if a single user's journal would
> suffice for a learning dataset in this case. For me, expenses across
> categories of interest are those have been stable for years. Plus, I’m
> willing to deal with false positives (but preferably not false negatives).
>
> There is a kind of machine learning problem called outlier detection. I
> think sciki-learn library is a good starting point
>
> Excellent, thank you for the helpful pointers! A quick search brought up
> these, which I’ve noted down to look into when I have time(TM):
> https://scikit-learn.org/stable/modules/outlier_detection.html
>
> https://scikit-learn.org/stable/auto_examples/neighbors/plot_lof_outlier_detection.html
> ​
>
>
> On Wednesday, January 24, 2024 at 10:09:54 AM UTC-8 erical...@gmail.com
> wrote:
>
> This would probably be more useful if users can provide their own examples
> of abnormal and normal expenses.  In that case, the model itself is
> probably not very difficult; I imagine a variety of off the shelf toolkits
> would work.  To me, the harder part seems like making the workflow smooth
> and robust -- deciding how users would flag outliers, run the classifier,
> correct misclassifications, cause retraining to happen, etc.
>
> On Wed, Jan 24, 2024 at 10:05 AM Yichu Zhou  wrote:
>
> There is a kind of machine learning problem called outlier detection. I
> think sciki-learn library is a good starting point if we want to use ML
> techniques. But in our case, I feel the definition of “abnormal” varies on
> different personal situations. It might be tricky to formulate the problem
> properly.
>
> On Tue, Jan 23, 2024 at 21:24 Red S  wrote:
>
> Definitely! That's what I had in mind. Would you or others on this list
> have experience in how to frame the problem from a deep learning
> classification problem, what tools/libraries to use, and such? Pointers
> appreciated.
>
> On Tuesday, January 23, 2024 at 8:08:31 AM UTC-8 char...@gmail.com wrote:
>
> Sounds like a good opportunity for deep learning classification problem.
>
> On Friday, January 19, 2024 at 11:45:35 AM UTC+1 Red S wrote:
>
> I'm curious, has anyone setup Beancount scripts or reports to flag
> expenses that might need further attention? The situation that made me
> think about this is a quarterly bill that doubled multiple times after
> years of being stable, which is an obvious red flag.
>
> Unlike in the past, virtually of my Beancount interactions are highly
> automated, which combined with the fact that time is at a premium these
> days, causes me to miss details like this.
>
> In this particular case, a rule to flag expenses that deviate from their
> norm over a certain time period (monthly, annually) might be simple to
> write, but I was wondering for a more general, perhaps fancier solution
> that would learn to distinguish what's normal and call attention to what's
> not, as rules based solutions tend to be incomplete and require constant
> fiddling.
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/d1cffa4f-4c32-484c-b4f8-c6d4cbf748cen%40googlegroups.com
> <https://groups.google.com/d/msgid/beancount/d1cffa4f-4c32-484c-b4f8-c6d4cbf748cen%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRStSTD1gq319FO0RfNoR4enS6SLacBHWj7E%2BKmDtkZbQ%40mail.gmail.com.

Re: T-bills through Treasury Direct - How to Record?

[Timothy Jesionowski]

Usual solution for that is to use different income accounts.

On Wed, Feb 21, 2024, 12:29 PM CDT  wrote:

> Another wrinkle in this puzzle...
>
> My understanding is that t-bills are not taxed as capital gains but as
> interest income on 1099-INT.
> Also, they are NOT taxed at the state level only at the Federal level.
>
> So I'm wondering how that could be recorded in such a way as to separate
> the different types of interest received throughout the year.
>
> On Tuesday, February 20, 2024 at 11:41:45 AM UTC-5 mtb...@gmail.com wrote:
>
>> In your example, why wouldn't you expire the position at $1000 instead?
>>
>> You are holding Bills in USD commodity, but that doesn't quite match what
>> they are. Those Bills have USD values that can fluctuate. You don't have to
>> hold them to maturity either. You could trade in and out of those, so I
>> think it's better if they are their own commodity.
>>
>> You could lump them all into one commodity if you prefer to simplify your
>> assets.
>> For ex.
>> 2022-05-01 commodity BILLS
>> 2022-05-01 open Assets:Brokers:Etrade:B91282CBA8 BILLS
>> 2022-05-01 open Income:Interest:Etrade:B91282CBA8 USD
>> 2022-05-01 open Income:Capital-Gains:Etrade:B91282CBA8 USD
>>
>> 2022-12-02 * "buystock" "[B91282CBA8] US Treasury"
>> Assets:Brokers:Etrade:B91282CBA8 1000 BILLS {95.55127 USD}
>> Assets:Brokers:Etrade:USD -95551.27 USD
>>
>> 2022-12-15 * "INT - UNITED STATES TREASURY NOTE - REG INT ON 10 BND" 
>> "[B91282CBA8]
>> "
>> Assets:Brokers:Etrade:USD 62.5 USD
>> Income:Interest:Etrade:B91282CBA8 -62.5 USD
>>
>> 2023-12-15 * "DEPOSIT - US TSY NOTE 012523DE15 REDEMPTION OF MATURED
>> BOND"
>> Assets:Brokers:Etrade:Cash 10 USD
>> Assets:Brokers:Etrade:B91282CBA8 -1000 BILLS {95.55127 USD} @ 100 USD
>> Income:Capital-Gains:Etrade:B91282CBA8
>>
>>
>> On Tuesday, February 20, 2024 at 10:17:51 AM UTC-5 CDT wrote:
>>
>>> What about this as a format?...
>>>
>>> 2024-01-16 * "Treasury Direct" "Security Issued"
>>>   interestrate: "5.390%"
>>>   cusip: "912797JD0"
>>>   Assets:US:TreasuryDirect:T-bills 995.89 USD
>>>   Assets:US:TreasuryDirect:CofI -995.89 USD
>>>
>>> 2024-02-13 * "Treasury Direct" "Interest Payment"
>>>   cusip: "912797JD0"
>>>   Assets:US:TreasuryDirect:CofI 4.11 USD
>>>   Income:US:TreasuryDirect:Interest -4.11 USD
>>>
>>> Only issue is that the date on the interest is forwarded to the future
>>> because that 4.11 isn't mine until that date.
>>>
>>> Is there any way to make all of this in one transaction?   Also how can
>>> I have a date that might be in the future not register when I pull reports?
>>>
>>> Also, I have it reinvested each month so how would you close the one
>>> transaction and create a new one and let the old one go?
>>>
>>>
>>>
>>> On Tuesday, February 20, 2024 at 9:26:23 AM UTC-5 mtb...@gmail.com
>>> wrote:
>>>
 I treat these just like stocks, this is an example. I have to prepend
 "B" to the cusip number for these.

 2022-05-01 commodity B91282CBA8
 2022-05-01 open Assets:Brokers:Etrade:B91282CBA8 B91282CBA8
 2022-05-01 open Income:Interest:Etrade:B91282CBA8 USD
 2022-05-01 open Income:Capital-Gains:Etrade:B91282CBA8 USD

 2022-12-02 * "buystock" "[B91282CBA8] US Treasury"
 Assets:Brokers:Etrade:B91282CBA8 1000 B91282CBA8 {95.55127 USD}
 Assets:Brokers:Etrade:USD -95551.27 USD

 2022-12-15 * "INT - UNITED STATES TREASURY NOTE - REG INT ON 10
 BND" "[B91282CBA8] "
 Assets:Brokers:Etrade:USD 62.5 USD
 Income:Interest:Etrade:B91282CBA8 -62.5 USD

 2023-12-15 * "DEPOSIT - US TSY NOTE 012523DE15 REDEMPTION OF MATURED
 BOND"
 Assets:Brokers:Etrade:Cash 10 USD
 Assets:Brokers:Etrade:B91282CBA8 -1000 B91282CBA8 {95.55127 USD} @ 100
 USD
 Income:Capital-Gains:Etrade:B91282CBA8


 On Monday, February 19, 2024 at 8:56:10 AM UTC-5 bl...@furius.ca wrote:

> I have a bunch of these now too, I haven't converted to Beancount yet,
> but I think it'll be straightforward.
> I think there is a choice to make about whether you want to
> - just account for the cash flows (which should be really easy, book
> as a new commodity with a price that begins at what you paid and ends at
> the face value, with transactions for coupons in between)  or
> - if you also want to be precise and account for the accrued interest
> and discounted value portions separately on acquisition.
> Anyhow, I'll try to post one of these here or to a doc as an example
> once I do mine.
>
>
>
> On Mon, Feb 19, 2024 at 8:12 AM CDT  wrote:
>
>> What is the best way to post entries for t-bills?
>>
>> When you purchase a 30 day t-bill on Treasury Direct, you purchase at
>> a discount, so if it's $1100 face value bill, and the interest rate is
>> 5.4%, you get a 5.4% ($4.53) discount and only pay $1,095.47.
>>
>> In 30 days the face value is $1100.
>>
>> So how is t

Re: New User: Starting Debt

[Timothy Jesionowski]

https://beancount.github.io/docs/the_double_entry_counting_method.html#equity

If you're interested, I recommend reading the whole document. Martin wrote
a very clear explanation of the fundamentals behind accounting.

On Thu, Mar 28, 2024, 2:42 PM Chary Chary  wrote:

> Hello!
>
> I am not an accountant, but as far as I understand, Equity is exactly the
> the right account for this.
>
> Whenever I myself have a question like this it helps me think and google
> assuming that I am running an accounting for a small business.
>
> In this case Equity is everything which owners invest in the company or
> draw from it.
>
> What you are doing when initiating  "Opening Balance"  is equivalent to
> closing old company and transferring all assets as well as liabilities to a
> new company, and this has to go through Equity as far as I understand.
>
> It is definitely not *Income *and *Expenses*
> On Thursday, March 28, 2024 at 5:22:06 PM UTC+1 dotros...@gmail.com wrote:
>
>> Good morning all!
>>
>> How do I input the debt I already have when starting to use beancount?
>>
>> My entry looks like:
>>
>> ```
>> 2024-03-28 * "BofA:Credit" "Opening Balance"
>>   Liabilities:BofA:Credit  -113.44 USD
>>   Equity:Opening-Balances   113.44 USD
>> ```
>> But I'm thinking that equity is maybe not the right place for this, or
>> maybe there's something else that I'm doing wrong! I would love some
>> direction!
>>
>> Thank you! :)
>>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/04b2bd07-b8fd-4392-a613-bb8399d3fe5fn%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWTV4tAicKi_jWAJUUeoanqdPAHgkMw%2Bt8nN%2BTFP7-WwBg%40mail.gmail.com.

Re: Viewing transactions with multiple currencies

[Timothy Jesionowski]

Maybe try:
Assets:Points -400 USD @@ 4 POINT

I'm not sure what Fava will render this as, but if you care about the total
cost in points more than the exchange rate then this is clearer in your
ledger.


Sincerely,
Timothy Jesionowski


On Sat, Apr 6, 2024 at 10:34 AM Ken Mankoff  wrote:

> Hello,
>
> I'd like to be able to see (in Fava) the total expenses (USD only) vs the
> total cost (USD, POINT, MILE) of a vacation I took, where some of the
> expenses were paid with points and miles.
>
> How should I book these transactions?
>
> For this transaction,
>
> 2024-01-01 price POINT 0.01 USD
> 2024-01-19 * "Hotel"
> Expenses:Travel:Lodging
> Liabilities:CC   -68.30 USD
> Assets:Points -4 POINT
>
> I've tried
>
> 1)Assets:Points -4 POINT
> 2)Assets:Points -4 POINT @ 0.01 USD
> 3)Assets:Points -4 POINT {0.01 USD}
>
> (2) and (3) always show up as USD, even if I select "At cost" or "Units"
> in Fava
>
> (1) does what I want... but relies on the 'global' POINT -> USD
> conversion. I'm wondering if there is an explicit conversion method like
> (2) or (3) though, because if I have several point accounts, and am
> regularly spending points at different values with different merchants, I'd
> prefer to track conversion per-transaction than update a global value. The
> global value doesn't work if I have two transactions in the same day with
> different conversions.
>
> Thanks,
>
>-k.
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/9495bfe9-a234-40ba-a4d1-77cb6479c485n%40googlegroups.com
> <https://groups.google.com/d/msgid/beancount/9495bfe9-a234-40ba-a4d1-77cb6479c485n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWQDKxhWQEOrccB9JoS4EPUCEm3bMbfaBP2kOCxJnoX_rg%40mail.gmail.com.

Re: Loving beangulp

[Timothy Jesionowski]

So now I'm wondering, since I've got a handful of purely custom importers
and a whole bunch of new importers to write next quarter, what does the
preponderance of the community use and why? I've heard of Red's importers,
beancount-import, and now beangulp. I know there's others. I haven't looked
at any of them personally yet because I'll need to package them for my
niche linux distro first (NixOS has *some downsides*).

Just looking at the github repos:

   1. beangulp was written by the same guy that wrote beancount itself (Hi
   Martin!) so I would expect it to integrate very well.
   2. beancount-import has a web UI, which seems like a very useful tool
   for verifying all this automation (especially for expense categorization,
   which I'm skeptical can *ever* be particularly reliable)
   3. red's importers has the most active community by far, and seems to
   focus heavily on a "run the script every time you look at the reports"
   workflow

I don't have unit tests on my importers, and I'm importing from CSV's
because I just got the simplest thing working. It's a KISS
<https://en.wikipedia.org/wiki/KISS_principle> setup that's exactly as
messy as it sounds. So given that I need to do an overhaul anyways, I'm
curious why, for example, James doesn't use red's scripts.

Is it just that a fully automated setup is harder to build? The peace of
mind from looking at the web UI to verify stuff?

Sincerely,
Timothy Jesionowski


On Mon, May 20, 2024 at 11:48 AM James Cook  wrote:

> On Mon, May 20, 2024 at 03:33:15AM GMT, Felipe Flores wrote:
> >Hey all, came here to express some gratitude for all the work you guys are
> >doing. I've been using beancount with fava to manage all my finances down
> >to the dollar for the last year or so, and I absolutely love it.
> >
> >Just wanted to add that I just migrated a bunch of importers to beangulp,
> >and it was way easier than I expected. Wonderful job there. The whole
> >reason I tried it out is that I spent a couple hours pulling my hair
> trying
> >to connect a debugger to my regression tests to no avail. With beangulp,
> >however, I just had to tell the debugger config to launch the file with
> >args (one of identify, generate, test, etc) and it worked just like that!
> >I'd even suggest you guys advertise this as a feature!
> >
> >If anyone stumbles upon this thread wondering whether they should move
> over
> >to beangulp: do it. It's an easy migration, and they've even added an
> >ImporterProtocol class that will make the transition even smoother.
> >
> >Thanks again!
>
> In case people haven't heard of it, I've been quite happy with
> beancount-import:
>
> https://github.com/jbms/beancount-import
>
> I have not tried beangulp, so I don't know how they compare. But I
> will mention beancount-import:
>
> - Has a web interface letting me quickly categorize transactions
>(i.e. choose which account my money went to).
>
> - Chooses the right account automatically most the time (maybe 95%),
>so mostly in this web interface I'm just pressing enter to confirm
>each transaction. To do this, it trains a model based on transactions
>already in my beancount ledger.
>
> - Adds metadata to imported transactions to keep track of where they
>came from (e.g. a transaction ID from an ofx file). This lets me
>(a) not worry about whether or not I've imported something (e.g. when
>I export from my bank, I just replace my existing ofx download with
>a new one covering a longer time range) and (b) see a list of
>postings I've entered manually that don't correspond to anything
>imported (a sign something went wrong). This is my favourite
>feature and I wonder if beangulp has something similar.
>
> - Also, I have been able to write my own custom importer including
>unit tests without much difficulty.
>
> --
> James
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/3ku5paorsc7iygd3zg7i433b7j46ecycgwgd3hvun757niycfy%40pnnt32hdaald
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRoARN%3DPm7ZcpANOfhmTkDtRWeDhL2qaA7DK4z-1AVopQ%40mail.gmail.com.

Re: Find invoices yet to be payed

[Timothy Jesionowski]

Generally accepted practice as I understand it is to have an
Assets:Receivables account and a Liabilities:Payables account. Essentially
this let's you date the logical transaction (when they agree to pay you /
when you send the invoice) to one date and put the money in a placeholder
account, then date the physical transaction to whatever day the money lands
in your actual bank account.

I don't know how you organize your invoices but you could put document
entries with links to the invoices themselves and then use ^ABC123 as a
link on the document entry and both transaction entries.

That's how I'd do it at least. Lets your receivables show up on a balance
statement, and also gives you a way to track each invoice separately.

On Fri, May 31, 2024, 10:48 AM Paul Walker  wrote:

> That's a fun query. This may you started (can use in fava's query).
> Include or remove "desc" to sort the non-zero (un-paid) invoices into view.
> select links, sum(position) as balance
> where account ~ "Liabilities:Invoices"
> group by links
> order by balance desc
>
> You might also use transaction flags. This still requires editing old
> transactions, but "!" is intended for use with incomplete transactions
> .
> Other characters can be used as well, say "%". Search these out with fava
> filter  *flag:"%"*
> 2024-05-01 % "Invoice"
>   Liabilities:Invoices
>   Expenses:Expense  123 USD
>
> Paul
>
> On Friday, May 31, 2024 at 9:52:07 AM UTC-4 ga...@realify.com wrote:
>
> I'm not sure if this is expressible in BQL (I'm not at my computer right
> now to try this out), but conceptually you could write a query that sums up
> the amount of each posting from your "Accounts Receivable" account, grouped
> by tag. Then filters out tags that don't match your invoice tag pattern,
> and then filters out groups that have a zero sum.
>
> If this isn't expressible in BQL, you could use beancount's Python API to
> do this in Python with probably only a few lines of code.
>
> Gary
>
>
> On Friday, May 31, 2024 at 3:07:34 PM UTC+2 Maurice de Laat wrote:
>
> Hello all!
>
> First message, let me start by thanking for such a wonderful piece of
> software!
>
> Currently seeking my way through beancount and fava and wondering what
> would be a good way to find invoices that have yet to be payed.
>
> I could tag an incoming or outgoing invoice with p.e. "^tobepayed", and
> remove that tag when the invoice is being payed, but that would mean that I
> would have to change a previous transaction's tag which seems as not the
> most practical thing to do.
>
> Currently I do have an unique tag for each invoice which is being used
> when the invoice is received as well as when the invoice is being payed. It
> would be great if I could use these tags to find the invoices yet to be
> payed.
>
> Any thoughts?
> Thank you!
> Maurice
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/f973f028-a4fe-47e7-95d8-7e37acee3f6an%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWQp_5HK5z3bkOBuZKvNcH8%2B1%2BXKuXWqU5b63b9hi5vmTg%40mail.gmail.com.

Re: Find invoices yet to be payed

[Timothy Jesionowski]

Meant to add: ABC123 is just whatever invoice number you already have on
file. Could use ^Invoice-123 or such.

On Fri, May 31, 2024, 1:00 PM Timothy Jesionowski <
timothy.n.jesionow...@gmail.com> wrote:

> Generally accepted practice as I understand it is to have an
> Assets:Receivables account and a Liabilities:Payables account. Essentially
> this let's you date the logical transaction (when they agree to pay you /
> when you send the invoice) to one date and put the money in a placeholder
> account, then date the physical transaction to whatever day the money lands
> in your actual bank account.
>
> I don't know how you organize your invoices but you could put document
> entries with links to the invoices themselves and then use ^ABC123 as a
> link on the document entry and both transaction entries.
>
> That's how I'd do it at least. Lets your receivables show up on a balance
> statement, and also gives you a way to track each invoice separately.
>
> On Fri, May 31, 2024, 10:48 AM Paul Walker  wrote:
>
>> That's a fun query. This may you started (can use in fava's query).
>> Include or remove "desc" to sort the non-zero (un-paid) invoices into view.
>> select links, sum(position) as balance
>> where account ~ "Liabilities:Invoices"
>> group by links
>> order by balance desc
>>
>> You might also use transaction flags. This still requires editing old
>> transactions, but "!" is intended for use with incomplete transactions
>> <https://beancount.github.io/docs/beancount_language_syntax.html#transactions>.
>> Other characters can be used as well, say "%". Search these out with fava
>> filter  *flag:"%"*
>> 2024-05-01 % "Invoice"
>>   Liabilities:Invoices
>>   Expenses:Expense  123 USD
>>
>> Paul
>>
>> On Friday, May 31, 2024 at 9:52:07 AM UTC-4 ga...@realify.com wrote:
>>
>> I'm not sure if this is expressible in BQL (I'm not at my computer right
>> now to try this out), but conceptually you could write a query that sums up
>> the amount of each posting from your "Accounts Receivable" account, grouped
>> by tag. Then filters out tags that don't match your invoice tag pattern,
>> and then filters out groups that have a zero sum.
>>
>> If this isn't expressible in BQL, you could use beancount's Python API to
>> do this in Python with probably only a few lines of code.
>>
>> Gary
>>
>>
>> On Friday, May 31, 2024 at 3:07:34 PM UTC+2 Maurice de Laat wrote:
>>
>> Hello all!
>>
>> First message, let me start by thanking for such a wonderful piece of
>> software!
>>
>> Currently seeking my way through beancount and fava and wondering what
>> would be a good way to find invoices that have yet to be payed.
>>
>> I could tag an incoming or outgoing invoice with p.e. "^tobepayed", and
>> remove that tag when the invoice is being payed, but that would mean that I
>> would have to change a previous transaction's tag which seems as not the
>> most practical thing to do.
>>
>> Currently I do have an unique tag for each invoice which is being used
>> when the invoice is received as well as when the invoice is being payed. It
>> would be great if I could use these tags to find the invoices yet to be
>> payed.
>>
>> Any thoughts?
>> Thank you!
>> Maurice
>>
>> --
>> 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 beancount+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/beancount/f973f028-a4fe-47e7-95d8-7e37acee3f6an%40googlegroups.com
>> <https://groups.google.com/d/msgid/beancount/f973f028-a4fe-47e7-95d8-7e37acee3f6an%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWQMafEZmHXsuKewpq5ci0X-jLQ64T%3DK_b%3DsADUKc3W8SQ%40mail.gmail.com.

beancount-import matching across include directives

[Timothy Jesionowski]

I've been adjusting my workflow to use beancount-import's webUI for
reconciliation and expense categorization. One thing I'm noticing is that
it isn't always matching transactions I have in sub-ledgers that are
"include"ed. Try as I might, I can't find any documentation around this.

What should always happen for these old transactions is that it finds the
matching transaction in whichever beancount file and proposes a merged
transaction and an in-place edit to that file. This already works
*sometimes*, but often it does not and the suggestion is to place a
duplicate transaction in the default_output argument of
beancount_import.webserver.main which is incorrect.

Is there some metadata I should be providing to either the data source or
the webserver that would tell it to follow includes?


Sincerely,
Timothy Jesionowski

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWTAQ_nOGiEp%2B%3DLVRRYDD0pMZfA8yrZq27-oY4roXi0zdg%40mail.gmail.com.

Re: New Beancount tutorial: The Zen of Balance

[Timothy Jesionowski]

Overall I really like it as an introduction, especially for non-technical
friends and family. My one caveat is that the section on equity isn't
terribly clear English. I think it gets the point across, but...
"harder-to-understand" should be "hardest-to-understand", "could be equity"
should be "is equity", and the next sentence should end "equity is usually
the one that you want".

On Thu, Aug 1, 2024, 11:26 PM fin  wrote:

> Fang-Pen Lin wrote:
> > --=_Part_68196_206928381.1722561477308
> > Content-Type: multipart/alternative;
> >   boundary="=_Part_68197_73804885.1722561477308"
> >
> > --=_Part_68197_73804885.1722561477308
> > Content-Type: text/plain; charset="UTF-8"
> > Content-Transfer-Encoding: quoted-printable
>
>
>   hi,
>
>   for my own purposes i found this very helpful:
>
>
> https://martin.kleppmann.com/2011/03/07/accounting-for-computer-scientists.html
>
>   the reason that various accounts must be negative or
> positive is just because of the nature of double entry
> book keeping.  if Assets are positive then to balance
> the amounts coming in must be offset by a negative and
> amounts going out must be offset by a positive.
>
>   fin
>
>
> > Hi Beancount users,
> >
> > I have been learning and using Beancount for a few years, and I've
> read=20
> > many articles and documents introducing Beancount. However, sometimes,
> I=20
> > felt confused by some new concepts, and not all articles explained
> things=
> >=20
> > clearly. For example, I was initially confused about why income is=20
> > negative. After quite some effort, I have a certain level of confidence
> to=
> >=20
> > maintain my books with Beancount. I looked back and wondered if there
> was a=
> >=20
> > book teaching Beancount in a more approachable way. Therefore, I spent
> some=
> >=20
> > time thinking about how to explain Beancount and double-entry
> accounting=20
> > concepts more intuitively.
> >
> > Eventually, I came up with a diagram, which I call it pile-hole
> diagram.=20
> > Imagine all the money flowing, like digging a hole in the ground and=20
> > putting a pile of dirt on the side. Here's an example of how I
> explained=20
> > income:
> >
> > [image: Assets is usually positive because it's something you have.]
> >
> > I think I should be able to visualize all kinds of money movements with
> a=
> >=20
> > diagram like that. With the idea, I kick-started writing the book a
> few=20
> > days ago, and it's free. You can read it here:
> >
> > https://academy.beanhub.io
> >
> > It's still working in progress, and any feedback is welcomed =F0=9F=99=8C
> >
> > --=20
> > 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 e=
> > mail to beancount+unsubscr...@googlegroups.com.
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/=
> > beancount/00ad774a-2bbf-4f67-9563-2188e389c447n%40googlegroups.com.
> >
> > --=_Part_68197_73804885.1722561477308
> > Content-Type: text/html; charset="UTF-8"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi Beancount users,I have been learning and using Beancount
> for=
> >  a few years, and I've read many articles and documents introducing
> Beancou=
> > nt. However, sometimes, I felt confused by some new concepts, and not
> all a=
> > rticles explained things clearly. For example, I was initially confused
> abo=
> > ut why income is negative. After quite some effort, I have a certain
> level =
> > of confidence to maintain my books with Beancount. I looked back and
> wonder=
> > ed if there was a book teaching Beancount in a more approachable way.
> There=
> > fore, I spent some time thinking about how to explain Beancount and
> double-=
> > entry accounting concepts more intuitively.Eventually, I
> came u=
> > p with a diagram, which I call it pile-hole diagram. Imagine all the
> money =
> > flowing, like digging a hole in the ground and putting a pile of dirt on
> th=
> > e side. Here's an example of how I explained income: /><=
> > img src=3D"https://academy.beanhub.io/img/beancount/income-asset.svg";
> alt=
> >=3D"Assets is usually positive because it's something you have." /> /> > r />I think I should be able to visualize all kinds of money movements
> with=
> >  a diagram like that. With the idea, I kick-started writing the book a
> few =
> > days ago, and it's free. You can read it here: href=3D"https:=
> > //academy.beanhub.io">https://academy.beanhub.io />It's st=
> > ill working in progress, and any feedback is welcomed =F0=9F=99=8C /> > iv>
> >
> >
> >
> > -- 
> > You received this message because you are subscribed to the Google
> Groups &=
> > quot;Beancount" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an e=
> > mail to mailto:beancount+unsubscr...@googlegroups.com
> ">beancount=
> > +unsubscr...@googlegroups.com.
> > To view this discussion on the web visit

Re: OFX - not worth the time investment?

[Timothy Jesionowski]

I've seen write-ups of other people's setups that claim 40% availability
but so far Fidelity is the only service I could get it to work on. Amex
canned it in 2022 IIUC, and every other service I use did so long before
that.

On Sat, Sep 28, 2024, 5:40 PM Chris Jansen  wrote:

> I've been using beancount for about 2 years now, and in the last month
> I've started looking more closely at the External Contributions
> .
> I decided to try reds-importers, and pretty quickly discovered a few things:
>
>1. ofxhome.com is gone.
>2. ofx.chase.com doesn't work anymore ("Name or service not known")
>3. FDX is a new thing, and does not appear to be friendly to
>open-source accounting tools like beancount.
>
> For those that have used OFX for a long time - is it slowly going away?
> Are there alternatives that facilitate automatic downloads?
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/aad4ef72-a10e-451d-b64c-9d3937dca6cdn%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRo8h4jaDrwZWSO1CZvWceNbjZc9sm7OfNnw%2BvbV-MBdQ%40mail.gmail.com.

Re: Custom fields in options_map?

[Timothy Jesionowski]

A bit more to the point, I can understand wanting to have VUSD (Virtual
USD) income expenses just to express an opinion. Is that vaguely what
you're trying to do?

On Sat, Nov 23, 2024, 1:54 PM Timothy Jesionowski <
timothy.n.jesionow...@gmail.com> wrote:

> How are you quantifying time value? I can understand using a
> hypothetically inviolable unit of account like gold or CPI, but you're
> talking about accounting with an explicit discounting rate attached to
> things.
>
> Of course that's assuming you're trying to account for opportunity cost.
> If you're "merely" trying to get a more natural way to represent
> value-in-transit than the usual pairs of transactions on virtual
> Payables/Receivables accounts then I wonder what benefit you're expecting
> beyond what you get from links.
>
> On Sat, Nov 23, 2024, 1:47 PM 'James Edington Administrator' via Beancount
>  wrote:
>
>> I'm trying to make a plugin to enable temporal settlement, where
>> different legs of a transaction occur at different dates (to cover the
>> major use-cases of “money is in clearing, you lost time value”, “merchants
>> billed you very late, you gained time value”, etc.)
>>
>> It's going *very* well so far, except that I can't figure out how to
>> cause my plugin to ingest custom values for options_map; Beancount always
>> complains that my custom option is an “invalid option”. Does anyone know
>> how to declare those?
>>
>>
>> https://gist.github.com/98dedad9d856402f7688c47288e53eba/c40c7f4efd0b740012e12134e7bdf17cf95c29f9#file-temporal_settlement-py-L123
>>
>> --
>> 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 beancount+unsubscr...@googlegroups.com.
>> To view this discussion visit
>> https://groups.google.com/d/msgid/beancount/53649bb5-390d-4608-b8d2-30514478db03n%40googlegroups.com
>> <https://groups.google.com/d/msgid/beancount/53649bb5-390d-4608-b8d2-30514478db03n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWTgXS64Py8fyBeH-zejQKJBw6Pb7eYYv32w2s%2BENDf5yQ%40mail.gmail.com.

Re: Custom fields in options_map?

[Timothy Jesionowski]

How are you quantifying time value? I can understand using a hypothetically
inviolable unit of account like gold or CPI, but you're talking about
accounting with an explicit discounting rate attached to things.

Of course that's assuming you're trying to account for opportunity cost. If
you're "merely" trying to get a more natural way to represent
value-in-transit than the usual pairs of transactions on virtual
Payables/Receivables accounts then I wonder what benefit you're expecting
beyond what you get from links.

On Sat, Nov 23, 2024, 1:47 PM 'James Edington Administrator' via Beancount <
beancount@googlegroups.com> wrote:

> I'm trying to make a plugin to enable temporal settlement, where different
> legs of a transaction occur at different dates (to cover the major
> use-cases of “money is in clearing, you lost time value”, “merchants billed
> you very late, you gained time value”, etc.)
>
> It's going *very* well so far, except that I can't figure out how to
> cause my plugin to ingest custom values for options_map; Beancount always
> complains that my custom option is an “invalid option”. Does anyone know
> how to declare those?
>
>
> https://gist.github.com/98dedad9d856402f7688c47288e53eba/c40c7f4efd0b740012e12134e7bdf17cf95c29f9#file-temporal_settlement-py-L123
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/53649bb5-390d-4608-b8d2-30514478db03n%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWSjDYB0j8He-4t_thAzP%2Bd6wYhp7PWKA%2BffN1ajoqve8g%40mail.gmail.com.

Re: Employer Paid Benefits (Non-taxable vs taxable)

[Timothy Jesionowski]

What I do is have a separate currency like CUSD (Corporate-USD) for money
flows that are about me but aren't my money. Works just as well for travel
expenses.

Mostly this just makes the Income balances more immediately legible.

On Sun, Dec 8, 2024, 4:04 PM Gary Roach  wrote:

> Hi all,
>
> I'm working on importing my paycheck and I'm not sure how to handle
> employer paid benefits. I have 3 employer paid benefits: imputed life
> insurance (taxable), life insurance (non-taxable), and medical insurance
> (non-taxable).
>
> For the taxable imputed life insurance, I think it makes sense to have an
> income and an expense leg on the paycheck entry since this does count as
> taxable income for me and the expense was paid on my behalf.
>
> 2024-12-01 * "Hooli Paycheck"
>   Income:Hooli:Salary  -2000 USD
>   Assets:Bank-Account   1250 USD
>   ;; Employer Paid Benefits
>   Income:Hooli:Imp-Life  -50 USD
>   Expenses:Hooli:Imp-Life 50 USD
>   ;; Before Tax Deductions
>   Expenses:Pre-Tax:Medical50 USD
>   Expenses:Pre-Tax:Dental 50 USD
>   Assets:Pre-Tax:401K100 USD
>   Assets:Pre-Tax:HSA 100 USD
>   ;; Taxes
>   Expenses:Taxes:Income  250 USD
>   Expenses:Taxes:Medicare 50 USD
>   Expenses:Taxes:Social-Secuirty  50 USD
>;; After Tax Deductions
>   Assets:Post-Tax:ESPP   100 USD
>
> I believe the above entry is correct from a tax perspective. Income:Hooli
> represents Gross Income and Income:Hoolie - Expenses:Pre-Tax -
> Assets:Pre-Tax represents Taxable Gross Income.
>
> However, this doesn't include the remaining employer paid benefits for
> which I'm not liable for from a tax perspective. This has the problem of
> not representing the true compensation from the employer as well as
> underrepresenting the true cost of health insurance.
>
> My first thought was to add them in a similar way as the imputed life
> insurance benefit.
>
> 2024-12-01 * "Hooli Paycheck"
>   Income:Hooli:Salary  -2000 USD
>   Assets:Bank-Account   1250 USD
>   ;;Taxable Employer Paid Benefits
>   Income:Hooli:Imp-Life  -50 USD
>   Expenses:Hooli:Imp-Life 50 USD
>   ;;Non-Taxable Employer Paid Benifits
>   Income:Hoooli:Life -50 USD
>   Income:Hoooli:Medical -225 USD
>   Expenses:Pre-Tax:Hooli:Life 50 USD
>   Expenses:Pre-Tax:Hooli:Medical 225 USD
>   ;; Before Tax Deductions
>   Expenses:Pre-Tax:Medical50 USD
>   Expenses:Pre-Tax:Dental 50 USD
>   Assets:Pre-Tax:401K100 USD
>   Assets:Pre-Tax:HSA 100 USD
>   ;; Taxes
>   Expenses:Taxes:Income  250 USD
>   Expenses:Taxes:Medicare 50 USD
>   Expenses:Taxes:Social-Secuirty  50 USD
>;; After Tax Deductions
>   Assets:Post-Tax:ESPP   100 USD
>
> Income:Hoolie - Expenses:Pre-Tax - Assets:Pre-Tax still represents Taxable
> Gross Income, but the employer paid benefits are now counted towards my
> Gross Income. Which I guess it is, but my W-2 doesn't usually include that
> in Gross or Taxable Gross. I guess I could still calculate Gross with
> Income:Hoolie - Expenses:Pre-Tax:Hooli to remove the non-taxable employer
> paid benefits, but this seems a bit off to me. I'm curious what everyone
> else is doing here?
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/8e20a919-b660-429d-8f9a-9b8bf7024bf2n%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWS-pigWDEaL-pALcUZnTQ3fVQAyzxBbZ%2BqRO5svNZVgzA%40mail.gmail.com.

Re: Banks/Brokerages with OFX?

[Timothy Jesionowski]

...Just realized I was running a bash script in zsh without realizing it,
so my redirect was erroring rather than clobbering. So that works now.

Anyways, thanks for the tip on SimpleFin. That site (supposedly) supports
every financial institution I use. In theory, I could escape the manual csv
download paradigm entirely!


Sincerely,
Timothy Jesionowski


On Sun, Dec 15, 2024 at 5:43 PM David Avraamides 
wrote:

> I've been downloading OFX files every few days from Fidelity and Fidelity
> NetBenefits with ofxget. I did it yesterday, in fact. What errors are you
> receiving?
>
> That said, I've been testing SimpleFin the last few weeks as it covers so
> many of the financial institutions I care about and it's simpler to deal
> with.
>
> On Sat, Dec 14, 2024 at 1:28 AM Timothy Jesionowski <
> timothy.n.jesionow...@gmail.com> wrote:
>
>> I've been banking with Fidelity for the last year or so, and they
>> recently cut off the direct download access for OFX. It hasn't been
>> available from their website for some time either.
>>
>> Especially for a brokerage account, having OFX statements to import is a
>> huge boon since they're more detailed and the import is more stable than
>> with csv files. But from what I can tell pretty much every major
>> institution is moving away from them. Does anyone know of companies that
>> are maintaining their OFX access?
>>
>>
>> Sincerely,
>> Timothy Jesionowski
>>
>> --
>> 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 beancount+unsubscr...@googlegroups.com.
>> To view this discussion visit
>> https://groups.google.com/d/msgid/beancount/CAOVsoWT_ToBHQvJyCNpFMTrKDD5P98qGir0c%3DT6vrdvF8yrrVQ%40mail.gmail.com
>> <https://groups.google.com/d/msgid/beancount/CAOVsoWT_ToBHQvJyCNpFMTrKDD5P98qGir0c%3DT6vrdvF8yrrVQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/CAN5otWMd4qmqyWqKJPyTM%2B4Nma%3DLdPdFcVR6zgxh6AZS7FqS%2BA%40mail.gmail.com
> <https://groups.google.com/d/msgid/beancount/CAN5otWMd4qmqyWqKJPyTM%2B4Nma%3DLdPdFcVR6zgxh6AZS7FqS%2BA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRyhbwLC7O69qpi_G%3DDpTp3Fe8b3dDkYk6XonMwe7XQ0Q%40mail.gmail.com.

Banks/Brokerages with OFX?

[Timothy Jesionowski]

I've been banking with Fidelity for the last year or so, and they recently
cut off the direct download access for OFX. It hasn't been available from
their website for some time either.

Especially for a brokerage account, having OFX statements to import is a
huge boon since they're more detailed and the import is more stable than
with csv files. But from what I can tell pretty much every major
institution is moving away from them. Does anyone know of companies that
are maintaining their OFX access?


Sincerely,
Timothy Jesionowski

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWT_ToBHQvJyCNpFMTrKDD5P98qGir0c%3DT6vrdvF8yrrVQ%40mail.gmail.com.

Re: Importing with BeanGulp: How to automatically detect duplicate transactions

[Timothy Jesionowski]

I use beancount-import for reconciliation and it works well.

https://github.com/jbms/beancount-import

On Sun, Dec 22, 2024, 2:43 PM Robert  wrote:

> I have not found a good example of how to do this with V3 yet, but what
> path should I take in extending my importers to automatically detect
> duplicates (and comment them out) with beangulp?
>
> Thanks.
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/3d86284f-1ac8-41c9-81a1-acd95eb9458fn%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWSyCzA7%2Bjn2S5f6oMw93RvSjHdYWopUxKQXWtCy_eYmEQ%40mail.gmail.com.

ofxhome API issue

[Timothy Jesionowski]

https://github.com/csingley/ofxtools/issues/193

Looks like the directory site containing all the URLs and such got sold off
to an advertising agency.

Here's a dump of all the information that was on there. Just specify org,
fid, and url so that ofxget doesn't need ofxhome and you shouldn't be
affected.

Sincerely,
Timothy Jesionowski

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRUhTRSXFW8e5CfgSgZZFEiYKiCwaHX-uBwNO6D--9Ubg%40mail.gmail.com.

Re: ofxhome API issue

[Timothy Jesionowski]

https://github.com/ddoherty03/ofxhome_dump/blob/master/ofxhome_dump_2024-02.xml

Sincerely,
Timothy Jesionowski


On Mon, Apr 7, 2025 at 8:54 PM Timothy Jesionowski <
timothy.n.jesionow...@gmail.com> wrote:

> https://github.com/csingley/ofxtools/issues/193
>
> Looks like the directory site containing all the URLs and such got sold
> off to an advertising agency.
>
> Here's a dump of all the information that was on there. Just specify org,
> fid, and url so that ofxget doesn't need ofxhome and you shouldn't be
> affected.
>
> Sincerely,
> Timothy Jesionowski
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWR-%3D_Y%3DDRyyO-YgAGUSVq5JjWFZHPgS1cJgZLM7EGrHzg%40mail.gmail.com.

Re: Tracking Shared expenses

[Timothy Jesionowski]

I just do the allocation manually. Not a satisfying answer, but how many
keystrokes is this plug-in saving you?

(Also, minor nit, but do y'all use debtors/creditors or
receivables/payables?)

On Mon, Apr 21, 2025, 7:56 AM Ghanashyam Prabhu  wrote:

> Hello, Seems like beancount_share plugin worked well with Beancount v2 but
> isn't compatible with Beancount_v3? What are the options to track shared
> expenses on Beancount v3?
>
> Thanks,
> Ghanashyam
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/d11a7e9b-e765-4bba-be27-6442e4bcabcen%40googlegroups.com
> 
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWS2-pKBRVcynBZ%3DTL6s8%2BZqMwaDQNGWDbOuj-AFyJEfxQ%40mail.gmail.com.

Re: Veryfi OCR API (and Emacs front-end for it)

[Timothy Jesionowski]

OCR plus some LLM prompts would be a more general solution than regex, if
it works. But if Veryfi works than I wouldn't bother. (LLMs are probably
what they use anyways...)



Sincerely,
Timothy Jesionowski

On Sat, Jun 21, 2025, 1:25 PM TRS-80  wrote:

> Martin Blais  writes:
>
> > These days for OCR I think you can just download a free vision model
> > from Hugginface and run it locally and it would work.
> > I remember doing that in the recent past.
>
> I imagine something like that just returns a big blob of plain text,
> amirite?  Or can you have it return the data to you in a more structured
> format, with specific fields (key-value pairs) more relevant to a
> receipt?
>
> With this Veryfi API, they are returning JSON with very specific fields
> (e.g., card number, date, payee, tax, tip, total, even individual
> receipt lines (including UPCs when avalable), etc.) and it seems to be
> very accurate so far for me.
>
> When I played with other general OCR tools in the past, I remember the
> OCR itself was only half the battle.  Even if you got that accurate, you
> then had to write regex trying to pull all this other specific info out
> from that.
>
> --
> Cheers,
> TRS-80
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/87bjqh7y19.fsf%40isnotmyreal.name
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWRzf7FGZaE-P%3D1URKqkvQSOQVcHc%2BKHUe6OANSMfmsoVQ%40mail.gmail.com.

Re: formatting/precision when generating transactions

[Timothy Jesionowski]

That's a normal consequence of how beancount tracks precision. Putting an
integer amount of dollars implies exact precision, while putting N decimal
zeros says the transaction should balance to N decimal places in that
currency.



Sincerely,
Timothy Jesionowski

On Mon, Jul 7, 2025, 10:39 AM Zurab Sajaia  wrote:

> Hi all,
>
> I've been just living with this annoyance for a while but perhaps there is
> a solution I'm missing?
> When I import transactions for stock purchases where I usually have a
> round cash value, say 100 usd, and units of stock are fractional, i.e.
> 2025-07-07 * "buy ABC"
>   assets:cash   -160 USD
>   assets:abs  1.2019 ABS { 133.12 USD}
>
> And this transaction doesn't balance because there is a rounding error.
> What I end up doing (the annoying part from above) is to add zeros to the
> cash amount - 160.00 USD and then the error disappears.
>
> Is there a way better/right way to deal with such issues?
>
> Thanks!
> Zurab
>
> --
> 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 beancount+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/e8897673-ac6f-4256-a883-8e5bf25eeedcn%40googlegroups.com
> <https://groups.google.com/d/msgid/beancount/e8897673-ac6f-4256-a883-8e5bf25eeedcn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/beancount/CAOVsoWTRq8xxtExL3VZ5vhELPrwEJdo-xFPU_rMUv%3DOwwEQU9g%40mail.gmail.com.