-
23-07-2015, 05:58 PM
#161
Capital Allowance
This sheet is great - but I have a question for my first year of accounts
Do you insert capital allowance purchases in the months as you go, or keep them separate for end of year fill in on HMRC website?
Thanks in advance everyone
-
24-07-2015, 09:03 PM
#162
Where do you place capital allowance expenses on the spreadsheet?
-
25-07-2015, 10:17 PM
#163
Originally Posted by
Steve Francis
Where do you place capital allowance expenses on the spreadsheet?
Hi Steve, I just add them as I go as an expense. The spreadsheet totals them up for you for the claim at the end of the tax year.
Thanks!
-
13-09-2015, 03:35 PM
#164
Hi
Was looking for something like this, brilliant sheet, however i am having trouble opening the 2015-2016 file. i have managed to open the 2014-2015. I believe the reason is because i have excel 2003 saved on my computer. Can you please advice if there is a way around this or i will just have to save the 2014-2015 and change the dates..
many thanks
-
13-09-2015, 08:33 PM
#165
Hi,
Thanks for the interest in the worksheet. No problem, I've uploaded a version to work with Excel 97 - 2003 so hopefully this will work ok. It's on this page for download:
Childminding Accounts Worksheet Download - Home
and just select the 2nd link.
Hope this help
Thanks.
Originally Posted by
brightstars2015
Hi
Was looking for something like this, brilliant sheet, however i am having trouble opening the 2015-2016 file. i have managed to open the 2014-2015. I believe the reason is because i have excel 2003 saved on my computer. Can you please advice if there is a way around this or i will just have to save the 2014-2015 and change the dates..
many thanks
-
Post Thanks / Like - 0 Thanks, 3 Likes, 0 Dislikes
-
14-09-2015, 10:43 AM
#166
Originally Posted by
happytoddlers
Hi,
Thanks for the interest in the worksheet. No problem, I've uploaded a version to work with Excel 97 - 2003 so hopefully this will work ok. It's on this page for download:
Childminding Accounts Worksheet Download - Home
and just select the 2nd link.
Hope this help
Thanks.
Hi
You are a STAR! thank you, a life saver.
thanks
-
23-09-2015, 11:48 AM
#167
Thank you so much for this, I've got my first mindee starting tomorrow and was starting to panic about the accounts, I have now calmed down, you're a lifesaver!
-
Post Thanks / Like - 0 Thanks, 1 Likes, 0 Dislikes
Rick liked this post
-
02-10-2015, 10:07 AM
#168
Sorry to be a pain but does anyone know where I would put rent in the spreadsheet? Would I put it down as a shared cost and then work out the proportion that I can claim? TIA
-
21-10-2015, 08:02 PM
#169
Hours problem
HI first of all I would like to say a big thank you, I have used your books for the previous year and this year. But I just wondered if you can help me as I have just noticed that on the front page where it calculates everything my weekly hours are not showing up from June onwards... do you know what this could be? thank you I hope you can help.
Kirsty
-
04-11-2015, 03:33 PM
#170
Originally Posted by
happytoddlers
Hi,
Thanks for the interest in the worksheet. No problem, I've uploaded a version to work with Excel 97 - 2003 so hopefully this will work ok. It's on this page for download:
Childminding Accounts Worksheet Download - Home
and just select the 2nd link.
Hope this help
Thanks.
This is amazing thank you so much from a Newbie on here and to Child minding!! This will be a life saver as I get on my feet!!!
-
08-11-2015, 12:29 AM
#171
Originally Posted by
Kirsty Mapes
HI first of all I would like to say a big thank you, I have used your books for the previous year and this year. But I just wondered if you can help me as I have just noticed that on the front page where it calculates everything my weekly hours are not showing up from June onwards... do you know what this could be? thank you I hope you can help.
Kirsty
So sorry I've only just seen this message. The issue you've found is known and can be fixed.. see Childminding Accounts Worksheet Download - Home and see the bottom of the page. If you're worried about doing the update then please feel free to PM me and I'll do the update for you.
Thanks!
-
27-12-2015, 10:45 AM
#172
No idea at all!
Hi This is amazing what you are doing for fellow childminders and I admire the support and advice you are giving everyone.
My problem may be staring me in the face but I do not find your sheets to be as easy as everyone is saying. I have been using the Pacey account books for the last couple of years and they are a drag with all the math that my brain has to figure out. So your sheets sound great but I don't understand them so well.
There seems to be just a summary sheet for the whole month/year and no where to actually enter the daily expenses. (food, toys, outings ect)
Am I missing a link?
I would be very grateful if you could help me out as I am hoping to that my life can be made a lot easier like you have made others.
Thanks a million for your time and help.
Pippa S
-
30-12-2015, 04:24 PM
#173
Hi,
This looks great and something ive been looking at getting sorted for a long time..however I cant work out a few things..
Your council tax for example shows as £150..do I put my actual council tax amount per month in that box?
The hours worked I put in as 40 but its changing them to 960?!
I haven't got any further as wanted to see what I was doing wrong!!
Thanks
-
02-01-2016, 12:17 AM
#174
Hi Pippa,
Thanks for the message and sorry for the delay in getting back to you. For entering in the expenses etc., you need to click on the relevant month tabs along the bottom. Can you please tell me which software you are using? Excel, Libre, OpenOffice? Feel free to private message me.
Many thanks!
Originally Posted by
Pippa Saines
Hi This is amazing what you are doing for fellow childminders and I admire the support and advice you are giving everyone.
My problem may be staring me in the face but I do not find your sheets to be as easy as everyone is saying. I have been using the Pacey account books for the last couple of years and they are a drag with all the math that my brain has to figure out. So your sheets sound great but I don't understand them so well.
There seems to be just a summary sheet for the whole month/year and no where to actually enter the daily expenses. (food, toys, outings ect)
Am I missing a link?
I would be very grateful if you could help me out as I am hoping to that my life can be made a lot easier like you have made others.
Thanks a million for your time and help.
Pippa S
-
02-01-2016, 07:40 AM
#175
I have a question I've been meaning to ask and I did my tax return a couple of days ago so have finished the accounts and need to print them all to file away
Is there an easy way to get them to print out and not spread over several pages? I'm using libre office and have tried changing page orientation and have made margins smaller but can't delete the empty columns and if I pick shrink to fit page it doesn't seem to make any difference.
It's the 2014/2015 I'm trying to print, and probably missing something obvious!
-
02-01-2016, 11:01 PM
#176
Hi,
It's a good point. The layout of the sheets isn't ideal for printing. I think this should be a priority for the 2016-17 worksheet. feel free to email your final worksheet to me at msn@horrod.com and I'll convert it to pdf which will print out better.
thanks,
Originally Posted by
alex__17
I have a question I've been meaning to ask and I did my tax return a couple of days ago so have finished the accounts and need to print them all to file away
Is there an easy way to get them to print out and not spread over several pages? I'm using libre office and have tried changing page orientation and have made margins smaller but can't delete the empty columns and if I pick shrink to fit page it doesn't seem to make any difference.
It's the 2014/2015 I'm trying to print, and probably missing something obvious!
-
18-01-2016, 07:05 PM
#177
Originally Posted by
happytoddlers
Hi All!
I recently started childminding and found that the book keeping has been a bit of a headache
. Although the NCMA forms are a good starting point, I did find that there was a lot of repetition on entries and endless flicking through pages of weekly accounts / totals / this and that...
So last night
I decided to create this in excel in a format that is useful and does all the calculations for heating/lighting, Council tax, Water etc... by proportioning your weekly hours with the guidelines stated by the HMRC. It also calculates the end-of-year accounts on the fly and gives a profit/loss graph. I certainly think this will save me a lot of time (of which I just didn't have!) and make the tax return a lot easier.
Feel free to use it although you may want to check my calculations. I've locked the cells that you don't need (shouldn't) change because they're calculated for you. I've coloured the cells in blue which are the ones you can alter.
Hope someone finds this useful!
Thanks,
Hayley
<Note from admin - See post 88 in this thread for the latest spreadsheet 2014/15>
hi there
Just started childminding business and came across this very amazing tool and was wandering where do i (record)put expenses that i have made prior starting childminding(house renovations,toys,gates,etc....).I have started on the 7/12/2015 and have been able to record all expenses and incomes from that date.Also are wages recorded as expenses?
-
18-01-2016, 07:13 PM
#178
Hi there
Thanks for this very useful worksheet,i have started childmindng last december 2015,and came accross this tool,was wandering where do i record all the expenses that i made before starting(e.g house renovation,heater,gates ect...) and also does wages count as expenses?
-
20-01-2016, 05:03 PM
#179
Hi happy toddler
Thanks for the worksheet,just want to ask a quick question,I have started my business on December 2015,supposing that I am using the worksheet to input sales and expenses, on the electricity ,council tax and water expenses ,as I understand it is calculated based on the working hours.And on the yearly account the working hours are added together and divided by weeks to get the average weekly working hour,but if you have traded only for half of the year(6months or 3months),it is still divided by 52,which will give you less average working hour.
-
21-01-2016, 10:23 PM
#180
Hi myriamabedi,
I found this extract that may answer your first question:
If the expenses were incurred within seven years of your starting to trade, and the expenses would have been tax-deductible if you had incurred them while you were trading, then you can claim they were incurred on your first day of trading. This rule does not apply to expenses that will form part of your accounts in any case, for example costs of stock.
If I were you I'd put all pre-trade expenses on the month you're starting (December) but put the receipt date as the date of the expense. This is purely for 'keeping a record' sake. Hopefully all pre-trade expenses were on or after April 2015? (cos that would keep it simple). My only advise is that if the 'renovations' involved building work, extensions or other major home improvements then I would be careful trying to claim it as a business expense. I put a playroom on the house but didn't claim the building work because otherwise it technically belongs to the business and any value increase in the home is proportionally seen as growing capital in the business (taxable!).
As for wages....no such thing in this work...its now called 'taxable income' as far as HMRC are concerned. And this is any invoicing you send out each month. Note: HMRC are cunning...it's what you've invoiced and not what you've received...so we're up for paying the tax on income not received .
So don't put anything down on the spreadsheet for wages. Just put in the invoice totals.
BTW, I'm not an accountant..this is my take on it with a little help from google...who also isn't a accountant!
Thanks!
Originally Posted by
myriamabedi
Hi there
Thanks for this very useful worksheet,i have started childmindng last december 2015,and came accross this tool,was wandering where do i record all the expenses that i made before starting(e.g house renovation,heater,gates ect...) and also does wages count as expenses?
Bookmarks