Business record keeping & contractor bookkeeping spreadsheet

Share This Guide, Choose Your Platform!


When you run your own UK contractor company, it’s important to know how to organise your small business records. As part of a contractor’s bookkeeping and accounting, a person should know how to complete their business record keeping. They should also know how to maintain business records (UK) for their UK contracting company. Indeed, when keeping business records, this includes the basic bookkeeping via a business record keeping system. It also includes maintaining the financial records for your UK contracting business. What’s more, it’s even more important for limited company directors to keep accurate records when they maintain VAT record keeping. A contractor bookkeeping spreadsheet (UK) was normal in years gone by. However, nowadays many will now use limited company contractor bookkeeping software via a digital online system.

As mentioned above, when running your own UK contractor limited company, you may previously have used a simple bookkeeping for contractors’ solution. This could have been an Excel VAT bookkeeping spreadsheet for small business. It’s common that a small business accounting spreadsheet suffices when your business is a one-person venture. However, in most cases the simple bookkeeping spreadsheet for UK contracting professionals is now a thing of the past. As a result, most now keep their records online, especially if they’re VAT registered. For those that prefer it and aren’t VAT registered, they can still use a contractor spreadsheet for small business accounting to record their financial transactions.

In this guide, we’ll look into business record keeping requirements for UK contractors and small business. What’s more, we’ll investigate the types of record keeping in business, how to maintain records for your business and the types of business records. Indeed, maintaining accounting records is key for any business. Therefore, it’s important to get this right from the outset.

Initial thoughts

Basic record keeping for business

What is the best way to keep business records when you are record keeping for small business? One of the best bookkeeping tips is to organise yourself with well-kept bookkeeping. In addition, a good starting point is to ensure you keep up with the updates on a regular basis. What’s more, when you’re keeping business records (UK) as a contractor or business owner, besides maintaining financial records, there may be other company records to maintain. Indeed, these other records may include:

  • Health and safety.
  • Employee records -this includes personal details such as national insurance numbers.
  • GDPR requirements, etc.

This article will focus on business record keeping tips. Indeed, this is in terms of how to keep bookkeeping records for a small business, including financial record keeping. Moreover, this is an especially important read for someone who is starting a business and keeping records for the first time.

Know from the outset which records to keep

Let’s suppose you’re a sole trader or a contractor starting up your own company for the first time. In this case, it is essential to know, from the outset about company record keeping. Indeed, this includes a contractors’ bookkeeping and which records one should retain. This also includes how to update and look after your business record keeping on an ongoing basis.

Common questions

If you’re a new business owner you may have various questions around how to do your company’s record keeping. Therefore, some common questions and thoughts around this will include:

  • What’s record keeping?
  • How to maintain accounts in business?
  • How to maintain small business accounts?
  • What is business record keeping?
  • How to maintain company accounts?
  • How to keep financial records for a small business?
  • What records to keep for small business?
  • How to start keeping books for a small business UK?
  • How to maintain accounts for small business?
  • How do I keep financial records in Excel?
  • Why you need good accounting records to satisfy HMRC?
  • How long do you have to keep business records UK?

In this article, we’ll look at all of the above and find out how to keep good records for your business.

Maintain business records (UK) 

How to keep accounting records for small business

When you are maintaining business records and organise these well, this will stand you in good stead. When we consider how to maintain records, if you keep up to this and ensure that the records are accurate, it will give you a good overall view of your company’s financial position. Indeed, when you organise your records well and are keeping business accounts, if these are accurate and up to date you can view these at any moment in time, should you need to.

It should be every contractor and small business owner’s aim to maintain accounts record keeping to a high standard. Indeed, keeping business records up to date is quite important. When limited company directors do so, they will have accurate data for either themselves or their accountant to:

  • Complete your business accounts for the company financial year and a company tax return. Once they are complete, you can then file the financial statements etc with HMRC and Companies House.
  • Complete your tax return for the personal tax year with income details from your business and any other personal income details. Once complete, you can then file your tax return with HMRC.

When you conform to the above, it will help you and your business stay on the right side of the various tax offices.

Use online contractor accounting software (UK)

If you use an online accounting digital service, such as FreeAgent, that is compliant with Making Tax Digital; this will make your updating easier. This is in comparison to the use of a contractor bookkeeping spreadsheet which was the usual way in the past. Basically, a digital platform is, in effect, bookkeeping software online and this is a good way to maintain business records. Indeed, when you use a digital service, it will help streamline your business’ bookkeeping and accounting. In addition, you can also make use of the FreeAgent invoicing system which makes sending invoices and reminders for these much easier. There are also many other plus points such as logging expenses and filing payroll amongst other features in digital software.

Besides key data such as your Balance Sheet and cash flow being available, small business record keeping software makes the updates to your business records with its financial transactions much easier than when you use a small business spreadsheet (UK) type system. Therefore, digital software helps you with business record keeping more effectively with regard to your business’s financial information.

Making Tax Digital (MTD) is now compulsory for VAT record keeping and the filing of VAT returns. In addition, it will also extend into other financial reporting areas in the future. The near future plans include MTD for landlords and Self Assessment is also on the horizon.

It is an excellent way to start if you organise your company well from the outset. It would help if you always aim to manage your accounts and small business bookkeeping (UK) effectively throughout the financial year. Your contractor accountant can help and advise you with regards to accounting and record keeping for small business.

Keeping your bookkeeping records on Excel

If you are not VAT registered, you may prefer to use a contractor or sole trader bookkeeping spreadsheet (UK) or even a business record keeping book. If you use a small business bookkeeping spreadsheet, you may ask how do you maintain bookkeeping in Excel? The answer here is you could set up an accounting spreadsheet yourself, or, your accountant may have a template spreadsheet for small business bookkeeping which you can use. Whichever template you use, you should ensure that all of the formulas are correct and include the relevant cells. Alternatively, if you use a record keeping book for business you should keep this up to date by updating it regularly.

Maintain business records -the types of business records to keep

As part of keeping accounts for small business, what records should you keep when you maintain records as a UK contractor? Basically, the types of accounting records for small businesses to keep are not set out by HMRC. However, these financial and accounting records for contractors and small businesses include:

  • Cash books if you keep any offline records and this could be used to record transactions. Prior to online accounting, most businesses would keep a cash book to record their business transactions.
  • Invoices or remittance advice for your services or sales.
  • Company credit card statements.
  • Payroll information (payroll records) you have a PAYE scheme. 

When you are a business owner, you will more than likely have to complete an annual personal tax return. Likewise, you will also need to keep and retain records of any details for your tax return for income tax purposes.

Other considerations

Maintain business records -how long to keep financial records for a business (UK) 

As part of your small business record keeping, you should be aware of how long to keep your records. Therefore, let us consider how long to keep tax records (UK limited company) for your business.

As a UK contractor or UK business owner, when we look at how long to keep business records (UK), the rule in place is six years. Therefore, you should be keeping accounting records for each of your accounting periods for a minimum of six years. Accounting periods usually cover a year; therefore, for the year to 30 June 2023, you should keep the records safe until July 2029.

The purpose of saving your accounting records for six years is that you may have a VAT, PAYE, or Corporation Tax review by HMRC in the future. They will have a requirement to see your records if you undergo an HMRC review. Once the six years have gone by, you can destroy the records. 

Maintain business records -keep up with it 

When you maintain your bookkeeping records (small business), it is a good idea to set up a process. Basically, this process or processes will be your business record keeping and you should stay on top of this from day one. While you maintain and are keeping business records, you can spend fifteen minutes per month to organise things and complete any necessary updates. Indeed, if you complete your business record keeping processes each month, it is an excellent way to keep on top of it. However, if you let it slip, this will leave you several months to catch up on all at once.

You could keep the actual small business bookkeeping on an Excel-type spreadsheet. You can also keep them on a digital service such as FreeAgent, especially if you should be maintaining VAT record keeping.

Your invoices and receipts, and mileage records should be kept either on a manual or electronic basis. You can also use a mixture of these storage methods.

If you use a limited company spreadsheet, you should ensure that you save both the basic bookkeeping spreadsheet and the actual records in a safe place. It is also wise to make a spare backup of the small business accounts spreadsheet.

Bookkeeping records -small business -move online 

Today, you can still use a contractor bookkeeping spreadsheet on Excel or another system if you are not VAT registered. You can use a basic accounts spreadsheet to maintain business records for your business. However, since Spring 2019, if you have VAT registration in place, you should maintain VAT record keeping on a digital system like FreeAgent. There are many other digital systems out there, however FreeAgent is very popular with limited company contractors and small businesses.

FreeAgent and other online systems also help improve how businesses update their books. This ia also a much more efficient way to maintain your VAT record keeping in comparison to the business accounts spreadsheet option. Basically, this is because they help keep the business up to date as they link directly to your company’s bank account. With a digital system, you should also be able to update your records on the go. Most, if not all, have an app which you can download to your smartphone.

When you have your records on the cloud, this will also mean they are up to date with the latest bank information at any time. You can link your bank account to the accounting record keeping software. As part of keeping financial records this way, you can see a snapshot of your company’s finances at any time, wherever you are at any given time.

Final thoughts 

As part of keeping business records and maintaining a financial record keeping system, most UK contractors nowadays use a digital platform such as FreeAgent. Generally, this is now the best way to keep records for small business. When we consider bookkeeping for contractors, they will update and maintain business records for their UK contracting company via FreeAgent on an ongoing basis. However, for some who do not register for VAT, if they prefer, they can still use a contractor bookkeeping spreadsheet.

When you are well-organised and keep good business records, it will stand you in good stead for your contractor accountant. Indeed, if you stay on top of this, it will also assist for your own reasons if you need to refer back to something in the future. Basically, if your records are well-kept, it is easier to locate past transactions if a query arises in the future. Finally, it is also important to have accurate and well-kept records in case HMRC ever do a review in the future.

Link to Contractor Advice UK group on


Published On: April 6th, 2023 / Categories: First timer guide, Record Keeping /

Share This Guide, Choose Your Platform!

Leave A Comment