The ABC of keeping a book-keeping system

Book-keeping makes your paperwork easier.  It provides a system that tells you – and your accountant – exactly what is going on.

Whether you use a manual or computer-based system, the same principles apply.  It is worth deciding if you are going to computerise your accounts at an early stage.  While a traditional paper-based system will look suitable for many start-ups, the accounting function could soon swallow valuable time as your business starts to grow.  If you start with computerised accounts, there will be no need to go through the time consuming process of transferring your paperwork onto a computer package.

This briefing covers:

1.  How to record business income and payments
2.  How to use your bank statement to check that you have not made any mistakes
3.  Tips for cash businesses such as shops

What do you need?
You have to record all the money coming into your business and all the money going out, both to keep track of your cashflow and for your tax records.  To do this you will need:

(a)  A record of every sale.
Cash businesses, such as shops, will use till rolls and point-of-sale systems to record sales.
Non-cash businesses should issue an invoice for every sale.  Keep them in two files: Sales Paid and Sales Unpaid.

(b)  Invoices or receipts for every purchase.
Keep two files: Purchases Paid and Purchases Unpaid.

(c)  Records of payments into and out of your bank account
Open a separate business bank account and ask for monthly bank statements

(d)  Records of payments made by cash
Keep receipts for cash purchases in a box file labelled Petty Cash.

(e)  A Cash Book for summarising the information.  Cash Books come in hard copy and electronic forms.
You can buy an analysis book (a book with several columns on each page) from a business stationer.  This can be used as a hard copy Cash Book.  If you have accounting computer software it will perform the same functions as a Cash Book.

The Cash Book whether hard copy or electronic, simply records all the money coming into and going out of your bank account.  Your accountant can help you set up a simple book-keeping system, choosing headings to suit your business.

Sales
You need a simple routine procedure to keep track of your sales.

Every time you make a sale, issue an invoice.

Give every invoice an original number (1,2, 3 and so on) and keep a copy of each.
File the copy invoices in Sales Unpaid.  Put the most recent invoice on top.  The invoices will automatically be in date order.

When an invoice is paid, pay the customer’s cheque into your account, using the paying-in book provided by the bank.
On the stub of the paying-in slip write the date, invoice number(s) and amount(s).  Take the invoice from the Sales Unpaid file.  Write ‘paid’ plus the date in the top right-hand corner.  File the invoice in Sales Paid.  Put the most recently paid invoice on the top.  The invoices will automatically be in the order they were paid.

Once a week, update your Cash Book or software package.
Look through your paying-in book stubs.  Enter into the Cash Book details of all the invoices paid.
Check the Cash Book entries against the invoices in the Sales Paid file.  Put a tick against the invoice number on the invoice to show that the invoice details have been entered into your Cash Book.

Once a week check through your unpaid invoices and chase any that are falling due.
Everything will match.  Invoices are in the same order as entries in the Cash Book, which is in the same order as your bank statement.

Non-sales income
From time to time your business will have other income apart from sales.  This might include:
(a)  New loans or grants
(b)  Interest on your deposit account
(c)  Equipment disposals
(d)  Tax refunds

You will not receive invoices for all of these, but they will appear on your bank statement.
Every month enter details of these exceptional transactions in the Cash Book below the entries for money received from sales.

Purchases
Every time you make a purchase, ask for an invoice or a receipt and keep a note of all purchases for which you do not have a receipt.  File the bills in Purchases Unpaid in date order, with the most recent on the top.

When you pay a bill, write the date, supplier and amount on your cheque stub.  If you pay several invoices with one cheque, write down each amount and the total.  Take the invoice out of the Purchases Unpaid file and write the date and cheque number in the top right-hand corner.  File the invoice in Purchases Paid in date-of-payment order.  If you have a receipt, as well as an invoice, staple them together.

Once a week update your Cash Book or accounting programme.
Look through your cheque stubs.  Enter the details of the bills you have paid into the Cash Book.
Check the details against the invoices in the Purchases Paid file.  Put a tick against the cheque number (in the top right-hand corner) to show that the invoice details have been entered into your Cash Book.

Everything will match.  Invoices will be in the same order as entries in the Cash Book, which will be in roughly the same order as entries on your bank statement.

Cash purchases
Pay the cash out of your own pocket and write details of the purchase on the receipt.  Keep the receipts in your Petty Cash file or use a spike, which is convenient and automatically keeps the receipts in date order until you deal with them.

Total all the petty cash receipts monthly and write yourself a cheque for the total.  Attach the receipts to an A4 sheet and file in Purchases Paid.  Enter the details in the Cash Book

You can treat purchases by personal credit card in exactly the same way.
Refund yourself the total of all the business purchases with a business cheque when the credit card bill arrives.  Staple all the receipts to an A4 sheet.  Enter details in the Cash Book, with your name and ‘credit card refund’ in the supplier column.

The bank statement
Every month compare your bank statement and Cash Book.  After any errors are corrected, both balances should be the same.  Match each entry in the Cash Book with the entry on the statement.  If you regularly pay batches of cheques into your bank, you need a ‘bank’ column in the ‘money in’ section of your Cash Book.  This shows the total value of money paid in each day, which will match the figures shown on your bank statement.

Payments made by direct debit or standing order will not yet be recorded in the Cash Book.  Nor will bank charges and interest.  Enter the details in the Cash Book below the list of entries for cheques which have been written out that month.
Then tick off the item in the Cash Book and on the bank statement.  Make sure that every item appearing on the bank statement has been ticked off.

Some items will not yet appear on the bank statement.  Money paid in by you but not yet cleared (e.g. customer’s cheques) or cheques you have sent to suppliers which have yet to be paid into their accounts.

Calculate the adjusted bank balance.  The adjusted bank balance is what the bank balance would be if all the money paid in and all the cheques paid out were shown on the bank statement.  It equals the end-of-month balance showing on the bank statement plus money paid in but not on the statement less cheques written, but not on the statement.

Reconcile the bank statement.  Write down the adjusted bank balance at the start of the month and add the total sales revenue paid in and other income for the month (taken from your Cash Book).  Deduct the total payments for the month (taken from your Cash Book).  This should equal the adjusted bank balance at the end of each month.

When the figures agree, you have successfully reconciled your bank account.

If the figures do not agree, there is an error.  If the difference is $5.25, look for a sales invoice, other income, or payment entry for $5.25.  It should not take too long to find it.

GST
If your business registers for GST you will need to make some changes.

There will be very few complications on the sales side.  You must issue GST invoices and you should enter the details of the GST in a separate column in the Cash Book.

The golden rule is that you must have a GST invoice for all purchases. over $50.  For small purchases of standard-rated (12.5%) goods, you can calculate the GST paid.  Total cost x 12.5/112.5.  Enter the details of the GST in a separate column in the Cash Book.  Enter the total under ‘total’ in the Cash Book, enter the total less GST under the individual heading (e.g. stationery).

Cash businesses
If, like a shop, you sell for cash – as opposed to allowing customers to pay after a credit period – the basic principles are much the same.

Shops face two particular problems.
(a)  If you take cash (from sales) and spend it (e.g. on wages), it is easy to lose track of what is going on.
(b)  The tax office (and the IRD, if you are registered for GST) will always be more suspicious of cash.

However, there are simple steps you can take to avoid any complications.
Keep your till rolls or EFTPOS cash summaries.  Use them like sales invoices in your book-keeping and keep a separate record of all money going in and out of the till.  Reconcile this record daily or weekly to check that the amounts add up to the actual cash you have.  If you use money from the till for a purchase, put the receipt in the till immediately.

Please call us on 09 449 0417; 0800 836 836, or email us at enquiries@bizadvice.co.nz if you would like to discuss how we could help you with your book-keeping needs.

Download It Now – 100% FREE
I agree to have my personal information transfered to AWeber ( more information )
We're going to give this eBook 100% FREE. No cost. No money. Just fill out the form you'll have instant access to your eBook now, which is packed full of practical advice to reduce your next tax bill!
*Your information is private and we will never share, rent or sell it

Leave A Comment