Simple script for converting a transaction CSV exported from USAA into a YNAB import compatible format.

usaa2ynab.py

import argparse
import csv
import pathlib

parser = argparse.ArgumentParser()
parser.add_argument("infile", type=str, help="CSV file exported from USAA's web portal")
parser.add_argument(
    "outfile",
    nargs="?",
    type=str,
    help="CSV file to create. (default: 'ynab_out.csv' within infile's parent directory)",
)

args = parser.parse_args()
if args.outfile is None:
    args.outfile = pathlib.Path(args.infile).parent / "ynab_out.csv"

with open(args.infile, "r", newline="") as infile, open(args.outfile, "w", newline="") as outfile:
    ussa_reader = csv.DictReader(
        infile,
        fieldnames=["Status", "Blank1", "Date", "Blank2", "Payee", "Memo", "Amount"],
    )
    ynab_writer = csv.DictWriter(
        outfile, 
        fieldnames=["Date", "Payee", "Memo", "Amount"], 
        extrasaction="ignore"
    )
    ynab_writer.writeheader()
    ynab_writer.writerows(ussa_reader)