Shiftmate
Laundry weight and delivery tracking Excel template
Track the exchange rate accepted and delivered, the kilogram price and collection. Excel template showing open delivery and charge balance.
Prepared by:Shiftmate Product and Operations Team · Son kontrol:
Actual file previews
The images below are the actual data entry and executive summary pages of the workbook to be downloaded.
Step by step usage
Examine the example and prepare the blank file
Record the weights on the same dry weighing basis. Do not compare wet and dry kilograms. Each acceptance job is a separate line; The delivery quantity is cumulative dry kilograms. The price is calculated based on the accepted total. Do not use this file for jobs that are priced only per piece. Use the yellow input fields on the tracking page; Do not change the blue formula fields. The sample sheet is filled with fictitious records and does not count towards the actual work total.
Write actual records in the yellow fields
It is the kg accepted minus the delivery pending delivery. The work price is the accepted kilogram × kilogram price. Open payment is the total collection amount minus the price. If the delivered amount exceeds the acceptance or collection amount, a control warning occurs. The summary shows the remaining kilogram and open TL amount separately; Payment does not seal the delivery. An empty mandatory field is distinguished from a real zero. Correct missing or incorrect records in the control column; Since these lines are excluded from the summary, do not use the total as a final report until the problem is resolved.
Fix control alerts and review summary
Put the remaining work on the delivery schedule. Reconcile weighing differences with the customer.
What does this Excel file solve?
Track the exchange rate accepted and delivered, the kilogram price and collection. Excel template showing open delivery and charge balance. Record the weights on the same dry weighing basis. Do not compare wet and dry kilograms. Each acceptance job is a separate line; The delivery quantity is cumulative dry kilograms. The price is calculated based on the accepted total. Do not use this file for jobs that are priced only per piece. Use the yellow input fields on the tracking page; Do not change the blue formula fields. The sample sheet is filled with fictitious records and does not count towards the actual work total.
What's inside the file?
Remaining delivery kg, Work cost, Open payment. The file contains sample rows, canned formulas, data validation fields, risk colorings, and executive summary.
Calculation and control logic
It is the kg accepted minus the delivery pending delivery. The work price is the accepted kilogram × kilogram price. Open payment is the total collection amount minus the price. If the delivered amount exceeds the acceptance or collection amount, a control warning occurs. The summary shows the remaining kilogram and open TL amount separately; Payment does not seal the delivery. An empty mandatory field is distinguished from a real zero. Correct missing or incorrect records in the control column; Since these lines are excluded from the summary, do not use the total as a final report until the problem is resolved.
Worked example: Laundry weight and delivery tracking: calculation example
50 kg accepted, 30 kg delivered. 40 TL/kg. 1,000 TL collection. Result: 20 kg awaits delivery; The total price is 2,000 TL and the open payment is 1,000 TL.
Decisions that can be taken as a result of this
Put the remaining work on the delivery schedule. Reconcile weighing differences with customer
Common usage mistakes
Comparing wet weight with dry delivery. Mixing piece work with kilogram work. Using the summary total as the final result without correcting the lines with control warnings
Limits and proper use
It does not include part barcodes, textile counts, loss/damage charges or delivery signatures. Weighing differences and additional services must be managed separately. The file does not issue receipts or invoices. The file is prepared for 150 record lines. The parent summary includes all valid rows, regardless of filters. When capacity is full, open a new period copy; additional rows require the summary and validation ranges to be updated as well. There are no macros, external data connections or automatic notifications.
Compatibility and quality control
Two pages of this file were visually inspected; Formulas were recalculated and checked in empty, sample and incorrect entry scenarios. There was no separate device testing of the Excel desktop application. .xlsx without macro; formulas and drop-down lists are included in the file. The tracking page includes 150 preset record lines and a standalone Sample page. Prepared for desktop Excel; Check views and validations in other spreadsheet applications.
Scope of this file
This standalone file is prepared for laundry weight and delivery tracking. It's not that Shiftmate automates this industry workflow; The application focuses on team, shift and timesheet management.
Relevant official and technical resources
Frequently asked questions
Is there a partial delivery?
Yes. Write the total dry kilograms to date in the field provided. Don't write the final submission alone.
Is piecework suitable for dry cleaning?
No. The calculation is based on kilograms. If you enter the price per piece as the price per kilogram, the result will be meaningless.
Is the job completed once the payment is made?
No. The remaining kilograms appear separately; The job is physically open until all deliveries are made.
Do I need to create an account to download the file?
No. You can download the Excel file directly after creating a download request with your email address. Creating a workspace is not mandatory. If there is an area that does not meet your needs, you can request an edit via the contact form.