Does your royalty system sales match your accounting system sales?
- Were sales for all distributors and retailers imported for every month?
- Did you accidently duplicate a sales import?
- Were the correct exchange rates used for foreign currency sales.
EasyRoyalties has tools that will help you audit your imported sales transactions?
Tool 1. Sales Summary Report
The first tool is the Sales Summary Report (Reporting > Sale summary). This report summarizes sales revenue by month and for the year to date. If the report sales amounts don’t match the total in your accounting records use the sales analysis report to find out why.
Tool 2. Sales Analysis Report
If the sales summary report numbers do not tie use the sale analysis report (Reporting > Sales analysis) to see where the error is occurring? Were sales from a distributor omitted or imported twice? Were the correct exchange rates used foreign sales currency transactions?
The sales analysis report shows sales and returns for the specified period.
This report can group sales by:
- Marketing Class
- Product Line
- and several more groupings
You can filter by 12 reporting options such as; sales only for a specified sales import batch, publication date range, title, sales date range.
Grouping the report by customer shows you the total sales dollars and quantity for each customer’s (Amazon.com, Amazon KDP, Audible, Apple, Barnes & Nobles, Baker & Taylor, Google, Ingram) sales import file. Compare the customer’s total to your distributor’s report to validate the sales numbers.
Tool 3. Sales Detail Report
The Sales details report (Reporting > Sales details) lists all the sales records and the currency for the specified search criteria.
Tool 4. Sales Record List View
From the sales record list view (Data & functions > Sales) you can see all sales records. The view can be filtered to show only records that meet a specified criteria. You can add or delete columns to show additional information about each sales. The record list can be sorted in ascending or descending order.
A user with foreign sales can add a column to see the exchange rates used. If you sort the list in descending order records with a highest exchange rate will be at the top.
Clients that pay royalties based on MSRP can add a column to see the MSRP applied to each sales record. This will tell you if you omitted entering an MSRP price in the product record.
Tool 5. Sales Record Export
Our royalty software allows the user to export sales records to an Excel file for detailed analysis.