So somebody pays the invoice that has these hours on it. In addition I've got this paid field here. So I can start a new record without having to type the entire client's name. 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 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. The name is actually looked up automatically. So that's just the number of hours times the rate. Now the total, as you can guess, is calculated using a formula. I enter in the client number, put a date, the number of hours, and the rate. The record is a client number, name, and information about that set of billable hours. Now Consultations is a sheet here that actually has a record on each row. I can add more to the list as I get new clients. It's the client ID, just a number, and a name. This is a table where I've entered in the data manually.

That's the only table that I need to create this invoice.

The other is a list of records of billable hours. One is a sheet with clients in it and it's just client ID's and names. The way I've created that is by creating Tables using records as rows. If I do that notice the name of the client changes, these records change, the total changes, and I have an entirely new invoice. Watch what happens if I change the client ID. But I haven't entered any of this data except for this client ID. So here's what such an invoice may look like. Then if you want to create invoices have a single invoice that pulls data from that. 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. 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.

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. What they'll do is create an invoice on each sheet. So I sometimes get questions from people using Numbers and they're trying to create invoices. Let me show you how to create an invoicing system using Numbers. Video Transcript: Hi, this is Gary with. Check out Creating a Billing and Invoicing System In Numbers at YouTube for closed captioning and more options.

Tiny invoice for mac