Vendor Central: Contesting Chargebacks and Invoice Reconciliation
Transcription
In your control document, copy and paste the purchase orders from your own system into the relevant, heading in the worksheet, do a V lookup or copy and paste the invoice date into the relevant column, and then indicate which financial year the receipt date is in. For example, a purchase order invoice in your system on March 5th, 2019 would be a Mar dash 19 financial period.
show moreCopy and paste or V lookup, the invoice value into the relevant column. Then do a V lookup function from your backup report, pivot table to pull the receipt date into the relevant column, and then indicate which financial year the receipt date is in. For example, a purchase or receipt by Amazon or March 5th, 2019 would be a Mar dash 19 financial period.
Copy and paste the purchase order net receipts into the relevant column as well. If no net receipts or receipt date pulls through from the backup report pivot table, you can immediately see that that specific purchase order invoiced and shipped in this month has not yet been received by Amazon as they’re not on the Amazon backup report.
Leave the receive date and financial period received columns blank as well as the net received column. Bear in mind that you may need to look for these missing purchase orders in the previous month of shipped orders, as they may now only be recorded in this month’s backup report of net receipts from vendor central. Next, do the necessary calculations in the variance, variants, and net receipts column between invoice value and Amazon net receipt.
If there are any variances, go back to your backup report and search for them in the purchase order in question until you find them, you can then provide an explanation in the next column, being sure to take note whether it was due to a shortage or an overage, as you can now be liable for the shortage or the overage.
Depending on whether you have already submitted a dispute for them or not. At this stage, you can clearly see the following information from the reconciliation of your purchase orders and invoices, which purchase order was not received by Amazon in the same month that you shipped it, which purchase orders are not included in the net receipts from which your co-op deductions are calculated for this month.
Any variances between what you shipped and invoiced and what Amazon claims to have receipts. The ability to search for shortages and overages or price discrepancies, and use them to reconcile the reports you pull from your dispute management dashboard or your price discrepancies on your invoices page on vendor central.