Key takeaways
- Register each bike so job history follows it.
- Add parts as lines; they leave stock automatically.
- Set warranty days per job, not per shop.
- Pay mechanics only on released jobs.
A bike shop sells two things from the same stockroom. Parts go over the counter at a price, and the same parts go into repair jobs where they are bundled with labour. When both come out of one shelf and only one is written down, the shop discovers the shortage during inventory rather than during the week. BikeDesk PH makes the job order the place where parts, labour, mechanic pay, and warranty all meet.
Register the bike, not just the customer
A customer can bring in three different bikes over a year. Registering each one with its brand, model, type, and serial number means a job order points at a specific bike.
When that bike comes back, the previous jobs are already attached to it, which settles most warranty conversations before they start.
Build the job from parts and labour
A job records the complaint, the mechanic, the labour fee, and any discount. Parts are added as lines, and each line takes the part's selling price and multiplies by the quantity.
Job total is parts used plus labour fee less discount. The same quantities reduce stock, so a tire fitted to a bike and a tire sold at the counter both leave the shelf in the sheet.
Release with a warranty date
Warranty days are set per job, because a brake adjustment and a wheel rebuild do not deserve the same cover. When the bike is released, the warranty-until date is computed from the release date.
A job with no release date shows a blank warranty, which is the correct answer for a bike still on the stand.
Pay mechanics from released work
Each mechanic carries a labour share rate. Mechanic pay is the labour fee times that rate, and it is only earned when the job is marked Released, so an unfinished job never creates a payable.
The mechanic report totals jobs released, labour billed, parts billed, job sales, pay earned, and net to shop. That is the payout sheet and the productivity view in one place.
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.
BikeDesk PH Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.
No supplier ordering, barcode scanning, card or e-wallet terminal connection, no brand warranty claim filing, no serial-number registry lookup, no official receipts, and no payroll or tax filing.
Frequently asked questions
Does a mechanic earn a share of the parts too?
No. Pay is a share of the labour fee only, which keeps the incentive on the work rather than on fitting expensive parts.
What if a customer brings their own part?
Leave it off the job parts lines and charge the labour fee only. Stock is untouched and the job total stays correct.
Can I sell a whole bicycle through this?
Yes. List the bicycle as a stock item and record it as a counter sale; on hand and gross profit follow the same rules as a tire.
Does this replace official records?
No. No supplier ordering, barcode scanning, card or e-wallet terminal connection, no brand warranty claim filing, no serial-number registry lookup, no official receipts, and no payroll or tax filing.
