Invoice

7 stepsWatch a freelancer finish an invoice: pick products, set quantities and discounts, and remove a line. Click into the page at any point to take over.Pick a product on the empty line. VLOOKUP finds its price and tax rate on the price list, and a new empty line appears under it by itself: B11:B15 becomes B11:B16.Type a quantity of 6. The line total, the subtotal, the tax and the total due recalculate as the edit lands.Give the 25 brand books a 15% discount. The Discount line takes it off, and the tax is worked out on what is left.Fill the new line: 12 stock photo licenses. Its lookups and total follow, and the next empty line is already waiting under it.Type 0% over the brand books’ tax rate. The cell keeps your number in place of its lookup, and Tax and Total due follow.Remove the logo line with the button in the page’s margin. The row goes, every range shrinks from B11:B17 to B11:B16, and the total due drops by $2,332.80.Your turn. Pick a product on the empty line, change quantities, discounts and rates, or remove a line from the margin.Watch a freelancer finish an invoice: pick products, set quantities and discounts, and remove a line. Click into the page at any point to take over.