Welcome to HostingForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Credit Card Receipt and Invoice Matching questions

 
   Web Hosting Problem Solving Community! (Home) -> ECommerce RSS
Related Topics:
Credit Card Details - Hi, I have a form set up on my website that allows customers to input their credit card details, which are to the webserver that hosts my website in a secure manner How do i then retrieve these details in a secure manner (ie a..

Credit Card processing - Hi, Can anyone recommend a good company to process credit card payments for I currently use PayPal, but often have to reject orders when customers want to give me their credit card info over the phone. I have to tell them to send a

Anyone have a second to evaluate my credit card website? - I'd really some objective feedback on If you have a website, I'll post a link on for your time. Thanks

Credit card process online - I am looking for a PSP (payment service provider) that accept online credit card for a DMC company, travel Our website is Worldpay does not accept us. Can anyone help us? Thank you in advance.

Credit card processing question - I'm in the process of starting a small furniture company, and I intend to sell the majority of my products from my future web site. I'm also planning on hitting a few craft fairs per year. Most of my products will sell in the range from $80 - $300, with
Next:  ECommerce: Merchant account recommendations  
Author Message
poddys

External


Since: Feb 26, 2008
Posts: 1



(Msg. 1) Posted: Tue Feb 26, 2008 12:16 pm
Post subject: Credit Card Receipt and Invoice Matching questions
Archived from groups: alt>ecommerce (more info?)

Our primary business is wholesale, our finance systems running on
AS400.
We recently generated a Direct To Consumer service, selling items
through our web sites, Infomercials and QVC.
The problem that we are having is in matching some of our credit card
payments to the invoice which is generated when the goods are
shipped. I am sure that other companies don't have this problem, and
it just may be the companies that we are dealing with, but hopefully
someone can suggest a solution.

Orders are raised through the web site (etc), each order being given a
unique Merchant Reference Number on the eCommerce system (all orders
are held here, whether generated through web, phone or QVC).
These are then interfaced to our mainframe system, generating Sales
Orders.

When the items are shipped, the Sales Invoice details (document number
+ amount) are updated on the eCommerce system.

The payment process charges the customer card, updates on the
eCommerce system, and the details are sent to the bank.

The bank itself handles Visa/Mastercard transactions, but passes
American Express and Discovercard sales to those companies.

Eventually (1-3 days later depending on card type) the bank confirms
to us the deposits that were made for the day, however in some cases
our Invoice Number is not shown on the detail file.

90% of the time our Invoice Number does show for Visa/Mastercard,
however for Amex and Discovercard it never shows, and we either get no
reference at all or the same reference for each transaction.

The file from the bank does not contain any other useful reference,
only an Invoice Number, so if this is not in the correct format, all
that we can go on to match with the original sales invoice is the
date, card type and amount.

Is this something that other companies have problems with?
I would have thought that being able to correctly match a payment with
it's invoice, ideally by invoice number (in case of multiple
shipments) or by sales order number (Merchant Reference Number) would
be a standard feature.


2nd complication............

We also have promotions that allow items to be paid in 3 or more
installments. In this case, the payment processing company tell us
that they have to generate a unique reference for each payment, and
this is the only reference we get back from the bank. So in this case
we can't even use amount or date to link back to the original invoice.

Any suggestions on how we might be able to deal with this (other than
switching companies) would be much appreciated.

 >> Stay informed about: Credit Card Receipt and Invoice Matching questions 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> ECommerce All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]