ComusThumbz Dokumentation
HTML Markdown Drucken/PDF Klartext
Admin-Anmeldung

Dokumentationsmenü


Admin-Zugang

Financial Reports

Overview

The Financial Reports page is a comprehensive financial tracking and analytics dashboard for the ComusThumbz creator monetization system. It provides detailed insights into platform revenue, creator earnings, token transactions, and financial health metrics. The page tracks all monetary activities including token purchases, tips, subscriptions, PPV unlocks, product purchases, and withdrawals, with clear separation between platform revenue and creator earnings.

Location: Navigate to this page via Admin Panel → Reports → Financial Reports or access directly via ct/admin/financialreports.php

[Screenshot: financial-reports-main-interface]

Getting to This Page

Navigate to Admin Panel → ReportsClick Financial Reports link

  1. Alternatively, access directly via ct/admin/financialreports.php

 

Note:
This page provides comprehensive financial analytics for the creator monetization system. Use the date filters to analyze specific time periods and the transaction type filter to focus on specific revenue streams.

 

System Requirements

 

Configuration Required:
This page requires the creator monetization database tables and performs complex SQL queries. Ensure your database is properly configured before using this page.

 

PHP Requirements

Requirement Minimum Recommended Notes
PHP Version 8.0 8.2+ Uses strict types, null coalescing
memorylimit 128M 256M For complex aggregation queries
maxexecutiontime 60 120 Multiple database queries

Required PHP Extensions

Extension Required Purpose
mysqli Yes Database connectivity
session Yes CSRF protection, authentication
json Yes Chart.js data encoding
date Yes Date filtering and formatting

Required PHP Functions

Function Required For Notes
bin2hex() CSRF token generation Security
randombytes() CSRF token generation Security
date() Date range filtering Date calculations
strtotime() Date calculations Date diff, sorting
numberformat() Currency formatting Display
htmlspecialchars() XSS prevention Security

Folder Permissions

Folder Permission Purpose
ct/admin/ 755 (read/execute) Page access

Network Requirements

Endpoint Protocol Purpose
Chart.js CDN HTTPS Chart rendering
Font Awesome CDN HTTPS Icons

Features & UI Elements

Page Header

[Screenshot: financial-reports-header]

Element Description
Title "Financial Reports" with chart icon
Breadcrumb Dashboard → Reports → Financial Reports
Back to Reports Returns to reports.php
Token Usage Link to tokenusage.php

Value Toggle (Tokens/USD)

[Screenshot: financial-reports-value-toggle]

Button Action
Tokens Display all values as token amounts
USD Display all values as USD (tokens × $0.10)
Tip: Click the toggle buttons to switch between viewing values as tokens or USD. This affects all statistics cards and breakdown displays on the page.

Date Range Filter

[Screenshot: financial-reports-filters]

Element Description
Date From Start date for report period (default: first of month)
Date To End date for report period (default: today)
Transaction Type Filter by: All, Tips, Subscriptions, PPV, Purchases, Withdrawals
Apply Filters Submit button to apply filters

Tax Season Export

[Screenshot: financial-reports-tax-export]

Element Description
Year Selector Dropdown to select tax year (2020-2050)
Tax Season Export Generates comprehensive Excel export with sections
Warning: The Tax Season Export generates an Excel file with complete financial data for the selected year, including cash flow, liabilities, platform revenue, and monthly breakdowns. Ensure you have a valid year selected before exporting.

Summary Statistics Grid

[Screenshot: financial-reports-stats-grid]

Card Description Border Color
Token Purchases Total tokens purchased (money in) Blue
Tips Volume Total tips sent, count, average Default (green)
Platform Earnings Platform fee revenue Red
Creator Earnings Creator share of transactions Green
Pending Withdrawals Tokens awaiting payout Orange
Completed Payouts Tokens paid out, USD amount Default

Additional Statistics Row

Card Description
Unique Spenders Users who made transactions, avg spend
Active Creators Creators who received earnings, avg earnings
Subscriptions Total subscription tokens, count, average
PPV Unlocks Total PPV tokens, count, average
Refunds Refunded tip tokens, count
Avg Transaction Average transaction size

Accordion Sections

The page uses collapsible accordion sections for detailed analytics:

Transaction Insights

Metric Description
Largest Tip Biggest single tip transaction
Tips Per Day Average daily tip volume
First-Time Spenders New users this period
Returning Spenders Repeat users, repeat rate %
Token Conversion Purchased vs spent ratio

Subscription Health

Metric Description
Active Subs Current active subscriptions
Cancelled Cancelled count, churn rate
Auto-Renew Rate % of active with auto-renew
Avg Duration Average subscription length (days)
Expired Expired without renewal

Withdrawal Metrics

Metric Description
Pending Payouts Awaiting processing (USD)
Avg Withdrawal Average payout amount
Processing Time Average days to complete
By Method Breakdown by PayPal, bank, crypto, etc.

Revenue Trends

Metric Description
Week-over-Week Growth % vs last week
Month-over-Month Growth % vs last month
Best Day Highest revenue day of week
Slowest Day Lowest revenue day of week

Tips by Content Type

Displays token breakdown by content type (video, gallery, post, profile, livestream).

Token Velocity

Metric Description
All-Time Purchased Total tokens ever sold
All-Time Spent Total tokens ever used
Turnover Rate Spent ÷ Purchased %
Unspent Rate User balances ÷ Purchased %
User Balances Unspent tokens (liability)
Creator Balances Unwithdrawn earnings (liability)

Revenue Breakdown Cards

[Screenshot: financial-reports-breakdown]

Revenue by Source:

  • Tips
  • Subscriptions
  • PPV Unlocks
  • Total Volume

 

Platform vs Creator Split:

  • Platform Fee Rate (%)
  • Platform Earnings (Tips)
  • Creator Earnings (Tips)
  • Total Platform Revenue

 

Charts

[Screenshot: financial-reports-charts]

Chart Type Description
Daily Revenue Trend Line Total volume, platform, creator over time
By Hour Pie Spending distribution by hour (0-23)
By Month Pie Rolling 12-month revenue
Revenue Details Polar Area PPV Stream, Tip Goal, Per-Minute, PPV Post, Other
Platform vs Creator Doughnut Fee split visualization

Top Lists (Modals)

[Screenshot: financial-reports-modals]

Modal Content
Top 100 Creators Ranked by earnings with tips, subscribers, balance
Top 100 Users Ranked by spending with tips, subs, PPV breakdown

Transaction History Table

[Screenshot: financial-reports-transactions]

Column Description
Date Transaction timestamp
Type Badge: tip, subscription, ppv, tokenpurchase, withdrawal
From User who initiated (link to userdetails)
To Creator who received (link to creatordetailadmin)
Amount Token amount with USD equivalent
Split Platform/Creator split with percentages
Details Message or status, refund indicator

Pagination

Element Description
Info "Showing X - Y of Z transactions"
First/Previous Navigate to first/previous page
Page Numbers Direct page links (5 around current)
Next/Last Navigate to next/last page

Tax Season Export

The Tax Season Export generates a comprehensive Excel report with 6 sections:

Section 1: Cash Flow

  • Token Purchases (Money IN)
  • Creator Withdrawals (Money OUT)
  • Net Cash Flow

Section 2: Token Liabilities

  • User Token Balances (unspent)
  • Creator Token Balances (unwithdrawn)
  • Total Liabilities

Section 3: Platform Revenue

  • Tips (with platform/creator split)
  • Creator Subscriptions
  • PPV Content Unlocks
  • Total Platform Revenue (taxable income)

Section 4: Net Position Summary

  • Cash Position
  • Liabilities breakdown
  • Adjusted Net Position
  • Platform Revenue (Taxable Income)

Section 5: Monthly Revenue Breakdown

  • 12-month breakdown of platform and creator earnings

Section 6: Tax Summary

  • Final taxable income figure with important tax notes

 

Success:
The Tax Season Export clearly separates platform revenue (your taxable income) from customer deposits (token purchases) and creator payments. This format is designed to help with tax reporting compliance.

 

Step-by-Step Usage

Viewing Financial Overview

  1. Navigate to Admin Panel → Reports → Financial Reports
  2. View default statistics for current month
  3. Use value toggle to switch between Tokens/USD
  4. Click accordion headers to expand detailed sections

Filtering by Date Range

  1. Enter start date in Date From field
  2. Enter end date in Date To field
  3. Click Apply Filters
  4. All statistics and charts update for selected period

Filtering by Transaction Type

  1. Select type from Transaction Type dropdown:
  • All Types (default)
  • Tips
  • Subscriptions
  • PPV Unlocks
  • Token Purchases
  • Withdrawals
  1. Click Apply Filters
  2. Transaction table shows only selected type

Generating Tax Report

  1. Select year from Year Selector dropdown
  2. Click Tax Season Export button
  3. Excel file downloads automatically
  4. Review all 6 sections for tax reporting

Viewing Top Creators/Users

  1. Click Top 100 Creators by Earnings button
  2. Modal opens with ranked creator list
  3. Click creator name to view detailed profile
  4. Press Escape or click outside to close

Navigating Transaction History

  1. Scroll to Transaction History section
  2. Use pagination controls at bottom
  3. Click user/creator names to view profiles
  4. Refunded transactions shown with strikethrough

Token to USD Conversion

The page uses a configurable token rate:

$tokenrate = 0.10; // 1 token = $0.10

All USD values are calculated as:

USD = tokens × $0.10

 

Platform Fee Calculation

Platform fees are retrieved from tblCreatorPlatformSettings:

SELECT settingvalue
FROM tblCreatorPlatformSettings
WHERE settingkey = 'platformfeepercent'

Default: 20%

For each transaction:

  • Platform Share: tokens × (platformfeepercent / 100)
  • Creator Share: tokens × ((100 - platformfeepercent) / 100)

 

Troubleshooting

Common Errors

 

Error:
"No transactions found for the selected period"


Cause: No transactions exist in the date range
Solution:

  1. Expand the date range
  2. Check if creator monetization is active
  3. Verify users are making transactions

 

 

Error:
"Unable to load financial data"


Cause: Database connection or table issues
Solution:

  1. Verify database connection in config.inc.php
  2. Check all required tables exist
  3. Review MySQL error logs

 

 

Warning:
Charts not rendering


Cause: Chart.js CDN blocked or unavailable
Solution:

  1. Check network connectivity
  2. Verify CDN is accessible
  3. Check browser console for errors

 

 

Warning:
Tax export downloads empty file


Cause: No data for selected year
Solution:

  1. Select a year with transaction data
  2. Verify transactions exist in database

 

Performance Tips

 

Tip:
For large transaction volumes, the page may take longer to load. Consider:
  • Narrowing the date range
  • Filtering by specific transaction type
  • Using database indexes on createdat columns

 

Translatable Strings

The following strings should be added to backendtranslations.md:

financialreportstitle = "Financial Reports"
financialreportsbreadcrumb = "Financial Reports"
financialreportsback = "Back to Reports"
financialreportstokenusage = "Token Usage"
financialreportstokens = "Tokens"
financialreportsusd = "USD"
financialreportsreportoptions = "Report Options"
financialreportsdatefrom = "Date From"
financialreportsdateto = "Date To"
financialreportstransactiontype = "Transaction Type"
financialreportsalltypes = "All Types"
financialreportstips = "Tips"
financialreportssubscriptions = "Subscriptions"
financialreportsppvunlocks = "PPV Unlocks"
financialreportstokenpurchases = "Token Purchases"
financialreportswithdrawals = "Withdrawals"
financialreportsapplyfilters = "Apply Filters"
financialreportstaxexport = "Tax Season Export"
financialreportstokenpurchasesstat = "Token Purchases"
financialreportstipsvolume = "Tips Volume"
financialreportsplatformearnings = "Platform Earnings"
financialreportscreatorearnings = "Creator Earnings"
financialreportspendingwithdrawals = "Pending Withdrawals"
financialreportscompletedpayouts = "Completed Payouts"
financialreportsuniquespenders = "Unique Spenders"
financialreportsactivecreators = "Active Creators"
financialreportsrefunds = "Refunds"
financialreportsavgtransaction = "Avg Transaction"
financialreportstransactioninsights = "Transaction Insights"
financialreportssubscriptionhealth = "Subscription Health"
financialreportswithdrawalmetrics = "Withdrawal Metrics"
financialreportsrevenuetrends = "Revenue Trends"
financialreportstipsbycontent = "Tips by Content Type"
financialreportstokenvelocity = "Token Velocity"
financialreportsrevenuebysource = "Revenue by Source"
financialreportsplatformvscreator = "Platform vs Creator Split"
financialreportsdailytrend = "Daily Revenue Trend"
financialreportsbyhour = "By Hour"
financialreportsbymonth = "By Month"
financialreportsrevenuedetails = "Revenue Details"
financialreportstopcreators = "Top 100 Creators by Earnings"
financialreportstopusers = "Top 100 Users by Spending"
financialreportstransactionhistory = "Transaction History"
financialreportsnotransactions = "No transactions found for the selected period."

Version History

Version Date Changes
1.0 2025-12-12 Initial release with Phase 11 creator monetization

Related Pages