Platform: Enolytics DTC
Summary:
What it shows: A comprehensive payment breakdown for all paid orders, showing exactly how customers paid and what they paid for. This ready-made report filters out complimentary orders (1) excludes $0 orders so you see only actual revenue transactions. No setup needed — just run it and go.
Who should use it:
• Accounting teams reconciling payment processing fees and deposits
• Finance managers analyzing payment method preferences and processing costs
When to use it:
• Monthly reconciliation of credit card processing statements with actual sales
• Analyzing payment method trends to negotiate better processing rates
• Auditing discrepancies between your POS system and payment processor reports
Questions this report answers:
• "How do I pull a report showing all credit card transactions with processing details?"
• "Where can I see a breakdown of how customers are paying for their orders?"
• "Can I get a list of all orders with the exact tender amounts and card brands?"
• "How do I reconcile my Square/Stripe fees with what actually processed?"
• "Where can I find order-level payment data for my accountant?"
Tip: Use the Completed Date column with your date picker to match specific reconciliation periods — this ensures your payment data aligns perfectly with your processing statements.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: Accounting Reports
Click Order Tender Report
Quick Stats:
1 filter(s) applied
5 dimension(s) displayed
6 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
⚠️ Date Picker Required: This report uses time-sensitive measures that respond to the date picker. The bookmark does not save date picker settings. Please adjust the date picker to ensure the report shows the data for your desired time period.
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Order Tender Report shows comprehensive payment breakdown for all paid orders, displaying exactly how customers paid and what they paid for.
Filters Applied
The following filters narrow down the data in this bookmark:
Dimension Filters:
Is 0 Dollar Order is one of: False
📋 Columns Displayed
Dimensions:
Completed Date — This is the to local time zone converted date of the order_completed_at (UTC timestamp)
Order Number — The actual order number of the order (normally represented in numeric format but we will use it as a string)
Tender Type — The type of tender used for payment. These are enums like: Credit Card, Cash, COD, External, etc.
Amount Tendered — Order amount paid via the payment gateway, does not include the tip_tendered
Card Brand — The brand of the credit card used for payment. (Visa, Amex, Mastercard, etc.)
Measures:
ℹ️ Additional Details
Bookmark ID:
137c3f56-2dee-4842-8566-fa187a3bd9a4