Your Rate Book, step by step
Six steps from opening the file to getting paid, shown with one example job. Every figure is the real file's own working.
Save the guide as a PDFA copy of this guide to keep or print.
First, open the file
-
Got Excel, on a PC or a Mac?
Double click the file. That is it.
-
On a Mac with Numbers, or no Excel at all?
Open it in Google Sheets. It is free and runs in Safari or Chrome.
- Go to drive.google.com and sign in with a free Google account.
- Press New, then File upload, and pick your Rate Book.
- Double click it, then press Open with Google Sheets.
Why not Numbers? It loses the dropdown lists for your town and tax area.
-
Opened the free sample in your browser?
Press Edit a copy at the top to type in it. It needs a free Microsoft account.
1Fill in Your Numbers
Tab: Your Numbers
Do this once. Every other tab reads from it.
You type
The file works out
2Add each job
Tab: Job Pricing
One row per job. It works out the price.
You type
The file works out
Labour £518 plus materials with your markup, £360.
3Make the quote
Tab: Quote
Type the job number. The quote fills itself in.
You type
The file works out
Print it, or save it as a PDF to send.
4Make the invoice
Tab: Invoice
When the job is done, type the same job number.
You type
The file works out
5Track the payment
Tab: Job Pricing
Type the dates on the job row.
You type
The file works out
It stays owed until you type the paid date.
6Check your year
Tab: START HERE, the first tab
Nothing to type. It adds up every job.
You type
Nothing
The file works out
Tax is worked on profit, so materials you buy are left out.
Good to know
- The quote or invoice shows £0: check the job number matches a row on Job Pricing.
- There is no list to pick your town or tax area: the file is open in Apple Numbers. Open it in Google Sheets instead.
- You typed over a cell that works itself out: undo it. Only type in the pale orange cells.
- You want to check a price: the Town Rates tab shows the going day rate in each town in your file.