Login

The lifecycle of an invoice.

by Stuart McLean 3. February 2010 05:59

Although many business owners do not wish to understand the intricacies of double entry bookkeeping, they are interested in invoices.  By understanding how an  invoice is processed through the books you will gain understanding of the bookkeeping process but also how your accounts can be used to assess how your business is doing.

A businesses books are made up of a set of accounts or (nominal accounts) with transactions debiting and crediting these accounts such that the sum of the balances of these accounts is always zero.  There are also accounts for customers and suppliers – although these do not form part of the businesses financial position.

Impact of the Invoice

When an invoice is raised there are 3 nominal accounts impacted – the debtors control account, the sales account and the sales tax control account.

So, an invoice for £100 + VAT at 17.5% will have the following impact.

Account Debit Credit
Debtors 117.50  
Sales Tax Control   17.50
Sales Type A   100

The customers account will also be debited £117.50 – but this does not form part of the financial accounts.

What can we use this for?

Manage debt

The debtors control account will show us the total amount owed by all our customers.  Keep this low!  Most software will also have an aged debt report which will apportion this debt to each customer and show how long it has been due for.  Use this to manage your cash flow.

Typical Aged Debt Report

Name Tel. No. 0-30 Days 30-60 Days 60-90 Days Older than 90 Days Total
A1 Design Services 01742 876 234 23535 0 0 0 23535
ABS Garages Ltd 0191 254 5909 0 0 0 2533.31 2533.31
Bobs Building Supplies 01983 567 123 0 11500 0 0 11500
Business Exhibitions 017684 30707 11.75 0 287.5 2066.62 2365.87
Compton Packaging 0191 121 9876 0 0 0 2807.04 2807.04
County Golf Supplies 0191 385 6432 0 0 0 2028.03 2028.03
Edward Stuart 0191 839 3940 0 0 0 2341.25 2341.25
F G Landscape & Design 01603 354564 0 0 0 11260.26 11260.26
Fred Briant 01908 78787878 470 0 0 0 470
Graham Electonics 0141 373 2828 0 0 0 4149.09 4149.09
Hausser GMBH 00 49 531 3443334 0 0 0 1975.16 1975.16
John Smith Studios 01327 617 542 0 0 0 972.07 972.07
Kinghorn & French 0191 676 5656 0 0 0 7398.35 7398.35
Macolm Hall Associates 01244 343433 0 0 0 6927.16 6927.16
Mikes Insurance Services 01754 234 895 0 0 0 3597.16 3597.16
Mile Road Health Centre 01981 674 234 0 0 0 2307.84 2307.84
Morley Solicitors 01789 656 556 0 575 0 392.67 967.67
One Customer   0 11595 0 0 11595
Patterson & Graham Garages 0987 678 234 0 0 0 915.24 915.24
Peter Young 08976 656 878 0 0 0 2106.84 2106.84
Picture Frame Ltd 01249 265 9874 0 0 0 311.56 311.56
Pond Supplies 1234567 0 575 0 0 575
Robertson Joinery 0181 789 2323 0 0 0 4550.2 4550.2
S D Enterprises 0191 937 9836 0 0 0 15339.68 15339.68
Stevenson & Smith 01244 453 232 0 0 0 1562.75 1562.75
Swan Leisure Centre 0191 567 2345 0 0 0 1598.83 1598.83
The Show Lodge 0121 383 0345 0 0 0 7148.07 7148.07
The Video Rental Company 0678 234 5678 0 0 0 2041.66 2041.66
Total   £24,016.75 £24,245.00 £287.50 £86,330.84 £134,880.09

Most software will also allow you to create statements for the customer showing what amounts are outstanding.

Monitor how much VAT you will have to pay. 

For companies using standard VAT (rather than cash accounting) VAT is due on invoices raised.  So, the amount of VAT to pay in the next return will be the (approximately) the difference between the Sales Tax and Purchase Tax control accounts.  Make sure you have taken this into account in your cash flow – make sure you have enough money in the business to pay the VAT.

Sales analysis

This invoice was raised to the sales account “Sales Type A”.  The sales accounts accumulate the total invoices or sales over the financial year.  So, by creating different sales accounts to represent different areas of the business you can see which areas of business are generating the most revenue.

For example, you may choose to create sales accounts based on geographic area – creating Sales North, Sales South, Exports etc.

Alternatively you may use different areas of your business such as consulting, advertising, wood products and metal products.

Impact of the Receipt

Hopefully you will get paid for your invoice.

When this happens you record a customer receipt.

  Debit Credit
Debtors   117.50
Bank Account 117.50  

The customer account and the individual invoice will also be credited with the received amount.

The customer receipt has the effect of debiting the Debtors control account by the amount received and debiting the Nominal account representing the bank account.

The original debt has been removed from the Debtors' control account and the same amount Debited to the bank account.

Many people (including myself) become confused at this point.  Having received money from a customer and paid it into my bank account – why is the account debited?

To understand this we first look at the accounting equation:

Assets  = Liabilities + Owner’s Equity

In order to ensure that this equation always balances bookkeepers use a trick – they record an increase in the value of everything on the left of this equation as a Debit and an increase in the value of everything on the right as a Credit.

(In my opinion the equation should read: Assets + Liabilities + Owners Equity = 0).

This is why when you pay money into your account the tiller will “Credit” your account.  To the bank your account is a liability so to increase the value they credit it.  You debit your account because to you its an asset.

If you didn’t follow this – don’t worry.  What you do need to know is - both the Debtor’s control account and the Bank Account are assets of the company so we debit these accounts to increase their value.

What can we use this for?

Monitoring the cash position of the business

The books tell us how much money is actually in our bank account.

Monitoring the speed, frequency and pattern of payments from customers

Look historically at customers who take a long time to pay and maybe ask for up front payments from them.  Look for payment patterns – if a customer always seems to  pay at the end of a quarter perhaps this is the best time to do business with them or to ask for payment.

Reconciling our bank accounts.

 

Since we have a complete list of transactions against the bank account on our books and a complete set

Conclusion

A basic understanding of double entry bookkeeping coupled with a decent accounting system can help you manage your cash flow more efficiently.

Bookmark and Share

Tags: ,

Bookkeeping

Comments

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading



Blogs

Here we post general information about Fusion Accounts, bookkeeping and running a business.  Please feel free to comment on these blogs.

Tag cloud