Bookkeeping Spreadsheet – Excel Template

For smaller type businesses sometimes a computer based accounting system is just over the top. We spoke recently about a very simple invoicing software package that may suit small businesses who just want to issue quotes and invoices but you may be in a smaller business who wants a bit more detail about how your business is getting on.

The basic bookkeeping spreadsheets (which can be downloaded at the bottom of this post or from the Toolbox) are designed to be easy to use. Hopefully they may also save you a few quid with your accountant StartUp Scotland, icon smile, Bookkeeping Spreadsheet   Excel Template, getting businesses up and running.

These bookkeeping templates are relevant to smaller type businesses that are either sole traders or partnerships. They may also be suitable for smaller limited companies. You also have options of whether to download the VAT or Non-VAT spreadsheet depending on whether you bhttp://www.scottishbusinessblog.co.uk/wp-admin/post-new.phpusiness is VAT registered or not.

Just to say as well that these are just templates that you can change to make them better suit your business.

Download Bookkeeping Spreadsheet (incl. VAT) [Excel Format]

Download Bookkeeping Spreadsheet (No VAT) [Excel Format]

If you use the above spreadsheets and you have found them useful please feel free to leave your comments below StartUp Scotland, icon smile, Bookkeeping Spreadsheet   Excel Template, getting businesses up and running.

StartUp Scotland, , Bookkeeping Spreadsheet   Excel Template, getting businesses up and running.

FinanceCornerstone

This article has been provided by Finance Cornerstone Limited. Providers of Bookkeeping, Credit Control and Management Accounts to businesses throughout Edinburgh, Fife and the Lothians.

More Posts - Website

  • Pingback: Valuable Internet Information » Bookkeeping Spreadsheet – Excel Template | Scottish Business Blog()

  • http://www.griffith-elder.com David Elder

    The spread sheet is very useful for my subsidiary in China. Very easy to use and understand.

    I am trying to find out how to change the headings in the drop down boxes now. I already made the date field in col A come in automatically when you type the name into col B. I will also make col B a drop down box, and have a list on another page of all my suppliers. (when I find out how to do it!)

  • http://www.edit-ability.com Tiffany

    This is a great spreadsheet template guys. Very helpful indeed. Thanks for putting this out there!

  • http://www.cherishproductions.co.uk Mark

    Great template! This is just what I’ve been looking for for my wedding video business!

  • Vic

    Thanks for the bookkeeping templates. They follow the KISS principle: Keep It Sweet and Simple.

    I passed the link on to another forum which deals with open source point of sale software. The templates will, probably, be of interest to many small businesses.

  • http://www.retrolenses.co.uk James

    After looking for some help with my accounting for my VERY small business I found and downloaded this spreadsheet.
    It looks to be exactly what I needed and seems clear and easy to follow.
    Thanks for this, I hope it keeps the taxman happy !

  • Adel

    A fantastic resource, thank you kindly for sharing the template it is very much appreciated.

  • Christy

    Awesome, thanks, it’s great for me, a newbie to bookkeeping and looking after my husbands mess ;-)

  • PJ White

    Just a quick, but very heartfelt, thank-you for creating and sharing the bookkeeping spreadsheet. We searched for ages for the right package for our partnership business. Most are overengineered, clunky, non-intuitive. Your template does precisely the job, neatly and understandably. We’re even having fun customising it. Many, many thanks.

  • http://www.facebook.com/Netodex Andy Brocklehurst

    Thank you so much for sharing this. Really saved me a lot of time. Much appreciated.

  • Matari Clarke

    This is excellent a really good spread sheet well done.

  • Benitosutton

    Hi guys – just wanted to say great site, lots of help, really appreciated.

    Cheers,
    Ben

    http://www.excelconsultant.net

  • Christopher

    Very cool, great website, friend sent the link. I will be back.

    Christopher

  • Christine Myers

    Hi
    Thanks for this template. Just about to start up and its a bit of a minefield but this is simple to follow and easy to use.
    Again many thanks

  • Aoife

    Hi there, just wondering if you were able to edit the names of the catefgories on the right in the spreadsheet? I don’t know how to edit them in the “expense detail” drop down menu. Any help much appreciated!

  • nipflicker

    hi mate just figured it out, if you select the drop down box you want to edit and then select the data tab on the top menu. then go to data validation. it will show a menu with the source location eg: =$F$514:$F$554 this means cells F514 – F554 hold the listed items. so if you want to add one more just change the end of it to F$555 and exit. then on you sheet top left corner where it shows what number cell you are looking at eg A1. type in that box F555 as this is the box you want to add the value to. then in the fx box next to it write the new label you want to add to the list and vola! if you want to add more just increase the number and change as above. hope this helps

  • nipflicker

    hi mate just figured it out, if you select the drop down box you want to edit and then select the data tab on the top menu. then go to data validation. it will show a menu with the source location eg: =$F$514:$F$554 this means cells F514 – F554 hold the listed items. so if you want to add one more just change the end of it to F$555 and exit. then on you sheet top left corner where it shows what number cell you are looking at eg A1. type in that box F555 as this is the box you want to add the value to. then in the fx box next to it write the new label you want to add to the list and vola! if you want to add more just increase the number and change as above. hope this helps

  • nipflicker

    hi mate just figured it out, if you select the drop down box you want to edit and then select the data tab on the top menu. then go to data validation. it will show a menu with the source location eg: =$F$514:$F$554 this means cells F514 – F554 hold the listed items. so if you want to add one more just change the end of it to F$555 and exit. then on you sheet top left corner where it shows what number cell you are looking at eg A1. type in that box F555 as this is the box you want to add the value to. then in the fx box next to it write the new label you want to add to the list and vola! if you want to add more just increase the number and change as above. hope this helps

  • Lynd43

    Thank you for your free download bookkeeping it helps me a lot

  • Lauracullen108

    My question is after you add the new label how do i get it to show up in the summary with the amount

  • Giselatrejo1988

    Hi i did this but my question is how do i get it to show in the summary since its not doing it could you please let me know

  • Linles

    Seems ok, but we developed a far easier to use (and more powerful) one several years ago (we’re accountants) – it’s free so if anyone want it feel free to ask, website is business-results.co uk (or just do a google search for “linles”) – you don’t have to become clients if you don’t want too, we just want to help make life easier for small businesses.

  • http://www.business-results.co.uk/ Linles

    Forgot to mention – we also have a mileage log/claim calculator that anyone is welcome to have for free as well if they want – http://www.business-results.co.uk

  • John

    Thanks for the spreadsheet, very useful.

    To add extra payment categories I found it easier to turn on Headings from the View tab in Excel. I then went to the bottom row 565 (or there abouts), I then selected that row and the one above, clicked the right mouse button and selected unhide.

    From here I could then add new categories in the right place, rather than all at the end, keeping them ordered alphabetically. You can then insert a column in the right place and copy the formula from another row and change it’s reference to the row for the new category.

    You can add a new row on the summary worksheet, just remember to reference the summary for that column on the Payments sheet.

    Hope this helps.

  • Jason

    Hi, great template – thanks. However, when I put in my sales invoices, if I go over a certain number of invoices (4) or perhaps a certain £ amount (in this case around £890) the sales invoice column on the summary changes from the amount, to hash tags instead so it doesn’t show how much money I’ve earned. Am I doing something wrong?

    Thanks for your help,
    Jason

  • Garris

    Most likely the column just needs resizing. I seem to remember this happened to me once and making the column size larger showed the values!

    Hope this helps

  • Pj Tuck

    I’ve had to fiddle a bit (find the heading and drop down list tables), but this is perfect for my needs. Perhaps better to have a separate worksheet with the tables in, than to hide them by decreasing the row height to zero. Also linked the headings to the tables, so if I edit the lists, the headings change as well. Added another totals row under the headings, saves scrolling down to row 495 to see them, new row now frozen so it’s always visible..

    Thanks for the basics..

  • Pj Tuck

    ..happy to share if anyone needs to..

  • Emma

    I found this spreadsheet excellent – thank you. Exactly what I have been looking for.

  • BRIGHTIDEAS888

    GENIUS GENIUS! LOT OF LOVE COMING YOUR WAY
    THANKS A MILLION

  • Tsallen57

    Thanks so much! You just saved me 10 hours of linking… and THINKING! Don’t tell my client!

    Cheers to the guys on the other side of the pond!
    Terry

  • Renee Cipcricklewood

    Thank you, just what I need. You have saved a very busy volunteer hours of work. Many many thanks.