How can I quickly review which sales lines from a Partially Reported file remain unreported?

A fully reported status means that all lines in a sales file have been reported in a Statement. However, if a file is partially reported, that means not all lines have been reported in at least one Statement.

The quickest way to view which lines remain unreported is by exporting the sales file after mappings are created by Curve. To do so, we'd go into the sales file in question, scroll down to the bottom of the page, and click on “Filter”. 

This will make all sales lines visible on our screen. We would then need to click on “Export”. As soon as the file is ready to be downloaded, we will receive a notification via email and on the platform.

The file received shows all mappings made by Curve. Please note that this is not the original sales file received from the source of the income.

Let’s take a look at the columns of this file:

• The first one displays the Curve ID assigned to each line.
• The second column shows the Curve ID assigned by Curve to the file.
• The Cat Type refers to the sale type (which can be either Release, Track, or Contract).
• The columns indicating an “original value” - such as the "Original Barcode" - would show the equivalent value as this was included in the original sales file.
• The "Mapped" fields would direct us to the catalogue item in Curve that a sale was mapped to.
• In a similar manner, we can review the rest of the fields until we get to the last four or five columns, which are the main indicators of whether a sales line has been reported or not in a Statement.

The columns "Reported Period IDs" or "Reported Period Names" would indicate in which Period a line has been reported. If these columns are blank, it means the sales line is Unreported. These are the ones that we would be focusing on in such a scenario.

The columns "Included Period IDs" or "Included Period Names" would show the Periods that these lines have been included in.

So, if a sales line has been included in a Period but not reported in one, the "Included" fields will be populated, while the "Reported" fields (i.e., "Reported Period IDs" and "Reported Period Names") would be blank.

This approach would be very helpful if we wanted to review individual Partially Reported Sales Files. For a thorough analysis, we would suggest downloading the Unreported Sales CSV from the Period, as well as creating a Fixed Report for Unreported Sales Lines on the Reports tab.

For more information , please refer to the Article: Resolving Unreported Sales & Unreported Costs.