How To Create A Complete Employee Payroll In Excel + FREE DOWNLOAD

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@richybambino]

This channel is at another level that I had not seen before, the way to teach this tool that is essential and transversal, all courses teach them in a traditional way, but this channel is incredible, congratulations friend, the fortune of being able to find this channel, it is magnificent, you take Excel to another level that I have not seen before.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I am very happy to help and share. Each template is free, using the links in the video description, however, if you would like all 300 of my templates you can get them from here: bit.ly/300WkBks_Randy Each Tuesday I create a new one, and we do live chat every week on Video premier. Here is the next one: kzbin.info/www/bejne/ooSQYpaYnrOVj8k

[@Cocomelon_Animation]

Sir print pdf micro not available please solve this issue

[@ExcelForFreelancers]

Hi and thanks, the Print feature was added on our Patreon platform here: www.patreon.com/posts/employee-payroll-88009764 I hope this helps and thanks so much.

[@alvinthiumai7639]

​@@ExcelForFreelancers😅

[@rond9222]

Hi Randy, another brilliant application of Excel. Even though I already use payroll software, so won't be using yours it is still interesting to learn your techniques. Unlike most of your apps, I did notice one error in your logic. On the deductions of taxitems with yearly maximums, you didn't take into account the case where the YTD was under the maximum, but after the current payroll is added, it will exceed the maximum. You need to use the min function to compare the Calculated Deduction & the difference between YTD & Max Cost.

[@rond9222]

Took the liberty of proposing a formula: =IF(T9=0,"",IF(AND(INDEX(Tax_MaxCost,MATCH(T9,Tax_ItemNames,0),1)

[@ExcelForFreelancers]

Hi and thanks so much. Yes that is very helpful. I really appreciate that and will make the necessary update to the application for Patreon and KZbin memberships. Thanks so much for your continued support. Much appreciated

[@slminc]

This one is going straight into my project tracker. I will top it up with the mobile time clock. We shop is patiently waiting for it.

[@ExcelForFreelancers]

Awesome. This one is clean, straightforward and organized, so its a step for sure from the one I did many years ago. Thanks for your support

[@joshuaursal4549]

You are a God in excel, Thank you so much for sharing your talent

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Joshua

[@jamesagblevor7522]

This is absolutely fantastic work. Well done

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@jorgepalomera6009]

Randy you are made for this sir. Thanks for all the teaching you are giving us herein.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Jorge. Thank you for your Likes, Shares & Comments. It really helps.

[@taimoorkhan8203]

This is a Must watch....

[@ExcelForFreelancers]

That is great. I design this from scratch, during the video, so I am sure you will love it

[@yitzchakkatzir1547]

Fantastic - just one question - does it not fir better with MS Access instead of Excel?

[@ExcelForFreelancers]

Hi and thanks very much. This would also work great in Access, however most people prefer using Excel, therefore we create it in Excel. Thank you for your Likes, Shares & Comments. It really helps.

[@rotimioladunni7761]

You're simply awesome. It looks like you created VBA by yourself. Most importantly, your time in putting all of this together and sharing with all, is appreciated. I just need 10% of what you know😅 Thank you. I look forward to the Payroll Manager coming up in few minutes.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you enjoy the training

[@keitamoussa2229]

I heard my favorite word "scratch" :) Thanks Randy ! Can't wait !

[@ExcelForFreelancers]

Thank you Keita, yes this one is designed from scratch so you will really love it. Thanks again for your continued support.

[@beaumccarthy662]

This is absolutely fantastic. Just wondering where you got the background pic from. Ive been searching everywhere for it

[@ExcelForFreelancers]

Hi and thanks so much. For the last few months I have been making every background and logo in Midjourney. I really love these AI-Generated images. The Logo that you see in this application is also AI-Generated with Midjourney. I hope this helps and thanks so much.

[@prabhatrawat4394]

@@ExcelForFreelancersHow can we get the same background? Is it written somewhere in the code?

[@benosborne413]

GREAT. Would been great if the leave, sick leave, absent could also be recorded in one application

[@ExcelForFreelancers]

Hi and thanks so much. I do have all of that in my Employee Manager series here: kzbin.info/aero/PLIBeRriXvKzD6v9jJ3OPrIymavpIsLVLL I hope this helps and thanks so much.

[@farhadali2448]

Excellent job

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@hammeedabdo.82]

Please, we want various projects and applications such as the use of Excel in trading and linking it to trading platforms and making mechanisms of trading mechanisms, such different projects will be great.

[@ExcelForFreelancers]

Hi, and thanks so much. I will do my best however there are already a ton of Excel-based trading applications available. Thank you for your Likes, Shares & Comments. It really helps.

[@rbrtktl]

478k subscribers, it is unbelievable. That is population of Capital City of The Microsoft Excel😊. Happy Birthday 🎉 @ Randy 🎉

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that I really, really appreciate that. Trying my best :)

[@rbrtktl]

@@ExcelForFreelancers I know you do

[@prabhatrawat4394]

Hello Randy, Thanks a lot helping us providing such interesting videos about VBA's. I would like to know how can I have the same background of blue which you have in the excel. Do you prefer any website to download such wallpapers?

[@ExcelForFreelancers]

Hi and thanks so much. I have been using www.Midjourney.com to create my backgrounds and I really love it. I hope this helps and thanks so much.

[@prabhatrawat4394]

@@ExcelForFreelancers By any chance do you have any video created how you do it? If not, any way you can share the sample images which you are using as background. I tried googling things but didn't find any same resemblance background images. Thanks for helping the community by creating such wonderful videos

[@prabhatrawat4394]

@@ExcelForFreelancers And also how have you pasted that image to your excel as background? A bit curious about this.

[@ExcelForFreelancers]

Hi and thanks so much. I do not have a video on how to create backgrounds, however once you sign up for midjourney you can create a prompt such as "blue abstract background -ar 16:9" as the ar is the aspect ratio, then you can download any one you like, increase the site, and once in Excel go to "Page Layout" and then "Add background" I hope this helps and thanks so much.

[@peteradongo7298]

Looking forward to this training

[@ExcelForFreelancers]

For sure, you are very welcome and looking forward to having you join us Peter

[@prabhatrawat4568]

Hello, can you also share the site you use for the Userform backgrounds? Thanks

[@ExcelForFreelancers]

Hi and thanks. Yes. In the last 6 months I have been using Midjourny (www.Midjourney.com) to generate all of my artwork for logos and backgrounds. I hope this helps and thanks so much.

[@michaelmicah4761]

Hie, is this a usable template for a small business or for practice and training only?

[@ExcelForFreelancers]

Hi and thanks so much. This is a template for training, however it can be secured, updated and customize for your requirements. If you need help I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? [e-mail] Thanks so much.

[@Kanyoni1]

Hi Randy, Can you direct me on how i can get this great product you have created here

[@ExcelForFreelancers]

Hi, you can download this file for free using the links in the description under the word DOWNLOAD, however if you would like an updated version of this, that includes printing the pay stubs. I have that available on Patreon here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks.

[@biblechannelforkids]

Sir Randy, That's great indeed. And hopefully you will create HR Recruitment tracker also.

[@ExcelForFreelancers]

HI and thanks, yes I can. Can you tell me what you would like to see in an HR Requirement Tracker application? Thank you for your Likes, Shares & Comments. It really helps.

[@biblechannelforkids]

@@ExcelForFreelancers Hopefully you can include HR recruitment tracker,

[@ExcelForFreelancers]

But you have not told me what is in this type of application, so I would not know what to build. You have not listed any features, data, UI or other components

[@biblechannelforkids]

@@ExcelForFreelancers Thanks Mr. Randy for the clarification. Actually, I really like your tutorial. It really helps us, as your vivid follower. I have been following since the year you have started your journey here in KZbin. By the way, the features I want to see in an HR Requirement Tracker are the following: 1. Applicant Tracking: The ability to track and manage candidate applications throughout the recruitment process, including storing candidate information, resumes, and other relevant documents. 2.. Job Posting and Advertising: Allows me to create and manage job postings, and track the performance of different job advertising channels. 3. Candidate Database: A centralized database to store candidate profiles, resumes, and other relevant information. This allows recruiters to easily search and retrieve candidate information as needed. 4. Resume Parsing: The ability to automatically extract relevant information from resumes and populate candidate profiles with key details such as contact information, work experience, education, and skills. 5. Communication and Collaboration: Features that facilitate communication and collaboration among hiring managers, recruiters, and other stakeholders involved in the recruitment process. This may include email integration, in-app messaging, and comment threads. 6. Interview Scheduling: Tools to schedule and manage candidate interviews, including the ability to send interview invitations, track responses, and manage interview slots. 7. Reporting: Basic reporting capabilities to track recruitment metrics such as the number of applicants, candidate status, and source of hire. This helps in getting an overview of the recruitment process. 8. Workflow Automation: Automation of repetitive tasks such as sending email notifications, generating offer letters, and updating candidate status. This saves my time and improves efficiency in the recruitment process.

[@ExcelForFreelancers]

Thanks so much. Now that list is very helpful and its something that I can build a nice template on. Have you seen my Job Application Manager? kzbin.info/www/bejne/fYq9gGyvlpKoqdk Thanks so much

[@HollySpake-Gray]

Hello! I have been watching the video and have downloaded the file. I am not able to get some of the drop down functions to work. For example, under Selected Pay Period Employees, it will not let me filter by Employee Type and Pay Type. The options are there and the drop downs are there but it is not filtering based on my selections. Can you please advise? Thank you

[@ExcelForFreelancers]

Hi and thanks, you can make sure to check the dates in the advanced filter criteria. There could be a difference in regional date formats (for example the format of your criteria is different than the format of your data) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@thomasmullan5964]

Would it be possible to create this entire report using python using libraries such as Openpyxl? I have payroll data stored on a SQL database and want to automate the timesheet reporting and job costing analysis

[@ExcelForFreelancers]

Hi Thomas, Thanks so much for your comment. It may be possible however I have not worked with that and and focused on the VBA aspect of it. You should give it a try. Thank you for your Likes, Shares & Comments. It really helps.

[@SyedMuzammilMahasanShahi]

Thanks Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much

[@mvm7554]

This is great, thanks for the efforts

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@mariadlr3774]

Omai I cant wait 👌👌👌

[@ExcelForFreelancers]

Great, thanks so much Maria. I am sure you are going to love it. Thank you for your Likes, Shares & Comments. It really helps.

[@naveedhafeez920]

Hi andy great job.... this is Xlsm file extension... it's not opening in Excel? How it will work...?? I have downloaded the template under this video???

[@ExcelForFreelancers]

Hi and thanks so much. This should open in any desktop version of Excel (not the browser version) Also make sure to upload the macros after downloading using the methods described here www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much. I hope this helps and thanks so much.

[@prabhatrawat4394]

I am creating a dashboard to monitor performance and represent data graphically. Additionally, want an editable user form, a login page to differentiate admin and user rights. Please confirm if you have a template that includes all of these features? Thanks for sharing such wonderful tutorials.

[@ExcelForFreelancers]

Hi and thanks very much. I have them, but in separate templates. Please feel free to combine any of my templates, and if you need help to create the application, please post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@T_h_e_Best]

cool, but I have a question: how you create PDF code book? can you share this knowledge?

[@ExcelForFreelancers]

Hi and thanks I do share those on my Patreon platform here: www.patreon.com/ExcelForFreelancers

[@YazanKhaled-e7j]

Great job sir ❤

[@ExcelForFreelancers]

Thanks so much. For sure you will love this training

[@Rose-xc7wz]

With the default picture. Have you tried to record a macro while doing that piece to see what the VBA code would be to do that one piece. That is how I started learning VBA years ago.

[@ExcelForFreelancers]

Hi and thanks for your comment. I did actually, that was the first thing I tried but no luck and have not had any suggestions from anyone. I would still love to find a solution on this if you have one, that would be great. Seems so simple, but I have not found a solution on it yet. Thanks again

[@Rose-xc7wz]

@ExcelForFreelancers I will think on it a little. Never know. I have dreamed of solutions before....

[@ExcelForFreelancers]

Great, thanks so much

[@ajaykumarswain9746]

Sir I am waiting for it 🙏

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I am sure you will love it

[@afrizalbahtiar1565]

I am waiting to use the template for my job as payroll specialist

[@ExcelForFreelancers]

That is great. I am sure it will make a big impact. Thank you for your Likes, Shares & Comments. It really helps.

[@scienceecosystem8019]

Creat a content on How to create automatic attendance sheet for students,😊

[@ExcelForFreelancers]

Hi and thanks so much. I do have that already here: kzbin.info/www/bejne/qF6UiJyZlp6iptk I hope this helps and thanks so much.

[@rnunez047]

Se ve muy bueno. Gracias de antemano.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I know you will love this one

[@galianoazazdeazevedo5966]

Sh*t !!! You're extremely good at Excel. How long have you been practicing?

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I started with Excel in 1995, however, I did not learn any VBA until 2015. Thank you for your Likes, Shares & Comments. It really helps.

[@Mr_MicDaniel]

I did not get the template on my email It showing successful on the website but no appearing on my inbox

[@ExcelForFreelancers]

Hi If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@agnosticoparatodo]

Cada vez me gusta más tu canal. Haces proyectos impresionantes.

[@ExcelForFreelancers]

Gracias. Thanks so much. Very kind of you

[@prabhatrawat4394]

From which website you have downloaded the blue background image??

[@ExcelForFreelancers]

Hi and thanks so much. I created this background using MidJourney.com which is AI Generated. Also the same for the logo. I share these pictures, logos and all of the resources from each training on our Patreon channel updates every week here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@JeaneferMati-ong]

Hi I hope you can respond but when I tried to add employee I am getting an error message

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@joemanflyer2001]

I like to use of the tabs at the bottom

[@ExcelForFreelancers]

Yes for sure thanks so much for sharing.

[@rnunez047]

Desde cero 🎉

[@ExcelForFreelancers]

Thanks so much

[@diamondvirtualsolutions1766]

I’ve downloaded this and not sure how to remove the preloaded employee information and add my employees from the start, it would have been nice to have downloaded a empty file bs preloaded but with instructions on how someone new to use this.

[@ExcelForFreelancers]

Hi and thanks very much Diamond. You can highlight the cells on the Employee sheet and use the Delete key to remove the employees (Just make sure to keep the headers) Since these are free templates used for training purposes, I don't have a ready-template however that is something that I will create very soon since a lot of people have the same requests. Please make sure to watch the training video to help you understand how the worksheet functions. I hope this helps and thanks so much.

[@adedotunadelaja3830]

Where did you download it, I can't find it

[@niteeshkumarshukla3525]

​@@ExcelForFreelancers great support boss,you are a very helpful person 🎉🎉

[@IssaAli-d1f]

Sir Can you talk about how to calculate and prepare payroll cheques please ?

[@ExcelForFreelancers]

Hi and thanks so much. On the Patreon platform, next week, I will make an update that includes printing pay stubs here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@skomwulski]

How would you treat empl. replacement here? as example: ID 32 decided to leave, ID27 will be promoted to that role, for ID27 we plan to have open position with 2 months vacancy (recriutment period)?

[@ExcelForFreelancers]

Hi and thanks you can make employees inactive and they will no longer show up. You can also add fields such as position for employees. This way only certain employees are displayed to be paid. Pay rates can change at any time. I hope this helps and thanks so much.

[@Cocomelon_Animation]

Hi sir please help... 1 issue print pdf button can't working and employees picture issue so please solve this problem 😊

[@ExcelForFreelancers]

Hi and thanks for your comment. I have added the Print Pay Periods feature on our Patreon Platform post here: www.patreon.com/posts/employee-payroll-88009764 I hope this helps and thanks so much.

[@venkateshh160]

I am interested to learn VBA coding, need your help. Will you help?

[@ExcelForFreelancers]

Hi and thanks for your comment. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy

[@charllote18]

hello is it possible if you can a copy??? for it?/

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@Cocomelon_Animation]

Sir print pdf micro not available please solve this issue

[@ExcelForFreelancers]

Hi and thanks for your comment. I have added the Print Pay Periods feature on our Patreon Platform post here: www.patreon.com/posts/employee-payroll-88009764 I hope this helps and thanks so much.

[@sikhoji8319]

add employee save button not working

[@ExcelForFreelancers]

Hi and thanks you will want to right click it and make sure it is assigned to the correct macro. Please make sure to follow the training to help you. I hope this helps and thanks so much.

[@sikhoji8319]

add employee button open but save button not working "error " Private Sub SaveBtn_Click() Employee_SaveUpdate End Sub

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@ofactoradvertisingpvtltd7241]

Print area is missing Please how to do it

[@ExcelForFreelancers]

HI and thanks very much. You can set the Print area to any range then use ActiveSheet.PrintOut I hope this helps and thanks so much.

[@bijooy]

Download link is not working

[@ExcelForFreelancers]

Hi If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@jorgeayala6054]

"Arriba Juarez" es el nombre de TODO el mariachi de JG. Se llama asi en honor a la tierra "natal por adopcion" del Divo de Juarez.

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps.

[@skatesanjelahandag6109]

Can you share the file with me please?😭

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@malcolmsokol4294]

Did not see anything on end of year tax reporting . W-2 reports etc. Also did not see anything on printing checks.. just the stub info. The tax info could be interesting because of how pay periods sometimes overlap calendar year beginnings and ends. So someone could be paid in first week of Jan and the income is reported in the new year based on the date of payment, although the earning period would be the last week or whatever in December. So the issue of YTD calcs may need to be reviewed since YTD usually corresponds to a tax reporting year. Did not watch all your calcs to see what you actually do but just raising some issues that occurred to me.

[@ExcelForFreelancers]

Hi Malcom, thanks so much for your suggestions. There are literally hundreds of features I would have loved to add to this however this was already a 2 1/2 hour training so i have to have some limits. Dynamic fiscal years being one of them. Please feel free to download this template and customize it however you like. Thanks again for your continued support.

[@malcolmsokol4294]

Just some ideas and maybe a Part II. I realize some issues because I attempted to do a payroll type app in Excel and realized it was beyond doable. Tying in to IRS onloine systmes for withdholding reporting and direct deposit stuff was beyond possible.@@ExcelForFreelancers

[@ExcelForFreelancers]

Thanks so much for sharing Malcolm :)

[@odunolaoladimeji4385]

how do I get the template

[@ExcelForFreelancers]

Hi @odunolaoladimeji4385 , you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@samreensyed7]

34:00

[@ExcelForFreelancers]

Hi and thanks, did you have a question concerning that period in the video?

[@ihteshammustafa2936]

He is just making the template not teaching it

[@ExcelForFreelancers]

Hi and thanks so much. The larger templates I share with you on how I made it, and the smaller ones I build from scratch, during the video. I have an entire playlist of 'From Scratch' videos here: kzbin.info/aero/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks so much.