Overview
You can now filter your Orders, Revenue Recognition, and Cancellations journal entry templates by Order Reconciliation Status. This allows you to split out reconciled versus unreconciled orders directly within your journal entries — making it easier to identify which orders have been matched to a payment and which ones may need to be handled manually.
This is especially useful if you work with payment processors that Blue Onion does not currently integrate with (e.g., Truemed, certain buy-now-pay-later providers). With this filter, you can isolate unreconciled orders into a separate template and manage the full order-to-cash process for those transactions on your own, while letting Blue Onion handle the rest.
Which Journal Entry Types Support This Filter?
This filter is available on the following journal entry types:
Orders
Revenue Recognition
Cancellations
This filter is not available on Cash Receipt or other payout-based journal entries, as those are driven by settlement data rather than order data.
How to Use the Filter
Navigate to Journal Entries > Templates
Open an existing template or create a new one for Orders, Revenue Recognition, or Cancellations
In the Filters section, you will see Order Reconciliation Status as an available filter option
Select the status you want to filter by:
Reconciled — Orders that have been matched to a payment in Blue Onion
Unreconciled — Orders that have not yet been matched to a payment
Save your template
You can create separate templates for reconciled and unreconciled orders if you want to journal them differently. For example:
Template A — "Orders (Reconciled)": Filtered to reconciled orders only. These are orders where Blue Onion has matched the payment and you can rely on the full journal entry lifecycle.
Template B — "Orders (Unreconciled)": Filtered to unreconciled orders only. These may include orders paid through unsupported payment processors that you need to book manually.
Important Note: Adjustments Are Expected
When using this filter, you may notice Adjustments appearing in your journal entries. This is expected behavior.
An order's reconciliation status can change between processing runs — for example, an order that was unreconciled yesterday may become reconciled today once the payment settles and is matched. When this happens, Blue Onion will generate an adjustment to move that order from the unreconciled template to the reconciled template so that your journal entries stay accurate.
Common Use Cases
Unsupported Payment Processors: If you use a payment processor that Blue Onion doesn't integrate with (e.g., Truemed), those orders will remain unreconciled because there's no payment data to match against. You can create a separate unreconciled template to isolate these orders and handle the journal entries for them manually in your accounting system.
Reconciliation Visibility: Even if all your payment processors are integrated, this filter gives you visibility into which orders have been fully matched versus which ones are still pending reconciliation. This can be helpful during month-end close to ensure nothing is missed.
Splitting Journal Entries for Review: Some customers prefer to review unreconciled orders separately before posting them. Creating a filtered template lets you do this without having to manually sort through a combined export.
Questions?
If you have any questions about this feature or need help setting up your templates, please reach out to [email protected].