Начало / Таблици / Фактури

Commercial Invoice

Commercial Invoice - Aqua Blue edition This workbook is a ready-to-use commercial invoice for goods sold, presented in a soft aqua header panel, tinted column titles, striped rows and a solid aqua total bar. It keeps the full content and every calculation of the original template and changes only the visual presentation, with the complete text in English. The "Commercial Invoice" sheet carries the seller's details, the bill-to block, the invoice number and date, the line-item table and the totals block, while the "Customers" sheet holds the customer list. Selecting a company from the drop-down list in cell C3 fills the customer address, phone number, fax number, e-mail address and contact name automatically by looking them up in the customer list, so an invoice is issued in a few seconds. Line items are typed into the table starting at row 8, where each row takes a date, item number, description, quantity, unit price and discount. The Total column works out quantity x unit price minus discount for every line and stays blank until both quantity and unit price are present. The Invoice Subtotal adds up all line totals, Other Taxes multiplies that subtotal by the tax rate entered in cell H14, and the Total adds the delivery charge and deducts any deposit already received. Only the tax rate, the delivery charge and the deposit are typed into the totals block; everything else is a live formula that updates as soon as a line is edited. Amounts are formatted in pounds sterling, the invoice date defaults to the current day, and the payment note under the table picks up the company name automatically. The layout is prepared for A4 portrait printing, fitted to the page width and horizontally centred, with the navigation button between the two sheets left outside the print area.

Аква синьо, Небесно синьо, Кралско синьо, Лавандулово синьо, Виолетово, Аметист, Магента, Пурпурно червено, Тюркоаз, Синьо-зелено, Тъмно синьо-зелено, Сиво-синьо, Графит, Въглен

AquaBlue, #00ADEE, light theme, xlsx, spreadsheet template, editable template, English, SkyBlue, RoyalBlue, #3598F3, Periwinkle, Violet, Amethyst, #895FFC, Magenta, Crimson, Turquoise, Teal, #0292B3, DeepTeal, dark background, dark theme, SlateCyan, Graphite, Charcoal, aqua blue, sky blue, royal blue, modern, deep teal, sky blue design, periwinkle design, violet design, amethyst design, magenta design, crimson design, turquoise design, teal design, deep teal design, slate cyan, slate cyan design, graphite design, charcoal design, business form, quantity, unit price, invoice number, invoice date, payment terms, small business, currency format, high contrast, bookkeeping, white background, purple accent, royal blue design, accounting, live formulas, soft blue violet, portrait, pink accent, description, tax rate, line items, cyan accent, accent rule, violet accent, commercial invoice, invoice template, aqua blue invoice, excel invoice, billing, sales invoice, goods invoice, customer database, customer list, drop-down customer selection, automatic lookup, index match, bill to, today function, item number, discount, line total, invoice subtotal, other taxes, vat, delivery charge, deposit received, total due, gbp, pound sterling, auto calculation, printable a4, fit to width, two worksheets, navigation link, wholesale, retail, trading company, cheque payable, overdue interest, aqua design, header panel, striped rows, colour total bar, sky blue invoice, clean, minimal, royal blue invoice, blue panel, #7E8FF1, periwinkle invoice, card layout, #6D5BD0, violet invoice, amethyst invoice, purple theme, solid table header, lavender panel, #FF52B9, magenta invoice, pink theme, bold title, #D2255F, crimson invoice, turquoise invoice, open lines, teal invoice, solid masthead, reversed header, deep teal invoice, reversed text, #00ABEE, slate cyan invoice, light grey theme, #3A4149, graphite invoice, grey theme, dark table header, blue accent, #7470C0, charcoal invoice, black background

Изтегли .xlsx