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.
Is there any accounting guideline if I set up all the vendors in SAP for the charges we paid on American Express credit card?
Answers
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
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.
Filed Under:
Accounting