Sales records can be entered manually or imported into our royalty software. Most clients import sales from Microsoft Excel spreadsheets. You can also import sales from comma delimited text files or Microsoft Access table and queries.
Sales records are the foundation of royalty calculations. Royalties can be calculated on revenue or quantity sold. Revenue based calculations can be based on full retail value, net sale amount, net revenue, gross margin or net profits.
Sales related fields; such as sales type or territory (on the more tab), can impact royalty calculations.
Detailed sales records allow facilitates sales analysis that allows for better decision making.
Importing separate numbers for sales and returns allows the sales analysis report to calculate the returns rate by backlist/front list, currency, customer, edition, format, product line, sales channel, sales type, title or territory.
Importing the customer name allows for analysis of sales by customer. You can report on purchases by customer or see all customers that purchased a title. You can see whether your customer base is growing or shrinking.
Importing the territory allows you to see sales by country.
Importing the invoice number allows you to drill down to the source invoice. You can calculate the average invoice value and average number of lines per invoice.
Excel savy users can perform powerful sales analysis with Pivot Tables or Excel’s PowerPivot add-in.