• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Recommended Books
  • Tools
  • Blog
  • Contact
  • Hire Me
Small Biz Geek

Small Biz Geek

Small Business Design, Marketing & Technology Journal

Nerdy analysis of small business design, marketing and technology

  • The Internet
  • Marketing
  • Graphic Design
  • Web Dev
  • Web Design
  • Social Media
  • Privacy & Security
  • Tech
  • Misc

Easy Filing System for Small Biz Receipts

Published: September 9, 2014; Updated: October 22, 2016 Filed Under: Filing, Gadgets, Legal, Software

Keeping records of business expenses by saving your receipts need not be the headache we imagine. Setting up a simple Excel spreadsheet and religiously entering your monthly outgoings shows how the business is performing.

Receipt Filing System

Beside highlighting the all important figures, it will be easier for you to calculate your expenses and lower your overall profit in your tax return.

Recording & Filing

It is then a case of keeping a chronological system of paperwork (.PDF docs, PayPal receipts, bills, shop receipts etc) that can be directly or indirectly attributed to the operations of your business.

Receipts folder

Come up with a simple filing method you are comfortable with. Don’t over complicate things.

I use plastic A4 sleeves in which proof of all my expenses for the month are contained. I insert a plain sheet of paper at the forefront of the plastic sleeve with the Year and month clearly written.

 

Receipts Filing System

Keep your receipt filing system simple

 

Often, I am billed digitally by suppliers and the only way to get a receipt is make a computer screenshot then print it out.

I prefer a .PDF but sometimes you just have to do your best with what is (or is not) provided. Get it done while you have the chance.

If you can’t create receipts immediately, write down that it needs to be done and make it a priority.

Digital Copies

As well as keeping printed receipts, I also make digital copies of all receipts. I scan these in at 300dpi (usually an A4 sheet) and resize to about 1000 pixels on the shortest edge.

I use a hierarchical folder system and all receipts use the same naming convention.

Digital Copies of Receipts

Everything is backed up to USB sticks as often as possible.I keep these in a safe place.

If I lost all my data and struggled to do my tax returns, I would literally cry, no joke.

USB flash drive

I once heard someone say that if your data is not backed up in at least three places, then your data doesn’t really exist. That has stuck with me and I always remember to diversify how I back up.

About once a fortnight I back up EVERYTHING to a Seagate Expansion USB3 2TB USB storage device which plugs in at the mains. It copies all my data pretty fast, and when I say all my data, I’m talking about my entire business data, not just digital receipts. I paid about £70 for this device and I consider it a worthwhile investment.

Seagate Expansion 2TB USB3 data storage

My trusty 2TB USB backup device. I’ve given her a name – “Seagate”. Haahh!

If you want to buy one of Seagate backup devices yourself, you can click this Amazon link and I will earn a small commission. Amazon’s commissions are very low – approximately enough to buy a packet of salted peanuts.

Spreadsheet

Organising your finances should not be overly complicated. Start as you mean to go on by familiarising yourself with spreadsheets and getting used to the way they work. Microsoft Excel is what I use, but Apache Open Office is free and opens any spreadsheet document.

There are plenty of free Excel cashbook templates floating around online. I downloaded a template, played around with it, read some Excel tutorials (even watched some YouTube videos) and finally made some customisations.

Remember the financial year begins April 6th in the UK, and if you’re a first time sole trader you won’t need any spreadsheets set up for VAT or Limited liability companies.

Performance & Costs Breakdown

Costs and sales should be entered ASAP into the spreadsheet. Some people prefer to tally up at the end of a period but a small business on a budget needs to keep a running total. This is useful in circumstances such as a sales pitch or negotiation where you may decide to make discounts but need to know if you can afford to do so.

Template spreadsheets are often categorized vaguely under headings such as “Fixed costs”, “Variable costs”, “Inventory” etc, and for a startup or small business, it is helpful to set up metrics that provide more detailed feedback on the overall health and/or impact of spending.

My own spreadsheet is set up to specifically monitor particular types of expenditure and tells me what the return on investment is over the year.

Excel Spreadsheet Cashbook

I have broken down my costs as follows and continue to add new metrics to the spreadsheet:

  • Rent/ Rates
  • Water
  • Light/ Heat
  • Loan Repayments
  • Insurance Costs
  • Travel Expenses
  • Internet
  • Professional Fees
  • Capital Equipment
  • Skype (Cr.)
  • Skype (Subscription)
  • VoIP (18185)
  • Mobile Telephone (Cr.)
  • Marketing & Promotion
  • Facebook Advertising
  • Misc consumables
  • I.T. Equipment
  • Post and carriage
  • Art Materials
  • Printing and Stationery
  • Contingencies
  • PC Repairs
  • URL reg. (Yola & GoDaddy)
  • Web Hosting (DreamHost, Godaddy)

Data Under One Roof

If you’re running several small ventures as a sole trader, you’re allowed to operate under one trading name. This means you can create new data cells in the same spreadsheet and associate these cells with each of your different businesses by naming them accordingly.

I run several different income generating websites, but they all are run using the same equipment and office resources. You can see I have mentioned art and design materials (Sometimes I paint and sell artwork) as well as web design outlay.

Having an overall view of your costs against sales will allow you to change or amend your business plan – it is your financial roadmap.

Final Advice

Stay on top of your expenses and be disciplined in recording everything. Even when I am tired and don’t feel like it, I make myself do it because I’ll thank myself later when it is out the way.

If you get to a stage where you’re very busy you could always pay an accountant, but honestly, in the early days of running your business it might be best if you force yourself to learn the basics and pick up the rest as you go along. I hate maths and anything to do with numbers, but when real money is in jeopardy I suddenly don’t mind getting stuck in!

Keep it simple… and keep your calculator handy! Haha! 😀

Tips

  • When you register as a sole trader you can operate under one trading name – an umbrella company of sorts – and your expenses may be claimed back for all your ventures
  • If you purchase business stationery in a supermarket, pay for it separately to your groceries – you need a receipt just for the biz expense
  • New businesses can claim costs dating 12 months prior to the official trading date. In other words, once you begin paying National Insurance contributions the costs incurred In the 52 week period before the first N.I. payment is tax deductible
  • Search the internet and see if you can find a podcast on accounting for beginners. Listening to someone else talk about/teach the subject is a great way to learn

 

You Might Also Be Interested In...

  • Argh! Why Does Google Delete Genuine Business Reviews? 🤖
  • Claw Back Time and Improve Business Communications with Private Videos
  • Google Security Smackdown: Websites Without HTTPS Will Suffer 🔓

Filed Under: Filing, Gadgets, Legal, Software Tagged With: Data, Spreadsheet, Tax

About Small Biz Geek

I'm Darren, helping small businesses with design, marketing & tech.

Small Business Website Design

Do you need help with something web related?

Hire Me

Reader Interactions

Subscribe to Blog Feed by Email

Your email address won't be shared. You'll never be spammed. Check your inbox to confirm opt-in.

Add Your Thoughts Cancel reply

Your email address is safe and will NOT be shared with anyone else.

Hateful, spammy or abusive comments will not be tolerated.

For more information please see the comment policy.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search Website

Latest Blogs

  • A Story of Seductive Social Media Success and Neglected Email Strategy 🏚️
  • The Classic Social Media Trend Destined to Ruin Your Business 😭
  • Looking for Online Work? Don’t Fall for this Fake Hays Recruitment WhatsApp Scam ⚠️
  • Cream of the Crap: How Fake Reviews, Bad Businesses and Dangerous Products Rise to the Top 💣
  • Exposed: The Hong Kong Investment “Fraud Recovery” Scammer Deceiving Victims 🤑
  • Computer Says No: Does Your Website Work for People with Disabilities? ♿
  • Chinese Tinder Profiles Are Using Photos of Pretty Girls to Scam “Investors” 💋
  • Small Biz Owners “Trapped” Using Email Addresses Belonging to Internet Service Providers 🪤
  • In the Pandemic, QR Codes are Finally Proving Worthy in the West 😷
  • Small Businesses Finally Start Marketing… and All It Took Was a Global Pandemic 🏁
  • UK Contractors Operating Ltd Companies Should Be Mad as Hell with HMRC and IR35 🧾
  • 20 Years On and Website Hit Counters are Still a Waste of Pixels 🧮
  • Competitors Can Easily Edit Your Google and Facebook Business Listings 🤨
  • Waiting on Final Images for a WordPress Website? Use this Handy Thumbnail Placeholder Trick 🪟

Footer

Primary Navigation

Home
About Darren
Good Books
My Tools
Blog Posts
Hire Me
Contact Me

Derby & Nottingham Area

The Internet
Marketing
Graphic Design
Website Development
Website Design
Social Media
Technology
Miscellaneous
Privacy & Security

Let’s Connect

Twitter
YouTube
LinkedIn
RSS

Small Business Blog · Privacy Policy · Commenting Policy · Website Disclaimer · ICO number: ZA305900


Written and designed by Ilkeston Web Design