eParkiet LogoeParkiet
Reports

Financial Reports

Understanding financial data and payment tracking in eParkiet

Overview

Guide to understanding and managing financial information in eParkiet, including payment tracking, revenue monitoring, and data export for accounting purposes.

Accessing Financial Information

Financial Data in eParkiet

Where to Find Financial Information:

  1. Payments Section - Access payment tracking and transaction information
  2. Reports Section - View basic financial analytics and summaries
  3. Tournament Dashboard - See revenue information for specific tournaments
  4. Participant Records - Check individual payment statuses

Available Financial Data

Payment Information:

  • Individual participant payment statuses
  • Transaction histories and payment methods
  • Revenue totals by tournament
  • Payment processing fee information

Basic Analytics:

  • Total revenue over selected time periods
  • Payment completion rates
  • Most popular payment methods
  • Basic financial performance metrics

System Capability: eParkiet provides basic financial tracking and reporting. For advanced accounting features, export data to external accounting software.

Revenue Tracking

Tournament Revenue Information

Access Tournament Financial Data

  1. Navigate to your Reports section
  2. Select date range for analysis
  3. Filter by specific tournaments if needed
  4. Review revenue totals and payment status

Revenue Components

  • Registration Fees - Category fees collected from participants
  • Payment Processing Fees - Stripe and other processing costs
  • Net Revenue - Total income after processing fees
  • Outstanding Payments - Unpaid registrations

Export Financial Data

  • Excel Format - Detailed spreadsheet for analysis
  • CSV Format - Raw data for importing into accounting software
  • PDF Format - Professional reports for documentation

Financial Performance Tracking

Key Metrics Available:

  • Total revenue by tournament
  • Payment completion rates
  • Average transaction values
  • Processing fee costs
  • Refund amounts and frequency

Time Period Analysis:

  • Use date range filters to analyze specific periods
  • Compare tournament performance over time
  • Track seasonal revenue patterns
  • Monitor payment method preferences

Payment Transaction Management

Transaction Information

Payment Records Include:

  • Participant name and contact information
  • Tournament and category registrations
  • Payment amounts and methods used
  • Transaction dates and confirmation status
  • Processing fees and net amounts

Payment Status Tracking

Payment Monitoring:

  • Completed - Successfully processed payments
  • Pending - Payments in process
  • Failed - Unsuccessful payment attempts
  • Refunded - Returned payments
  • Outstanding - Unpaid registrations

Transaction Information:

  • Payment method (Stripe, PayPal, bank transfer, cash)
  • Transaction timestamps and references
  • Processing fees and net amounts
  • Participant registration details
  • Payment confirmation status

Financial Analysis:

  • Total revenue by payment method
  • Processing fee calculations
  • Net revenue after fees
  • Payment success rates
  • Refund impact on total revenue

Processing Fees and Costs

Fee Information:

  • Stripe Processing Fees - Credit card and payment processing costs
  • International Fees - Additional fees for international participants
  • Currency Conversion - Exchange rate costs when applicable
  • Net Revenue Calculation - Revenue minus all processing fees

Accounting and Tax Information

Financial Data Export for Accounting

Prepare Financial Data

  1. Navigate to Reports section
  2. Select the appropriate date range
  3. Choose tournaments to include in report
  4. Review revenue and payment information

Export Transaction Data

  1. Select export format (Excel, CSV, or PDF)
  2. Choose to include detailed transaction information
  3. Export complete financial records
  4. Save exported data securely

Accounting Integration

  • Transaction Records - Complete payment history
  • Revenue Summaries - Total income by period
  • Processing Fees - Detailed fee breakdowns
  • Tax Information - Data needed for tax preparation

Tax Preparation Data

Information Available for Taxes:

  • Gross Revenue - Total income from tournaments
  • Processing Fees - Business expenses for payment processing
  • Net Income - Revenue minus processing costs
  • Transaction Records - Detailed payment documentation
  • Participant Information - For invoice and receipt records

Tax Considerations:

  • Export detailed transaction records for tax filing
  • Include processing fees as business expenses
  • Maintain records for required retention periods
  • Consult with tax professional for specific requirements

Working with Financial Data

Data Export and Analysis

Export Options:

  1. Excel Spreadsheets - Detailed financial data with formulas and formatting
  2. CSV Files - Raw data for importing into accounting or analysis software
  3. PDF Reports - Professional formatted summaries for documentation

Data Filtering:

  • Date Ranges - Select specific time periods for analysis
  • Tournament Selection - Focus on specific events
  • Payment Status - Filter by payment completion status
  • Revenue Metrics - Include or exclude processing fees

Using Exported Data

Accounting Software Integration:

  • Export transaction data to Excel or CSV
  • Import into QuickBooks, Xero, or other accounting software
  • Match revenue records with bank deposits
  • Track business expenses and processing fees

Financial Analysis:

  • Create custom spreadsheet reports using exported data
  • Analyze revenue trends over time
  • Compare tournament performance
  • Calculate return on investment for events

Best Practices for Financial Management

Regular Financial Monitoring

Weekly Tasks:

  • Review payment completion rates
  • Monitor outstanding payments
  • Check for failed payment attempts
  • Process any necessary refunds

Monthly Tasks:

  • Export financial data for accounting
  • Review total revenue and processing fees
  • Analyze payment method performance
  • Reconcile with bank deposits

Record Keeping

Financial Documentation:

  • Export Regular Reports - Monthly financial summaries
  • Transaction Records - Detailed payment histories
  • Processing Fee Documentation - For business expense tracking
  • Refund Records - Documentation for returned payments

Compliance and Audit:

  • Maintain financial records for required retention periods
  • Keep documentation for tax preparation
  • Store exported data securely
  • Regular backup of financial information

Integration with External Tools

Accounting Software:

  • Export Data Regularly - Use CSV or Excel exports for accounting software
  • Match Bank Records - Reconcile exported data with bank statements
  • Track Expenses - Include payment processing fees as business expenses
  • Professional Support - Work with accountant for proper categorization

Tax Preparation:

  • Annual Data Export - Complete financial records for tax filing
  • Revenue Documentation - Gross income from tournament operations
  • Expense Records - Processing fees and other business costs
  • Professional Consultation - Work with tax professional for compliance

Financial Management Tip: Regular data export and consistent record keeping will simplify your accounting and tax preparation processes significantly.


Next Steps