Set up a basic record-keeping system

Whatever kind of business you run, you are required by law to keep financial records relating to it.

There are a number of business benefits to be gained from keeping accurate and up-to-date records. It saves you time, and therefore money, whenever you need to produce financial reports. You can be confident that you’re only paying the tax you owe. It also helps you keep up to date with how much you owe to suppliers and how much you are owed by customers.

This guide shows you how to meet your legal obligations and set up a basic system that works for you.



What should my system include?

There are six basic sets of financial records that should help you run a tight business:

  • the cash sales book
  • the cash purchases book
  • the cash book summary
  • the sales ledger
  • the purchase ledger
  • the wages book (only needed if you employ staff)

See the other pages in this guide for more information.

The law states that all business owners must maintain financial records and retain them as a general rule for a minimum of six years. However, if you are:

  • an employer, you need to keep Pay As You Earn (PAYE) records for three years (in addition to your current year)
  • a contractor in the Construction Industry Scheme (CIS), you need to keep your CIS records for three years (in addition to your current year)
  • keeping records to complete a personal (non-business) tax return, you only need to keep them for 22 months from the end of the tax year to which they relate

Although the level of record keeping required may vary from business to business, it should include:

  • all receipts and expenditure
  • all goods purchased or sold

There are no rules about the format you must use to record your figures – those kept on paper are just as valid as those stored on computer.

What’s important is that you keep accurate, relevant financial records and update them on a regular basis. You may incur a penalty if you’re unable to back up the statements made in your income tax or VAT (if it applies to your business) returns.

Small businesses that are above the VAT threshold may be able to take advantage of the simplified record-keeping requirements afforded by the VAT Flat Rate Scheme. See our guide on VAT accounting schemes: the basics.


The cash sales and purchases/expenses books

The cash book is the central record of all the money that comes into and goes out of your business – often referred to as cashflow.

To complete your cash book, you’ll need to collect and hold on to:

  • cheque book stubs
  • cancelled cheques
  • bank paying-in books
  • bank statements
  • copies of your own invoices
  • receipts and delivery notes
  • your suppliers’ invoices
  • receipts for all cash purchases, till rolls, etc
  • remittance advice slips from customers
  • copies of payments made or received using online banking systems
  • credit or debit card statements
  • credit and debit card transaction slips/vouchers

A separate record for sales and purchases (receipts and payments) is sensible. Once you have a turnover of more than £77,000 (the VAT registration threshold) it will help you calculate your VAT liability – the difference between the VAT you reclaim and your total VAT on sales.

See the example spreadsheets below:

Cash book – sales

DateCustomerAmount
received
Cash salesChequeCredit
/debit card
Bank pay-in amounts
       

Download our cash book spreadsheet for sales [opens in a new window].

Cash book – purchases and expenses

DateSupplierAmount paidPaid cashPaid chequePaid credit/debit card
      

Download a cash book spreadsheet for purchases and expenses [opens in a new window].

Recording the type of expense – business related or personal – will help when filling in your annual tax and VAT return (if registered for VAT). You will need to be able to distinguish between ‘allowable’ expenses and ‘non-allowable’ expenses. Find out about different kinds of expenses on the HM Revenue & Customs website- Opens in a new window.

Check the individual entries in your cash book with the bank statement to pick up items paid directly into your bank account. If you pay by cheque, you should also check that these have been properly credited by your suppliers.

The cash book summary reconciles the totals from the cash book sales and cash book purchases and expenses. It helps you check what your opening and closing balances are and helps you monitor how your business is performing.

Cash book – summary (reconciliation)

Date Amount
 Opening cash balance (A) 
 Cash receipts (B) 
 Cash banked (C) 
 Cash payments (D) 
 Closing cash balance (E) 
   
Date Amount
 Opening cheque account balance (F) 
 Total value of pay-ins for period (G) 
 Total value of payments for period (H) 
 Closing cheque account balance (I) 
   

Download our cash book summary spreadsheet [opens in a new window].

To reach the closing cash balance (E), the calculation is (A + B) – (C + D) = E.

To reach the closing cheque account balance (I), the calculation is (F + G) – H = I.

The closing cash balance (E) should always equal the cash in hand. If it does not the discrepancy should be investigated. It may be because of an unentered receipt or payment.

The closing cheque account balance (I) should always equal the balance on the bank statement at the close of business on the same day as the cheque account is made up to, after allowing for unpresented cheques or bankings.

Small, simply structured businesses may find the cash book above sufficient. However, keeping sales and purchase ledgers as shown later in this guide will enable you to record sales, purchases on credit, and keep track of amounts owed to you from sales and by you for purchases. This will make it easier to monitor your cashflow.

Many businesses choose to use accounting software to help them manage accounts more efficiently. It can make the process quicker and more straightforward. Using accounting software can also make the process of e-filing (submitting records electronically) very simple. See the page in this guide on computerising financial records.


The sales ledger

A sales ledger normally records:

  • the sales your business has made
  • the amount of money received for your goods or services
  • money owed (debtors) at the end of each month

It’s a useful business-planning tool, enabling you to monitor and chase slow payers and see which customers are most profitable. Also, if you are VAT registered, it can help you with calculating your VAT liability and submitting your VAT Return. For more details on VAT, see our guide – introduction to VAT.

Sales ledger

DateInvoice
number
CustomerNetVATGrossDate
paid
Payment
type
        

Download our sales ledger spreadsheet [opens in a new window].

How do I use my sales ledger?

Every time you invoice a customer, record it in the sales ledger – do this regularly, at least once a week. Each week or month, you can add up the total amount of sales invoiced by you, also called turnover (an important business statistic). By recording the amounts paid by customers in the sales ledger you will also be able to identify the money owed to your business. Any customers that have exceeded your payment terms can then be chased.

If you choose to use accounting software, the process of identifying overdue payments will be quicker and easy. See the page in this guide on computerising financial records.

If you are not VAT registered then you have no need of the ‘Net’ and ‘VAT’ columns.  For more details on VAT, see our guide – introduction to VAT.

To support your sales ledger you need to keep copies of your invoices. These must be kept on file or on computer for six years. It will assist tracing sales invoices if you give each sales invoice a number and record this number against an entry in the ledger.

If any of your customers has both cash and invoiced sales, the sales ledger can be used to record both. In these cases, the cash sales are normally recorded in the sales ledger on a daily basis, and should be supported by till receipts or any other record issued to the customer. The entry in the sales ledger can just say ‘cash sales’ in the customer column.


The purchase ledger

A purchase ledger records all purchases made by your business.

It helps you to monitor:

  • your business’ outgoings
  • how much money you owe (creditors) at any one time

In addition, it gives you a record of your most regular suppliers and how much you have spent with each.

If you are VAT registered it can also help you with calculating your VAT liability and submitting your VAT Return. For more details on VAT see our guide – introduction to VAT.

See our example of a typical purchase ledger- Opens in a new window.

Download our purchase ledger spreadsheet [opens in a new window].

To support your purchase ledger for reconciliation purposes you may wish to make reference to bank or card statements.

How do I use my purchase ledger?

By recording in the purchase ledger payments for purchases you have made, you will be able to identify the amount unpaid. Each time a payment is made, note it in the “Date paid” column. You can add up the totals on a regular basis to see how much you owe.

It is a good idea to number each bill when you receive it and record this number against an entry in the ledger. It is also advisable to file the bills in numerical order. That way, you will be able to easily find the bill if a query arises at a later date.

If you are not VAT registered then you have no need of the ‘Net’ and ‘VAT’ columns.  For more details on VAT, see our guide – introduction to VAT.


The wages book

If you employ staff, you will need to keep a record of how much you pay each of them and the deductions made from their wages.

For each employee you must keep a record of:

  • their gross pay (the mains things that count are wages, salary, overtime payments, statutory payments)
  • any tax deducted or refunded
  • any National Insurance contributions (NICs) deducted or refunded
  • any Student Loan deductions

HM Revenue & Customs (HMRC) provides a form – P11, Deductions working sheet – on which to manually record these details and keep as your wages records.

HMRC strongly recommends using payroll software to automate your payroll function. There are many advantages to using payroll software. It makes calculating and paying wages quicker, and also makes end-of-year reporting easier. For more information, see our guide on payroll software.

Why do I need to keep wages records?

  • You will have a single, detailed record of one of the most significant costs for most small businesses.
  • You will be able to easily answer any staff questions you may receive when they come to do their own self-assessment income tax returns.
  • You will be able to prove that you pay the national minimum wage and equal pay for work of equal value should you need to.

Computerising financial records

A computerised system can save you a great deal of time. It will allow you to add, delete, amend and share your data easily and will recalculate your running totals for you.

Computerising your accounts can also have wider business benefits. It will allow you to file government returns (such as VAT and tax returns) online as well as potentially enhancing your business’ ability to communicate online with customers for applications such as e-invoicing.

Choosing a software package

You can either use your computer’s standard spreadsheet package or you can buy an accounting software package.

Accounting packages have been developed to meet the needs of most small businesses. Well-known packages include:

  • Sage Instant Accounting and TAS Books
  • Intuit QuickBooks and QuickBooks Pro, Regular and Accountant
  • Pegasus Capital Gold

More advanced accounting packages are sold in ‘modules’, with each one handling an aspect of financial management. Most businesses buy at least three modules (sales, purchase and nominal ledger). Well-known packages include:

  • Sage Line
  • Pegasus Opera

Remember if you are using an accountant, your software packages should be compatible.

If you are registered for VAT, your system must enable you to meet your legal obligations to:

  • account for VAT properly
  • provide information to inspectors should they visit you
  • keep records in the required detail for the required length of time

For more information see our guide on accounting software.

HM Revenue & Customs (HMRC) has been working with the IT software development industry to facilitate the provision of simple mobile record keeping applications (apps) for small businesses and the self-employed that are below the VAT threshold. Some of these apps are available now. Find simple record keeping apps on the HMRC website.


Hints and tips

To keep good control of your financial record-keeping, get into these good habits.

Hints and tips

What you need to doWhen
Record sales in the sales ledgerdaily or at least weekly
Record payments received in the sales ledgerdaily or at least weekly
Record purchases in the purchase ledgerdaily or at least weekly
Record payments made in the purchase ledgerdaily or at least weekly
Reconcile the sales and purchase ledgersevery month
Chase all outstanding paymentsas soon as they are overdue
Check your cash book against your bank statements and your sales and purchase ledgers against your cash bookevery time you receive a bank statement

And try the ‘four S’ approach:

S is for…system – spend time setting up a system which you stick to. Allocate a regular time every week/month to deal with your financial administration, or make it a key task for a trusted employee. File your records logically – put receipts in date-marked envelopes or folders and file bank statements in order.

S is for…separate – one of the biggest mistakes business owners make is to mix their personal and professional finances. It is best to treat the business as a separate person, from which you only take income in the form of wages, dividends and in claiming back business expenses against receipts. So keep it separate – and simple.

S is for…security – the fewer people involved in your record-keeping, the fewer the errors that are likely to creep in. Make it very clear whose responsibility it is to maintain records. It is a good idea to password-protect your computer records, and only divulge the password to a small number of people.

S is for…(safe) storage – even if you choose to keep all your records on a computer, it is vital that you keep a regular (weekly, if not nightly) electronic back-up, and a paper copy elsewhere. Store records that cannot be copied, such as chequebook stubs and paying-in books, in a fireproof box.


CASE STUDY

Here’s how I established an effective record-keeping system

Michelle De Bruyne used an accountant to set up her limited company, AmHealthy, which markets a herbal nutrition programme. However, she decided to do her own bookkeeping. Good organisation, she says, has helped her track the progress of her business as well as look after her customers.

What I did

Devise a filing system

“It’s very easy in this business to know what payments are coming in because customers often purchase a complete one-month nutrition programme. It’s the small costs, like local advertising and postage that are harder to keep track of. There are lots of small receipts.

“I put all my receipts into appropriately labelled plastic sleeves in a lever arch folder that’s also divided on a month-by-month basis. If something is paid for by cash, the receipt goes into the cash sleeve; if by bank account, into the bank-account sleeve; and if by credit card, into that sleeve. Every time I get a receipt, I make a decision about which folder it goes into. Also, if the receipt doesn’t state what was purchased, I immediately write on it what it was for.

“In fact, all paperwork to do with the business is kept in an ordered filing system. It’s especially important as the business is a limited company and I know the obligations that brings.”

Separate business from domestic expenses

“Because I run my business from home, there are often mixed expenses. For example, I might have bought one item for the business alongside all my food for the week. All those expenses add up too, so I tag the business items on the receipt with a tick and that then goes into the relevant sleeve too.”

Use a computer and back up data regularly

“Our bank gave us an accounting package when we opened our business account and that has proved very helpful. It allows for categories such as marketing, administration, telecoms and stationery, so I can enter the relevant figures from the filed receipts directly into the relevant category. It really helps me keep track of how much I’m spending, on postage for example.

“I keep customer-order records on the system too. It’s such a prompt for me to know who’s buying what and when. It’s important marketing information. I back up the computer records at least once a month.”

What I’d do differently

Think about a system before I started up

“I was very disordered when I first started. Now I file receipts as I get them and when I receive statements, I use that as a prompt to enter data on to our accounting system and to reconcile things. Developing a routine has been very helpful. An early investment in files and computer software does pay dividends later.”

For more information on effective record-keeping, see our guide on how to set up a basic record-keeping system.

Every effort has been made by the author(s) to ensure this article’s accuracy but it does not constitute legal advice tailored to your circumstances. If you act on it, you acknowledge that you do so at your own risk. We cannot assume responsibility and do not accept liability for any damage or loss which may arise as a result of your reliance upon it.