Jump to content

Archived

This topic is now archived and is closed to further replies.

M.K Cleaners.co.uk

Check This Out

Recommended Posts

M.K Cleaners.co.uk

My sister finally finished it, I had a look at some of the formulas on this and there crazy long.

 

No more adding up for me!!

 

In a nut shell

 

It tell me how much I have collected each week

How much is outstanding each week

how much each house has paid in one year

How much is still to collect for that year.

 

Exactly what I wanted, well nearly. I wouldnt mind the per year totals adding up for all houses. I did ask but got a very bad look after it lol

MarcsBook 01.04.12 (1).xlsx

Share this post


Link to post
M.K Cleaners.co.uk

to confusing for me :( lol :P

 

I can see why, its basicly how I work my books just now. Minus the totals.

Share this post


Link to post
M.K Cleaners.co.uk

aslong as u understand it mate thats all that matters ;):P lol

 

Yeah, I suppose it good this way, that way if I lose it they wont be able to make sense of it lol.

 

Al though I do have fields password protected

Share this post


Link to post
harunh

lol good stuff

 

and yeah having a password is essential mate keep all the data safe :)

Share this post


Link to post
MajorClean

Looks Brilliant M8! My Uncle sorted me with a fantastic custom-made system that lists name address, suburb/area, type of house & cleaning requirement; ie Fronts Only or Full House with Conservatory etc. It's got the Frequency so that once you put in the last clean, it changes colour when they're next due. Also has any outstanding payments owed in red so I can see at a glance who owes me what, & I can cluster all the customers in one area to do on the same date. I love seeing what I've earned & how fast the database is growing. The only thing missing is it doesn't have a section for when I've done Guttering, Fascias or Patio jobs, so I guess I'll just have to pocket those on the sly lol

Share this post


Link to post
harunh

Looks Brilliant M8! My Uncle sorted me with a fantastic custom-made system that lists name address, suburb/area, type of house & cleaning requirement; ie Fronts Only or Full House with Conservatory etc. It's got the Frequency so that once you put in the last clean, it changes colour when they're next due. Also has any outstanding payments owed in red so I can see at a glance who owes me what, & I can cluster all the customers in one area to do on the same date. I love seeing what I've earned & how fast the database is growing. The only thing missing is it doesn't have a section for when I've done Guttering, Fascias or Patio jobs, so I guess I'll just have to pocket those on the sly lol

 

Good stuff and ueah pocket on the sly :P lol

Share this post


Link to post
WindyCleanerMan

Google drive has the same thing, google version of excel. Can access from any comp with that. saved online.

Share this post


Link to post
Kips

looks good but how do you control the frequency and dates? what do you put in for weekly, 2 weekly, monthly etc?

Share this post


Link to post
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.