Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Product Names and Shipping Address on Aging Report

Product Names and Shipping Address on Aging Report (c5150)

c5150 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open microsoftinvoicetemplatefreedownload.xlsx.

Product Names and Shipping Address on Aging Report (IMFE Edition)

Product Names and Shipping Address on Aging Report - IMFE edition

Download

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 want this design to be set as the default template by the installer program.

3.39 MBDownload

Without database file. How to download and use

147 KBDownload

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

520 KBDownload

Detail

Product Names and Shipping Address on Aging Report

c5150

Product Info on Accounts Receivable Aging Report

microsoftinvoicetemplatefreedownload

Related template fixed: c4055 c4059 c5084 c4103

Related gallery fixed: office,5

The "Aging" report in our Invoice Manager program is also called Account Receivable Aging Report. In earlier versions of Excel Invoice Manager, it is also called Customer Statement. This sample for bank analyst shows how to add item names from invoice detail section to the aging report.

The account receivable aging report is based on the "Invoice Header" database table. This is where the "Shipping Address" field (cell name "oknShipAddress") saved to. So there is no problem to display the shipping address on the aging report. Here are the brief steps to follow:

  1. Activate the "Aging" report worksheet if it isn't the current one.
  2. Go to Excel "View" ribbon tab and push check the "Gridlines" and "Headings" boxes in the "Show" group.
  3. Click to select the first heading cell on the aging report. Usually it is "invoice#" (the cell name is "oknAgInvoiceID".
  4. Click "Format Painter" on Excel "Home" ribbon tab.
  5. Click the first empty cell on the heading line -- in this case, it is $O$24. This copies the format of the first heading cell to the empty cell.
  6. Name this cell "oknAgShipAddress". This tells Invoice Manager that the column should fill with the shipping address information.

Filling product names into the aging report is a bit complex. This is because the product names -- i.e. the "Description" column on the invoice worksheet -- is saved to the "Invoice Body" database table. The relationship between the "invoice body" and "Invoice Header" is a one-to-many relationship. So it is necessary to combine all the product names into one, and then save the combined text to the "Invoice Header" database table. See Office Invoice Templates for more samples on this.

It is not as easy as you might imagine to combine several cell values into one. As explained on trumpexcel.com there are multiple ways you can do this, but Excel offers no special formula for this -- except Excel 2016 (Office 365), which offers the "TEXTJOIN" function.

Since our templates should support earlier version of Excel, we use the old "CONCATENATE" function. The following formula looks a bit long but it works for all the major Excel versions:

=TRIM(CONCATENATE(oknProductName_1," ",oknProductName_2," ",oknProductName_3," ",oknProductName_4," ",oknProductName_5," ",oknProductName_6," ",oknProductName_7," ",oknProductName_8," ",oknProductName_9," ",oknProductName_10," ",oknProductName_11," ",oknProductName_12))

This formula combines all the product description cells and separates them with a space. The "TRIM" function is used for removing all the redundant spaces from the result.

In this sample, the result of the formula is assigned to the "oknStatementNotes" cell. We then define a custom field "StatementNotes" in the "Invoice Header" database table.

Now it is easy to add the "StatementNotes" field from the "Invoice Header" database table. Just follow the steps described earlier for the "Shipping Address" field. Download the sample invoice template for free to find out how it works.

Like other form designs here on InvoicingTemplate.com, Product Info on Accounts Receivable Aging Report 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#c5150
NameProduct Names and Shipping Address on Aging Report
CategoryService Invoice Template
Release DateTuesday, November 13, 2018
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)16.50
Print Area$F$3:$M$46
Papaer Size / OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00