Understanding Order Transactions Report for Mixed Payment Methods

Overview

When processing orders with multiple payment methods (such as partial cash and partial credit card payments), PayHelm's standard reports may initially display only one payment type per order. This can create confusion when reconciling payments, especially for businesses that accept split payments. The Order Transactions report provides detailed visibility into all payment methods used for each order.

Common Payment Method Reporting Issues

Mixed Payment Orders

Many businesses encounter situations where customers pay using multiple methods:

• Partial cash + partial credit card
• Multiple credit cards for a single order
• Gift cards + credit card combinations
• Store credit + cash payments

Standard Report Limitations

PayHelm's standard payment reports may show:

• Only the primary payment method
• Aggregated totals without payment method breakdown
• Single payment type per order line

Example Issue: An order totaling $398 might show as "credit card" in standard reports, even though it was actually paid with $372 credit card + $26 cash.

Solution: Order Transactions Report

What is the Order Transactions Report?

The Order Transactions report is a detailed view that shows:

• Individual transaction lines for each payment method per order
• Complete payment breakdown showing exact amounts for each payment type
• Transaction-level detail rather than order-level summaries
• All payment methods used including cash, credit cards, and alternative payments

Accessing the Order Transactions Report

1. Navigate to Reports Section

• Log into your PayHelm dashboard
• Go to the "Reports" tab in the main navigation

2. Find Order Transactions

• Look for "Order Transactions" in your available reports list
• This report may be located in the "Transaction Reports" or "Payment Reports" category

3. Apply Date Filters

• Set your desired date range to focus on specific time periods
• Use filters to narrow down to specific payment methods if needed

Understanding the Report Data

Transaction Line Details:

• Each payment method appears as a separate line item
• Shows exact amount processed through each payment type
• Includes transaction IDs and payment processor information
• Displays timestamps for each payment component

Payment Method Breakdown:

• Cash transactions
• Credit card types (Visa, Mastercard, Discover, American Express)
• Alternative payment methods
• Store credits and gift card usage

Use Cases for Order Transactions Report

Financial Reconciliation

• Daily Cash Reconciliation: Match cash payments to register totals
• Credit Card Processing: Verify card transaction amounts with processor statements
• Mixed Payment Analysis: Understand customer payment preferences

Accounting and Bookkeeping

• Payment Method Reporting: Generate detailed breakdowns by payment type
• Tax Preparation: Accurate reporting of cash vs. card sales
• Audit Trail: Complete transaction history for compliance

Business Intelligence

• Payment Trends: Analyze how customers prefer to pay
• Cash Flow Management: Track cash vs. electronic payment ratios
• Seasonal Analysis: Compare payment method usage across different periods

Troubleshooting Mixed Payment Issues

If You Still See Discrepancies

1. Verify Integration Settings

• Ensure your POS system properly sends all payment data to PayHelm
• Check that partial payments are being recorded correctly

2. Check Data Sync Timing

• Mixed payment orders may take additional time to process completely
• Allow for processing delays when checking recent transactions

3. Review Order Details

• Cross-reference with your POS system's order details
• Verify that all payment components were captured during the sale

When to Contact Support

Contact PayHelm support if:

• Order Transactions report still shows incomplete payment data
• You need assistance setting up the report for your specific needs
• Payment amounts consistently don't match your POS records
• You need help interpreting the transaction-level data

Alternative Report Formats

PayHelm may offer the Order Transactions data in different formats:

• Detailed CSV Export: For further analysis in spreadsheet applications
• Summary Reports: Aggregated views by payment method
• Custom Report Builder: Create tailored views for specific business needs

Ask your PayHelm support team about additional reporting options that might better suit your business requirements.

Best Practices

Regular Monitoring

• Review Order Transactions reports daily for cash reconciliation
• Set up automated reports for consistent payment method tracking
• Monitor for any discrepancies between POS and PayHelm data

Documentation

• Keep records of mixed payment policies and procedures
• Document any recurring payment method issues for support reference
• Maintain audit trails for financial compliance requirements

The Order Transactions report provides the detailed payment visibility needed for accurate financial reporting and reconciliation when dealing with complex payment scenarios.