diff options
Diffstat (limited to 'python/bowdst.py')
| -rw-r--r-- | python/bowdst.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/python/bowdst.py b/python/bowdst.py index 628b54cb..79658f89 100644 --- a/python/bowdst.py +++ b/python/bowdst.py @@ -230,6 +230,12 @@ def load_cash_report(workdate: datetime.date, cob): df = df[ df["Transaction Type"].isna() | df["Transaction Type"].isin(["BUY", "SELL"]) ] + df["Opening Balance Local"] = ( + df["Opening Balance Local"] + .replace("[(]", "-", regex=True) + .replace("[),]", "", regex=True) + .astype("float") + ) df = df.groupby(["Account Name", "Account Number", "Local Currency Code"]).sum() df["date"] = cob df["fund"] = "BOWDST" |