Book keeping excel Workbook UPDATED

[Emmalou77]

Happy toddler i'm sorry to be a pain, i am a total novice with lots yet to learn and am struggling to input reciept price
in the month on April, please can you tell me what i'm doing wrong?

[Emmalou77]

Happy toddler i'm sorry to be a pain, i am a total novice with lots yet to learn and am struggling to input reciept price
in the month on April, please can you tell me what i'm doing wrong?

It's ok happy toddler, the penny has now dropped

[Rick]

hurray!

[Emmalou77]

hurray!

Hi, it's me again! I'm just filling in the spread sheet for 12/13 and in both May and June
show Junes dates, can i just manually change this or will i mess up the whole spread sheet?

Thanks in advance.

[Emmalou77]

Hi, it's me again! I'm just filling in the spread sheet for 12/13 and in both May and June
show Junes dates, can i just manually change this or will i mess up the whole spread sheet?

Thanks in advance.

When i input coucil tax, water an so on, do i put in my total monthly bill and then the spreadsheet will work it out?
or do i have to work out my % then divide by 12 months then in put the figure i come up with?

[Tigertots]

Help this wont open up for me

[hectors house]

When i input coucil tax, water an so on, do i put in my total monthly bill and then the spreadsheet will work it out?
or do i have to work out my % then divide by 12 months then in put the figure i come up with?

For council tax and water rates you take the figure for the whole year (but you generally only pay it over 10 months), eg: council tax bill is £1200 for year then divide it by 12 amount each month is £100 and enter that figure on the spreadsheet - when you enter the number of hours each week you work, the spreadsheet will work out the % you are entitled to claim.

For gas and electricity just enter in the amount you pay each month and again the spreadsheet will work out the % for you.

[Emmalou77]

For council tax and water rates you take the figure for the whole year (but you generally only pay it over 10 months), eg: council tax bill is £1200 for year then divide it by 12 amount each month is £100 and enter that figure on the spreadsheet - when you enter the number of hours each week you work, the spreadsheet will work out the % you are entitled to claim.

For gas and electricity just enter in the amount you pay each month and again the spreadsheet will work out the % for you.

Thank you Hector house for your help, i was diddling myself out of some money there!

Any idea on the spread sheet dates that are incorrect? can i change them?

[Emmalou77]

Hi all,

If anyone has any problems with the spreadsheet or needs guidance then please feel free to message me.

Thanks!

Hi, i have noticed that both may and june have junes dates in so i have changed it, the problem is that when i input my hours of work it isnt adding up right

The calculator is giving me one figure and the spread sheet a lower figure, i haven't used a spread sheet before and wondered if there is a reason for this that im not aware of? I cant continue until im sure im doing it right

[Samijanec]

Does anyone know if these work in excel on a mac please?

[Crippa]

This workbook is amazing. Thanks so much.

[Crippa]

Hi, i have noticed that both may and june have junes dates in so i have changed it, the problem is that when i input my hours of work it isnt adding up right

The calculator is giving me one figure and the spread sheet a lower figure, i haven't used a spread sheet before and wondered if there is a reason for this that im not aware of? I cant continue until im sure im doing it right

What cells arent adding up correctly? Perhaps need to check the formula is correct.

[Emra81]

I'm not registered yet but want to start recording the expenses I'm already racking up what with courses and resources etc...this spreadsheet is a-bloomin-mazing!

Happy Toddlers, you are my hero

[Bels]

This is fabulous, thank you!!

[Mummy Sarah]

Thank you sooo much Happy Toddlers, you have saved me from many sleepless nights

[cathtee]

Here is the spreadsheet for 2013-14 tax year accounts. Hope this is useful!

www.horrod.com/Accounts201314.xlsx

Thanks!

Thank you so much for this spreadsheet, I have recently dropped my weekly hours and this is perfect for the percentages for utility bills, It is a good job I came across this as I probably would have just still gone with the full 10% and 33% .

Thanks

[big waves]

Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!

[Rick]

Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!

As far as I'm aware you don't need to worry about that. HMRC work that out for you and send you a bill or you can set up a direct debit

[tulip0803]

Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!

You cannot put NI payments through your accounts they are not tax deductible - everyone that earns over a certain amount has to pay NI. So you don't put them in your accounts

[tas]

Thank you for the 2013/14 spreadsheet, its brill!