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] > <mailto:[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/D7B1C8D0-A926-48F8-99B4-8B90311BC5E3%40gmail.com.
