-
Notifications
You must be signed in to change notification settings - Fork 5
/
csv2txf.py
executable file
·124 lines (104 loc) · 4.07 KB
/
csv2txf.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
#!/usr/bin/python
#
# Copyright 2012 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
"""Converts a file to TXF for import into tax software.
Does not handle:
* dividends
Docs:
* TXF standard: http://turbotax.intuit.com/txf/
"""
from __future__ import annotations
from decimal import Decimal
from datetime import datetime
import sys
from typing import List
from brokers import GetBroker
import utils
def ConvertTxnListToTxf(txn_list: list[utils.Transaction], tax_year: int, date: str) -> List[str]:
lines = []
lines.append('V042') # Version
lines.append('Acsv2txf') # Program name/version
if date is None:
date = utils.txfDate(datetime.today())
lines.append('D%s' % date) # Export date
lines.append('^')
for txn in txn_list:
lines.append('TD')
lines.append('N%d' % txn.entryCode)
lines.append('C1')
lines.append('L1')
lines.append('P%s' % txn.desc)
lines.append('D%s' % txn.buyDateStr)
lines.append('D%s' % txn.sellDateStr)
lines.append('$%.2f' % txn.costBasis)
lines.append('$%.2f' % txn.saleProceeds)
if txn.adjustment:
lines.append('$%.2f' % txn.adjustment)
lines.append('^')
return lines
def RunConverter(broker_name: str, filename: str, tax_year: int, date: str) -> List[str]:
broker = GetBroker(broker_name, filename)
txn_list = broker.parseFileToTxnList(filename, tax_year)
return ConvertTxnListToTxf(txn_list, tax_year, date)
def GetSummary(broker_name: str, filename: str, tax_year: int) -> str:
broker = GetBroker(broker_name, filename)
total_cost = Decimal(0)
total_sales = Decimal(0)
txn_list = broker.parseFileToTxnList(filename, tax_year)
for txn in txn_list:
assert txn.costBasis is not None
total_cost += txn.costBasis
assert txn.saleProceeds is not None
total_sales += txn.saleProceeds
return '\n'.join([
'%s summary report for %d' % (broker.name(), tax_year),
'Num sale txns: %d' % len(txn_list),
'Total cost: $%.2f' % total_cost,
'Total proceeds: $%.2f' % total_sales,
'Net gain/loss: $%.2f' % (total_sales - total_cost),
])
def main(argv):
from optparse import OptionParser
parser = OptionParser()
parser.add_option("--broker", dest="broker", help="broker name")
parser.add_option("-f", "--file", dest="filename", help="input file")
parser.add_option("-o", "--outfile", dest="out_filename",
help="output file, leave empty for stdout")
parser.add_option("--outfmt", dest="out_format",
help="output format: `txf` or `summary`")
parser.add_option("--year", dest="year", help="tax year", type="int")
parser.add_option("--date", dest="date", help="date to output", type="str")
(options, args) = parser.parse_args(argv)
if not options.filename:
sys.stderr.write('Filename is required; specify with `--file` flag.\n')
sys.exit(1)
if options.year:
year = int(options.year)
else:
year = datetime.today().year - 1
utils.Warning(f'Year not specified, defaulting to {year} (last year)\n')
output = None
if options.out_format == 'summary':
output = GetSummary(options.broker, options.filename, year)
else:
txf_lines = RunConverter(options.broker, options.filename, year, options.date)
output = '\n'.join(txf_lines)
if options.out_filename:
with open(options.out_filename, 'w') as out:
out.write(output)
else:
print(output)
if __name__ == '__main__':
main(sys.argv)