CiviCRM Community Forums (archive)

I've been searching the documentation for help on this one, haven't gotten any where...

We need to retrieve the full billing name for each contribution, as entered into the payment processor; this is necessary for us to reconcile contributions with our accounting system.

Unfortunately, I'm not able to find the billing name anywhere via the Civi interface.  It doesn't seem to be one of the fields available under the contribution reports.

When I look at the database, I see that the billing information creates an "Address" record associated with the contribution.  However, the billing first and last name are combined into a single field ("name") in the address table.

Any hints on how I can generate a report which includes billing first and last name separately?  Any help would be much appreciated.  Thanks!