Payroll cost by month
Payroll is usually the largest line a small company pays, and the number is locked inside a stack of PDFs. This skill reads the payslips Well already holds for one month and lays them out per person: gross pay, tax withheld, social contributions, net pay, each in the currency its payslip was issued in. It states what the payslips printed and nothing else, so an amount a payslip never carried is reported as unread rather than filled in with a zero.
npx skills add wellapp-ai/skills --skill payroll-cost-by-monthAsk anything or use / for commands...
How the skill answers
Every step of the run, in order, with the card each one returns. A step that hands its work to another skill says which one.
- You ask
What did payroll cost us last month?
- Pin the workspaceSkill useddefine-workspace
Workspaces
Pick the workspaces to work in.
Your workspaces - Pin the monthSkill useddefine-period
- Read the schema
- Read the month's payslips
- Check the read covered the month
- Account for the rows a date filter cannot place
- Read the four amounts per person
- Split the statuses rather than filtering them away
- Keep each currency its ownSkill usednormalize-currency
- Show the rows
- If any required step errors or returns unusable data
- You get
The payslips for the month read line by line: gross pay, tax withheld, social contributions and net pay per employee, each in the currency its payslip was issued in.
More skills to try
Every skill answers a different question from the same connected data. Add one, ask, and see the working.
Runway
Know how many months of cash you have at your current burn, with both sides of the division shown.
Cash position
Know how much cash you hold right now, with the accounts counted and the ones left out both stated.
Cost structure
See where your company's money actually goes, no spreadsheets required.
Receivables aging
See who owes you money, and how long they have been sitting on it.
Bills due
See what you owe and when, ordered by due date with a running total.
Rank clients by LTV
Find out who your best customers really are, ranked by what they've actually paid.
Frequently asked questions
Does this give me the fully loaded cost of employment?
No. It reports the employee side of each payslip. The employer versus employee side of a payslip line is not a readable field on the payslip records, so employer charges are out of scope and the answer says so.
Is this our headcount?
No. It counts the people who have a payslip in the month. An employment contract with no payslip for that month is not reachable from these rows, so a person on unpaid leave or one whose payslip has not landed does not appear.
Where does the total come from?
From the rows the read returned, added up in the answer. There is no server-computed payroll total, so when the month holds more rows than one read returns, the skill says the month was not covered and stops rather than adding up a sample.
What happens with several currencies in one month?
Each payslip keeps the currency it was issued in and the answer reports per currency. A single converted total is given only with the rate and the rate date beside it, and a currency with no rate is named and left out of that total.
What if an amount is blank on the payslip?
It is reported as unread. Gross pay, tax withheld, social contributions and net pay are each stored as optional, and a blank one means the payslip did not print it, which is not the same as zero.
Which countries does it cover?
The four header amounts are read from any payslip that carries them. The line level rubric catalog behind payroll covers France and the United States, so a payslip from another country's payroll has no rubric to map its individual lines onto.
Which columns does the table show?
The payslips table draws employee, period end, pay date, gross, net, status, source and document. Tax withheld and social contributions are read and stated in the written answer rather than drawn as columns.
Ask your first question today
Connect your tools, then ask in plain language. Every answer traces back to the record behind it. Free to start.