SayPro Revenue Tracking Excel Sheet

To generate the SayPro Revenue Tracking Excel Sheet, you’ll need to run the following Python code on your local machine. Unfortunately, you must be logged into ChatGPT to use the Python tools directly here.

Here’s the full code you can copy and run using Python and Pandas:

pythonCopyEditimport pandas as pd

# Create sample data for each section of the SayPro Revenue Tracking Excel Sheet

# Monthly Revenue Overview
monthly_revenue = pd.DataFrame({
    "Month": ["Jan 2025", "Feb 2025", "Mar 2025", "Apr 2025", "May 2025"],
    "Donations": [1200, 1500, 1300, 1600, 1800],
    "Training Fees": [5000, 4800, 5100, 5500, 6000],
    "Consulting": [3000, 3200, 2900, 3100, 4000],
    "Other": [200, 250, 220, 300, 350]
})
monthly_revenue["Total Revenue"] = monthly_revenue[["Donations", "Training Fees", "Consulting", "Other"]].sum(axis=1)

# Revenue by Stream (Detailed)
revenue_by_stream = pd.DataFrame({
    "Date": ["2025-05-01", "2025-05-03", "2025-05-05"],
    "Stream": ["Training", "Consulting", "Donations"],
    "Source/Client": ["ABC NGO", "Gov Dept X", "Jane Doe"],
    "Service/Item": ["Virtual Workshop", "Strategy Session", "One-time Donation"],
    "Amount": [450, 1200, 100],
    "Payment Method": ["EFT", "Invoice", "Online Pay"],
    "Notes": ["Paid in full", "Partial payment", "Via donation portal"]
})

# Create Excel writer
excel_file = "SayPro_Revenue_Tracking_Sheet.xlsx"
with pd.ExcelWriter(excel_file, engine="xlsxwriter") as writer:
    monthly_revenue.to_excel(writer, sheet_name="Monthly Revenue Overview", index=False)
    revenue_by_stream.to_excel(writer, sheet_name="Revenue by Stream", index=False)

print(f"Excel file '{excel_file}' created successfully.")

📝 Requirements:

• Install pandas and xlsxwriter:

bashCopyEditpip install pandas xlsxwriter

Once you run this code, it will generate an Excel file named SayPro_Revenue_Tracking_Sheet.xlsx with sample data. You can customize or expand it further as needed.