1 files changed, 2 insertions, 6 deletions
diff --git a/python/baml.py b/python/baml.py
index 57038842..a7951611 100644
--- a/python/baml.py
+++ b/python/baml.py
@@ -38,24 +38,20 @@ def load_cash_report(workdate: datetime.date):
             "Local Currency",
             "Account Name",
             "Portfolio ID",
-            "Information As Of",
         ],
-        parse_dates=["Information As Of"],
     )
     df = (
         df[df["Asset Class"] == "CASH AND EQUIVALENTS"]
-        .groupby(
-            ["Local Currency", "Account Name", "Portfolio ID", "Information As Of"]
-        )
+        .groupby(["Local Currency", "Account Name", "Portfolio ID"])
         .sum()
     )
+    df["date"] = prev_business_day(workdate)
     df = df.reset_index().rename(
         {
             "Portfolio ID": "account_number",
             "Local Currency": "currency_code",
             "Account Name": "account_name",
             "Local Market Value": "balance",
-            "Information As Of": "date",
         },
         axis=1,
     )