Invoicing in Google Sheets for Freelancers (FILTER by DATE)

0:00 Let's work through a very common problem for freelancers, which is invoicing. We're going to write some work we do here, a date, the number of hours we do, and a rate, uh, where we can get that rate from here, settings. So we create a very basic invoice here, and what we're going to do is we're going to make sure we're filtering the start and end dates so that we only Bill or invoice for work that we've done within a certain range inclusive of those dates. So we want to say the entire month of April And then we're also gonna get the sum of hours and then total that to have the total bill so that our Invoicing or billing is super easy. So we have a few Examples here. We have like March and April now if I went over to invoice and I just did Invoicing in Google Sheets for Freelancers How To Sum By Client

0:47 filter range It's gonna be time sheet. We're gonna get a A, B, and C, but we're going to condition , the condition is going to be that B is greater than or equal to, and we're going to click over here to our invoice, the start date . We're also going to add another comma and do exactly the same thing, B except it'll be less than or equal to, and then we're going to go back and click the end date . So now, we have everything we've done within this. Month of April because we have the start date of April 1st. If we choose March 1st to March 31st see our dates change So we have very Invoicing in Google Sheets for Freelancers Filter a Database in Google Sheets based on Dates, Checkboxes, and Dropdown selections! How To Filter by Date in Google Sheets

1:34 different billing for hours what we can do here is we can do a sum Right? Uh, of whatever is here, but we might not know exactly how far down to go. So what we can do is do take is actually super simple. We can take this same filter . And we would filter B column, but we actually just need the hours columns. We need C colon C, and then we're going to do a sum of that. So wrap the entire filter by the sum. The issue might be that if we have nothing here, uh, you'll get an N A. So I go if N A, I add that there, and add a nothing there for that N A there. Invoicing in Google Sheets for Freelancers How To Sum By Client

2:28 So now if there happens to be nothing there, like if we choose maybe the wrong year, we have zero instead of like an error or even one. Here we can do the same thing, wrap filter with if and a, and just put nothing. Okay, but now we need billing, our billing. So we did just F6, the number of hours, times, The rate here in the settings, you can do that in a separate cell if you want or not, but let's say go back to 24, 24, and now we have a pretty simple way to bill, uh, invoice. You can always file, download PDF and we can set some parameters here if we wish and export a PDF super easily to bill next time we need billing done. Invoicing in Google Sheets for Freelancers Two Outputs, Same Cell

3:17 Just keep writing in the timesheet here and we have an automatic billing. Invoicing in Google Sheets for Freelancers