Run with: hledger -f example.timedot bal -O csv -p tomorrow -N | python timeclock.py "2018/05/08"

example.timeclock

i 2018/05/08 06:15  Some:Project
o 2018/05/08 09:00

timeclock.py

#!/usr/bin/env python
# -*- encoding: utf-8 -*-

import sys
import csv

if __name__ == '__main__':
    date = sys.argv[1]

    csvreader = csv.DictReader(sys.stdin, delimiter=",")

    for row in csvreader:
        account = ":".join(row['account'].split('.'))
        balance = row['balance'].replace('.', ',')
        print """{date} * Foobar
  {account}  {balance} h
  Equity:Workday  -7,7 h
  Assets:Receivables:Overtime
""".format(date=date,
  account=account,
  balance = balance)