Microsoft's Excel is everywhere in the business world, in part because it's such a versatile platform. Med-e-Forms offers several free Excel workbooks that handle a variety of tasks for small businesses such as physicians in private practice. The company's Free Excel Invoice Template & Profit Calculator is essentially a basic business suite in one Excel workbook.
Some of the free Excel templates we've seen from this publisher have been fairly plain, but this tool's clear, colorful instructions and efficient layout show what Excel is capable of doing. The Instructions sheet provides details for Excel 2007-2010 (we used Office 2010) and for Excel 2003 and earlier. With directional arrows and screenshots, it's much more like traditional software than a spreadsheet template, and it made setting up this tool easy work. We entered our data on the Customers sheet, including Payment Terms, Sales Rep, and contact information. Next, we entered the items we were invoicing on the Items sheet, either goods or services along with price, tax, and other data. The template stores this data. The Invoice sheet let us create customized invoices drawing on the data we'd entered, including a customized letterhead, and displayed costs and profits in a side table. A Summary sheet displayed all our invoices. While the instructions are clear, the provided example entries may do just as good a job of showing new users what goes where. Most of the data will be familiar to small-business professionals (large ones, too) and nothing seemed unusual. There are frequent ads for the publisher's PDF-based shareware tools, but they're hardly a nuisance and won't appear on your invoices.
We were impressed by this free Excel tool and what it does. Small businesses need all the help they can get these days. Free Excel Invoice Template & Profit Calculator really steps up.
While creating Invoices is a critical part of business, without knowing your profit, or loss, you may be taking some big chances. With our Free Excel Invoice Template & Profit Calculator We have taken the concept of an Excel Invoice Template we built a complete small business solution around it in one, simple to use Excel workbook. Simply enter your Customers on one sheet, along with their Payment Terms, Sales Rep and address information. Then, on the Item sheet create any type of Service or Material Item, enter the description Sales Price, Item Costs and taxable status.
Once this information has been entered, you never have to type it in again, as all information is kept in the tables. Invoices can be created in seconds, by simply selecting from a drop down list of Customers. Once a customer has been selected, all Address, Payment Terms, Due Date, and Sales Rep are automatically filled in under the appropriate boxes. Entering Items is even simpler. Select an item from the drop down list, and watch how the Item Description, Price, Cost and Taxable status are automatically entered. As the invoice is created, all Invoice Totals, Costs and Profit are automatically calculated, while only the Invoice Totals are printed on the Invoice for your customers. Once the Invoice has been created, a click of a single button will post all totals to a summary page, the Invoice Is cleared, and the Invoice # is updated. The Summary page is an simple way to not only view your Invoice Totals, Total Costs and Total Profit, but allows you to enter Customer Payments so following up on unpaid invoices can be done simply. Download our Free Excel Invoice Template and Profit today, and start enjoying your business all over again.
What's new in this version:
Updated template to work with all versions of MS Excel, fixed minor issues with Address field on Invoice