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:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us