Key takeaways
- Put the monthly rate on the site, once.
- Log every visit as a job with the crew hours.
- Charge supplies to the job that used them.
- Read margin per site before renewing a contract.
A cleaning company can be busy every day and still lose money on one site nobody wants to talk about. The rate was agreed a year ago, the crew size crept up, and supplies go out the door without a name on them. LinisDesk PH puts the contract on the site and the costs on the job, so margin per site becomes a number instead of a feeling.
Put the contract on the site
A site carries the client name, address, service type, contracted monthly rate, and billing day. That single row is what gets billed every period, so nobody has to remember what was agreed.
A schedule row records the days, shift, hours per visit, crew size, and times per week, and the sheet works out the visits per month that the rate is supposed to buy.
Charge crew hours to the job
Each visit is logged as a job against a site. Crew members are assigned with their hours, and pay is computed from the crew member's rate per hour.
Only assignments marked Done count toward the job, so a shift that did not happen never quietly becomes a cost.
Charge supplies to the site that used them
Cleaning chemicals, trash bags, and floor wax are issued with a Job Use movement that carries the site and the job. Quantity times unit cost becomes the supplies cost on that job.
Stock on hand drops at the same time, so the stockroom and the site costing stay in step from a single entry.
Bill the period and read the margin
An invoice needs the site, a period start and end, and any extra charges. The contracted monthly rate is pulled from the site and pro-rated at rate divided by 30 times the days billed, so a part month or a single week bills correctly.
SITE REPORT lines up billed, collected, crew pay, and supplies cost per site, and the margin column shows which contracts are worth renewing at the current rate.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
LinisDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No payroll or government contribution computation, DOLE service-contracting compliance, biometric attendance, chemical safety certification, contract drafting, official receipts, or tax filing.
Frequently asked questions
What if a site is billed for extra work on top of the contract?
Enter it as extra charges on that period's invoice. The contracted monthly rate stays untouched and the amount due includes both.
Does it compute payroll and government contributions?
No. Crew pay here is job costing at an hourly rate so you can see what it costs to serve a site. Payroll and contributions stay in your payroll process.
Can I bill a part month when a contract starts mid-period?
Yes. Billing uses the monthly rate divided by 30 times the days billed, so a week or a half month bills in proportion without editing the contract.
Does this replace official records?
No. No payroll or government contribution computation, DOLE service-contracting compliance, biometric attendance, chemical safety certification, contract drafting, official receipts, or tax filing.
