COMMON INVOICE - AQUA BLUE EDITION =================================== This workbook is a ready-to-use service invoice for small businesses, freelancers and consultants, styled in a vivid aqua-blue accent on a white page. You fill in your own company name, address, telephone, fax and website in the header block, and the customer's details in the BILL TO block on the left. The DATE field is a live formula that always shows the current day, and the DUE DATE field is calculated automatically as thirty days after that date, so payment terms never have to be worked out by hand. The invoice number and customer ID are free text fields that you overwrite for each new document. In the items table you type a description of each service, part or labour line together with its amount, using up to sixteen lines. Placing the letter "X" in the TAXED column marks a line as taxable, and the Taxable field below adds up only the lines you have marked, so mixed taxable and non-taxable invoices are handled on a single sheet. The Subtotal adds every amount in the table, the Tax due field multiplies the taxable amount by the tax rate you enter and rounds it to two decimals, and the TOTAL adds the subtotal, the tax and the "Other" line, which you can relabel as Shipping or Discount. The OTHER COMMENTS block carries your payment terms, the panel on the right names the payee for cheques, and a second sheet called Help explains how to customise, reuse and send the invoice as a PDF. FUNCTIONS AND FORMULAS Invoice date =TODAY() automatic current date Due date =DATE + 30 automatic payment deadline Subtotal =SUM(F17:F32) total of all invoice lines Taxable amount =SUMIF(TAXED column,"x",...) total of the lines marked "X" Tax due =ROUND(Taxable * Tax rate,2) tax rounded to two decimals TOTAL =Subtotal + Tax due + Other amount payable CELLS YOU FILL IN A1:A6 your company name and contact details F4, F5 invoice number and customer ID A10:A14 customer name, company, address and telephone A17:A32 description of each line item E17:E32 "X" where the line is taxable F17:F32 amount of each line item F35 tax rate (percentage) F37 "Other" amount - shipping, discount or any charge you rename A36:A41 payment terms and notes E41 the name cheques should be made payable to Layout, cell addresses, merged ranges, number formats, print area and every formula are identical to the original template; only the visual design and the language have changed. The workbook contains no macros and opens in Excel 2007 and later, in LibreOffice Calc and in Google Sheets.
Аква синьо, Небесно синьо, Кралско синьо, Лавандулово синьо, Виолетово, Аметист, Магента, Пурпурно червено, Тюркоаз, Синьо-зелено, Тъмно синьо-зелено, Сиво-синьо, Графит, Въглен
AquaBlue, light theme, xlsx, English, ROUND, SUM, Help sheet, SkyBlue, RoyalBlue, Periwinkle, Violet, Amethyst, Magenta, Crimson, Turquoise, Teal, DeepTeal, dark theme, SlateCyan, Graphite, Charcoal, aqua blue, SME, sky blue, royal blue, deep teal, spreadsheet, print ready, no macros, slate cyan, service invoice, pdf export, grand total, accounting number format, invoice number, payment terms, thank you note, small business, USD, editable, colour scheme aqua blue, light design, colour scheme sky blue, colour scheme royal blue, colour scheme periwinkle, colour scheme violet, colour scheme amethyst, colour scheme magenta, colour scheme crimson, colour scheme turquoise, colour scheme teal, colour scheme deep teal, dark design, colour scheme slate cyan, colour scheme graphite, colour scheme charcoal, hourly rate, excel, subtotal, professional services, customer details, customer id, tax rate, sales tax, today formula, sumif, tax calculation, line items, consultant, agency, invoice template, billing, sales invoice, bill to, discount, vat, invoice, Excel invoice template, AquaBlue edition, automatic date, due date, 30 day payment terms, payment deadline, taxable amount, tax due, total payable, other charge, shipping, 16 line items, description column, amount column, taxed column, X marker, company header, contact block, other comments, make cheques payable to, payee, instructions, how to send an invoice, A4 print area, freelancer, contractor, self-employed, workshop, labour, parts, service fee, dollar, reusable, openpyxl compatible, LibreOffice Calc, Google Sheets, SkyBlue edition, RoyalBlue edition, Periwinkle edition, Violet edition, Amethyst edition, Magenta edition, Crimson edition, Turquoise edition, Teal edition, DeepTeal edition, SlateCyan edition, Graphite edition, Charcoal edition