Where to Find Unreconciled Bank Rows in Blue Onion
🔍 1. Payout Summary — Your Starting Point
The Payout Summary is the central hub for reviewing all incoming payouts or bank deposits. To get to Payout Summary page, please follow the instructions below:
Login to your Blue Onion account
On the left hand side, click "Payout Summary"
Each line represents a payout and includes the following columns:
How to find unreconciled rows:
Apply Filters
Set Reconciliation Status or Status filters to:
Unreconciled
Unknown
This view gives you a quick read on which payouts still need attention and is often the best place to begin any investigation.
📊 2. General Ledger → Payouts Reconciliation
This GL-centric view is designed for accounting teams needing to validate financial integrity at the ledger level. It shows:
Summary of payout amounts vs. GL entries
Drill-down capabilities for GL vs. transaction variances
Use this view when:
You see a variance on the Payout Summary
You need to determine whether the variance stems from GL issues, timing, or transaction mapping
🚧 3. Cash In Transit
This area lists expected deposits (such as customer payments or orders) that haven't yet matched to a bank record.
Use this view when:
You have a known payout but the corresponding bank deposit hasn’t been reconciled
You suspect timing delays or processing lags between payment systems and bank feeds
This is useful for identifying legitimate in-transit funds vs. true mismatches.
🧾 4. Source Data → Payments
Here you’ll find raw payment and processor data imported into Blue Onion.
To find unreconciled payments:
Apply Filters
Bank Reconciliation Status
Reconciled: Payments that were matched to their corresponding bank transaction
Unreconciled: Payments that were not matched to a reconciled bank transaction
Order Reconciliation Status
Reconciled: Payments that were matched to their corresponding order or reconciled refund
Unreconciled: Payments that were not matched to a reconciled order or reconciled refund
📘 5. Journal Entries → Explorer (At Cash Receipt)
This view surfaces Cash Receipt Journal Entries, which represent posted bank entries in the ledger.
Use this view to:
Verify that a Journal Entry exists for a specific bank row
Check if the journal entry (JE) lines reflect the correct payout amount and related details.
This is where you go to ensure that the back-end accounting records align with bank activity and that nothing was missed or duplicated.
✅ Conclusion: Best Practices for Troubleshooting Unreconciled Rows
Unreconciled bank rows can have many root causes—timing issues, data delays, mismatched orders, or incorrect GL entries. The key is knowing where to look and how to interpret the information each view provides.
Quick Recap:
Start in Payout Summary for a high-level overview
Drill into GL Reconciliation or Source Data to investigate discrepancies
Use Cash In Transit for timing-related issues
Double-check Journal Entries - Explorer for missing or mismatched ledger entries