The Orchard
How to get the data
Distribution Income:
- Log in to The Orchard
- Navigate to Accounting -> Statements and click Request Report for the desired period. Be sure to leave the default settings as shown below - Report Type: Full Report, File Type: Download in .xls format, Number Format: Download in US format.
- The Orchard will send a notification email when your statement(s) are ready to view. Navigate back to Statements and click View Requested
- Download the .Zip
Publishing Income:
- Log in to The Orchard
- Navigate to Accounting -> Statements and click View for the desired period
- Click Get download link then Download next to the file name 'publishing_statement_[MONTH]_[YYYY]
- Statements should download in .xlxs format
Expenses:
Expense transactions aren't included in reports available from the Statements tab in the Orchard Workstation. To export expense reporting from the Workstation, do the following:
- Navigate to Accounting -> View and select the date range for the desired period
- Scroll to the bottom of the page to the Expenses Breakdown module
- Choose View By Expense as shown below:
- Click Export View and choose Download.xls
Orchard data is on a two month pay lag; e.g. if you're looking for paid timestamp in February, download December data.
In instances where The Orchard is handling third-party publishing deductions on your behalf - these publishing deductions are included in your monthly statements and brought in by our importer as separate transactions.
Importing into IC:
- In IC, navigate to Royalties -> Data Imports.
- To Import:
- Distribution income, select the Orchard (Zip) importer from the dropdown menu
- Publishing income, select the Orchard Publishing importer from the dropdown menu
- Expenses, select the Orchard (Expense) importer from the dropdown menu
- Choose the desired file and click "Import"
Please note - if you are importing Orchard data in EU format (example: 10.000,50 USD), European Formatting must be enabled by clicking the checkbox in the Importer Settings (Royalties -> Data Imports -> Importers -> (Orchard Importer) -> Settings) as shown below: