Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Designer Invoicing Format with Bamboo Chinese Painting. Double-click the downloaded file to extract all files.
  2. Open the template "designer-invoicing-format-bamboo-chinese-painting.xlsx" or "designer-invoicing-format-bamboo-chinese-painting-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Designer Invoicing Format with Bamboo Chinese Painting

Designer Invoicing Format with Bamboo Chinese Painting (c4096)

c4096 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open designer-invoicing-format-bamboo-chinese-painting-uis.xlsx.

Designer Invoicing Format with Bamboo Chinese Painting (UIS Edition)

Designer Invoicing Format with Bamboo Chinese Painting - UIS edition

Download Designer Invoicing Format with Bamboo Chinese Painting (c4096)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

450 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.86 MBDownload

Detail

Whether you are a web designer or graphic designer, you want to make your works attractive. Your invoices and bills could be attractive too. This template based on the c4030 designer (gray theme) added a bamboo Chinese painting created using illustrator and exported as PNG.

Our designer invoicing templates series was created to show you the most attractive, at least very different from the standard template shipped with Uniform Invoice Software. Some of them are suggested by our customers. As you can find Microsoft Excel provides fairly enough tools to customizing the look and feel of the form. A background image, or a foreground image added as a shape object, is one of the great ways to decorate a form. Look at this PDF designer bill sample, the image is included in the PDF invoices generated with Uniform Invoice Software too.

The bamboo Chinese painting picture is added as a background image which covers the whole printable form. While the form itself is still in the gray color theme, the image is in green and set to 25% opacity. This level of opacity makes sure the foreground text (black) visible even when it is on the visible background.

The PNG image was originally created using illustrator as vector image so the background colors is easily removed (set to transparent). As you can see many images / background pictures used in the templates here on InvoicingTemplate.com have a transparent background. The benefit of this is that you usually don't have worry about the boundaries of image and the printable sheet. On the other hand, if an image has a very prominent background (such as red), and boundaries of the printable Excel sheet do not correctly cover the whole background image, the final result may look very towering.

This form layout includes a column of "Taxable" checkboxes that are placed on column B - outside the printable section. Which means that, these boxes work, but will not be visible on the invoices that you print using this form (or PDF invoices created using this form). The checkbox are form controls that are named "oknWidget_taxable1, oknWidget_taxable2, oknWidget_taxable3 ... oknWidget_taxable6". Each tax box is linked to a hidden cell that are named "oknTaxable_1, oknTaxable_2, oknTaxable_3 ... oknTaxable_6". We then use an Excel array formula to calculate the taxable subtotal:

{=SUM ( oknTaxable_1:oknTaxable_6 * oknLineTotal_1:oknLineTotal_6 )}

And then, the tax is calculated using a formula like this:

=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )

If all the invoiced items are taxable (or not taxable), you can safely delete all the "Taxable" checkbox controls, and then modify tax formula to this to simplify the tax calculation:

=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknSubtotal + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )

Do you liking Chinese painting? If so, you may like to add it to your invoices too. Take this as a sample or a starting point, you may be able to create beautiful forms that are very private and special to your own business.

Like other form designs here on InvoicingTemplate.com, Designer Bill Template with Bamboo Chinese Painting is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4096
NameDesigner Invoicing Format with Bamboo Chinese Painting
CategoryService Invoice Template
Release DateMonday, October 31, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines6
Line Height (Points)49.50
Print Area$F$3:$P$41
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left16.56
Right36.00
Top72.00
Bottom72.00

Sample Templates