Is there a method of tracking vendor activity in Pcard purchases?
We currently down load Pcard purchase activity weekly from the bank as a text file, convert to an Excel file and upload using a variant of transaction GLupload. This works well enough for placing each transaction in the proper GL account/cost center but the entire balance is listed under the bank as the vendor.
Is there a better way to manage Pcard payment so we can track the charges to individual merchants (vendors) so we can see how much we are paying each vendor without looking through each weekly upload? Can we match pcard vendors to the SAP vendor master or a separate list of vendor such as business partner?
Thanks for any ideas!