Copier rental billing format: per-copy bills from meter readings
Service and rental. By Aman Dobriyal. Updated .
A photocopier rental billing format has one job: turn two meter readings into a bill the customer won't argue with. The sum is simple. The trouble is everything around it. A misread digit, a machine swapped mid-month, a reading nobody took.
This is the format I'd use by hand or in Excel, and the point where it starts costing you money.
The per-copy billing formula
Most rental agreements carry three numbers: a monthly rent, a count of free copies included in that rent, and a rate for every copy above it.
- Copies this month = closing meter reading minus opening meter reading.
- Extra copies = copies this month minus free copies. Below zero counts as zero.
- Bill = monthly rent + (extra copies x per-copy rate), with GST added on top.
An example with made-up numbers. Rent Rs 2,000, with 3,000 free copies and 50 paise for each extra copy. Opening reading 41,200, closing reading 45,900. Copies made: 4,700. Extra copies: 1,700. Bill: 2,000 + 850 = Rs 2,850 before GST.
If the machine counts black and colour separately, or A3 separately, treat each meter as its own line with its own readings, free copies and rate. Work out each line the same way and add them up.
A photocopier rental billing format in Excel
One row per machine per month. Keep the agreement terms (rent, free copies, rate) on a separate sheet and look them up, so a rate change is made in one place.
- Customer and site
- Machine model and serial number
- Opening reading, linked to last month's closing cell so nobody types it again
- Closing reading, and the date it was taken
- Copies made, extra copies and amount, all formulas. For extra copies use =MAX(0, copies - free copies)
- Who took the reading
Print the bill with both readings on it. A customer who can check the subtraction himself rarely phones to dispute it.
The mistakes that produce a wrong bill
- One wrong digit. 45,900 typed as 49,500 is 3,600 copies nobody made. Look twice at any machine whose count is far above its usual month before the bill goes out.
- A reading lower than last month's. It was misread, or the counter was reset or replaced during a repair. Never bill a negative. Find out which it was.
- A machine swapped mid-month. The stand-in has its own meter. You need the old machine's reading on the day it left and the stand-in's reading on the day it arrived, both billed on the same agreement.
- A machine added or removed mid-month. Charge rent for the days it was there. Check what your agreement says about free copies for a part month.
- No reading at all. Decide in advance what happens, write it into the agreement, and do the same thing every time.
- Readings sent as photos in a chat and typed in later by someone else. Keep asking for the photo anyway. It settles disputes.
Where Excel stops working
Excel does the arithmetic perfectly. It can't make the engineer take the reading. It can't keep the photo next to the row. It can't stop someone typing over last month's closing figure.
With a short machine list, one careful person can hold all of that together. When month end has turned into days of phoning engineers and typing numbers, the sheet is the bottleneck, not the person.
What software changes
In the rental billing system I build, the engineer enters the reading on his phone and has to take a live photo with it. A reading that drops or jumps is held back for the office to check. Bills start as drafts and become final when the office says so. A stand-in machine is billed on the same agreement, and rent is split by days when a machine is added, removed or swapped mid-month. At month end there is one list of what is billed and what is still waiting.
What it doesn't do: bill by itself. The office still checks every draft, and I'd keep it that way. It also needs mobile data on site, because there is no offline mode today.
Short answers
How do you calculate a per-copy bill for a rented copier?
Subtract last month's meter reading from this month's to get the copies made. Take away the free copies in the agreement. Multiply what is left by the per-copy rate and add the monthly rent. If fewer copies were made than the free allowance, the bill is the rent alone.
What should a copier rental bill show?
The machine and its serial number, the opening and closing readings with the reading date, copies made, free copies, extra copies, the per-copy rate, the rent and GST. Showing both readings lets the customer check the sum.
What if this month's meter reading is lower than last month's?
Don't bill it. Either the reading was misread, or the counter was reset or replaced during a repair. Check with the engineer, record the meter change with both figures, and bill after that.
This is the core of my field service and rental billing product: readings with photo proof, draft bills worked out from the agreement, and the odd readings held for checking. If month end is eating your week, see how it works, or leave your number and I'll call you back. Field service and rental billing. Leave your number for a call back.