Skip to main content
Glama

Tokenbooks - crypto and fiat accounting and payments

Import Adjustment Journals

import_adjustment_journals

Preview or post a complete CSV or XLSX file of balanced manual adjustment journals for one portfolio. Preview first; post only after reviewing every blocking issue, then resend the unchanged source with its preview token and any resolutions.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
actionYespreview: Parse the file and report what it would import, writing nothing. Always preview before posting. post: Commit the import that a preview of the same file produced.
fileNameYesOriginal CSV or XLSX source filename.
resolutionsNoOnly for action post; required for each.
portfolioRefYesPortfolio name or slug inside that workspace. Call list_portfolios to resolve it.
previewTokenNoToken returned by the matching preview, proving the file has not changed since. Only for action post; required for each.
workspaceRefYesWorkspace name or slug. Call list_workspaces to resolve it.
contentBase64YesCSV or XLSX source file content as base64-encoded bytes (max 5 MiB).

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
actionYes
issuesNo
summaryNo
journalsYes
importRefNo
readyToPostNo
previewTokenNo
createdJournalCountNo
omittedJournalCountYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed4 schema fields changed
    • removedInput schema / oneOf
      Removed value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "description": "Parse the file and report what it would import, writing nothing. Always preview before posting.",
      -        "enum": [
      -          "preview"
      -        ],
      -        "type": "string"
      -      },
      -      "contentBase64": {
      -        "$ref": "#/properties/contentBase64"
      -      },
      -      "fileName": {
      -        "$ref": "#/properties/fileName"
      -      },
      -      "portfolioRef": {
      -        "$ref": "#/properties/portfolioRef"
      -      },
      -      "workspaceRef": {
      -        "$ref": "#/properties/workspaceRef"
      -      }
      -    },
      -    "required": [
      -      "workspaceRef",
      -      "portfolioRef",
      -      "action",
      -      "contentBase64",
      -      "fileName"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "description": "Commit the import that a preview of the same file produced.",
      -        "enum": [
      -          "post"
      -        ],
      -        "type": "string"
      -      },
      -      "contentBase64": {
      -        "$ref": "#/properties/contentBase64"
      -      },
      -      "fileName": {
      -        "$ref": "#/properties/fileName"
      -      },
      -      "portfolioRef": {
      -        "$ref": "#/properties/portfolioRef"
      -      },
      -      "previewToken": {
      -        "$ref": "#/properties/previewToken"
      -      },
      -      "resolutions": {
      -        "$ref": "#/properties/resolutions"
      -      },
      -      "workspaceRef": {
      -        "$ref": "#/properties/workspaceRef"
      -      }
      -    },
      -    "required": [
      -      "workspaceRef",
      -      "portfolioRef",
      -      "action",
      -      "contentBase64",
      -      "fileName",
      -      "previewToken",
      -      "resolutions"
      -    ],
      -    "type": "object"
      -  }
      -]
    • changedInput schema / properties / action / description
      Previous value: -"Parse the file and report what it would import, writing nothing. Always preview before posting."New value: +"preview: Parse the file and report what it would import, writing nothing. Always preview before posting. post: Commit the import that a preview of the same file produced."
    • changedInput schema / properties / previewToken / description
      Previous value: -"Token returned by the matching preview, proving the file has not changed since."New value: +"Token returned by the matching preview, proving the file has not changed since. Only for action post; required for each."
    • addedInput schema / properties / resolutions / description
      Added value: +"Only for action post; required for each."
  2. Changed3 schema fields changed
    • changedOutput schema / oneOf
      Previous value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "const": "preview",
      -        "type": "string"
      -      },
      -      "issues": {
      -        "oneOf": [
      -          {
      -            "$ref": "#/$defs/AjFullIssues"
      -          },
      -          {
      -            "$ref": "#/$defs/AjIssueSummary"
      -          }
      -        ]
      -      },
      -      "journals": {
      -        "items": {
      -          "$ref": "#/$defs/AjPreviewJournal"
      -        },
      -        "maxItems": 3,
      -        "type": "array"
      -      },
      -      "omittedJournalCount": {
      -        "maximum": 9007199254740991,
      -        "minimum": 0,
      -        "type": "integer"
      -      },
      -      "previewToken": {
      -        "pattern": "^[0-9a-f]{64}$",
      -        "type": "string"
      -      },
      -      "readyToPost": {
      -        "type": "boolean"
      -      },
      -      "summary": {
      -        "$ref": "#/$defs/AjPreviewSummary"
      -      }
      -    },
      -    "required": [
      -      "action",
      -      "previewToken",
      -      "readyToPost",
      -      "summary",
      -      "journals",
      -      "omittedJournalCount",
      -      "issues"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "const": "post",
      -        "type": "string"
      -      },
      -      "createdJournalCount": {
      -        "exclusiveMinimum": 0,
      -        "maximum": 9007199254740991,
      -        "type": "integer"
      -      },
      -      "importRef": {
      -        "maxLength": 128,
      -        "minLength": 1,
      -        "pattern": "^adjustment-journal-import-[a-z0-9-]+$",
      -        "type": "string"
      -      },
      -      "journals": {
      -        "items": {
      -          "$ref": "#/$defs/AjPostJournal"
      -        },
      -        "maxItems": 3,
      -        "type": "array"
      -      },
      -      "omittedJournalCount": {
      -        "maximum": 9007199254740991,
      -        "minimum": 0,
      -        "type": "integer"
      -      }
      -    },
      -    "required": [
      -      "action",
      -      "importRef",
      -      "createdJournalCount",
      -      "journals",
      -      "omittedJournalCount"
      -    ],
      -    "type": "object"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "action": {
      +        "const": "preview",
      +        "type": "string"
      +      },
      +      "issues": {
      +        "oneOf": [
      +          {
      +            "$ref": "#/$defs/AjFullIssues"
      +          },
      +          {
      +            "$ref": "#/$defs/AjIssueSummary"
      +          }
      +        ]
      +      },
      +      "journals": {
      +        "items": {
      +          "$ref": "#/$defs/AjPreviewJournal"
      +        },
      +        "maxItems": 3,
      +        "type": "array"
      +      },
      +      "omittedJournalCount": {
      +        "maximum": 9007199254740991,
      +        "minimum": 0,
      +        "type": "integer"
      +      },
      +      "previewToken": {
      +        "pattern": "^[0-9a-f]{64}$",
      +        "type": "string"
      +      },
      +      "readyToPost": {
      +        "type": "boolean"
      +      },
      +      "summary": {
      +        "$ref": "#/$defs/AjPreviewSummary"
      +      }
      +    },
      +    "required": [
      +      "action",
      +      "previewToken",
      +      "readyToPost",
      +      "summary",
      +      "journals",
      +      "omittedJournalCount",
      +      "issues"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "action": {
      +        "const": "post",
      +        "type": "string"
      +      },
      +      "createdJournalCount": {
      +        "maximum": 9007199254740991,
      +        "minimum": 1,
      +        "type": "integer"
      +      },
      +      "importRef": {
      +        "maxLength": 128,
      +        "minLength": 1,
      +        "pattern": "^adjustment-journal-import-[a-z0-9-]+$",
      +        "type": "string"
      +      },
      +      "journals": {
      +        "items": {
      +          "$ref": "#/$defs/AjPostJournal"
      +        },
      +        "maxItems": 3,
      +        "type": "array"
      +      },
      +      "omittedJournalCount": {
      +        "maximum": 9007199254740991,
      +        "minimum": 0,
      +        "type": "integer"
      +      }
      +    },
      +    "required": [
      +      "action",
      +      "importRef",
      +      "createdJournalCount",
      +      "journals",
      +      "omittedJournalCount"
      +    ],
      +    "type": "object"
      +  }
      +]
    • removedOutput schema / properties / createdJournalCount / exclusiveMinimum
      Removed value: -0
    • addedOutput schema / properties / createdJournalCount / minimum
      Added value: +1
  3. Changed3 schema fields changed
    • changedInput schema / properties / portfolioRef / description
      Previous value: -"Portfolio name or slug inside that workspace. Call list_portfolios, or find_portfolios when the user named one, to resolve it."New value: +"Portfolio name or slug inside that workspace. Call list_portfolios to resolve it."
    • changedInput schema / properties / resolutions / items / anyOf
      Previous value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "accountNumber": {
      -        "description": "Ledger account to use for that row, from list_ledger_accounts.",
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "description": "Kind of reference this row fixes.",
      -        "enum": [
      -          "account"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "description": "1-based line number in the CSV file.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "description": "1-based row number within the sheet.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "description": "Worksheet the row belongs to.",
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      }
      -    },
      -    "required": [
      -      "accountNumber",
      -      "kind",
      -      "locator"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "externalId": {
      -        "description": "Counterparty's external identifier, as recorded on the counterparty.",
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "description": "Kind of reference this row fixes.",
      -        "enum": [
      -          "counterparty"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "description": "1-based line number in the CSV file.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "description": "1-based row number within the sheet.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "description": "Worksheet the row belongs to.",
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      }
      -    },
      -    "required": [
      -      "externalId",
      -      "kind",
      -      "locator"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "kind": {
      -        "description": "Kind of reference this row fixes.",
      -        "enum": [
      -          "counterparty"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "description": "1-based line number in the CSV file.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "description": "1-based row number within the sheet.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "description": "Worksheet the row belongs to.",
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      },
      -      "name": {
      -        "description": "Counterparty name to use for that row, from list_counterparties.",
      -        "minLength": 1,
      -        "type": "string"
      -      }
      -    },
      -    "required": [
      -      "kind",
      -      "locator",
      -      "name"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "centerName": {
      -        "description": "Responsibility center to use for that row, from list_responsibility_centers.",
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "description": "Kind of reference this row fixes.",
      -        "enum": [
      -          "responsibilityCenter"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "description": "1-based line number in the CSV file.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "description": "Source file format.",
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "description": "1-based row number within the sheet.",
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "description": "Worksheet the row belongs to.",
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      },
      -      "typeKey": {
      -        "description": "Responsibility center type the name belongs to, such as costCenter.",
      -        "minLength": 1,
      -        "type": "string"
      -      }
      -    },
      -    "required": [
      -      "centerName",
      -      "kind",
      -      "locator",
      -      "typeKey"
      -    ],
      -    "type": "object"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "accountNumber": {
      +        "description": "Ledger account to use for that row, from list_journal_line_assignment_options (type: ledger_account).",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "account"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      }
      +    },
      +    "required": [
      +      "accountNumber",
      +      "kind",
      +      "locator"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "externalId": {
      +        "description": "Counterparty's external identifier, as recorded on the counterparty.",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "counterparty"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      }
      +    },
      +    "required": [
      +      "externalId",
      +      "kind",
      +      "locator"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "counterparty"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      },
      +      "name": {
      +        "description": "Counterparty name to use for that row, from list_journal_line_assignment_options (type: counterparty).",
      +        "minLength": 1,
      +        "type": "string"
      +      }
      +    },
      +    "required": [
      +      "kind",
      +      "locator",
      +      "name"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "centerName": {
      +        "description": "Responsibility center to use for that row, from list_journal_line_assignment_options (type: responsibility_center).",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "responsibilityCenter"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      },
      +      "typeKey": {
      +        "description": "Responsibility center type the name belongs to, such as costCenter.",
      +        "minLength": 1,
      +        "type": "string"
      +      }
      +    },
      +    "required": [
      +      "centerName",
      +      "kind",
      +      "locator",
      +      "typeKey"
      +    ],
      +    "type": "object"
      +  }
      +]
    • changedInput schema / properties / workspaceRef / description
      Previous value: -"Workspace name or slug. Call list_workspaces, or find_workspaces when the user named one, to resolve it."New value: +"Workspace name or slug. Call list_workspaces to resolve it."
  4. Changed6 schema fields changed
    • changedInput schema / oneOf
      Previous value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "enum": [
      -          "preview"
      -        ],
      -        "type": "string"
      -      },
      -      "contentBase64": {
      -        "$ref": "#/properties/contentBase64"
      -      },
      -      "fileName": {
      -        "$ref": "#/properties/fileName"
      -      },
      -      "portfolioRef": {
      -        "$ref": "#/properties/portfolioRef"
      -      },
      -      "workspaceRef": {
      -        "$ref": "#/properties/workspaceRef"
      -      }
      -    },
      -    "required": [
      -      "workspaceRef",
      -      "portfolioRef",
      -      "action",
      -      "contentBase64",
      -      "fileName"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "action": {
      -        "enum": [
      -          "post"
      -        ],
      -        "type": "string"
      -      },
      -      "contentBase64": {
      -        "$ref": "#/properties/contentBase64"
      -      },
      -      "fileName": {
      -        "$ref": "#/properties/fileName"
      -      },
      -      "portfolioRef": {
      -        "$ref": "#/properties/portfolioRef"
      -      },
      -      "previewToken": {
      -        "$ref": "#/properties/previewToken"
      -      },
      -      "resolutions": {
      -        "$ref": "#/properties/resolutions"
      -      },
      -      "workspaceRef": {
      -        "$ref": "#/properties/workspaceRef"
      -      }
      -    },
      -    "required": [
      -      "workspaceRef",
      -      "portfolioRef",
      -      "action",
      -      "contentBase64",
      -      "fileName",
      -      "previewToken",
      -      "resolutions"
      -    ],
      -    "type": "object"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "action": {
      +        "description": "Parse the file and report what it would import, writing nothing. Always preview before posting.",
      +        "enum": [
      +          "preview"
      +        ],
      +        "type": "string"
      +      },
      +      "contentBase64": {
      +        "$ref": "#/properties/contentBase64"
      +      },
      +      "fileName": {
      +        "$ref": "#/properties/fileName"
      +      },
      +      "portfolioRef": {
      +        "$ref": "#/properties/portfolioRef"
      +      },
      +      "workspaceRef": {
      +        "$ref": "#/properties/workspaceRef"
      +      }
      +    },
      +    "required": [
      +      "workspaceRef",
      +      "portfolioRef",
      +      "action",
      +      "contentBase64",
      +      "fileName"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "action": {
      +        "description": "Commit the import that a preview of the same file produced.",
      +        "enum": [
      +          "post"
      +        ],
      +        "type": "string"
      +      },
      +      "contentBase64": {
      +        "$ref": "#/properties/contentBase64"
      +      },
      +      "fileName": {
      +        "$ref": "#/properties/fileName"
      +      },
      +      "portfolioRef": {
      +        "$ref": "#/properties/portfolioRef"
      +      },
      +      "previewToken": {
      +        "$ref": "#/properties/previewToken"
      +      },
      +      "resolutions": {
      +        "$ref": "#/properties/resolutions"
      +      },
      +      "workspaceRef": {
      +        "$ref": "#/properties/workspaceRef"
      +      }
      +    },
      +    "required": [
      +      "workspaceRef",
      +      "portfolioRef",
      +      "action",
      +      "contentBase64",
      +      "fileName",
      +      "previewToken",
      +      "resolutions"
      +    ],
      +    "type": "object"
      +  }
      +]
    • addedInput schema / properties / action / description
      Added value: +"Parse the file and report what it would import, writing nothing. Always preview before posting."
    • addedInput schema / properties / portfolioRef / description
      Added value: +"Portfolio name or slug inside that workspace. Call list_portfolios, or find_portfolios when the user named one, to resolve it."
    • addedInput schema / properties / previewToken / description
      Added value: +"Token returned by the matching preview, proving the file has not changed since."
    • changedInput schema / properties / resolutions / items / anyOf
      Previous value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "accountNumber": {
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "enum": [
      -          "account"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      }
      -    },
      -    "required": [
      -      "accountNumber",
      -      "kind",
      -      "locator"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "externalId": {
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "enum": [
      -          "counterparty"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      }
      -    },
      -    "required": [
      -      "externalId",
      -      "kind",
      -      "locator"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "kind": {
      -        "enum": [
      -          "counterparty"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      },
      -      "name": {
      -        "minLength": 1,
      -        "type": "string"
      -      }
      -    },
      -    "required": [
      -      "kind",
      -      "locator",
      -      "name"
      -    ],
      -    "type": "object"
      -  },
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "centerName": {
      -        "minLength": 1,
      -        "type": "string"
      -      },
      -      "kind": {
      -        "enum": [
      -          "responsibilityCenter"
      -        ],
      -        "type": "string"
      -      },
      -      "locator": {
      -        "oneOf": [
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "csv"
      -                ],
      -                "type": "string"
      -              },
      -              "lineNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "lineNumber"
      -            ],
      -            "type": "object"
      -          },
      -          {
      -            "additionalProperties": false,
      -            "properties": {
      -              "format": {
      -                "enum": [
      -                  "xlsx"
      -                ],
      -                "type": "string"
      -              },
      -              "rowNumber": {
      -                "maximum": 9007199254740991,
      -                "minimum": 1,
      -                "type": "integer"
      -              },
      -              "sheetName": {
      -                "minLength": 1,
      -                "type": "string"
      -              }
      -            },
      -            "required": [
      -              "format",
      -              "rowNumber",
      -              "sheetName"
      -            ],
      -            "type": "object"
      -          }
      -        ]
      -      },
      -      "typeKey": {
      -        "minLength": 1,
      -        "type": "string"
      -      }
      -    },
      -    "required": [
      -      "centerName",
      -      "kind",
      -      "locator",
      -      "typeKey"
      -    ],
      -    "type": "object"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "accountNumber": {
      +        "description": "Ledger account to use for that row, from list_ledger_accounts.",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "account"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      }
      +    },
      +    "required": [
      +      "accountNumber",
      +      "kind",
      +      "locator"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "externalId": {
      +        "description": "Counterparty's external identifier, as recorded on the counterparty.",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "counterparty"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      }
      +    },
      +    "required": [
      +      "externalId",
      +      "kind",
      +      "locator"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "counterparty"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      },
      +      "name": {
      +        "description": "Counterparty name to use for that row, from list_counterparties.",
      +        "minLength": 1,
      +        "type": "string"
      +      }
      +    },
      +    "required": [
      +      "kind",
      +      "locator",
      +      "name"
      +    ],
      +    "type": "object"
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "centerName": {
      +        "description": "Responsibility center to use for that row, from list_responsibility_centers.",
      +        "minLength": 1,
      +        "type": "string"
      +      },
      +      "kind": {
      +        "description": "Kind of reference this row fixes.",
      +        "enum": [
      +          "responsibilityCenter"
      +        ],
      +        "type": "string"
      +      },
      +      "locator": {
      +        "oneOf": [
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "csv"
      +                ],
      +                "type": "string"
      +              },
      +              "lineNumber": {
      +                "description": "1-based line number in the CSV file.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "lineNumber"
      +            ],
      +            "type": "object"
      +          },
      +          {
      +            "additionalProperties": false,
      +            "properties": {
      +              "format": {
      +                "description": "Source file format.",
      +                "enum": [
      +                  "xlsx"
      +                ],
      +                "type": "string"
      +              },
      +              "rowNumber": {
      +                "description": "1-based row number within the sheet.",
      +                "maximum": 9007199254740991,
      +                "minimum": 1,
      +                "type": "integer"
      +              },
      +              "sheetName": {
      +                "description": "Worksheet the row belongs to.",
      +                "minLength": 1,
      +                "type": "string"
      +              }
      +            },
      +            "required": [
      +              "format",
      +              "rowNumber",
      +              "sheetName"
      +            ],
      +            "type": "object"
      +          }
      +        ]
      +      },
      +      "typeKey": {
      +        "description": "Responsibility center type the name belongs to, such as costCenter.",
      +        "minLength": 1,
      +        "type": "string"
      +      }
      +    },
      +    "required": [
      +      "centerName",
      +      "kind",
      +      "locator",
      +      "typeKey"
      +    ],
      +    "type": "object"
      +  }
      +]
    • addedInput schema / properties / workspaceRef / description
      Added value: +"Workspace name or slug. Call list_workspaces, or find_workspaces when the user named one, to resolve it."
  5. First observed

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already indicate the tool is not read-only (readOnlyHint=false) and not idempotent (idempotentHint=false). The description adds the two-phase requirement of preview-before-post and the need to resend the source with a preview token, which is behavioral context beyond annotations. However, it does not disclose potential side effects of posting, error conditions, or what happens if the file is unbalanced—only that 'preview' reports issues. Given the annotation coverage, a 3 is appropriate.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, compact sentence that front-loads the purpose and immediately provides the key workflow. Every clause carries essential information: the input type, the two actions, the requirement for balanced journals, and the preview-then-post sequence. There is no filler or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a tool with 7 parameters, a two-phase workflow, and an output schema, the description captures the essential sequence (preview → review → post) and the critical constraint of resending the unchanged source with the preview token. The schema handles parameter details, and the output schema covers return values. The only minor gap is not explicitly explaining what a 'blocking issue' is, but that is inherent to the preview report and does not hinder an agent from using the tool correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 100% description coverage—every parameter is documented with its own description, including the 'action' enum, 'previewToken' pattern, and 'resolutions' structure. The tool description adds no parameter-level information beyond what the schema already provides, so it does not elevate the meaning. Baseline 3 is correct.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states a specific verb-resource pair: 'Preview or post a complete CSV or XLSX file of balanced manual adjustment journals for one portfolio.' It distinguishes between the two modes (preview vs. post) and specifies the exact input type and scope, making it unambiguous what this tool does.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides an explicit workflow: 'Preview first; post only after reviewing every blocking issue, then resend the unchanged source with its preview token and any resolutions.' This tells the agent when to preview and when to post, and outlines the required sequence. It does not mention alternatives or when not to use this tool, but the workflow guidance is strong.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources