The consolidated report provides you with a comprehensive overview of your sales with noon and can be used to do some of the following:
- Calculate sales by product
- Calculate sales over time
- Identify items that are intransit and have not been delivered
- Identify items that have been delivered but not yet paid for
Items will only be included in the consolidated report after dispatch by noon
Jump to sections
Accessing the consolidated report
The consolidated report is available in the custom section of the reports.
Items will only be included in the consolidated report once they have shipped. If an item you were expecting to see is not present you should check your current inventory position.
This version of the consolidated report is only available to partners on the stock request order processing flow
1. Go to Core > Reports
2- Select Custom then select the requested dates.
3- Click on submit.
4- Download Consolidated Report.
Understanding the consolidated report
These columns help you identify which of your products was sold. In addition the item number provides a reference that can be used across all subsequent reports.
|item_nr||The unique customer order you can use to link a sale for any item across reports|
|The unique partner sku you have uploaded in seller lab|
|sku||The noon SKU you sold the item against|
These columns give you all of the information about your sale covering commissions, the current item status the sales promise service levels and any applicable timestamps.
The shipped_date and returned_date are reliable as they are based on timestamps wholly under noon's control. The delivered_date can sometimes change in the event of a mistaken update by one of our logistics partners.
|city_from||The city of the noon dispatch warehouse|
The customer city (required for VAT attribution or reporting purposes)
|commission_type||The applicable commission scheme with noon. If your product is eligible for a promotion it will be communicated here|
|item_status||The current status of the item.|
|is_fbn||Whether the customer order was from a noon Express source|
|sla_type||The applicable noon sales promise.|
|shipped_date||The date of dispatch from noon's warehouse|
|delivered_date||The date of delivery to the customer.|
|returned_date||The date for return to noon's warehouse|
|return_ndr_due_date||The return due date if the item cannot be delivered to the end customer|
|return_cir_due_date||The return due date if the item is delivered to the customer and subsequently returned|
|currency_code||The sale currency. You will receive a separate statements denominated in UAE dirham or Saudi Riyal depending on the sale country|
Item prices and promotions
These columns provide you with visibility about any adjustments due to promotions, crossborder markups or taxation.
noon Markup and Indirect VAT are related to crossborder transactions and will no longer be applicable going forward.
The Seller Promo, noon Markup, Promo Deal and Promo Coupon values account for promotional activities. Promo coupons are always funded by noon and are credited back to you via Fee noon Promo.
|base_price||Seller price adjusted for promotional costs borne by you. With prior agreement between you and noon||Seller price minus seller promo|
|seller_promo||Any applicable promotion applied by you as a sale price||No calculation|
|seller_price||The price value updated in Seller Lab||Base price plus seller promo|
|noon_markup||Any applicable noon crossborder or logistics markup||No calculation|
|promo_deal||Any applicable promotion applied by noon||No calculation|
|offer_price||The price of the item on noon.com after all applicable promotions||Seller price plus noon markup and promo deal|
|promo_coupon||Any coupon or promotion applied by the customer||No calculation|
|indirect_vat||Any VAT charges due at the end country for crossborder||No calculation|
|invoice_price||The value invoiced to the customer||Offer price minus promo coupon and indirect VAT|
The Invoice Price corresponds to VAT Supply in the Invoice report and is inclusive of VAT, when recording the sale you can either use the VAT amount from the invoice report to decide how much to book to your VAT account.
Payments due and statements
Statements are generated weekly when the value of the weekly payment statement is greater than or equal to AED 1000. Once an item is delivered the Payment Pending value will increase to match the Payment Due amount. Once a statement is generated the value in Payment Statement Total will be deducted from the Payment Due amount.
If the value of your payment is less than AED 1000 then the payment will be processed if the value of your next weekly statements, or the sum of your weekly statements amount to AED 1000. Otherwise, we’ll process your payment once a month, regardless of its value, even if it’s below AED 1000.
|fee_commission||noon's commission on the sale. See noon service annexes for KSA and UAE|
|fee_closing||noon's closing fees on the sale. See noon service annexes for KSA and UAE|
|fee_noon_promo||Credit back to you of any marketing / promotional costs due by noon|
|fee_noon_markup||Deduction of noon crossborder fees where applicable|
|fee_adjustments||Adjustment to previous fee or commission values|
|fee_crossborder_vat||Deduction of noon crossborder VAT where applicable|
|fee_vat_deducted_at_source||No longer applicable|
|fee_noon_penalty||Penalty fee incurred by noon due to late or damaged return of an item|
|payment_due||Final payment due|
|payment_statement_total||Payment due in the next applicable statement|
|payment_pending||Final payment due less any payments in other statements|
|invoice_nr||The customer invoice reference for VAT purposes|
|creditnote_nr||The customer return invoice reference for VAT purposes|
|statement_nrs||A comma separated list of statements for the item|
Items missing from the consolidated report
Items will only be included in the consolidated report once they have been dispatched by noon.
For crossdock B2B (crossdock) there can be an average of 24 - 72 hours from the time you handover an item to the time it dispatches.
In addition in the following circumstances an item may not be dispatched at all:
- The customer cancels their order with noon prior to dispatch
- The item is received in a transfer but fails quality control
If the number of sales for a product is lower than what you expected based on what you handed over to noon you can check the following areas to tally the figures
- Your transfers from noon for return to vendor (RTV) documents
- Your stock close report for current noon stock on hand