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
}
]
}
Get the reconciliation worksheet with transactions
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
}
]
}
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
}
]
}