How to properly setup the page to get an accurate cashflow?

Hello,

I'm not to to sure on how to go about doing this.

I 'm looking to create an invoice details in excel where it correlates to the payment schedule. and the schedule is biweekly starting jan 3rd

I want to also match the start dates to each invoice date, where the invoice date is every 7 days (on a weekly basis)
But, I'm looking to have the invoice date driven in accordance to the employees start date


I'm doing this for a friend, but i'm not sure exactly what he is looking for, and what I have to do in excel
Does he just want me to keep on filling out employee 5 to finish the process?

Or should I create a separate column for each employee for it to be more detailed?

The Overall goal is to get an accurate cashflow

attached you can see what the excell sheet looks like

Hello,

Just a couple of questions and suggestions:

Why do you have the employees in column 1 grouped like that? It makes it more difficult to automate the rest of your sheet.
What's with the remaining amounts? Are they never paid or is it tax/insurance fee or what?

I made a start on how I would set up your workbook. Have a look at the attachment.

Cheers,

Michael