Skip to main content

Custom GL Reconciliation Tolerance

Set the maximum dollar difference allowed for automatic transaction matching between your payment processor and general ledger. Transactions within this tolerance will auto-reconcile; those exceeding it require manual review. Default: $0.02|Maximum: $1.00

B
Written by Brian Webb
Updated over 2 weeks ago

Overview

Blue Onion allows you to configure your own tolerance level for General Ledger reconciliation matching. This feature helps you balance reconciliation accuracy with operational efficiency by adjusting how closely transactions need to match before they're automatically reconciled.

What This Feature Does

The GL reconciliation tolerance setting determines the maximum dollar amount difference that Blue Onion will accept when matching transactions between your payment processor records and general ledger entries. When transaction amounts are within your specified tolerance, they'll automatically reconcile. Transactions that exceed the tolerance will require manual review.

Default Setting: $0.02 (2 cents) Maximum Allowed: $1.00

Why Adjust Your Tolerance?

Small discrepancies between systems are common due to:

  • Foreign exchange rate differences between when transactions are recorded in different systems

  • Sales tax calculation variations based on rounding or timing

  • Standard rounding differences in multi-step calculations

For high-volume businesses, these small mismatches can create hundreds of items requiring manual reconciliation, even when the differences are immaterial to your financial reporting.

How to Configure Your Tolerance

  1. Navigate to General Ledger in your Blue Onion dashboard

  2. Click on Configuration

  3. Select Reconciliation Tolerance

  4. Enter your desired tolerance amount (between $0.01 and $1.00)

  5. Save your changes

Your new tolerance will apply to all future GL reconciliation runs. This will require our pipeline to reprocess which will begin overnight after the change is made.

Choosing the Right Tolerance

Consider these factors when setting your tolerance:

  • Transaction volume: Higher volume businesses may benefit from a higher tolerance to reduce manual work

  • Average transaction size: Ensure your tolerance is immaterial relative to your typical transaction amounts

  • Reconciliation quality standards: Balance automation efficiency with your accuracy requirements

  • Common discrepancy patterns: Review your recent mismatches to understand typical variance amounts

We recommend starting conservatively and adjusting based on your reconciliation results over time.

Need Help?

If you're unsure what tolerance level is right for your business, contact your Customer Success Manager or chat with us in the app to discuss your specific reconciliation patterns and volume.


Did this answer your question?