Invoice Software Usa Free Download Excel Sheet

1. Freelance Writer Invoice Template

"Freelance Writer Invoice Template" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 91.

(From Download Page - about 81 words) - Creating a business document using this Freelance Writer Invoice Template is much like filling a blank paper form using a pen, but the Excel invoice template helps you go to electronic invoicing without a hard learning curve, and it also helps in computer-based accounting. Freelance Writer Invoice Template is printable like a general Excel document, and the print options can be easily adjusted by first opening Freelance Writer Invoice Template, and then go to the Page Setup dialog box in Excel.

(From Download Page - about 91 words) - Freelance Writer Invoice Template has two editions provided in the above table. The free edition of Freelance Writer Invoice Template has less features available and thus suitable for small businesses, but the result is as good as a commercial invoicing software program, which makes the Freelance Writer Invoice Template an easy invoice creator or invoice generator for the companies that don't have complex requirements. If the free edition of Freelance Writer Invoice Template does not fulfill your requirements simply upgrade to the Uniform Invoice Software edition of Freelance Writer Invoice Template.

(From Download Page - about 45 words) - Including this Freelance Writer Invoice Template, all invoice formats available here on InvoicingTemplate.com are created from the default invoice template shipped with Uniform Invoice Software. In fact, Freelance Writer Invoice Template can be seen as a sample on how to customize the default invoice template.

LEARN MORE PDF

2. Five Price Percentage Levels (Service, Custom Column)

"Five Price Percentage Levels (Service, Custom Column)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 91.

(From Detail Page - about 21 words) - This is the eighth sample of the multiple-price serial invoice templates. The template uses percentage discounts, and has no shipping fields.

(From Detail Page - about 85 words) - Just like the other service invoice templates available here on InvoicingTemplate.com, this invoice form with 5 price percentage levels (service, cosmetic) was created from the sales invoice template by moving all the shipping fields out of the printable area. The printable area is the white area on the center of the "Invoice" worksheet, which is section that is printed when you execute the "Print" command in Excel. It is also the section that is extracted when you execute the "Extract" command in Uniform Invoice Software.

(From Detail Page - about 99 words) - Moving the location of a cell or field is easy in Excel. To do this, you first unprotect the sheet (if the sheet is protected), and then select all the cells or fields you want to move, and then drag the border of the selected area to move it to the new location. If you need to move an Active X control, such as the "select a shipping address" icon button, you first need to switch to design mode, and then click and drag the icon button to the new location - in this case, outside the printable area.

(From Detail Page - about 111 words) - After moving out the "Shipping Date" field, you may like to expand the size of the neighboring fields to make the layout organized. This is done by expanding the Terms label and field. Expanding the "Terms" label is done by first selecting the original terms cell and the empty cells left by moving out the "Shipping Date" field, and then execute the "Merge and Center" command on Excel ribbon tab. To do this for the Terms field, you first need to move the original Terms cell to the first (left-most) cell of the empty space, and then select all the cells you want to merge, and then execute the "Merge" command.

(From Detail Page - about 53 words) - This invoice template has the "Color" column on the invoice body, which is defined as a custom field. For more information on the purpose and usage of custom fields, please refer to the documents included Uniform Invoice Software, which you can download for free and within the trial period it is fully functional.

LEARN MORE PDF

3. Auto Repair Invoice Template (2)

"Blank Vehicle Repair Invoice (2)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 89.

(From Detail Page - about 43 words) - Auto Repair Invoice Template (2) is a sample on customizing Auto Repair Invoice Template (1). This sample auto repair invoice template adds a drop-down list box to the original design, allowing to select car model from a list, instead of typing in manually.

(From Detail Page - about 56 words) - In the original format design, the "model" field is a simple Excel cell, or we can call it a text box, which allows you to enter the model manually. While the freely editable field makes it possible to enter any value into it, a drop-down box makes entering car model much easier and avoids typo errors.

...(61)...

(From Detail Page - about 150 words) - If you are interesting in the Uniform Invoice Software version of our auto invoice templates, don't worry - adding the drop-down list to the Excel invoice template will not break Uniform Invoice Software. Uniform Invoice Software welcomes any customizations and designs you could make with Microsoft Excel, as long as you adhere to the guidance described in the "Customizing Invoice Template" document included in Uniform Invoice Software. This customized auto repair invoice template, like all the other templates available here on InvoicingTemplate.com, are just examples of how to customize the default sales invoice template shipped with Uniform Invoice Software - a generic invoice template that is suitable for many business types. So to speak, InvoicingTemplate.com offers not only general invoice online, but also special formats that are suitable for different business types. Invoices are the important part in business and trading, so make sure your invoices meet your business requirements.

(From Detail Page - about 87 words) - During the past several years, we've designed thousands customized invoice template that meet requirements of different business and work with Uniform Invoice Software - which is formerly named Excel Invoice Manager and hosted on Office-Kit.com. Both Office-Kit.com and InvoicingTemplate.com are web sites built and running by Uniform Software Ltd. We'll put the invoice templates online here on InvoicingTemplate.com. Each customized template comes with two editions - one free edition that works without Uniform Invoice Software, and another enhanced edition that should run with Uniform Invoice Software installed.

...(87)...

(From Detail Page - about 63 words) - The protection of the Invoice worksheet in Auto Repair Invoice Template (2) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Auto Repair Invoice Template (2).

...(135)...

• In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
• In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

  (From Detail Page - about 53 words) - TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

  (From Detail Page - about 49 words) - Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

(From Detail Page - about 23 words) - Once you have finished your design work for Auto Repair Invoice Template (2), click the Design Mode button again to exit design mode.

...(11)...

(From Detail Page - about 40 words) - After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

...(14)...

(From Detail Page - about 17 words) - The gridlines and row/column headings could help a lot when design the layout of the invoice form.

(From Detail Page - about 64 words) - To Uniform Invoice Software version users: The Invoice form is protected to prevent accident modifications to layout and formulas. If you unprotect the sheet and try to close it, Uniform Invoice Software prompts a warning message about the protection status of the template. If you want to be able to change the list when creating invoices, you should unlock the range starting from Q16.

...(127)...

(From Detail Page - about 18 words) - Once everything is prepared, it is the time to use the Data Validation to create the drop-down list.

...(135)...

(From Detail Page - about 102 words) - The data validation tool, as shown in this example of Auto Repair Invoice Template (2), is one of the good examples of how Microsoft Excel-formatted templates could be an ideal tool for creating invoices and receipts. You may find invoice templates, whether free or not, available online in other formats, such as Microsoft Word, HTML or even PDF. But only Excel format invoice templates allows the end users without any programming knowledge to add features like what offered by the Data Validation tool. This is one of the important reasons why InvoicingTemplate.com choose to offer you invoice templates in Microsoft Excel format.

...(77)...

(From Detail Page - about 194 words) - Creating the drop-down list is in fact easy and quick in Excel. First, you must have the list of valid entries prepared. To create a list of valid entries for the drop-down list for Auto Repair Invoice Template (2), type the entries in a single column or row without blank cells. Now select the cell where you want the drop-down list added for Auto Repair Invoice Template (2). On the Data tab, in the Data Tools group, click Data Validation. In the Data Validation dialog box, click the Settings tab. In the Allow box, click List. To specify the location of the list of valid entries, do one of the following: If the list is in the current worksheet, enter a reference to your list in the Source box; if the list is on a different worksheet, enter the name that you defined for your list in the Source box. Make sure that the In-cell dropdown check box is selected. To specify whether the cell can be left blank, select or clear the Ignore blank check box. Close the dialog box to have Excel creates the drop-down list for Auto Repair Invoice Template (2).

(From Detail Page - about 49 words) - So with some simple clicks and entries, we have added a drop-down list to Auto Repair Invoice Template (2). There are many more things you can do with Excel. Feel free to play with it and use our invoicing templates as samples of creating your very own invoice templates.

LEARN MORE PDF

4. Receipt Template for Gold Shop (1)

"Receipt Template for Gold Shop (1)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 65.

(From Detail Page - about 42 words) - Receipt Template for Gold Shop is a free blank receipt template and cash receipt template designed especially for gold shop. The template has a Rate field outside of printable receipt form, with which you can specify the current unit price of gold.

(From Detail Page - about 105 words) - The free receipt template does not include "Bill To" and "Ship To" section inside the printable receipt form. The two common sections that appear on almost all free invoice templates available here on InvoicingTemplate.com, the "Bill To" and "Shipping To" sections, are moved out of the printable receipt form. If you have tried Uniform Invoice Software, you probably have noticed that the information appear in the "Bill To" sections are required - especially the Customer# field. If the Customer# is blank when the "Save To DB" command is being clicked, Uniform Invoice Software shows a warning message and refuse to save the invoice to database.

...(79)...

(From Detail Page - about 129 words) - The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Receipt Template for Gold Shop (1), all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the Invoice worksheet of Receipt Template for Gold Shop (1). To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

...(63)...

(From Detail Page - about 36 words) - The discount field located on the bottom of the free receipt template allows you apply a discount to the whole receipt. The payment receipt template does not include tax fields on the bottom of the form.

(From Detail Page - about 82 words) - The cash receipt template also has a "Making Charge" column outside the printable receipt form. It is a common practice for gold shops to add a making charge to the base cost (unit price * weight). So in this receipt the cost of each item is in fact calculated with the following formula: Weight * Rate + Making Charge. If you are running a gold shop, feel free to download and test the free receipt template to see it meets your requirements.

InvoicingTemplate.com also offers you variants of this receipt template, see Receipt Template for Gold Shop (2), which has the Making Charge column placed inside the printable receipt form; and Receipt Template for Gold Shop (3), which as the Rate cell moved into the printable receipt form; and Receipt Template for Gold Shop (4), which as both the Rate and Making Charge column moved into the printable blank receipt template.

LEARN MORE PDF

5. Service Invoice with Discount Percentage

"Service Billing Form with Discount Percentage" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 56.

...(48)...

(From Detail Page - about 63 words) - It's natural that different businesses need to detail their customer / client information on the different levels. For example, a retail shop may have to hide their customer information at all, including customer# and customer name etc.; on the other hand, a wholesale limited company or firm may need to add more details than what the default fields defined by Uniform Invoice Software.

(From Detail Page - about 102 words) - Adding a custom field to the Customer table in the database makes it possible to save the field value to database along with the other data of a customer / client. For example, adding the custom field Company Name to the Customer database table allows you to save the company name of a customer to the database when you save a customer. If you use Uniform Invoice Software version template Service Invoice with Discount Percentage and add the custom field to the invoice form, the value is retrieved and filled into Service Invoice with Discount Percentage whenever you pick up a customer.

...(22)...

• Click the "Customers" button on the "Invoices" ribbon tab for Excel 2007, Excel 2010 and Excel 2013, or click the "Customers" button on the Invoice worksheet if you are running Excel 2003.
• Click the "Custom Fields" button on the toolbar to open the Custom Field Manager dialog box.
• Make sure the "Database Table" list shows "Customers", and then click "Add Field". The "Add New Custom Field" dialog box appears.
• Enter VATRegNumber in the "Field Name" box, select "Text" as the "Type", Enter "50" into the "Size" box. Click OK to create the custom field.
• Click "Close" to close the "Custom Field Manager" dialog box.
• Now you have successfully create a custom field named VATRegNumber. To map this field to the Excel layout, use cell names. In this sample, the field VATRegNumber map to cell named oknVATRegNumber. That is, add the prefix "okn" to the field name.

...(104)...

(From Detail Page - about 101 words) - The Discount Percentage field of Service Invoice with Discount Percentage is added to the Invoice Header database tables only. This means that, unlike the Company Name field which is added to the Customer database table too, a discount value will not be filled in automatically when you pick up a customer on creating an invoice. If you want to be able to define a default discount percentage value for each customer and have the discount percentage reloaded each time you pick up a customer, you can easily implement this feature by adding the discount percentage field to the Customer database table.

...(232)...

(From Detail Page - about 127 words) - The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Service Invoice with Discount Percentage, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the Invoice worksheet of Service Invoice with Discount Percentage. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

(From Detail Page - about 61 words) - Tip: If you create a formula for a field or a cell be sure to lock it otherwise a warning mark appears on the cell. On the other hand, if you remove a formula from a locked cell in Service Invoice with Discount Percentage, unlock the cell to make sure it is editable when Service Invoice with Discount Percentage is protected.

...(164)...

(From Detail Page - about 100 words) - While the free version of Service Invoice with Discount Percentage is simple, the result invoice created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service invoice creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Service Invoice with Discount Percentage work for you.

(From Detail Page - about 24 words) - For a variant of this Excel invoice template where the discount field is defined as an amount value, see Service Invoice with Discount Amount.

LEARN MORE PDF

6. General Purchase Invoice Template (Consulting, One Tax)

"General Purchase Invoice Template (Consulting, One Tax)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 43.

(From Detail Page - about 36 words) - Whether your consulting business is running as a personal consultant or a group of consultants, to get paid timely you'll have to issue consulting invoices. A template like this one helps you done the job easily.

(From Detail Page - about 115 words) - Many consulting fields are not regulated. For example, anyone can claim to be a marketing consultant, tech support consultant, business management consultant, public relations consultant, writer, editor or graphic designer. As a result, the invoicing format used by different businesses vary depending on the special requirements in each field. Generally, consulting invoices are categorized as service invoices. Here on InvoicingTemplate.com we created a dedicated category (Consultant Invoice Template) for this topic due to its popular demands. If you cannot find your desired format in the consulting invoice templates, browse our service invoice templates where you may find more choice. You can also find useful information on other websites like Sample consulting invoice | Consultant invoice.

(From Detail Page - about 63 words) - c2027 - General Purchase Invoice Template (Consulting, One Tax) (General Purchase Billing Template (Consulting, One Tax)) is one of the formats in the serial purchase invoice template. As of Jan/31/2016, there are 3 template(s) in this serial. For the basic sales version, see General Purchase Billing Template (Sales, One Tax). For the basic service version, see General Purchase Billing Template (Service, One Tax).

...(66)...

(From Detail Page - about 40 words) - There is also a Taxable column on the invoice details section. If you have Uniform Invoice Software installed and your billable items are saved as products, the taxable boxes are also filled automatically when you pick products from saved items.

(From Detail Page - about 40 words) - The taxable option boxes are created using Microsoft Office form controls. Each box control has the "oknWidget_" prefix in its name, so that when you click the "Extract/Email" button to extract an invoice, the taxable box will be included too.

...(59)...

(From Detail Page - about 89 words) - If you items are always taxable or not taxable, you may find the additional taxable column redundant. If this is the case you can move all the taxable check boxes out of the printable invoice form. To do this, first switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab, and then select one tax box, or select all taxable boxes by push CTRL key on your keyboard and click each box. And then, you can drag the boxes out of the printable area.

(From Detail Page - about 44 words) - The "Project Summary" box is in fact the "oknNotes" field defined by the default invoice template shipped with Uniform Invoice Software. It can also create it as a custom field if you prefer. See the help document included in Uniform Invoice Software help file.

(From Detail Page - about 51 words) - On the bottom of the form, the field near "I certify that services have been provided/completed as described above - Signature of Consultant" is a text label. It is not defined in database, but designed for manually signature. If you don't need this, it is safe to delete all these labels.

LEARN MORE PDF

7. General Purchase Invoice Template (Service, One Tax)

"General Purchase Invoice Template (Service, One Tax)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 40.

(From Detail Page - about 34 words) - General Purchase Invoice Template (Service, One Tax) is a customized invoicing form based on c2025 General Purchase Invoice Template (Sales, One Tax). It differs from the original edition by removing the shipping address section.

(From Detail Page - about 148 words) - On InvoicingTemplate.com here we distribute Sales Invoicing Template and Service Invoicing Template with a simple rule - if an invoicing form contains a shipping address section, where you can fill in the address of products / goods should be delivered to, we say it is a sales invoice template. If a form contains no shipping address (or the shipping address section is out of the printable form), we say it is a service template. A service billing format, like this one, is suitable for service providers who don't delivery products and therefore don't need the shipping address fields on the form, for example legal, medical or health care, accounting or financial services, freelance work, designer, website development, copywriting & proof, consulting, handyman work, real estate, education, communications, housecleaning and babysitting, storage, processing, landscaping and gardening, auto repairs, catering, child care, pet care, advertising, tutoring, and other service businesses.

...(50)...

(From Detail Page - about 87 words) - In order to create this template - "General Purchase Billing Template (Service, One Tax)", we moved out the shipping address fields out of the "Print_Area" range. In Excel spreadsheet documents, the range name "Print_Area" defines what part of the sheet to print when you issue the print command. If the name "Print_Area" is not defined, the whole sheet will be printed; otherwise, only the range defined by the "Print_Area" name will be printed. Put it in other words, it defines what area is the printable invoicing form.

(From Detail Page - about 48 words) - To move out the address section, we first need to put the template into design mode. To do this, simply push down the "Design Mode" button on the "Invoice" ribbon tab. This commands unprotect the sheet and then push down the "Design" button on the "Developer" ribbon tab.

(From Detail Page - about 79 words) - Once the template is in design mode, drag your mouse to select all the cells that you want to move, then push your mouse key down on the border of the selected area and without releasing the mouse key, drag the selected to its new location. It's that simple! Once finished, you need to click the "Design Mode" button on "Invoice" ribbon tab again to switch it off, so that Uniform Invoice Software returns to its normal functional mode.

(From Detail Page - about 83 words) - You can download any templates here on InvoicingTemplate.com for free and create unlimited invoices using the template. However Uniform Invoice Software helps you in many ways. It makes your billing form a complete invoicing system that is able to track your customers, products, invoices and payments. Uniform Invoice Software is not a free product, but within the free trial period it is fully functional. So why don't download it - at least it helps you a lot when you are customizing the template.

LEARN MORE PDF

8. Invoice with Previous Balance (Service)

"Invoice with Previous Balance (Service)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 24.

(From Detail Page - about 28 words) - This is a service invoice version of Invoice with Previous Balance (Sales). It differs from the original version by moving all shipping-related fields out of the printable invoice.

(From Detail Page - about 49 words) - Please also refer to the original version to find out implementation details about this invoice template, including how Uniform Invoice Software maps database fields to Excel cells, and how to unlock a cell to make sure Uniform Invoice Software can read/write a cell even when the spreadsheet is protected.

(From Detail Page - about 64 words) - The main difference between this service version and the sales version is that all shipping-related fields are moved out of the printable invoice. By "printable invoice" we mean the white area on the center of the form, which is defined as the print area of the form and thus Excel will print only this area when you execute the "Print" command in Microsoft Excel.

LEARN MORE PDF

9. Plumbing Service Invoice Template (Landscape)

"Plumbing Service Invoice Template (Landscape)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 22.

...(103)...

(From Detail Page - about 104 words) - Checkboxes can not only be used as in a column value, but also could be on the invoice header and invoice bottom. For another example of using checkboxes, refer to Medical Invoice Template (1) and Medical Invoice Template (2). One thing to note for the Uniform Invoice Software version is that, if you extract an invoice, the taxable checkboxes will be kept on the extracted version. This is implemented by naming the checkboxes with "oknWidget_" prefix. All the other objects that don't have "oknWidget_" prefix in their names, like the command buttons on the plumbing service invoice form, will be deleted when being extracted.

(From Detail Page - about 35 words) - Please go to the download page to download the Plumbing Service Invoice Template (Landscape) in the format you like. If you are interested in the implementation details of Plumbing Service Billing Template (Landscape), read on.

...(100)...

(From Detail Page - about 40 words) - Like most free invoice templates available here on InvoicingTemplate.com, Plumbing Service Invoice Template (Landscape) has a logo image on the top-left corner. You should replace it with your own image before you can use the template for your own business.

...(90)...

• Right click the Logo image, and then select Properties from the menu.
• Click the Picture property, and then click the "..." button.
• Browse to the folder containing your icon file. Select and open the icon file.
• Close the Properties dialog box.
• Drag the border of the image object to resize it, if needed.

(From Detail Page - about 100 words) - If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

(From Detail Page - about 38 words) - Plumbing Service Invoice Template (Landscape) uses custom fields that are not defined in the default database shipped with Uniform Invoice Software. For example, underneath the "Bill To" section there is an oknJobAddress cell, which is a custom field.

...(135)...

(From Detail Page - about 111 words) - The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Plumbing Service Invoice Template (Landscape) without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

...(232)...

(From Detail Page - about 71 words) - Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software, i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With Uniform Invoice Software, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

LEARN MORE PDF

10. General Purchase Invoice Template (Sales, One Tax)

"General Purchase Invoice Template (Sales, One Tax)" was found to be relative to Invoice Software Usa Free Download Excel Sheet with the score grade of 18.

(From Detail Page - about 33 words) - Sometimes an invoice is also referred as purchase invoice from the view of the buyer. This general-purpose Excel-formatted purchase invoice sample includes two editable/fillable columns, Description and Amount, and a Taxable checkbox column.

(From Detail Page - about 50 words) - Like the other sales invoice template here on InvoicingTemplate.com, c2025 General Purchase Invoice Template (Sales, One Tax) is compatible / work well with Uniform Invoice Software, which is our invoicing software that connect a front-end Excel-formatted template with back-end database, providing features like management of customers, products, invoices and payments.

(From Detail Page - about 50 words) - c2025 - General Purchase Invoice Template (Sales, One Tax) (General Purchase Billing Template (Sales, One Tax)) is one of the formats in the serial purchase invoice template. As of Jan/31/2016, there are 2 template(s) in this serial. For the basic service version, see General Purchase Billing Template (Service, One Tax).

(From Detail Page - about 114 words) - As a sales invoice template, this sample template includes the "Ship To" section for you to detail the shipping address of the product sold. The default configuration of this section comprises of 5 fields / fields - oknShipName, oknShipAddress, oknShipCityStateZip, oknShipCountry, oknShipContact. Note that Excel Invoice Manager was renamed to Uniform Invoice Software, and with the release of Uniform Invoice Software, custom fields are not only supported in the main database tables like InvHdr, InvBdy, Customer and Product, but also CustomerShippingAddress. By adding custom fields (i.e. user-defined fields), you can add new fields to the Shipping Address section on the invoice form too, and have the newly added fields work with Uniform Invoice Software.

(From Detail Page - about 113 words) - Several other templates here on InvoicingTemplate.com have the Taxable options put on the printable form too. This sample, General Purchase Billing Template (Sales, One Tax) differs from others in that it implements the taxable options using the Form Controls. Microsoft Excel, and thus Uniform Invoice Software, actually supports two types of checkboxes added to a spreadsheet form - i.e. form control and ActiveX control. In case you need to add your own control, visit the Controls group of the Developer ribbon tab. This tab is not visible by default. To display it, first right-click an empty area on the Excel ribbon, choose "Customize the Ribbon" and then check the Developer ribbon tab option.

(From Detail Page - about 95 words) - The formulas of this bill sample are set so that when a Taxable box is checked, the Amount of the current is included when calculating tax. Likewise, if a taxable box is not checked, the amount of the current line is excluded from the tax calculation. This is done by using a array formula of a hidden cell named oknLineTotalTaxable (cell address B35): {=SUM(oknTaxable_1:oknTaxable_6*oknLineTotal_1:oknLineTotal_6)}. Note that the "{" and "}" symbols in the formula, which indicate it is an array formula. For a detailed explanation on array formula visit Guidelines and examples of array formulas.

LEARN MORE PDF