Skip to main content

Upload settlement

Accepted file types: xls, xlsx, csv, pdf, Max. file size: 10 MB.

Introduction

Welcome to our guide on how to fill out the statement template. This document will provide you with detailed instructions on how to accurately complete the template to ensure accurate reporting of your sales and royalties. Let’s get started!

You can download the template here

 

Standard Data

Customer ID / Customer: In this field, enter the name or identification of the customer associated with the statement. Please view email to see your customer ID, enter it here. If you don’t know, simply enter the customer’s name.

Period: Specify the period for which the statement is being generated. This can be a specific month, quarter, or any other relevant time period. Indicate the start and end dates clearly to avoid any confusion.

Currency: Specify the currency in which the statement is being presented. Enter the appropriate three-letter currency code (e.g., USD for United States Dollar, EUR for Euro).

 

 

Table Instructions

The table provided in the template allows you to itemize the relevant information about your sales and royalties. Fill out each column as follows:

#SKU / Item No: Enter the stock keeping unit (SKU) or item number associated with each product or item sold. This helps identify and track individual products in your inventory.

Description: Provide a brief description or name of the item sold. Include any pertinent details that will help identify the product.

Unit Price: Enter the price of each unit or item sold.

Quantity: Specify the number of units or items sold for each SKU or item number. This represents the quantity of each product sold during the specified period.

Royalty Rate (%): Enter the percentage royalty rate applicable to each product or item sold. This rate is usually pre-determined in your contractual agreement or royalty arrangement.

Total Royalty: Calculate the total royalty amount for each SKU or item by multiplying the unit price, quantity, and royalty rate (%). Enter the calculated total in this column.

Conclusion: Congratulations! You have successfully completed the statement template. By following these instructions, you can accurately report your sales and royalties, ensuring transparency and efficient record-keeping.

 

If you have any further questions or require assistance, please don’t hesitate to reach out to us at accounting@sayswho.dk.

Remember to save a copy of the completed template for your records and submit it according to our guidelines and deadlines.