Finding Marketplace Transactions and Revenue Reports
Finding Marketplace Transactions and Revenue Reports
How to Pull Registration or Sales Reports from Marketplace
First, you must have access to Marketplace, to add access contact the Business Services Systems Manager.
- Access Touchnet/Marketplace, go to Applications > Marketplace
- On the Left Menu go to Marketplace Reports > Stores > your store
- Choose the type of report (usually By Product) > enter the range of dates you are looking for orders from > View
- Once the results appear > click on the Product Name to see the detail
- Choose Export to CSV to download the report.
How to Categorize “Product” Expenses
When reconciling or categorizing expenses from the Marketplace store (i.e. invoice from the t-shirt supplier, cost of tickets to an event, etc.), use the SAME FOAPAL (budget code) that is tied to the Marketplace sales, BUT select an appropriate ACCOUNT CODE from the Expense Codes guide. If you are unsure of the FOAPAL that this connected to the Marketplace store, contact Business Services Systems Manager for any questions.
Example 1:
If the Marketplace FOAPAL for REVENUE is 100000-720040-717090-99, then the EXPENSE code for t-shirts would be 100000-720040-700002-65
…where Revenue is 100000 (Operating Budget) – 720040 is the department, 717090 is the account code for Marketplace Revenue used when the FUND is 100000, 99 is the program code
AND
Expense is 100000 – (Operating Budget) – 720040 is department, 700002 is the account code for clothing expenses, and 65 is the department’s program code.
Example 2:
If the Marketplace FOAPAL for REVENUE is 258222-565860-536102-99, then the EXPENSE code for sweatshirts sold would be 258222-565860-700002-57
…where Revenue is 258222 (Restricted Fund) – 565860 is the department, 536102 is the account code for Miscellaneous income (an example of an account code that can be used when the FUND is NOT 100000 – see Revenue Account Codes guide), 99 is the program code
AND
Expense is 258222 (Restricted Fund) – 565860 is the department, 700002 is the account code for clothing expenses, and 57 is the department’s program code.
Finding Marketplace Revenue in Finance Reports via Argos
Depending on the FOAPAL (budget code) that is tied to the Marketplace sales, you will be able to view the transactions collected via Marketplace if you have access to Finance Reports via Argos
If the Marketplace FOAPAL uses FUND 100000, the Account code will be 717090 (Account code for Marketplace Revenue)
- Transactions (Revenue) can be found in Finance Reports via Argos:
- Activity Code Report by Fiscal Year
- Budget and Transaction Expense by Fiscal year
- Transaction by Date Range
If the Marketplace FOAPAL uses a FUND OTHER than 100000, the Account code will vary depending on what the revenue is collected for (i.e. tickets, clothing, etc.).
- Transactions (Revenue) can be found in Finance Reports via Argos:
- Activity Code Report by Fiscal Year
- Transaction by Date Range
If the Marketplace FOAPAL has a Location Code of 9999 (indicating non-spendable) OR the FOAPAL is associated with MCSG (Macalester College Student Government)
- Transactions (Revenue) can be found in Finance Reports via Argos:
- Activity Code Report by Fiscal Year
- Transaction by Date Range
Ask us a question
Feel free to get in contact with us. We are happy to assist you!