Real descriptions, and the spreadsheets they became.
Each of these was built by Proper Spreadsheets from the words shown with it.
Find one close to what you need, start from its words and change anything
that does not fit. Building and previewing are free.
What was typed
I share a house with three friends and we split the bills evenly. I want a Housemates tab listing everyone who lives here, and a Bills tab logging every bill: what it was for, the category (rent, energy, water, broadband, council tax, food or other), the amount, the date it was paid, and which housemate paid it. On the Housemates tab show, for each person, how much they have paid, their fair share of the total, and how much they owe or are owed. On a summary show the total spent, the spending by category, and how much we spend this month.
I run a small team and need to plan time off. I want a Team tab listing each person, their role and their yearly holiday allowance in days, and a Leave tab logging every booking: who it is, the type of leave (holiday, sick, training or other), the first day off, the last day off, the number of working days it uses, and whether it is approved. For each person on the Team tab show the holiday days booked, the holiday days left and the sick days taken. On a summary show who is off today, how many people are off in the next fourteen days, bookings still waiting for approval, and the days taken by type of leave.
I am a freelancer. I need to track every invoice I send: the client, the date, what it was for, the net amount, the VAT, and whether it has been paid. I want to see what is still outstanding, what is overdue, and how much VAT I owe this quarter. I have a handful of regular clients I invoice repeatedly.
I run a small business on my own and need to keep my books for my tax return. I want to record money in and money out, put each one in a category, and see totals by category and by month, plus my profit so far this year.
I am a tradesman. I quote for jobs and want to know whether I actually made money on each one. Record the quote, the customer, my labour hours and hourly rate, materials, and the price I quoted. Show me the margin on each job and my win rate on quotes.
I sell on Etsy and want to know what I actually earn per order. Record each sale, the item, what I charged, the postage, Etsy's fees, and what the materials cost me. Show my profit per order and per month, and which items make the most.
I need to keep track of my clients and the projects I am doing for each one. For every project: the client, what it is, the fee, the deadline, the status, and how many hours I have put in. Show me what is due soon, what is still in progress, and the fees I have coming.
I hold stock for my small shop and keep running out of things. I want a list of every product with what it cost me, what I sell it for, and how many I have. Record stock coming in and going out, and show me what is running low and what my stock is worth.
I need to see whether I will have enough money in the bank over the next twelve months. Let me enter what I expect to come in and go out each month, in categories, and show me the closing balance each month and the worst month.
I need to log business mileage and expenses to claim back. For mileage: the date, where from and to, the reason, and the miles. For expenses: the date, what it was, the category and the amount. Work out my mileage claim at the going rate and total my expenses by category.
I have a couple of side hustles alongside my job and want to know which ones are actually worth it. Record the money coming in and the costs for each hustle, and the hours I spend on it. Show me the profit for each hustle, the profit per hour, the totals this month and this tax year, and how much to put aside for tax using a percentage I choose.
I want to get a grip on our household money. Let me set a budget for each category each month, then record what we actually spend, and show me where we went over, what is left, and how much we saved.
I keep losing track of which bills are paid. List every bill with who it is to, how much, when it is due each month and how it is paid. Then let me tick off each month as it goes out, and show me what is still to pay this month and my total monthly outgoings.
I want to find the subscriptions I am wasting money on. List each one with what it costs, how often it is billed, when it renews and how much I actually use it. Show me the yearly cost of each, my total a year, and which ones I should cancel.
I am paying off debts and want to see the end of it. List each debt with the balance, the interest rate and the minimum payment. Record each payment I make, and show me what I still owe in total, how much interest I am paying, and which debt to attack first.
I am saving for several things at once and want to see how each is going. List each goal with the target and the date I want it by. Record what I put in and when, and show me how much is in each pot, the percentage there, and whether I am on track.
I want to stop big yearly bills catching me out. Give me a list of funds, one for each thing I save for, like car insurance, the MOT, Christmas, birthdays and holidays, with how much it will cost, the month it is due and how much to put aside each month to be ready. Then a separate log where I record every payment into a fund or out of it. Show the balance in each fund and whether it will be ready in time.
I want to track my net worth over time. List everything I own with what it is worth and everything I owe, in categories. Let me record the figures each month and show me my total assets, total debts, net worth and how it has changed.
I want to know what my car actually costs me. Record every fuel fill with the litres, the price and the mileage, and every other cost like servicing, tax, insurance and repairs by category. Show me my cost per mile, my fuel economy and my total spend this year.
I rent out a few properties and need to keep the money straight for each one. List each property with its rent and mortgage. Record every payment in and out against a property, in categories, and show me income, costs and the position for each property and overall.
I let a place out short term and want to know what I really make. Record each booking: the guest, the dates, the nights, what they paid, the platform fee, and the cleaning cost. Show me my occupancy, my income per month and my net after costs.
We are renovating and I am terrified of the budget running away. Let me list each job by room with what I budgeted, then record what I actually spent and who to. Show me the total budget, the total spent, what is left, and which rooms have gone over.
We are moving house and everything is costing more than we thought. Let me list every cost with what I expected and what I paid, and a checklist of everything that needs doing with who is doing it and by when. Show me the total cost and what is still outstanding.
Christmas gets expensive and I lose track. I want to set an overall Christmas budget and list everyone I am buying for with how much I plan to spend on each person. Then I record each gift I buy: who it is for, what it is, where it came from, what it cost and whether it is wrapped. I also want to track the other costs like food, decorations, cards and postage against their own budgets. Show me what I have spent, what is left, who I still need to buy for and whether I am over budget.
I want to plan the whole of 2027 in one place. Set my expected income and a budget for each spending category for every month of the year, then log what I actually spend as it happens. Show me each month's budget against actual, the running total for the year so far, which categories I overspend on most, and how much I have saved across the year.
We are planning a wedding. I need a budget by category with what we estimated, what we have paid so far and what is still owed to each supplier, plus a guest list with who has replied and their meal choice. Show me the total cost, what is left to pay and the final head count.
We are planning a big trip and I want to know what it will cost. Let me plan each item by category with what I estimated and what I actually paid, and track the itinerary day by day. Show me the total estimated, the total spent and what is left in the pot.
I want to plan our meals for the week and stop overspending on food. Let me plan a meal for each day, build a shopping list from it with quantities and prices, and track what the weekly shop actually cost against what I budgeted.
I run a small sports club. I need a list of members with their subs and whether they have paid, and a fixture list with the date, the opponent, home or away and the result. Show me who still owes, the total collected, and our record for the season.
We are fundraising for a target and need to see how close we are. Record each donation with who it came from, how much, how it was given and whether gift aid applies. List our events with what each one raised and cost. Show me the total raised, the gift aid and how far we are from the target.
I organise volunteers and the rota is chaos. List each volunteer with what they can do and when they are available. Then a rota of dates and shifts with who is on and whether they have confirmed. Show me the shifts still unfilled and how many each person has done.
I run a choir and need to keep track of our repertoire and performances. List each piece with the composer, the arrangement, how long it is, how well we know it and which voice parts it needs. Then a list of performances with the date, the venue and which pieces we sang.
I am training and want to see progress. Record each workout with the date, the type, how long, and how hard it felt. Separately log my weight and measurements each week. Show me my workouts per week, my total time and how my weight has moved.
I want to build some habits and actually stick to them. Let me list the habits I am working on and how often I want to do each. Then record each day whether I did it. Show me my streak for each habit, how many days I hit this month and my best run.
I am job hunting and losing track of where I have applied. Record each application with the company, the role, the salary, where I found it, the date I applied and what stage it is at. Show me how many are still live, how many got to interview and my response rate.
I am a student and need to keep on top of my assignments and grades. List each module with its credits. Record each assignment with the module, what it is worth, the deadline, whether it is handed in and the mark I got. Show me what is due soon and my average so far.