Reconciliation File - UI Fields Mapping
Introduction
This article provides a comprehensive mapping of fields found in the Reconciliation File to their corresponding locations in the Platform user interface. The Reconciliation File contains billing and subscription data that enables sellers and distributors to reconcile invoices, track subscriptions, and analyze pricing across the supply chain. Understanding where each field originates in the platform helps users verify data accuracy and troubleshoot discrepancies.
In this article:
Field Mapping Reference Table
The following table provides a quick reference for all fields available in the Reconciliation File and their corresponding locations in the Platform.
| Field Name | Mapping to portal UI |
| Invoice Number |
AppXite Platform generated number per invoice receiver. |
| Invoice Status |
Invoice state. Three possible statuses: New, Verified, Processed. |
| Invoice Date |
Billing cycle i.e. date when invoices are generated. |
| Invoice Provider | Entity issuing the invoice. Visible under main reseller profile under Select organizations. |
| Business Location of Provider |
Location which main reseller organization is added into |
| Business Location of Receiver |
Location which end customer organization is added into |
| Invoice Receiver |
Entity receiving the invoice. 2. reseller on Distributor platform. |
| Receiver Status |
Invoice receiver status in the platform. Three possible statuses: New, Active, Blocked. |
| Receiver ERP ID |
Field available to enter customer ERP ID for invoice receiver in AppXite platform. Can be used for data mapping purposes. |
| Receiver Country |
Country of invoice receiver as defined for the organization under legal details. |
| Receiver VAT Number |
VAT number of invoice receiver as defined for the organization under legal details. |
| Contract Number |
Field available to enter Contract number under Contract section in the Platform. Can be used for data mapping purposes. |
| Contract Reference Number |
Field available to enter Contract reference number under Contract section in the Platform. Can be used for data mapping purposes. |
| Reference Contact Person |
Field available to enter Reference contact person under Contract section in the Platform. |
| Billing Address |
Invoice receiver billing address as defined for the organization under billing address. Important to maintain this field up to date as this field is used to issue invoices. |
| Comments |
If the subscription was purchased outside of AppXite Platform but is synced from Vendor, this subscription will get a message "Created Automatically while synchronized", otherwise this field will be empty. |
| Reseller Name | Entity part of the supply chain that is issuing the invoice to the end- customer. |
| Customer Name |
Entity that receives the final invoice. |
| Offer Name |
Offer name as available in the product catalog. |
| Subscription Name |
Purchased offer name. |
| Subscription Start Date |
Start date of subscription. |
| Subscription End Date |
End date of subscription. |
| Charge Start Date |
Start date for charge calculation in this billing period. |
| Charge End Date |
End date for charge calculation in this billing period. |
| Charge Type |
Charge Type. As possible statuses: Cycle Fee, Purchase Fee, Usage Fee, Correction, One-Time. |
| Commitment Term |
Term of commitment for subscription |
| Currency |
Invoicing currency. |
| Revenue Unit Price |
Unit price for a subscription for outgoing invoice to invoice receiver. |
| Customer Quantity |
Quantity for subscription for outgoing invoice to invoice receiver. |
| Revenue Total Price |
Total price for a subscription for outgoing invoice to invoice receiver. |
| Vendor |
Vendor providing particular offer. |
| Cost Unit Price |
Unit price for a subscription for incoming invoice to invoice provider. As a Disti , reseller unit price means in price for the distributor. As a reseller, reseller price is my unit price. |
| Cost Total Price |
Quantity for subscription for incoming invoice to invoice provider. As a Disti , reseller unit price means in price for the distributor. As a reseller, reseller price is my unit price. |
| Reseller Currency |
Total price for a subscription for incoming invoice to invoice provider. As a difference between Customer Price and Reseller Price can be calculated profitability of subscription, per customer, per reseller, or per vendor. |
| Retail Price Source |
Based on which price calculation is done: Vendor Retail Price or Reseller In Price |
| Retail Price Markup |
The mark-up on retail price. |
| Customer Markup |
Customer-specific markup |
| Price Markup Start Date |
Date from which mark-up is effective. |
| Invoice Provider Id |
AppXite Platform generated GUID number for Invoice Provider. |
| Invoice Receiver Id |
AppXite Platform generated GUID number for Invoice Receiver |
| Reseller Id |
AppXite Platform generated GUID number for Reseller |
| Customer Id |
AppXite Platform generated GUID number for Customer (consuming the subscription) |
| Vendor Customer Id |
Vendor-generated GUID number for Customer organization. For example, for Microsoft, this corresponds to customerId. |
| Offer Id |
AppXite Platform generated GUID number for Offer |
| Vendor Offer Id |
Vendor generated GUID number for Offer (For every other vendor except Microsoft) Vendor Offer ID is the same as Offer ID generated by Platform |
| Subscription Id |
Platform generated GUID number for provisioned Offer i.e. subscription |
| Vendor Subscription Id |
Vendor generated GUID number for provisioned Offer i.e. subscription. For example for Microsoft this corresponds to SyndicationPartnerSubscriptionNumber. |
| Custom Offer Properties |
Information regarding custom offer properties created via API |
| Invoice Reference # | Unique invoice reference number across vendors and sellers |
| Invoice Receiver MPN ID |
MPN ID of the Partner you're invoicing. |
Summary
The Reconciliation File provides comprehensive mapping between platform data and exported billing information. Understanding the source of each field in the Platform UI enables accurate reconciliation, troubleshooting, and financial reporting. The file includes invoice details, Organization information, Subscription data, pricing calculations, and unique identifiers necessary for multi-tier distribution management.
By referencing this guide, users can locate the origin of each data point within the platform, verify accuracy, and maintain data integrity across billing cycles. The standardized terminology and field mappings ensure consistency across the platform and facilitate integration with external systems.
Related content
Was this article helpful?
Articles in this section
- Navigating the Invoices
- Invoice Statuses
- How can I see details of my Incoming Billings?
- How can I see details of my Outgoing Billings?
- How to Consolidate the Invoices?
- Incoming Billings in Customer view vs. Outgoing Billings in Seller view
- How can I see Outgoing Invoices in Customer view?
- Reconciliation File - UI Fields Mapping
- How to understand invoicing by contract?
- Invoice per order
Add comment
Please sign in to leave a comment.