The Book-keepers Forum (BKF)

Post Info TOPIC: Approach to accounts

Senior Member

Status: Offline
Posts: 234
Approach to accounts

So, I have a client that has grown in the past year and had also has opened a business bank account. I am not experienced in dealing with businesses that don't work with accounting software!

In the past he had shown a list of monthly invoices/receipts and a separate tab for sales invoices. Now that he has a bank account covering the full year, I had recommended that he downloaded the bank statement into csv format and label all the transactions creating a cashbook.

Then I thought it would be a simple exercise to figure out the unpaid items and adjust for this. There is no VAT involved.

So the bank statement PLUS unpaid sales invoices LESS unpaid purchase invoices would pretty much square things.

However, he has AGAIN decided to simply list all the purchase and sales invoices in 12 monthly spreadsheet tabs x 2 (sales AND purchases).

Whilst I do see that it is still easy to query unpaid sales and purchases invoices, would he (or me!!) have to go through the bank and invoice list and reconcile them (match the entries in the bank against the invoice list).

Or would the the calculated bank account balance less actual simply be taken to DLA?? Of course in a perfect world with no brought forward balances or cash payments etc., the bank would match the calculated balance if the unpaid invoices were complete and correct!


Veteran Member

Status: Offline
Posts: 52

What is the alternative, do a bad job of his accounts because he doesnt understand fully what you need?Tell him its going to cost extra as his bookkeeping has not been done fully. Does he know what invoices are o/s at year end? How does he monitor it? Maybe he has a system that he has not explained/you have not extracted the correct information out of him. He gets paid cash and keeps it? Then tell him you cannot re-write history by claiming a divi to clear his o/d DLA and he now has S455 charge to pay. You cannot force him to use software, its his choice, but he does need to keep proper accounting records. Explain his duty of care/tell him to stop using his ltd co as his own personal bank account and recommend he tweaks his processes (spreadsheets are fine) to resolve this or pay for a bookkeeper to sort once a month/quarter ready for year end. If you dont want a spreadsheet client, dis-engage.



Status: Offline
Posts: 696

Have to agree with MAAT there, you have 3 options;

1. Educate him into doing some proper bookkeeping or moving onto a system like QB etc

2. Accept that the data you're going to get is a mess and you'll essentially need to do the bookkeeping from scratch and bill him accordingly. If the bank plus all sales/purchase records are on s/s already then you could import it all into a system and probably automate a lot of work...obviously that doesn't need to be reflected in your quote

3. Decide that he does not fit your client criteria and set him free for someone else to deal with

Whether you go with 1 or 2 the accounts do need to be compiled and completed properly and not cobbled together because neither of you want to do the bookkeeping.



Responses are my opinion based on the information provided. All information should be thoroughly checked before being relied on.

Page 1 of 1  sorted by
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to
Members Login
    Remember Me  

2007-2019 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to:

Privacy & Cookie Policy  About