Debit Note Template for Attorney

This debit note template is customized specially for attorney or similar businesses, containing fields that are useful for attorneys, such as "File Ref#", "Off. Fee Payment Voucher No.", "Invoice Currency", as well as two price columns "Official" and "Professional".

If you are looking for a general purpose debit note template, please visit Debit Note Template here on InvoicingTemplate.com. This customized debit note template for attorney was created based directly on the default sales invoice template shipped with Uniform Invoice Software installer program, by using custom fields.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Debit Note Template for Attorney uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

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 Debit Note Template for Attorney without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

When working with Uniform Invoice Software (UIS) version of Debit Note Template for Attorney, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Debit Note Template for Attorney and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), 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 UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

In detail, the custom fields added to the Invoice Header database table are "voucher", "YourRef", "OurRef", "InvCurrency", "TotalOfficial" and "TotalProfessional". In addition to that, there are also a custom field, "Official", added to both the Product table and Invoice Body database table, which appears as a column on the debit note form, as you can see from the screenshots below.

The field titled with "Our File Ref", which has a cell name oknOurRef, is implemented as a drop-down list.

Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid. If you prefer, you can allow users to enter invalid data but warn them when they try to type it in the cell. You can also provide messages to define what input you expect for the cell, and instructions to help users correct any errors. One thing you may not be aware of is that, most of the templates available here on InvoicingTemplate.com, including this Debit Note Template for Attorney, as well as the default spreadsheet template shipped with Uniform Invoice Software setup program, are using Data Validation to prevent incorrect data being entered.

The data validation tool, as shown in this example of Debit Note Template for Attorney, 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 business templates, whether free or not, available online in other formats, such as Microsoft Word, HTML or even PDF. But only Excel-formatted 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 invoicing templates in Microsoft Excel format.

Among other things, you can use data validation to do the following: 1), Restrict data to predefined items in a list; 2), Restrict numbers outside a specified range; 3), Restrict dates outside a certain time frame; 4), Restrict times outside a certain time frame; 5), Limit the number of text character; Validate data based on formulas or values in other cells. This template, Debit Note Template for Attorney, uses the first technique to create a drop-down list.

As shown in this example of Debit Note Template for Attorney, when you create a drop-down list for a cell, it displays an arrow in that cell. To enter information in that cell, click the arrow, and then click the entry that you want.

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 Debit Note Template for Attorney, 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 Debit Note Template for Attorney. 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 Debit Note Template for Attorney.

Although it is easy to create the layout and format of Debit Note Template for Attorney with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Debit Note Template for Attorney uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Debit Note Template for Attorney, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Debit Note Template for Attorney is provided in two editions - a freeware editions of Debit Note Template for Attorney, and a Uniform Invoice Software (UIS) edition of Debit Note Template for Attorney. Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

The freeware edition of Debit Note Template for Attorney provides exactly the same form layout and design in Microsoft Excel format as the UIS edition of Debit Note Template for Attorney. The most noticeable difference, at the first glance, is that the UIS edition of Debit Note Template for Attorney contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by UIS. For example, if you click "Save To DB", UIS validates and checks the current document on Debit Note Template for Attorney, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

Like other form designs here on InvoicingTemplate.com, Debit Note Form for Attorney 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.