The Book-keepers Forum (BKF)

Post Info TOPIC: Looking for Book keeping templates plz


Member

Status: Offline
Posts: 8
Date:
Looking for Book keeping templates plz


 

Hi

Does anyone have any examples of spread sheets for money in and money out that are typically used for a small vat register business that mainly deals in cash sales. Something that one could complete them self and send it off to a chartered accountant annually to be finalized?

 

Thanks

B&B



__________________


Senior Member

Status: Offline
Posts: 359
Date:

Best getting one from that chartered accountant. Who will do the MTD part?

__________________

Caron



Master Book-keeper

Status: Offline
Posts: 3904
Date:

^^  What Caron said but if not have a look at VT Cash Book.  It's not a spread sheet as such but it will allow you to record income and expenditure and then export the relevant information or even just send the file to them on completion of tax year.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Member

Status: Offline
Posts: 8
Date:

Sorry I may of said it wrong, I dont want to do this on a computer. I want to do it in a book with pen and paper

__________________


Veteran Member

Status: Offline
Posts: 88
Date:

Try Ryman, I think they might still deliver. They sell Collins VAT Book and Cash Books.



__________________

Lorraine 



Master Book-keeper

Status: Offline
Posts: 3904
Date:

In that case you want an analysis ledger. The trouble is you can't use them to do your VAT if over the VAT threshold.

This is an example although you can get them with less columns.

https://www.postofficeshop.co.uk/office-supplies/business-books-and-forms/analysis-books-and-pads/guildhall-31-series-account-book-20-cash-columns-1030



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Veteran Member

Status: Offline
Posts: 88
Date:

I think you can request permission from HMRC to submit a paper copy of the VAT Return in certain circumstances - such as disability, or being in an area with no internet access. I'm not sure if that's applicable in this case, though. 

The HMRC web-site will keep you right  - 

https://www.gov.uk/vat-returns/send-your-return

Hope that helps. 

 

 

 



__________________

Lorraine 



Master Book-keeper

Status: Offline
Posts: 8646
Date:

biggings and beegle wrote:

Sorry I may of said it wrong, I dont want to do this on a computer. I want to do it in a book with pen and paper


What is your turnover (sales)?        What was it when you registered for VAT?

Is it a Limited company, sole trader or partnership?

Give us an ideaof the sector you are in (not the business, unless you want to, but the sector).   

Are you planning on doing just the VAT in this way?   What about the general bookkeeping?

Why is your Accountant not assisting with such questions and suggesting something that is suitable having the knowledge of you and your business, rather than folk guessing with the answers on here?



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 8
Date:

The kind of template I had in mind was an expenses spred sheet page, where it would list in columns thing like cleaning, fixtures and fittings, travel ect. The page where you would record all the recites you had collected

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:

biggings and beegle wrote:

The kind of template I had in mind was an expenses spred sheet page, where it would list in columns thing like cleaning, fixtures and fittings, travel ect. The page where you would record all the recites you had collected


 Can you please answer my questions.

 

They are important because VAT reporting rules have changed massively in the last 12 months.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 8
Date:

Cheshire wrote:
biggings and beegle wrote:

The kind of template I had in mind was an expenses spred sheet page, where it would list in columns thing like cleaning, fixtures and fittings, travel ect. The page where you would record all the recites you had collected


 Can you please answer my questions.

 

They are important because VAT reporting rules have changed massively in the last 12 months.


 

I think I allready did!

biggings and beegle wrote:

The kind of template I had in mind was an expenses spred sheet page, where it would list in columns thing like cleaning, fixtures and fittings, travel ect. The page where you would record all the recites you had collected


 



__________________


Senior Member

Status: Offline
Posts: 359
Date:

no you didnt answer Joanne.

Bear this is a forum for bookkeepers and accountants not businesses to get free stuff.

So what has your Accountant suggested? Why has he/she not given you a template. Look at VT as John suggested!

__________________

Caron



Veteran Member

Status: Offline
Posts: 88
Date:

Hi B&B, 

Did you have a look at the analysis ledger book that John has suggested in his post? I've had a look at a few online retailers and that one looks  to be really good value. You would need to complete the column titles yourself to allocate the expenses but if you get a copy of the businesses accounts for last year and look over any previous business records you will get a sense of what columns you will need going forward. And you could ask the accountant for their advice on that. 

If you want to be able to record income also and have a weekly record of the cashflow then have a look at the selection of accounting books that Ryman and Amazon sell. I saw this one -

https://www.ryman.co.uk/simplex-account-book-a4-56-pages-28-sheets

There is a big selection of accounting books for small businesses on the Ryman web-site, and if John's suggestion doesn't work for you I think you will find an alternative there that does.

As John points out though, since the business you refer to is VAT registered then quarterly VAT returns will also need to be addressed and, apart from in exceptional circumstances, these need to be submitted electronically to HMRC. Its important that the business has a method in place for doing so, if the business plans to remain VAT registered. 

Hope that helps?

 

 

 

 



__________________

Lorraine 



Senior Member

Status: Offline
Posts: 359
Date:

OK why doesnt everyone just stop providing advice when we do not have access to the FACTS.

OP - answer Lorraines points ie

do you have a disability?
do you have internet access?

Without the above the point of suggesting use of books is BAD advice

Then answer Joannes questions.






__________________

Caron



Member

Status: Offline
Posts: 8
Date:

Lorry10 wrote:

Hi B&B, 

Did you have a look at the analysis ledger book that John has suggested in his post? I've had a look at a few online retailers and that one looks  to be really good value. You would need to complete the column titles yourself to allocate the expenses but if you get a copy of the businesses accounts for last year and look over any previous business records you will get a sense of what columns you will need going forward. And you could ask the accountant for their advice on that. 

Its no more than a blank book! Its the info of categories I put inside it that I need. I have no last year accounts as I have no running business at the moment, but if this forum is not for business people to come get free advice (as stated above) then there is no point going further with this thread


__________________


Member

Status: Offline
Posts: 8
Date:

Casu wrote:

OK why doesnt everyone just stop providing advice when we do not have access to the FACTS.

OP - answer Lorraines points ie

do you have a disability?
do you have internet access?

Without the above the point of suggesting use of books is BAD advice

Then answer Joannes questions.





 OK I think on that note then we will wind this thread up and call it a day



__________________


Senior Member

Status: Offline
Posts: 359
Date:

biggings and beegle wrote:
Lorry10 wrote:

 

, but if this forum is not for business people to come get free advice (as stated above) then there is no point going further with this thread

 The problem with giving advice to business owners on a forum is that you only have the bland original question and not the specifics about that particular business and businss owner behind it.  Without delving you will not get the information you require to form a proper and detailed view. Without forming that proper and detailed view people will give bad and wrong advice.

Often business owners think that they have a simple question, but there is no such thing, we need the information behind the question. Many folk do not know what they do not know hence why they end up receiving or giving dodgy advice.  Hence why I said you need to speak to your accountant.

Do you know what VAT scheme you are on? Do you know what all the relevant tax points are that could relate to the way you do business? Do you know what is a legitimate business expense that you can claim VAT back on for the type of business you are running?   We know none of these, never mind the other questions that remain outstanding that have openly been asked or at least alluded to by other posters.

Just one reason why we do not give advice to businesses on here. 



__________________

Caron



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Casu wrote:
biggings and beegle wrote:
Lorry10 wrote:

 

, but if this forum is not for business people to come get free advice (as stated above) then there is no point going further with this thread

 The problem with giving advice to business owners on a forum is that you only have the bland original question and not the specifics about that particular business and businss owner behind it.  Without delving you will not get the information you require to form a proper and detailed view. Without forming that proper and detailed view people will give bad and wrong advice.

Often business owners think that they have a simple question, but there is no such thing, we need the information behind the question. Many folk do not know what they do not know hence why they end up receiving or giving dodgy advice.  Hence why I said you need to speak to your accountant.

Do you know what VAT scheme you are on? Do you know what all the relevant tax points are that could relate to the way you do business? Do you know what is a legitimate business expense that you can claim VAT back on for the type of business you are running?   We know none of these, never mind the other questions that remain outstanding that have openly been asked or at least alluded to by other posters.

Just one reason why we do not give advice to businesses on here. 


 Totally agreed.  Lol on your copy and pasting Caron, plus now pinching some of my fave sayings.   Young Padawan wink

 

Does beg the question - why has the OP registered for VAT if no/minimum sales as yet.   Unless for the usual reasons, but not obvious on a NIL information base.

 

Highly recommend that you get that Accountant on board before you do ANYTHING else.   Think - tax planning...key is in the word 'planning'.  Could save yourself a fortune in the long run.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 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: bookcertltd@gmail.com.

Privacy & Cookie Policy  About