more-arw search

Q&A Forum

Is there any accounting guideline if I set up all the vendors in SAP for the charges we paid on American Express credit card?

Anonymous XYZ's Profile

My manager wants a report from SAP that shows each transaction we paid on American credit card. How much we paid for each transaction for the whole year and to whom we made payment on credit card with all details along with GL account coding. For e.g. If we paid $10k in a year for computer parts on Amex card. He wants a report from SAP system showing all the details for each transaction we coded for General Ledger acct. for Computer Expense. For that If I set up all those vendors in SAP and I enter as an invoice for each line item for all the transaction paid on American Express form Amex statement. Then I have to split the payment what we made to American Express by each charge for all the vendors for the total payment made to Amex. By doing this process, I am following account guideline or not? Is there any other option to split American Express credit card statement in order to get a detail reports from SAP for each charges on Amex statement? Please reply me at your earliest. Thanks.

Answers

Lisa Strassman, MBA
Title: Director of Finance and Corporate Contro..
Company: Daikin America, Inc.
(Director of Finance and Corporate Controller, Assistant Treasurer, Daikin America, Inc.) |

You can get good summary reports from American Express and don't need to input all the details into your G/L. You can get some canned reports or download the data into an Excel or a .csv file.

Anonymous XYZ
Title: Sr. Accounts manager
Company: XYZ
(Sr. Accounts manager, XYZ) |

However, my manager wants this report from General Ledger. That way we can get all credit card payment towards expenses plus payments by check and wire transfer everything we get from one place in single report. That gives us accurate picture.
Thanks.

992 views
Topics
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.