Free Timber Tally Sheet Template
An Excel sheet that works out the CFT as you type, and a printable form for the yard. Free, no sign-up.
Excel Sheet
100 lines. Type the girth and the length of each log and the volume works itself out by quarter girth, in CFT and CBM, with the number of logs and the totals at the foot.
Printable Form
A blank A4 page with 28 lines for a clipboard at the gate or the stack. Fill it in by hand, total each page and sign it.
What The Sheet Looks Like
| S. No | Log Or Tag No | Girth (in) | Length (ft) | Volume (CFT) | Volume (CBM) | Remarks |
|---|---|---|---|---|---|---|
| 1 | A-1041 | 48 | 12 | 12.000 | 0.340 | |
| 2 | A-1042 | 60 | 10 | 15.625 | 0.442 | |
| 3 | No Tag | 36 | 14 | 7.875 | 0.223 | Crack at one end |
| Total | 3 Logs | 35.500 | 1.005 |
You type the girth and the length. The shaded figures are worked out for you.
Want To Stop Filling In Tally Sheets?
In Timbba the gateman scans each log with a phone. The tally, the total for the lorry and the shortage against your supplier’s list are ready the same day, with nothing to type up afterwards.
More Free Tools:Log CFT CalculatorSawmill Recovery EstimatorAll Free Tools
What A Timber Tally Sheet Is For
A tally sheet is the record of what was really measured: one line for each log, with its number, its girth, its length and its volume, and a total at the foot. It is filled in when a lorry is unloaded, when a lot is bought or sold, and when stock is counted. When the supplier’s list says one thing and the yard holds another, the tally sheet is what settles it.
How To Fill It In
The top. Write the supplier, the species, the vehicle number and the consignment or lot before the first log, and the names of the person measuring and the person checking. A tally with no vehicle number cannot be matched to anything later.
One line for each log. Write the tag or hammer number as it is on the log. If the tag is torn or missing, write that in the same column and note it in Remarks. Do not skip the log.
Girth and length. Take the girth with a tape round the middle of the log, under the bark if that is how you buy. Take the length as the trade does in your market, usually rounded down to the unit you are billed in.
Remarks. Use it for what changes the value or the claim: a hollow, a crack, a wrong grade, a log from another lot.
Total and sign. Total each page, count the logs, and have both people sign. A tally that two people signed on the day is hard to dispute.
How The Volume Is Worked Out
The sheet uses the quarter girth method, also called Hoppus, which is how round logs are bought and sold across the Indian trade.
CFT = (girth in inches ÷ 4)² × length in feet ÷ 144
CBM = (girth in cm ÷ 400)² × length in metres
A log of 48 inches girth and 12 feet is 12.000 CFT. For one log at a time, or a log with a hollow, use the Log CFT Calculator.
Where Paper Tally Sheets Fall Short
The sheet is only as good as the copying that follows it. Figures are typed into Excel in the evening, a line is missed, a 6 is read as a 0, and the total is compared with the supplier’s list days later, when the lorry has long gone. Logs with no tag are the hardest: they are written down, but nobody can say which consignment they belong to.
That is the work Timbba takes away. Each log is scanned at the gate against the supplier’s list, so what is short is known the same day and a log with no tag is recorded and matched later. See timber management software for how the gate, the stock and the dispatch join up.
Questions
What is a timber tally sheet?
The form on which logs are listed as they are measured: one line for each log with its number, girth, length and volume, and a total at the foot. It is the record of what a lorry or a lot really held.
What columns does the template have?
Serial number, log or tag number, girth, length, volume in CFT, volume in CBM and remarks. Above them are the company, supplier, species, vehicle number, consignment or lot, date and who measured and checked.
How does the Excel sheet work out the volume?
By the quarter girth (Hoppus) method. In inches and feet, CFT is the girth divided by 4, squared, times the length, divided by 144. In metric, CBM is the girth in centimetres divided by 400, squared, times the length in metres. Type the girth and the length and both volumes appear.
Can I use it for more than 100 logs?
The Excel sheet has 100 lines. For a longer list, use a second copy of the file, or copy the last line down. The printed form has 28 lines to a page, with a page number to fill in.
Can I change the template?
Yes. It is an ordinary Excel file with nothing locked. Add your own name and logo, a grade column or a hollow column as your yard needs.
Is there a way to do this without paper?
Yes. In Timbba each log is scanned at the gate with a phone, checked against the supplier’s list, and the tally, the total and the shortage are ready the same day.
Doing This For Every Lorry?
Timbba scans each log at the gate and works out the volume for you, with the total for the lorry and the shortage against your supplier’s list, the same day.
