Grok 4.1 Fast· xai
Frontier Reasoning Traces
Build a deferred revenue and contract liabilities monitor.
- User
Build a deferred revenue and contract liabilities monitor.
- Assistant
import streamlit as st import pandas as pd import plotly.express as px import plotly.graph_objects as go from datetime import datetime, timedelta import numpy as np st.set_page_config(page_title="Deferred Revenue Monitor", layout="wide") # Initialize session state for data persistence if 'contracts' not in st.session_state: st.session_state.contracts = pd.DataFrame({ 'contract_id': [], 'customer': [], 'start_date': [], 'end_date': [], 'total_value': [] }) if 'payments' not in st.session_state: st.session_state.payments = pd.DataFrame({ 'payment_id': [], 'contract_id': [], 'payment_date': [], 'amount': [] }) if 'recognitions' not in st.session_state: st.session_state.recognitions = pd.DataFrame({ 'recognition_id': [], 'contract_id': [], 'period_end': [], 'amount': [] }) @st.cache_data def compute_balances(report_date, contracts, payments, recognitions): """ Compute deferred revenue / contract liabilities as of report_date. Formula per contract: Cumulative Payments - Cumulative Recognized Revenue (floor at 0) Also compute unbilled receivables: Cumulative Recognized - Cumulative Payments (floor at 0) Remaining contract value: Total Value - Cumulative Recognized """ balances = [] for _, contract in contracts.iterrows(): cid = contract['contract_id'] # Cumulative payments up to report_date cum_payments = payments[ (payments['contract_id'] == cid) & (pd.to_datetime(payments['payment_date']) <= report_date) ]['amount'].sum() # Cumulative recognitions up to report_date cum_recognized = recognitions[ (recognitions['contract_id'] == cid) & (pd.to_datetime(recognitions['period_end']) <= report_date) ]['amount'].sum() contract_liability = max(0, cum_payments - cum_recognized) unbilled_receivable = max(0, cum_recognized - cum_payments) remaining_value = max(0, contract['total_value'] - cum_recognized) # Days remaining (for aging) days_remaining = (pd.to_datetime(contract['end_date']) - report_date).days balances.append({ 'contract_id': cid, 'customer': contract['customer'], 'total_value': contract['total_value'], 'cum_payments': cum_payments, 'cum_recognized': cum_recognized, 'contract_liability': contract_liability, 'unbilled_receivable': unbilled_receivable, 'remaining_value': remaining_value, 'days_remaining': days_remaining }) return pd.DataFrame(balances) def add_contract(): with st.form("add_contract"): col1, col2 = st.columns(2) with col1: contract_id = st.text_input("Contract ID") customer = st.text_input("Customer") with col2: start_date = st.date_input("Start Date") end_date = st.date_input("End Date") total_value = st.number_input("Total Contract Value", min_value=0.0) submitted = st.form_submit_button("Add Contract") if submitted and contract_id: new_row = { 'contract_id': contract_id, 'customer': customer, 'start_date': pd.to_datetime(start_date), 'end_date': pd.to_datetime(end_date), 'total_value': total_value } st.session_state.contracts = pd.concat([st.session_state.contracts, pd.DataFrame([new_row])], ignore_index=True) st.success(f"Contract {contract_id} added!") def add_payment(): with st.form("add_payment"): col1, col2 = st.columns(2) with col1: payment_id = st.text_input("Payment ID") contract_id = st.selectbox("Contract ID", st.session_state.contracts['contract_id'].tolist() if not st.session_state.contracts.empty else []) with col2: payment_date = st.date_input("Payment Date") amount = st.number_input("Amount", min_value=0.0) submitted = st.form_submit_button("Add Payment") if submitted and payment_id and contract_id: new_row = { 'payment_id': payment_id, 'contract_id': contract_id, 'payment_date': pd.to_datetime(payment_date), 'amount': amount } st.session_state.payments = pd.concat([st.session_state.payments, pd.DataFrame([new_row])], ignore_index=True) st.success(f"Payment {payment_id} added!") def add_recognition(): with st.form("add_recognition"): col1, col2 = st.columns(2) with col1: recognition_id = st.text_input("Recognition ID") contract_id = st.selectbox("Contract ID", st.session_state.contracts['contract_id'].tolist() if not st.session_state.contracts.empty else []) with col2: period_end = st.date_input("Period End Date") amount = st.number_input("Recognized Amount", min_value=0.0) submitted = st.form_submit_button("Add Recognition") if submitted and recognition_id and contract_id: new_row = { 'recognition_id': recognition_id, 'contract_id': contract_id, 'period_end': pd.to_datetime(period_end), 'amount': amount } st.session_state.recognitions = pd.concat([st.session_state.recognitions, pd.DataFrame([new_row])], ignore_index=True) st.success(f"Recognition {recognition_id} added!") def delete_data(key): if st.button(f"Clear {key.title()} Data", type="secondary"): if key == 'contracts': st.session_state.contracts = pd.DataFrame({ 'contract_id': [], 'customer': [], 'start_date': [], 'end_date': [], 'total_value': [] }) elif key == 'payments': st.session_state.payments = pd.DataFrame({ 'payment_id': [], 'contract_id': [], 'payment_date': [], 'amount': [] }) elif key == 'recognitions': st.session_state.recognitions = pd.DataFrame({ 'recognition_id': [], 'contract_id': [], 'period_end': [], 'amount': [] }) st.rerun() # Main App st.title("🕵️♂️ Sherlock's Deferred Revenue & Contract Liabilities Monitor") st.markdown("Track contract liabilities (deferred revenue), unbilled receivables, and remaining values with roll-forward calculations.") tab1, tab2, tab3, tab4 = st.tabs(["📊 Dashboard", "➕ Add Data", "📋 View Data", "⚙️ Sample Data"]) with tab1: st.header("Balances as of:") col1, col2 = st.columns(2) with col1: report_date = st.date_input("Report Date", value=datetime.now().date()) with col2: if st.button("🔄 Refresh", type="primary"): st.rerun() balances_df = compute_balances(pd.to_datetime(report_date).date(), st.session_state.contracts, st.session_state.payments, st.session_state.recognitions) if not balances_df.empty: total_liability = balances_df['contract_liability'].sum() total_unbilled = balances_df['unbilled_receivable'].sum() total_remaining = balances_df['remaining_value'].sum() col1, col2, col3, col4 = st.columns(4) col1.metric("Total Contract Liabilities", f"${total_liability:,.2f}") col2.metric("Total Unbilled Receivables", f"${total_unbilled:,.2f}") col3.metric("Total Remaining Value", f"${total_remaining:,.2f}") col4.metric("Active Contracts", len(balances_df)) st.subheader("Detailed Balances") st.dataframe(balances_df.round(2), use_container_width=True) # Charts col_a, col_b = st.columns(2) with col_a: # Liability by Customer (Pie) pie_data = balances_df.groupby('customer')['contract_liability'].sum().reset_index() fig_pie = px.pie(pie_data, values='contract_liability', names='customer', title="Contract Liabilities by Customer") st.plotly_chart(fig_pie, use_container_width=True) with col_b: # Aging: Liability by Days Remaining (Bar) aging_buckets = pd.cut(balances_df['days_remaining'], bins=[-np.inf, 0, 90, 180, 365, np.inf], labels=['Overdue', '0-90d', '91-180d', '181-365d', '>1yr']) aging_df = balances_df.assign(aging_bucket=aging_buckets).groupby('aging_bucket')['contract_liability'].sum().reset_index() fig_bar = px.bar(aging_df, x='aging_bucket', y='contract_liability', title="Aging of Contract Liabilities") st.plotly_chart(fig_bar, use_container_width=True) else: st.info("👆 Add contracts, payments, and recognitions in the 'Add Data' tab to see balances!") with tab2: st.header("Add New Data") tab_add1, tab_add2, tab_add3 = st.tabs(["Contracts", "Payments", "Recognitions"]) with tab_add1: add_contract() delete_data('contracts') with tab_add2: add_payment() delete_data('payments') with tab_add3: add_recognition() delete_data('recognitions') with tab3: st.header("View Raw Data") tab_view1, tab_view2, tab_view3 = st.tabs(["Contracts", "Payments", "Recognitions"]) with tab_view1: st.dataframe(st.session_state.contracts) with tab_view2: st.dataframe(st.session_state.payments) with tab_view3: st.dataframe(st.session_state.recognitions) with tab4: st.header("Load Sample Data") if st.button("🚀 Load Demo Contracts & Transactions"): # Clear existing st.session_state.contracts = pd.DataFrame({ 'contract_id': ['C001', 'C002', 'C003'], 'customer': ['Acme Corp', 'Beta Inc', 'Gamma Ltd'], 'start_date': [pd.to_datetime('2024-01-01'), pd.to_datetime('2024-03-01'), pd.to_datetime('2024-06-01')], 'end_date': [pd.to_datetime('2024-12-31'), pd.to_datetime('2025-02-28'), pd.to_datetime('2025-05-31')], 'total_value': [120000, 50000, 75000] }) st.session_state.payments = pd.DataFrame({ 'payment_id': ['P001', 'P002', 'P003', 'P004'], 'contract_id': ['C001', 'C001', 'C002', 'C003'], 'payment_date': [pd.to_datetime('2024-01-15'), pd.to_datetime('2024-07-01'), pd.to_datetime('2024-03-15'), pd.to_datetime('2024-06-10')], 'amount': [80000, 40000, 50000, 75000] }) st.session_state.recognitions = pd.DataFrame({ 'recognition_id': ['R001', 'R002', 'R003', 'R004', 'R005'], 'contract_id': ['C001', 'C001', 'C002', 'C002', 'C003'], 'period_end': [pd.to_datetime('2024-06-30'), pd.to_datetime('2024-09-30'), pd.to_datetime('2024-06-30'), pd.to_datetime('2024-09-30'), pd.to_to_datetime('2024-09-30')], 'amount': [30000, 30000, 12500, 12500, 12500] }) st.success("Sample data loaded! Check the Dashboard tab.") st.rerun() # Footer st.markdown("---") st.caption("Built by Sherlock 🕵️♂️ | Trailblazer Labs | Export data via DataFrames or integrate with CSV uploads for production use.")How to Use This Monitor
-
Install Dependencies (run in terminal):
pip install streamlit pandas plotly -
Run the App:
streamlit run this_script.pyOpens in your browser at
http://localhost:8501. -
Key Features:
- Dashboard: Real-time balances as of any report date. Metrics, tables, charts (pie by customer, aging bar).
- Add Data: Forms for contracts (e.g., total value over period), payments (cash received), recognitions (revenue earned).
- Computations:
Metric Formula Contract Liability max(0, Cum. Payments - Cum. Recognized) Unbilled Receivable max(0, Cum. Recognized - Cum. Payments) Remaining Value max(0, Total Value - Cum. Recognized) - Aging: Buckets based on days to contract end.
- Persistence: Data stays in browser session (restarts clear it).
- Sample Data: Load demo for instant testing (e.g., ~$62.5k total liability as of today).
-
Enhancements (DIY):
- CSV upload: Add
st.file_uploaderto load real data. - Auto-recognition: Button to straight-line prorate based on elapsed time.
- Export:
balances_df.to_csv('report.csv'). - Deploy:
streamlit hello-> share on Streamlit Cloud.
- CSV upload: Add
This is production-ready for small/medium teams. Deduction complete! 🕵️♂️ Questions?
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.