Payables by accounting date (month-end close)

Filters payables by accounting date for monthly or quarterly close. Essential for ensuring the completeness of the accounting scope for the period.

โ†“ Download skill (.md)
82/100ยท๐Ÿ“† MonthlyยทExpertController
ERP exportReconciliationget_payables

๐ŸŽฏ Skill purpose

Filters payables by accounting date for monthly or quarterly close. Essential for ensuring the completeness of the accounting scope for the period.

๐Ÿ“Š What it produces

List of payables within the selected accounting period scope.

โšก Benefit

Before

Manual date extraction with risk of including out-of-period items.

After

Exact accounting scope for close, with no risk of period errors.



# Instructions โ€” Payables by accounting date (month-end close)

## โš ๏ธ Critical prerequisite

The `accountingDate` field is an **optional feature disabled by default** in Spendesk.
If it is disabled, `accountingDate` is `null` on all payables and a filter on this field silently returns 0 results.

**Before using this filter, check**: call `get_payables` without a date filter on 3 records and inspect the `accountingDate` field. If it is `null`, the feature is not enabled โ€” use `payableDate` instead.

## Step 1 โ€” Identify the company

Call `list_companies` to get the `companyId`.

## Step 2 โ€” Check whether accountingDate is enabled

Call `get_payables` with `pageSize=3` (no date filter).
Inspect `accountingDate` in the results:
- If populated โ†’ the feature is active, continue
- If `null` โ†’ **use `payableDate` instead** and inform the user

## Step 3a โ€” If accountingDate is enabled

Call `get_payables` with:
```
filters: { field: "accountingDate", operator: "between", value: { from: "<YYYY-MM-01T00:00:00.000Z>", to: "<YYYY-MM-lastDayT23:59:59.999Z>" } }
```

## Step 3b โ€” If accountingDate is null (standard case)

Call `get_payables` with:
```
filters: { field: "payableDate", operator: "between", value: { from: "...", to: "..." } }
```

And inform the user: "The accounting date (accountingDate) is not enabled on this account. Filtering was done on the document date (payableDate)."

## Step 4 โ€” Pagination

If `hasNextPage=true`, iterate with the `cursor` until exhausted.

## Step 5 โ€” Results

Display: number of payables, total in functional currency (sum `functionalAmount.amount / 10^precision`), breakdown by `bookkeepingStatus`.

## Example prompts

- "Show me the June 2026 invoices for the accounting close"
- "Which payables have an accounting date in July 2026?"

How to install this skill

/
  1. 1
    Download the file s18-accounting-date-cloture.md using the button above.
  2. 2
    Place the file in the .claude/ directory of your project (or ~/.claude/ for a global install).
    cp s18-accounting-date-cloture.md .claude/s18-accounting-date-cloture.md
  3. 3
    Use in Claude Code โ€” the skill is automatically discovered. Describe your need in natural language and Claude will apply the skill instructions.
๐Ÿ’ก Make sure the Spendesk MCP is configured in your .claude/settings.json with the tools get_payables.

Similar skills

โ˜… Top
95/100ยท๐Ÿ” Ad hocยทExpert

MCP coverage audit & gap analysis

Probes all available MCP tools, re-evaluates coverage of 50 persona use cases, detects new fields or tools, and regenerates the gap analysis report.

CFOControllerAP Manager
90/100ยท๐Ÿ“… WeeklyยทBeginner

Card requests via get_requests

Explains how to use get_requests for card requests and why expense reimbursements don't appear there. Avoids a frequent source of confusion between two distinct workflows.

ControllerFinance Analyst
90/100ยท๐Ÿ” Ad hocยทIntermediate

Active vs archived cost centers

Distinguishes active cost centers from archived ones with correct use of get_cost_centers. Avoids the counter-intuitive isArchived vs isActive naming convention pitfall.

ControllerFinance Analyst