summaryrefslogtreecommitdiff
path: root/ledger-convert-becu
diff options
context:
space:
mode:
Diffstat (limited to 'ledger-convert-becu')
-rwxr-xr-xledger-convert-becu20
1 files changed, 20 insertions, 0 deletions
diff --git a/ledger-convert-becu b/ledger-convert-becu
new file mode 100755
index 0000000..224fb22
--- /dev/null
+++ b/ledger-convert-becu
@@ -0,0 +1,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
+
+
+