Reconciliation Workflow Guide

Master your daily certification and allocation workflow

What is Reconciliation?

Reconciliation is your central hub for managing organic product flow. It's where you:

  • 1.Certify incoming purchase orders - Add lot numbers and expiration dates to organic products you receive
  • 2.Allocate outgoing sales orders - Assign inventory lots to fulfill customer orders using FEFO (First-Expired-First-Out)
  • 3.Review auto-matched orders - See orders that were automatically allocated by the system

Why this matters: Every organic transaction must have full traceability for USDA compliance. Reconciliation ensures each sale can be traced back to a specific certified lot from a specific supplier.

Accessing Reconciliation

Click Reconciliation in the main menu at the top of your dashboard.

The reconciliation page has two tabs:

Pending Tab

Items that need your action - purchase orders awaiting certification and sales orders needing allocation.

Reconciled Tab

Historical view of certified purchase orders and allocated sales orders (up to 50 most recent items).

Within the Pending tab, you'll see three collapsible sections:

  • • 📥 Incoming Purchase Orders (needs certification)
  • • 📤 Outgoing Sales Orders (needs allocation)
  • • ✅ Recently Auto-Matched (info only)

Part 1: Certifying Purchase Orders

When to Certify

When you receive organic products from a supplier, you must certify the purchase order by adding lot information. This creates an "organic lot" in the system that can be allocated to sales orders.

1

Click on a Pending Purchase Order

In the "Incoming Purchase Orders" section of the Pending tab, you'll see a list of POs that need certification. Click on any row to expand it with an AJAX inline form.

Exclude Button: If a PO was cancelled in your accounting system, click the "Exclude" button to remove it from your pending list without certifying it.

2

Review PO Details

The expanded view shows:

  • • Supplier name
  • • PO number and date
  • • Each organic line item (SKU, name, quantity, price)
3

Fill in Certification Form

For each organic line item, you must provide:

LOT-2025-001

The unique lot number from your supplier's label or certificate

2025-12-31

Critical for FEFO allocation - expires soonest are allocated first

Check this if you've physically received the shipment

4

Submit Certification

Click "✓ Certify & Submit"

What happens next:

  • • The PO moves from the Pending tab to the Reconciled tab
  • • An organic lot is created in the system
  • • Inventory is updated (if marked as delivered)
  • • This lot can now be allocated to sales orders
  • • View it anytime in the Reconciled tab's certified POs section

💡 Best Practices for Certification

  • • Always use the lot number from the supplier's label or organic certificate
  • • Double-check expiration dates - they're critical for proper FEFO allocation
  • • Only mark as "delivered" when physically received (not when ordered)
  • • Keep supplier certificates on file - upload them in the Suppliers page

Part 2: Allocating Sales Orders

When to Allocate

Most sales orders are automatically allocated using FEFO. You only need to manually allocate when:

  • • Multiple lots are available and the system needs confirmation
  • • Partial allocations are needed (split across multiple lots)
  • • Insufficient inventory requires prioritization
1

Click on a Pending Sales Order

In the "Outgoing Sales Orders" section of the Pending tab, click on any SO that needs allocation. The row will expand with an inline allocation form.

Exclude Button: If a sales order was cancelled in your e-commerce system, click the "Exclude" button to remove it from your pending list without allocating inventory.

2

Review Order Details

The expanded view shows:

  • • Customer name and order number
  • • Order date and status
  • • Each organic line item needing allocation
  • • Available lots sorted by FEFO (expires soonest first)
3

Choose Lots to Allocate

For each line item, you'll see available lots:

LOT-2025-001

Expires: 2025-06-30

Available: 50 lbs

FEFO: Expires First

LOT-2025-002

Expires: 2025-12-31

Available: 100 lbs

Tip: Allocate from the first lot (FEFO recommendation) unless you have a specific reason to use a different lot

4

Submit Allocation

Click "✓ Allocate & Submit"

What happens next:

  • • The SO moves from the Pending tab to the Reconciled tab
  • • Inventory is deducted from the allocated lot(s)
  • • Full traceability is recorded (SO → Lot → PO → Supplier)
  • • View it anytime in the Reconciled tab's allocated SOs section

📦 Example: Split Allocation

Customer orders 75 lbs, but LOT-2025-001 only has 50 lbs available:

  • • Allocate 50 lbs from LOT-2025-001 (expires first)
  • • Allocate 25 lbs from LOT-2025-002 (expires later)
  • • Both allocations are recorded with full traceability

Part 3: Viewing Reconciled Items

What is the Reconciled Tab?

The Reconciled tab shows your completed work - purchase orders you've certified and sales orders you've allocated. This is your historical record of organic product flow.

📥Certified Purchase Orders

View the last 50 purchase orders you've certified with:

  • • Supplier name and PO number
  • • Lot number and expiration date you assigned
  • • Quantity and unit of measure
  • • Certification date and delivery status

📤Allocated Sales Orders

View the last 50 sales orders you've allocated with:

  • • Customer name and order number
  • • Lot allocations (which lots were used for this order)
  • • Total quantity fulfilled
  • • Allocation date

✏️Editing Reconciled Items

Each reconciled item has an "Edit" button for corrections.

Note: Editing reconciled items affects audit trail integrity. When you click Edit, you'll be prompted to contact support@organiko.ai to make corrections with proper audit logging.

Part 4: Excluding Cancelled Orders

When to Use the Exclude Button

If a purchase order or sales order was cancelled in your accounting/e-commerce system after syncing to Organiko.ai, use the Exclude button to remove it from your pending list without certifying or allocating it.

1

Locate the Cancelled Order

In the Pending tab, find the purchase order or sales order that was cancelled in your source system.

2

Click the Exclude Button

Each pending item has a red "Exclude" button on the right side.

Click it to mark the order as excluded.

3

Confirm Exclusion

A confirmation dialog will appear asking: "Are you sure you want to exclude this purchase order? This is for cancelled orders only."

Click OK to confirm.

4

What Happens

  • • The order is marked as "excluded" in the database
  • • It disappears from your Pending tab
  • • An audit note is added with your email and timestamp
  • • Any related notifications are dismissed
  • • The order will NOT appear in compliance reports

⚠️ Important: Only Exclude Cancelled Orders

  • • Only use Exclude for orders that were cancelled in your source system
  • • Do NOT exclude orders just because you don't want to certify them
  • • Excluded orders are permanently removed from reconciliation workflow
  • • If you exclude an order by mistake, contact support@organiko.ai to restore it

Part 5: Recently Auto-Matched Orders

The "Recently Auto-Matched" section shows sales orders that were automatically allocated by Organiko.ai without requiring your input.

When Does Auto-Matching Happen?

A sales order is auto-matched when:

  • • There's exactly one lot available for the SKU
  • • The lot has sufficient quantity
  • • The lot is not expired

Why This Matters: Auto-matching saves you time! Most orders (typically 80-90%) are allocated automatically. You only need to handle edge cases.

Your Daily Workflow

  1. 1

    Morning: Check Reconciliation

    Log in and go to Reconciliation page

  2. 2

    Certify New Purchase Orders

    Add lot numbers and expiration dates for received shipments (5-10 minutes)

  3. 3

    Allocate Pending Sales Orders

    Handle any orders that need manual allocation (5-10 minutes)

  4. 4

    Done!

    Everything else happens automatically. Check back tomorrow or when you receive notifications.

Time Investment: Most users spend 10-20 minutes per day on reconciliation. The rest is automated!

Common Questions

What if I enter the wrong lot number?

Contact support@organiko.ai to correct a lot number. We'll update the record while maintaining audit trail integrity.

Can I certify a PO before it's delivered?

Yes! Leave "Mark as delivered" unchecked. You can update the inventory later when it arrives. This is useful if you have the lot number from an advanced shipping notice.

What if I have insufficient inventory?

Sales orders that can't be fulfilled will remain in the "Pending" section with a warning. You can partially allocate what you have available, and allocate the rest when new inventory arrives.

How do I override FEFO allocation?

When manually allocating, you can choose any lot - not just the one that expires first. Simply enter quantities in the lot you prefer. However, FEFO is recommended for compliance and freshness.

Master Reconciliation

Questions about reconciliation?

Contact Support: support@organiko.ai