Convert a Mint CSV to a Trader Account QIF

#powershell

#quicken

#coinbase

#import

#qif

#csv

$var = Import-Csv "C:\Users\talle\OneDrive\Documents\CSV\Xmas'24-April-27'25.csv"
$var2 = "!Type:Invst"
$var3 = $true
$var2 = $var | %{
if ($var3) { "!Type:Invst" }
$var3 = $false
"D"+$.Date.Replace("/2024", "'24").Replace("/2025", "'25")
"NCash"
"U"+$.Amount
"T"+$.Amount
"M"+$.Payee
"LMisc Expenses"
"^"
}
Set-Content -Value $var2 -Path "C:\Users\talle\OneDrive\Documents\CSV\file$($(Get-Date).Day).qif"