summaryrefslogtreecommitdiff
path: root/ledger-convert-becu
blob: 224fb22fb725f3cd8b3e3f309f8445ee7f5c9908 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#!/bin/sh

ACCOUNT=$1
FILE=$2

# Incoming header is
# "Date","No.","Description","Debit","Credit"
#
# Ledger columns are
# transid,date,payee,note,debit,credit,,code,

sed '1 s/.*/date,code,payee,debit,credit/' $FILE | sed 's/"-/"/' |tr -d \" > ${FILE}.ledger
ledger convert ${FILE}.ledger \
    --input-date-format '%m/%d/%Y' \
    --account "Assets:Current Assets:$ACCOUNT" \
    --auto-match \
    --rich-data --invert