Two sources, one dashboard: Monthly receipt totals are read from Daisy's Monthly Ledger tab (her finalized numbers, source of truth). Daily balance and net position trends are read from the Daily Email Log tab.
Balance Trend
DAILY CURRENT BALANCE & NET BALANCE (RMB) — FROM DAILY EMAIL LOG
Range:
Monthly Receipts
TOTAL PAYMENTS RECEIVED PER MONTH (RMB) — FROM MONTHLY LEDGER
Day-of-Month Pattern
AVG DAILY RECEIPT BY CALENDAR DAY — FROM DAILY LOG
Monthly Summary Table
END-OF-MONTH SNAPSHOTS
Month
Final Bal
Net Bal
Total Received
Recent Daily Observations
LAST 30 RECORDS FROM DAILY EMAIL LOG
Data Date
Day
Current Bal
Net Bal
Deadline
Recv Today
Email MTD
Update Data
Upload an Excel file (.xlsx) with the same structure as the source workbook: a Monthly Ledger tab and a Daily Email Log tab.