Key Points

References

Tax Planning Documents

taxes folder for the year

collect all related tax documents ( taxes paid, w2 forms, 1099 forms etc )

create a year folder for the tax years documents

software folder for tools - reformat fmr net gains csv for each taxable account or use txf tool to reformat taxable net gains

C:\Users\Jim Mason\Google Drive\_save\Finance\taxes    txf_added-notes.txt

see _my_financial management and taxes.docx

D:\dsfw\apps\hrblock for year tax software and year-data

C:\Users\Jim Mason\Google Drive\_save\Finance\tools\txf_creator

Tasks

1. get hrblock software for the year
2. update hrblock software - HRBlock2019.exe - Shortcut ( online or manual download of updates )
3. get taxable net gains from fin svcs ( like Fidelity )
4. use HR Block import financial data first based on your Fidelity login credentials
5. if that fails, then:
   1. use Fidelity ATP to get the financial net gains and download as an .xls file
   2. ATP > accounts > select account > select close positions > select period > view table > expand EVERY trade for lots > RB menu > export to xls
   3. optional — use groovy to create lot level details for every trade in TXF input format OR just assign default dates to summary lines based on CAP gain as LT or ST

   4. columns for TXF input file - TXFCreator only reads up to "Gain" column – rest is to automatically set dates using ST or LT gain info
      

      Symbol

      Quantity

      Date Acquired

      Basis

      Date Sold

      Proceeds

      Gain

      Short-Term G/L

      Long-Term G/L

      Basis/Share

      Proceeds/Share

   5. use txf software to convert net gains csv to file.txf format
6. get ccard, bank details as csv files for the year and categorize by expense type
7. load last year's returns after starting a new return
8. get last year's tax payments, refunds
9. get last year's taxes paid ( property tax etc )

Task - Convert taxable net gains csv file to TXF format

C:\Users\Jim Mason\Google Drive\_save\finance\taxes

_tax-notes2.txt

//=======================================
x140 ATP history reported

select only buy sell transactions
select only closed orders

shows gain / loss query by closed order with dates

use to create csv or xls for download to edit

after edit, export csv in matching format for txf-express tool

//=======================================
x150 txf conversion from fidelity csv

Double click the txf-creator.jar file to launch TXF Creator.

**********************************************************************
TXF Creator (Version 4.0) README.TXT
Copyright (c) 2008 TXF Express LLC December 2008

TXF Creator is a software product developed by TXF Express LLC, which
allows a user to convert stock trades from multiple brokerage accounts
to TXF (Trade eXchange Format) files with just a few clicks of the
mouse. The user can import stock trades into any tax software program
that accepts TXF such as TurboTax and TaxCut.

http://www.easytxf.com/

github txf oss tool

https://github.com/andreasg123/stock-gain-tax-import/issues/1

OR

run free online conversion

http://www.easytxf.com/

this worked for load in 2017 to hr block with valid csv file

-------------------------------------------
get the net gain csv file from Fidelity

OLD >> use ATP custom query on closed transactions for the year-on-year
export as csv

NEW >> download the 1099 csv file from accounts > tax information > 1099 forms > csv files for each account's

-------------------------------------------
Convert a net gain csv file in workbook

Option 1 NEW >> use libre office calc to convert to csv from 1099 formating

remove all but detail records
remove unneed columns
create gain column as sum of cost, proceeds columns
rearrange columns to meet txf format above
save as csv file

-------------------------------------------
FORMAT FOR TXF CSV file

Your CSV file should have ONLY the following six (6) columns in this EXACT order
(headers are optional):

Symbol Quantity Date Acquired Cost Date Sold Proceeds Gain
AAPL 100 10/01/2015 $21895.50 11/15/2015 30125.25 8170.25

Option 2 OLD >> - parse with groovy

jim-tax-symbol-parse.groovy

Key Concepts

Tax Planning

Retirement RMD rules

https://www.foxbusiness.com/personal-finance/this-retirement-rule-will-be-back-with-a-vengeance-in-2021

tax-RMD-2021-rule-changes-This retirement rule will be back with a vengeance in 2021.pdf  gdrive

No RMD in 2020

Potential Value Opportunities

Potential Challenges

Candidate Solutions

Step-by-step guide for Example

sample code block

Recommended Next Steps

Related articles