InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Product Names and Shipping Address on Aging Report

Open the template in Excel.

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 have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

728 KBDownload

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

5.83 MBDownload

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.

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
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
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Screenshot for Simple Sample - Discount Amount on Sales Report

Simple Sample - Discount Amount on Sales Report

Screenshot for Simple Sample - Customer Name on Product Report

Simple Sample - Customer Name on Product Report

Screenshot for Simple Invoice Sample - Sales Rep Name on Product Report

Simple Sample - Sales Rep Name on Product Report

Screenshot for Simple Sample - Total Quantity on Sales Report

Simple Sample - Total Quantity on Sales Report

Screenshot for Simple Sample - Moving Balance and Payment Cells

Simple Sample - Moving Balance and Payment Cells

Screenshot for Simple Sample - Moving Item# Column

Simple Sample - Moving Item# Column

Screenshot for Simple Sample - Using Currency Symbol

Simple Sample - Using Currency Symbol

Screenshot for Simple Sample - Discount Amount Field

Simple Sample - Discount Amount Field

Screenshot for Simple Sample - Moving Taxable Controls

Simple Sample - Moving Taxable Controls

Screenshot for Simple Sample - Changing Paper Size

Simple Sample - Changing Paper Size

Screenshot for Simple Sample - Changing Print Orientation

Simple Sample - Changing Print Orientation

Screenshot for Simple Sample - Discount Percentage Field

Simple Sample - Discount Percentage Field