The Intercompany Reconciliation report is used to identify unmatched or incorrectly matched intercompany transactions. This includes intercompany transactions that have not been paired with a corresponding transaction in another subsidiary, and paired transactions that have different amounts or currencies.
The Intercompany Reconciliation report has five sections and lists the mismatched intercompany transactions for:
- Unlinked Orders and Returns – intercompany transactions not paired with a corresponding intercompany transaction in another subsidiary. This section includes purchase orders, sales orders, return authorizations and vendor return authorizations.
- Mismatched Amount – paired intercompany transactions with amounts that do not match. This section includes purchase orders, sales orders, return authorizations, and vendor return authorizations.
- Mismatched Inventory Item Quantities – paired intercompany transactions with item quantities that do not match. This section includes only item quantities that do not match. Item rates on paired intercompany inventory orders are always the same. The Inventory Item Quantity columns identify the differences in quantities per item for the following:
- Item Fulfillment and Sales Invoice – the item quantity fulfilled on a sales order is different from the quantity billed on the sales invoice NetSuite creates the sales invoice from the sales order.
- Item Receipt and Vendor Bill – the item quantity received on a purchase order is different from the quantity on the vendor bill NetSuite creates the vendor bill from the purchase order.
- Item Receipt and Item Fulfillment – the item quantity fulfilled on a sales order is different from the quantity received for the paired purchase order
- Mismatched Billing – paired intercompany transactions with billed amounts that do not match. The amount billed (vendor bill) for the purchase order does not match the amount billed (invoice) for a sales order.
- Standalone Transactions – billing and payment transactions that are not associated with a sales order or purchase order
To view the Intercompany Reconciliation report, Navigate to Reports > Financial > Intercompany Reconciliation.
The Intercompany Reconciliation report displays the following columns:
- Purchasing Subsidiary
- Vendor
- Purchasing Trans – transaction number with drill down to source record
- Purchasing Trans Type – purchase order, return authorization, vendor bill, vendor credit
- Purchasing Trans Date
- Purchasing Trans Currency
- Purchasing Amount – amount is negative for reversed transactions such as return authorizations, credit memos, and refunds
- Purchasing Billed Amount
- Sales Subsidiary
- Customer
- Sales Trans – transaction number with drill down to transaction record
- Sales Trans Type – sales order, invoice, vendor return authorization, credit memo
- Sales Trans Date
- Sales Trans Currency
- Sales Amount – amount is negative for reversed transactions such as vendor return authorizations, bill credit
- Sales Amount Billed
