Textbook Buy and Sell Record

Who this is for

Every textbook, from purchase to resale. Each book is logged against its module with what it cost and where it came from, then what it was sold for or who has borrowed it, so the real cost of books across the degree is plain.

Students buying set texts new or second-hand who want to know what their books really cost once resales are counted, and who has the ones they lent out.

What this helps you track

• What each book cost and where it was bought
• Which module each book was bought for
• What each book was sold for and to whom
• Books lent out and not yet returned
• Total spent, total recovered and the net cost of books

How to use it

1. Write your name, course and year of study at the top.
2. Add each book when you buy it: title, module, where from, what you paid and its condition.
3. Leave Still held ticked while you have the book; when it is sold, untick it and write the buyer and the sale price.
4. If you lend a book, write the borrower's name and leave Still held ticked so you know it is coming back.
5. Net cost per book and the totals are worked out in the browser and the workbook; on paper, take the sale price from the cost.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What is the net cost?

What you paid for a book less what you got back for it. A book bought for 30 and sold for 12 has a net cost of 18. Books still on your shelf show their full cost until they are sold.

Why record the condition?

Because it affects what you can ask for a book later and settles any disagreement when a lent copy comes back. Note highlighting, missing pages or access codes already used.

How do I show a book that is lent rather than sold?

Write the borrower in the Sold or lent to column, leave the sale price blank and keep Still held ticked. The books still held figure counts it as yours until it is sold or given away.

Does it suggest resale prices?

No. What a book fetches depends on the edition, its condition and who needs it next year. Enter the price you actually agreed.