Ah I see. As someone on this list recently observed, by dabbling in open source personal finance, you get to see exactly what your bank is doing behind the scenes. Here, given this is a non-traditional checking account, Fidelity apparently holds your money in a couple different funds to ensure its value remains the same, is FDIC insured, and such.
The current banking.py importer does not support this case. You have two options: A) Extend banking.py to support these types of checking accounts. This is the cleanest way, is straightforward, and will help everyone with a non-traditional checking accounts, though it involves a bit of coding work. You can use the code in investments.py to generate the buy/sell transactions (as price conversions). B) As you suggested, completely ignore all the conversion-to-funds (QPIQ, QPCTQ ,etc.) transactions. You won't know how your money is held, if that interests you, but you will have a "cleaner" file. This is easy to implement. Just add skip_transactions() <https://github.com/redstreet/beancount_reds_importers/blob/6417ee3c9005e0ccb42f7bea2fe934407ca55580/beancount_reds_importers/libtransactionbuilder/investments.py#L152>, and this line <https://github.com/redstreet/beancount_reds_importers/blob/6417ee3c9005e0ccb42f7bea2fe934407ca55580/beancount_reds_importers/libtransactionbuilder/investments.py#L291> to banking.py, and then override it in your importer like this <https://github.com/redstreet/beancount_reds_importers/blob/6417ee3c9005e0ccb42f7bea2fe934407ca55580/beancount_reds_importers/etrade/__init__.py#L15>. I just did all of this and committed it, except for the overriding part. If you like this approach, install the bleeding edge, and then override. Hope that helps! -Red On Sunday, June 19, 2022 at 8:22:23 AM UTC-7 [email protected] wrote: > Here is an example of what’s generated and a couple notes about what I see: > - the core account can have different symbols, sometimes it’s QPIQQ, > sometimes it’s QPCTQ, etc. > - there looks to be one core account transaction per day. On 5/31 the core > account transaction matches the sum of all other transactions on the same > day > - I found that some transactions strings look to be cut short. For example > the first transaction listed ends in SHR=10, expect SHR=10.68 > - to me, the concept of “core account” sounds a lot like money market > accounts. Here’s some fidelity documentation > <https://www.fidelity.com/bin-public/060_www_fidelity_com/documents/PDF_Fidelity_Cash_Management_Account_FDIC_Disclosure_document_(PDF).pdf> > > 2022-05-19 * "YOU BOUGHT @ 1:SYM=QPIQQ SHR=10" > Assets:Fidelity:Checking -10.68000 USD > > 2022-05-19 * "DIRECT DEPOSIT Apple Cash TRAN" > Assets:Fidelity:Checking 10.68000 USD > > 2022-05-26 * "YOU BOUGHT @ 1:SYM=QPCTQ SHR=11" > Assets:Fidelity:Checking -1111.11000 USD > > 2022-05-26 * "DIRECT DEPOSIT *COMPANY PAYROLL*" > Assets:Fidelity:Checking 1111.11000 USD > > 2022-05-31 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-384" > Assets:Fidelity:Checking 384.89000 USD > > 2022-05-31 * "YOU SOLD @ 1:SYM=QPIQQ SHR=-10." > Assets:Fidelity:Checking 10.68000 USD > > 2022-05-31 * "CREDIT INTEREST AT US BANK NOT" > Assets:Fidelity:Checking 0.49000 USD > > 2022-05-31 * "CREDIT INTEREST AT CITIBANK NOT" > Assets:Fidelity:Checking 0.37000 USD > > 2022-05-31 * "CREDIT INTEREST AT WELLS FARGO" > Assets:Fidelity:Checking 0.06000 USD > > 2022-05-31 * "DIRECT DEBIT CARDMEMBER SERWEB" > Assets:Fidelity:Checking -396.49000 USD > > 2022-06-01 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-14." > Assets:Fidelity:Checking 14.98000 USD > > 2022-06-01 * "DIRECT DEBIT *CREDIT CARD*" > Assets:Fidelity:Checking -14.98000 USD > > 2022-06-02 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-220" > Assets:Fidelity:Checking 2200.00000 USD > > 2022-06-02 * "CHECK PAID *XXXX*" > Assets:Fidelity:Checking -2200.00000 USD > > 2022-06-03 balance Assets:Fidelity:Checking > XXXX.XX000 USD > > > Now an example of what’s expected, either I think “core account” > transactions could be ignored entirely or they could be auto-filled. Also I > suppose the “CREDIT INTEREST” could be auto-filled since I understand this > to be interest from funds held in core accounts. > > 2022-05-19 * "YOU BOUGHT @ 1:SYM=QPIQQ SHR=10<extend to 10.68>" > Assets:Fidelity:Checking:USD -10.68000 USD > Assets:Fidelity:Checking:QPIQQ 10.68000 USD > > 2022-05-19 * "DIRECT DEPOSIT Apple Cash TRAN" > Assets:Fidelity:Checking 10.68000 USD > <leave this to smart importer or manually filled> > > 2022-05-26 * "YOU BOUGHT @ 1:SYM=QPCTQ SHR=11<extend to 1111.11>" > Assets:Fidelity:Checking:USD -1111.11000 USD > Assets:Fidelity:Checking:QPCTQ 1111.11000 USD > > 2022-05-26 * "DIRECT DEPOSIT *COMPANY PAYROLL*" > Assets:Fidelity:Checking 1111.11000 USD > <leave this to smart importer or manually filled> > > 2022-05-31 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-384<extend>" > Assets:Fidelity:Checking:USD 384.89000 USD > Assets:Fidelity:Checking:QPCTQ -384.89000 USD > > 2022-05-31 * "YOU SOLD @ 1:SYM=QPIQQ SHR=-10." > Assets:Fidelity:Checking 10.68000 USD > > 2022-05-31 * "CREDIT INTEREST AT US BANK NOT" > Assets:Fidelity:Checking 0.49000 USD > > 2022-05-31 * "CREDIT INTEREST AT CITIBANK NOT" > Assets:Fidelity:Checking 0.37000 USD > > 2022-05-31 * "CREDIT INTEREST AT WELLS FARGO" > Assets:Fidelity:Checking 0.06000 USD > > 2022-05-31 * "DIRECT DEBIT CARDMEMBER SERWEB" > Assets:Fidelity:Checking -396.49000 USD > > 2022-06-01 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-14." > Assets:Fidelity:Checking 14.98000 USD > > 2022-06-01 * "DIRECT DEBIT *CREDIT CARD*" > Assets:Fidelity:Checking -14.98000 USD > > 2022-06-02 * "YOU SOLD @ 1:SYM=QPCTQ SHR=-220" > Assets:Fidelity:Checking 2200.00000 USD > > 2022-06-02 * "CHECK PAID *XXXX*" > Assets:Fidelity:Checking -2200.00000 USD > > 2022-06-03 balance Assets:Fidelity:Checking > XXXX.XX000 USD > > > On Jun 19, 2022, at 1:34 AM, Red S <[email protected]> wrote: > > It the issue one of just "noise" or is there a correctness issue? Could > you please post the beancount transactions that get generated by the > importer, and also the transactions you expect/want? > > On Saturday, June 18, 2022 at 2:17:10 PM UTC-7 [email protected] wrote: > >> I've been trying to use the banking importer from >> beancount-reds-importers for a checking account with Fidelity Investments. >> >> The issue I'm running into is the OFX I get from them includes all "core >> account settlements" - so every transaction has a duplicate core account >> line item. >> >> E.g. >> -> Direct Deposit from Company Payroll, $200 >> -> Purchase into Core Account QXXX, -$200 >> >> In my OFX file this looks something like this: >> <MEMO>YOU SOLD @ 1:SYM=QXXX SHR=-200 PRC=1.00000 >> >> This creates a bit of noise- I was trying to see if I could leverage the >> money_market logic from investments.py in a custom fidelity_banking.py but >> that's not going too well :D >> >> Wanted to see if anyone had some simple suggestions or existing solutions >> > > -- > 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 on the web visit > https://groups.google.com/d/msgid/beancount/2630e490-3859-4b7f-9975-71eb44d4c5fbn%40googlegroups.com > > <https://groups.google.com/d/msgid/beancount/2630e490-3859-4b7f-9975-71eb44d4c5fbn%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/64584bde-dc24-4188-963a-e4e1f9e5ef27n%40googlegroups.com.
