Build Quantity Invoice Kostenlos

Hi, this is Gary with MacMost.com. Let me show you how to create an invoicing system using Numbers. So I sometimes get questions from people using Numbers and they're trying to create invoices. What they'll do is create an invoice on each sheet. So they create a nice looking invoice and then they'll duplicate it and have different sheets in the same document or even different documents. The problem is you might as well just be using Pages or something to do that as you can't really do much with the data. The correct way to use a spreadsheet is to put records in rows where each row is a record for something like say billable hours. Then if you want to create invoices have a single invoice that pulls data from that. So here's what such an invoice may look like. But I haven't entered any of this data except for this client ID. Watch what happens if I change the client ID. I'm going to change it to client 5. If I do that notice the name of the client changes, these records change, the total changes, and I have an entirely new invoice. The way I've created that is by creating Tables using records as rows. So I actually have two sheets. One is a sheet with clients in it and it's just client ID's and names. The other is a list of records of billable hours. That's the only table that I need to create this invoice. So my first sheet here shows clients. This is a table where I've entered in the data manually. It's the client ID, just a number, and a name. So it's all just entered in. I can add more to the list as I get new clients. Now Consultations is a sheet here that actually has a record on each row. The record is a client number, name, and information about that set of billable hours. Some of these are entered in manually. I enter in the client number, put a date, the number of hours, and the rate. Now the total, as you can guess, is calculated using a formula. So that's just the number of hours times the rate. Simple enough. The name is actually looked up automatically. So it's using the Lookup function and then it will lookup from this number here, the client number that's entered in, and it will go to this table and lookup the ID in this column and grab the name out of that column. That's how that works. So all I need to do is say if I wanted to change this client I go to number 3 and you can see it changes the name automatically. So I can start a new record without having to type the entire client's name. Just their ID. In addition I've got this paid field here. I actually manually entered that in. So somebody pays the invoice that has these hours on it. I will type in the date they paid. Which is a good piece of information to have and it also gives me a record of the fact that they paid this line here. So how does this invoice work? Well, this name here works the same way as the name on the Consultations sheet does. It just looks it up. It looks up the client ID from this number here and grabs the ID from this column and then the name from this...