agentsclimarketplace

Receivables payables tracker

Skill OsomePteLtd/skills/skills/receivables-payables-tracker

Track who owes you money and who you owe. Use when the user asks about outstanding invoices, bills to pay, accounts receivable, accounts payable, or aging reports. Requires OSOME MCP server at https://mcp.osome.com/mcpFrom its SKILL.md

Install
npx -y skills add OsomePteLtd/skills --skill receivables-payables-tracker

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

6.2 KB, as published. Nobody here has run it

Receivables & Payables Tracker

Track who owes you money and who you owe.

When to Use

Invoke this skill when the user asks:

  • "Who owes me money?"
  • "What bills do I need to pay?"
  • "Outstanding invoices"
  • "Aged receivables"
  • "Aged payables"
  • "What's overdue?"
  • "Collection status"
  • "Accounts receivable / accounts payable"
  • "Who hasn't paid me?"
  • "Chase up invoices"
  • "What do I owe?"
  • "Overdue payments"
  • "Client hasn't paid"
  • "Unpaid invoices"
  • "Bills due soon"

MCP Server

This skill requires the OSOME MCP server:

https://mcp.osome.com/mcp

Tools Used

StepToolPurpose
1list-companiesSelect company
2get-companyCompany context
3get-aged-receivablesCustomer invoices by age bucket
4get-aged-payablesVendor bills by age bucket
5get-bank-accountsCurrent cash for context
Optionalprepare-document-uploadPrepare upload of invoice PDFs, bills, remittance advice, or supporting documents
Optionalcomplete-document-uploadComplete document creation after bytes are uploaded to the presigned target

Data Available

From get-aged-receivables / get-aged-payables:

  • Report format with headings and line items
  • Customer/vendor names (in report lines)
  • Amounts by aging bucket
  • Structure: { report: { headings: [...], lines: [...] } }

From get-bank-accounts:

  • Account balances to show available cash

From document upload tools (optional):

  • prepare-document-upload returns duplicate, maxSizeBytes, optional document, or an upload target plus uploadToken
  • Upload supporting documents for receivables or payables follow-up to the returned presigned POST target
  • complete-document-upload creates the OSOME document after the file bytes are uploaded
  • Supported file types: PDF, JPG/JPEG, PNG, CSV, XLS, XLSX
  • Maximum file size: 50 MB

Limitations

  • Document details limited - list-documents only returns { id, name }, not amounts or due dates
  • Invoice line items not available - For detailed invoice info, users should access OSOME dashboard
  • Report structure varies - Actual field names depend on the accounting system's report format
  • Document upload uses two MCP tools plus direct file upload - Call prepare-document-upload, upload the file directly to the returned presigned POST target, then call complete-document-upload with the same metadata and uploadToken

Execution Flow

  1. Call list-companies and select company
  2. Call get-company for context
  3. Call get-aged-receivables (as of today or specified date)
  4. Call get-aged-payables (as of today or specified date)
  5. Call get-bank-accounts for cash context
  6. Parse report data to extract aging buckets
  7. Present prioritized view
  8. If the user needs to upload an invoice, bill, remittance advice, or supporting file, use the document upload flow:
    • Prepare with companyId, filename, contentType, sizeBytes, and lowercase MD5 checksum
    • Call prepare-document-upload (requires OAuth scope company:documents:write)
    • If duplicate: true, explain that OSOME already has the document
    • Upload the file bytes outside MCP to upload.method/upload.url using returned upload.fields; include returned form fields exactly and append the file last
    • Do not send file bytes, contentBase64, or arbitrary upload headers to MCP
    • Call complete-document-upload with the same metadata plus uploadToken

Report Structure

Aged reports return data like:

{
  "report": {
    "headings": ["Contact", "Current", "1-30 Days", "31-60 Days", "61-90 Days", "90+ Days", "Total"],
    "lines": [
      ["TechCorp Pte Ltd", 5000, 0, 2000, 0, 0, 7000],
      ["StartupXYZ", 0, 3000, 0, 0, 0, 3000]
    ]
  }
}

Parse according to the headings returned.

Output Format

Accounts Receivable Summary

Total Outstanding: [amount]

Age BucketAmount% of Total
Current (0-30 days)[amount][%]
31-60 days[amount][%]
61-90 days[amount][%]
90+ days (Overdue)[amount][%]

Customers with Outstanding (from report):

  • ...

Accounts Payable Summary

Total Outstanding: [amount]

Age BucketAmount% of Total
Current (0-30 days)[amount][%]
31-60 days[amount][%]
61-90 days[amount][%]
90+ days (Overdue)[amount][%]

Vendors with Outstanding (from report):

  • ...

Cash Context

Current Cash Position: [from bank accounts] AR - AP Net: [receivables - payables]

Example

User: "Who owes me money?"

Response:

Accounts Receivable Report

CustomerCurrent31-6061-9090+Total
TechCorp45,00000045,000
StartupXYZ20,0008,0000028,000
BigClient0022,000022,000

Summary:

  • Total AR: SGD 95,000
  • Current: SGD 65,000 (68%)
  • Overdue (60+): SGD 22,000 (23%)

Action: Follow up with BigClient on SGD 22,000 (61-90 days).


User: "What bills do I need to pay?"

Response:

Accounts Payable Report

VendorCurrent31-6061-9090+Total
AWS12,50000012,500
Landlord8,0000008,000
Supplier0003,0003,000

Summary:

  • Total AP: SGD 23,500
  • Due soon (Current): SGD 20,500
  • Overdue (90+): SGD 3,000

Cash available: SGD 245,000 (from bank accounts) Coverage: 10x current payables

Error Handling

ScenarioResponse
No receivables"No outstanding customer invoices found."
No payables"No outstanding bills to pay."
Report parsing errorShow raw report data and explain structure
Very old items (180+ days)Flag as potential bad debt

Keep looking

Skills are one crate of 609,689. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.