Reconciling Marketplace Payments No AR

If there is a difference between the amounts shown as owed to the bookstore by the marketplace vendors and the bookstore, you will need to determine why.

  • Compare the payment amount to the Marketplace reconciliation report (sales and refunds) generated from PrismCore Ship Mail Order for the payment peri
  • Run a detail payment report from the marketplace sites to help reconcile to Mail Order. What can cause you to be out of balance?
  1. Did you account for the monthly fees charged by the marketplace vendor for selling items on their website?
  • Some of the marketplace vendors deduct these fees from the money transfer The email notification from Amazon indicated that a seller fee of 39.99 was subtracted from the payment. If you have not recorded the fee, the amount that you show as owed to the bookstore from Amazon will be overstated. Add the fee amount to the closing balance listed on the transfer and enter this as the automatic deposit amount at the register; (which is the gross amount of the payment received). Then enter the fee amount as a pay-out. The pay-in minus the pay-out should equal the actual amount of the transfer.
  • Some of the marketplace vendors charge the fees to your store’s credit card and send a check for the sale Therefore, the payment amount does not need to be adjusted.
  • If the marketplace vendor deducts the fee from the amount of your check you will manually deduct the fee amount from the Marketplace Reconciliation Report primary tender total and that amount should reconcile to the check amount.

    2. Have you recorded all of your refunds? Did you process a refund as a sale in Mail Order?
  • To determine if you have recorded your refunds in PrismCore Mail Order, print the Marketplace Reconciliation report from Ship Mail Orders for amazcom for the date range needed. Select refunds for the type.
  • Compare this report to your amazcom refunds on your Monsoon account. Are all refunds accounted for in PrismCore Mail Order?
  • See the Monsoon documentation for listing refunds on M Refunds for alibris.com, abebooks.com and half.com are processed on their respective websites, not on Monsoon.
  • From their websites, compare processed refunds with refunds entered in PrismCore Mail Order.

    3.Have all of your marketplace sales been recorded in PrismCore?
  • Generate the Marketplace Reconciliation report from Ship Mail Orders for the date range neede Select sales for the type.
  • Are all sales accounted for in PrismCore?
  • Compare this report to your Monsoon listing of sales on Monso

If you print and reconcile daily, this should not be an issue when a payment arrives.