Skip to main content
GET
/
service
/
general-ledger
/
reconciliations
/
{reconciliation_id}
/
worksheet
curl -X GET https://kube.acho.io/service/general-ledger/reconciliations/recon-2024-001/worksheet \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "reconciliation_id": "recon-2024-001",
  "summary": {
    "statement_ending_balance": 50000.00,
    "gl_ending_balance": 52000.00,
    "cleared_deposits": 30000.00,
    "cleared_withdrawals": 25000.00,
    "cleared_balance": 50000.00,
    "uncleared_deposits": 5000.00,
    "uncleared_withdrawals": 3000.00,
    "uncleared_balance": 2000.00,
    "bank_adjustments": 0,
    "book_adjustments": 0,
    "difference": 0
  },
  "cleared_transactions": [
    {
      "transaction_id": "txn-001",
      "date": "2024-01-05",
      "type": "deposit",
      "description": "Customer payment - ABC Corp",
      "reference": "PMT-2024-001",
      "amount": 15000.00,
      "cleared_date": "2024-01-06"
    },
    {
      "transaction_id": "txn-002",
      "date": "2024-01-10",
      "type": "withdrawal",
      "description": "Vendor payment - XYZ Supplies",
      "reference": "BP-2024-001",
      "amount": -8000.00,
      "cleared_date": "2024-01-11"
    }
  ],
  "uncleared_transactions": [
    {
      "transaction_id": "txn-010",
      "date": "2024-01-28",
      "type": "deposit",
      "description": "Customer payment - DEF Inc",
      "reference": "PMT-2024-015",
      "amount": 5000.00
    },
    {
      "transaction_id": "txn-011",
      "date": "2024-01-30",
      "type": "withdrawal",
      "description": "Check #1234",
      "reference": "BP-2024-020",
      "amount": -3000.00
    }
  ]
}

Request

Get the reconciliation worksheet with cleared/uncleared transactions and balance summary.

Path Parameters

reconciliation_id
string
required
The reconciliation session ID
curl -X GET https://kube.acho.io/service/general-ledger/reconciliations/recon-2024-001/worksheet \
  -H "Authorization: jwt YOUR_TOKEN"
{
  "reconciliation_id": "recon-2024-001",
  "summary": {
    "statement_ending_balance": 50000.00,
    "gl_ending_balance": 52000.00,
    "cleared_deposits": 30000.00,
    "cleared_withdrawals": 25000.00,
    "cleared_balance": 50000.00,
    "uncleared_deposits": 5000.00,
    "uncleared_withdrawals": 3000.00,
    "uncleared_balance": 2000.00,
    "bank_adjustments": 0,
    "book_adjustments": 0,
    "difference": 0
  },
  "cleared_transactions": [
    {
      "transaction_id": "txn-001",
      "date": "2024-01-05",
      "type": "deposit",
      "description": "Customer payment - ABC Corp",
      "reference": "PMT-2024-001",
      "amount": 15000.00,
      "cleared_date": "2024-01-06"
    },
    {
      "transaction_id": "txn-002",
      "date": "2024-01-10",
      "type": "withdrawal",
      "description": "Vendor payment - XYZ Supplies",
      "reference": "BP-2024-001",
      "amount": -8000.00,
      "cleared_date": "2024-01-11"
    }
  ],
  "uncleared_transactions": [
    {
      "transaction_id": "txn-010",
      "date": "2024-01-28",
      "type": "deposit",
      "description": "Customer payment - DEF Inc",
      "reference": "PMT-2024-015",
      "amount": 5000.00
    },
    {
      "transaction_id": "txn-011",
      "date": "2024-01-30",
      "type": "withdrawal",
      "description": "Check #1234",
      "reference": "BP-2024-020",
      "amount": -3000.00
    }
  ]
}