Revenue Reconciliation
FedEx/Webinterpret invoices, vendor balance, COGS, and monthly P&L without AI parsing.
Setup
CompanyVendor Payment
MatchReports
CSV / PrintNormal PDF Parse
PythonUpload a text-based PDF invoice or eBay logistics CSV. AARIA parses it with Python, detects FedEx, DHL, Webinterpret, EGS/FedEx duty/freight, or generic vendor format, and shows rows for review before saving.
Quick Entries
INRManual Expense
COGS
Profit Trend
Vendor Costs
Webinterpret Credit
Monthly P&L
Vendor Balance
All timeAccount P&L
INRMarket P&L
INRAnnual P&L
Manual Expenses
Payments
COGS Records
Confirmed Invoices
Invoice Lines
Financials
Net payout, eBay fees, refunds, and real SKU profit after eBay fees and our shipping cost.
Net Payout vs Gross Revenue
eBay Fee % by Category
Refund / Return Alerts
| Account | Refunds | Disputes | Fees | Action |
|---|
Real Profit per SKU
| SKU | Title | Revenue | Fees | Shipping | Real Profit |
|---|
eBay Expense Watch
Account expenses, sudden fee changes, and evidence that may need to be raised with eBay.
Expenses by Account ℹ
Expense Mix ℹ
Account Expense Summary ℹ
| Account ℹ | Gross Revenue ℹ | Sale Fees ℹ | Insertion Fees ℹ | Advertising ℹ | Store Plan ℹ | Listing Add-ons ℹ | Tax / Withholding ℹ | Total Expenses ℹ | Expense % ℹ | Open Alerts ℹ |
|---|
Charges to Review or Raise with eBay ℹ
Confirm category, second-category, relist, renewal, campaign, and package rules before raising a charge.
| Priority ℹ | Account | Date | Alert ℹ | Amount ℹ | Reason ℹ | Status ℹ | eBay Case ℹ | Note ℹ | Actions ℹ |
|---|
Charge Evidence Detail ℹ
| Account | Date | Fee Type | Description | Debit / Credit | Amount | Listing ID | Order ID | Transaction ID |
|---|
Account Health
Side-by-side health scorecard for all eBay accounts: seller level, feedback, defects, late shipment, and case risk.
Account Health Detail
| Account | Region | Seller Level | Positive % | Defect Rate | Late Shipment | Tracking On Time & Validated | Cases | Risk |
|---|
BBE / Service Metrics
Projected rate is the early-warning number. Lower is better. Rating compares Aeliya with similar eBay sellers.
| Account | BBE Type | Projected Rate | Current Rate | Rating | Cases | Transactions | Benchmark Avg |
|---|
Tracking & Order Action Control
Uploaded on time = tracking shipped date is on/before eBay ship-by date. Validated = carrier plus tracking number are both present.
| Account | Orders Needing Tracking | Tracking Uploaded | Validated | Uploaded On Time | Safer Cancel Count | Risky Cancel Count | Refund Possible |
|---|
Cancellation Reasons
| Reason | When to Use | Health Effect |
|---|
Refund Reasons
| Reason | When to Use | Type |
|---|
eBay Manager Scorecard
Shows what to improve without waiting for the account manager: listing quality, buyer visibility, tracking proof, promotions, and account-risk signals.
Imported eBay Manager File
| Imported Tab | Metric Values | Metric Names | First Period | Last Period |
|---|
Listing Hygiene Breakdown
What Needs Improvement
Scorecard Metric Detail
| Metric | Current | Previous | Change | Meaning |
|---|
Top Demand Lists
Monthly Management Synopsis
Target versus achievement, performance highlights, reasoned challenges, and next-month plan of action.
New Initiatives Taken This Month ℹ
Account Target vs Achievement ℹ
| Account ℹ | Gross Revenue ℹ | Revenue Target ℹ | Achievement ℹ | Month-on-Month ℹ | Orders ℹ | Refunded ℹ | Order Target ℹ |
|---|
Revenue Target vs Actual ℹ
Team Target vs Achievement ℹ
| Owner | Measure | Actual | Target | Achievement |
|---|
Monthly Order Outcomes ℹ
| Outcome ℹ | Order Count ℹ | Amount (USD) ℹ | What It Means ℹ | Data Source ℹ |
|---|
Account-wise Reconciliation ℹ
| Account | All Orders ℹ | All Order Amount | Paid Orders ℹ | Paid Amount | Fulfilled / Shipped ℹ | Shipped Amount | Cancelled | Cancelled Amount | Refunded | Refund Amount | Orders Stored Through ℹ |
|---|
Key Insights & Performance Highlights ℹ
Challenges Faced, with Reasons ℹ
Upcoming Month POA ℹ
Team Performance — Individual Breakdown
Per-executive production, errors, and attendance from Pricing and Listing apps.
🏷 Pricing Team (APEX)
| Executive | Submitted | Target | Achievement | Avg Price |
|---|---|---|---|---|
| Loading... | ||||
📋 Listing Team (ALIS)
| Executive | New Listed | New Target | New Achiev. | Updates | Upd. Target | Upd. Achiev. |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Key Takeaways
Monthly Management Synopsis — Email Format
eBay Selling Limits & Free Listing Allowances
The monthly selling ceiling and zero-insertion-fee listings are separate controls. Purchased add-ons are included only after admin records them from Seller Hub.
Admin: Add-on Packages & Seller Hub Usage ℹ
Account Limits and Fee Exemptions ℹ
| Account ℹ | Store Plan ℹ | Selling Ceiling ℹ | Ceiling Remaining ℹ | Store Base Free ℹ | Purchased Add-on ℹ | Total Free Fixed ℹ | Free Fixed Used ℹ | Free Fixed Remaining ℹ | Total Free Auctions ℹ | Main-Site Live ℹ |
|---|
Live Listings by Marketplace ℹ
| Account | eBay Site | Currency | Live Listings | Newest Update | Main Site |
|---|
Market Sold-Price Research
Compares your top revenue categories against sold-price market data. The eBay Marketplace Insights API needs special eBay approval, so ARIA uses CSV/imported market data unless approval is enabled.
Market Sold Median vs Your Average Price
Category Price Gap Detail
| Category | Your Avg | Market Median | Gap | Sample | Avg Days | Last Fetched |
|---|
eBay Meeting Brief
Account-wise before/after suspension-period impact, recovery evidence, and talking points for management and eBay.
eBay Sheet Data Source
| Imported Tab | Rows | Dated Rows | Account Rows | Revenue Found | Orders Found |
|---|
Before vs After Revenue
Impact Summary
| Metric | Before | After | Change |
|---|
Key Points to Present
Questions for eBay
Recovery Plan
Account-wise Impact
| Account | Before Revenue | After Revenue | Gap | Orders | AOV |
|---|
Top Lost Categories
| Category | Before | After | Gap |
|---|
Operational Signals
| Signal | Before | After | Meaning |
|---|
eBay Visibility & Health Evidence
Revenue Trend + 7-Day Rolling Average ℹ
Revenue by Account ℹ
Account Performance Summary
| Account | Orders | Revenue ℹ | AOV ℹ | Listings ℹ | Conv/1000 ℹ | Rev/Listing ℹ |
|---|
Daily Revenue + 7-Day Rolling Avg ℹ
Day-of-Week Revenue Pattern ℹ
Top 25 Revenue SKUs ℹ
| # | SKU | Account | Title | Orders ℹ | Units ℹ | Revenue ℹ | Avg Price ℹ | Zoho Stock ℹ | History ℹ |
|---|
Revenue by Account – Full Detail
| Account | Orders | Revenue | AOV ℹ | Active Listings ℹ | Conv/1000 ℹ | Rev/Listing ℹ |
|---|
Zoho Inventory Intelligence
Source: catalog.db → zoho_inventory. Grouped by brand / manufacturer; Zoho category is not used because it is mostly empty. Cross-referenced with eBay orders & sold_history.
Stock by Brand / Manufacturer ℹ
Sell Velocity by Brand / Manufacturer ℹ
🚨 Restock Alerts — Sold Items at Zero/Critical Stock ℹ
CRITICAL = Zoho stock = 0. WARNING = Zoho stock = 1. Sorted: urgency first, then last sold price (highest = most valuable to restock).
| Urgency ℹ | SKU | Item Name | Account ℹ | Last Price ℹ | Last Sold ℹ | Zoho Stock ℹ | Brand ℹ | History ℹ |
|---|
⚡ Last Piece Watch — eBay qty=1 + Zoho stock≤1 ℹ
When these sell you're instantly out of stock. Begin sourcing Critical items now.
| Priority ℹ | Account | SKU | Title | Price ℹ | Zoho Stock ℹ | History ℹ | eBay Orders ℹ | Brand |
|---|
🔁 Repeat Sellers — 3+ Sales in Zoho History ℹ
| SKU | Item Name | Brand ℹ | Times Sold ℹ | Max Price ℹ | Zoho Stock ℹ |
|---|
Daily New Listings vs Same-Day Revenue ℹ
Listing Pipeline Status ℹ
Listing Team — 30-Day Leaderboard ℹ
| Exec | New Listings ℹ | Updates ℹ | Active Days | Last Active |
|---|
Pricing Team — Activity ℹ
| Exec | Checks ℹ | Changes ℹ | Sold Marks ℹ | Last Active |
|---|
Daily Price Pushes vs Same-Day Revenue ℹ
Inventory Health by Account ℹ
KPIs
Dead Stock — 2+ Units, Zero eBay Sales ℹ
Sorted by stock value (price × qty). 'In Orders' = SKU appears in at least 1 PAID eBay order despite showing no snapshot sales.
| Account | SKU | Title | Price ℹ | Stock ℹ | Value ℹ | Days Listed ℹ | Zoho Stock ℹ | In Orders ℹ |
|---|
Daily Price Pushes by Account (Last 20 Days) ℹ
ABC Inventory — Velocity Classification ℹ
Pareto 80/20 — Revenue Concentration ℹ
Listing Age — eBay Cassini SEO Risk ℹ
Sell-Through Rate by Brand / Manufacturer ℹ
Green ≥50% STR · Yellow 20-49% · Red <20% (slow-moving)
Product Category Sales — Revenue by Category ℹ
Revenue Anomaly Detection i
SKU Lifecycle Tracker i
Revenue Intelligence & Campaign Recommendations
11 strategic frameworks applied to live data. Each card shows the framework, evidence from your data, and a specific action.
🧠 Self-Learning Patterns ℹ
Patterns confirmed from your data across sessions. Confidence grows each re-confirmation. ↑ = positive trend, ↓ = risk.
🔌 eBay API Sync Readiness
OAuth token status per account. Green = valid token. Sync Traffic pulls eBay Analytics impressions/views/CTR. Sync Offers checks Seller Initiated Offer eligibility for listings with watchers.
| Account | Token Status ℹ | Expires ℹ | Traffic Sync ℹ | Offers Sync ℹ |
|---|
📥 CSV Import Fallback
Use when API sync is unavailable. Download CSVs from eBay Seller Hub → Reports. Each import replaces the previous CSV data for that type.
eBay Seller Hub → Reports → Traffic Report. Columns: Listing ID, Title, Impressions, CTR, Page Views, Transactions.
eBay Seller Hub → Marketing → Promoted Listings → Reports. Columns: Campaign, Item ID, Impressions, Clicks, CTR, Spend, Revenue, ROAS.
eBay Seller Hub → Orders → Best Offers or SIO report. Columns: Item ID, Title, Price, Watchers, Best Offer Eligible, SIO Eligible.
eBay Research or Terapeak export. Columns: SKU, Item Name, Avg Sold Price, Min Price, Max Price, Total Sold, Sell Through Rate.
📊 Traffic Performance — Listing Level ℹ
Source: eBay Analytics API (Sync Traffic) or CSV import. Last 30 days by default.
| Account | Item # | Title | Impressions ℹ | CTR ℹ | Views ℹ | Search Views ℹ | Sales ℹ | Source |
|---|
🔍 Listing Ranking & Health Report ℹ
Run Sync Traffic first. Sync twice over different periods to unlock trend comparison (rising vs falling).
🤝 Interested Buyer Offer Eligibility ℹ
Eligible = you can send an SIO. Watchers = interested buyers. Sort by watchers to find best SIO candidates.
| Account | Item # | Title | Price ℹ | Watchers ℹ | SIO Eligible ℹ | Best Offer ℹ | Source |
|---|
📢 Promoted Listings — Ad Performance ℹ
Source: CSV import only. Download from eBay Seller Hub Promoted Listings reports.
| Account | Campaign | SKU | Item # | Impressions ℹ | Clicks ℹ | CTR ℹ | Spend ℹ | Revenue ℹ | ROAS ℹ | Date |
|---|
📈 Market Prices / Terapeak Research ℹ
Source: CSV import only. Download from eBay Research or Terapeak product research tool.
| SKU | Item Name | Avg Sold Price ℹ | Min Price ℹ | Max Price ℹ | Total Sold ℹ | Sell-Through % ℹ | Period |
|---|