aboutsummaryrefslogtreecommitdiffstats
path: root/python
diff options
context:
space:
mode:
Diffstat (limited to 'python')
-rw-r--r--python/bowdst.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/python/bowdst.py b/python/bowdst.py
index 436d0e8e..cea2c2e3 100644
--- a/python/bowdst.py
+++ b/python/bowdst.py
@@ -226,6 +226,7 @@ def load_cash_report(workdate: datetime.date):
/ f"Settled Cash Statement_{workdate:%d %b %Y}.csv"
)
df = pd.read_csv(p, thousands=",")
+ df = df[df["Transaction Type"].isna()]
df = df.groupby(["Account Name", "Account Number", "Local Currency Code"]).sum()
df["date"] = workdate
df["fund"] = "BOWDST"