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.
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
/
- 1Download the file
s18-accounting-date-cloture.mdusing the button above. - 2Place 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 - 3Use 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