summaryrefslogtreecommitdiff
path: root/ledger-convert-becu
diff options
context:
space:
mode:
authorJesse Morgan <jesse@jesterpm.net>2024-07-15 20:59:47 -0700
committerJesse Morgan <jesse@jesterpm.net>2024-07-15 20:59:47 -0700
commit1060babec0e4ade23b2d46fd7c8171cdebcd7dda (patch)
treed6aff9ed6b094e43d2470215da6ec78914964ed5 /ledger-convert-becu
parentac8ff544046d25838fbf2681d4fae92b1efe9cce (diff)
Add recent scriptsHEADmaster
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
+
+
+