American Express (AMEX) payment entry

Use this area for questions that are specifically related to Canada (e.g PST handling, Canadian cheque standards)
Forum rules
This forum is not the official Cognito Software support channel for MoneyWorks. If you need help from Cognito, then please contact us (or your local regional support representative) directly using the contact information on the Support page of the web site.

Please try the search facility before posting a new topic to see if your topic has already been covered.

If you do post a new topic, it's a good idea to choose a Topic Subject that it a bit more informative than "Help!" or "A problem". If your topic is actually recognisable by people scanning the forum, you'll have a much better chance of getting a response. Thanks and have fun.
Post Reply
Posts: 1
Joined: 03 Jul 2014 03:04
Product: Express
Region: Canada

American Express (AMEX) payment entry

Post by jsimkins » 03 Jul 2014 03:18

I'm having a problem figuring out how to correctly post American Express card payments. The other credit cards are no problem as the payment amount is equal to the invoice amount and the card charges appear as a separate transaction, easily posted to a financial charges account.

Amex, however, remits a payment that is the invoiced amount less their service charge. So, if the invoice is $1200.00, the payment would be $1170.00. Up to now, we've not had too many Amex accounts and I've dealt with this by adding a credit to the customer account equal to the credit card charge thus zeroing everything out nicely. However, when multiple charges are submitted, Amex sends back a bulk payment and the individual charges are not broken out, just the lump sum charge.

In a previous accounting system, I could open the clients account, apply the payment of 1170 and the card charge of 30 and the customer's account would be credited 1200, with the bank getting 1170 and finance charges getting 30. I can's see any easy way of doing this within Express but I'm not a real bookkeeper.

Any help out there?

Post Reply