{"id":425,"date":"2023-11-06T20:21:59","date_gmt":"2023-11-06T20:21:59","guid":{"rendered":"https:\/\/www.macalester.edu\/160-accepting-payments\/?page_id=425"},"modified":"2024-03-08T21:04:43","modified_gmt":"2024-03-08T21:04:43","slug":"reports","status":"publish","type":"page","link":"https:\/\/www.macalester.edu\/accepting-payments\/reports\/","title":{"rendered":"Finding Marketplace Transactions and Revenue Reports"},"content":{"rendered":"<section class=\"link-group block-container\" >\n            <div class=\"link-group__heading-row\">\n            <div class=\"link-group__heading-container\">\n                <h2 class=\"base-lockup__heading\">Finding Marketplace Transactions and Revenue Reports<\/h2>\n            <\/div>\n        <\/div>\n        <div class=\"link-group__links-row\">\n        <ul class=\"link-group__link link-group__link--\">\n        \t                <li class=\"link-group__link-item\">\n                    <a class=\"base-cta-featured\" href=\"#pull\" target=\"_self\">\n\t\t\t\t\t    Jump to How to Pull Registration or Sales Reports from Markerplace\n\t\t\t\t\t    <svg aria-hidden=\"true\" class=\"base-symbol base-cta-featured__arrow\" viewbox=\"0 0 24 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t    <use xlink:href=\"\/wp-content\/themes\/macalester-2020\/dist\/svgs\/symbol-arrow.svg#icon\"\/>\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t<\/a>\n                <\/li>\n                            <li class=\"link-group__link-item\">\n                    <a class=\"base-cta-featured\" href=\"#categorize\" target=\"_self\">\n\t\t\t\t\t    Jump to How to Categorize &#8220;Product&#8221; Expenses\n\t\t\t\t\t    <svg aria-hidden=\"true\" class=\"base-symbol base-cta-featured__arrow\" viewbox=\"0 0 24 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t    <use xlink:href=\"\/wp-content\/themes\/macalester-2020\/dist\/svgs\/symbol-arrow.svg#icon\"\/>\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t<\/a>\n                <\/li>\n                            <li class=\"link-group__link-item\">\n                    <a class=\"base-cta-featured\" href=\"#argos\" target=\"_self\">\n\t\t\t\t\t    Jump to Finding Marketplace Revenue in Finance Reports via Argos\n\t\t\t\t\t    <svg aria-hidden=\"true\" class=\"base-symbol base-cta-featured__arrow\" viewbox=\"0 0 24 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t    <use xlink:href=\"\/wp-content\/themes\/macalester-2020\/dist\/svgs\/symbol-arrow.svg#icon\"\/>\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t<\/a>\n                <\/li>\n                            <li class=\"link-group__link-item\">\n                    <a class=\"base-cta-featured\" href=\"#questions\" target=\"_self\">\n\t\t\t\t\t    Questions\n\t\t\t\t\t    <svg aria-hidden=\"true\" class=\"base-symbol base-cta-featured__arrow\" viewbox=\"0 0 24 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t    <use xlink:href=\"\/wp-content\/themes\/macalester-2020\/dist\/svgs\/symbol-arrow.svg#icon\"\/>\n\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t<\/a>\n                <\/li>\n                    <\/ul>\n    <\/div>\n<\/section>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"pull\">How to Pull <strong>Registration<\/strong> or Sales Reports from Marketplace<\/h2>\n\n\n\n<p>First, you must have access to Marketplace,\u00a0 to add access contact the Business Services Systems Manager.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Access <a href=\"https:\/\/secure.touchnet.com\/ucommercecentral\">Touchnet\/Marketplace<\/a>, go to <strong>Applications &gt; Marketplace<\/strong><\/li>\n\n\n\n<li>On the Left Menu go to<strong>&nbsp;Marketplace Reports &gt; Stores &gt; your store<\/strong><\/li>\n\n\n\n<li>Choose the type of&nbsp;<strong>report&nbsp;<\/strong>(usually By Product) &gt; enter the&nbsp;<strong>range of dates&nbsp;<\/strong>you are looking for orders from &gt;&nbsp;<strong>View<\/strong><\/li>\n\n\n\n<li>Once the results appear &gt; click&nbsp;on the&nbsp;<strong>Product Name&nbsp;<\/strong>to see the detail<\/li>\n\n\n\n<li>Choose<strong>&nbsp;Export to CSV<\/strong>&nbsp;to download the report.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"categorize\">How to Categorize &#8220;Product&#8221; Expenses<\/h2>\n\n\n\n<p>When reconciling or categorizing expenses from the Marketplace store (i.e. invoice from the t-shirt supplier,\u00a0 cost of tickets to an event, etc.), use the <strong>SAME FOAPAL<\/strong> (budget code) that is tied to the Marketplace sales, <strong>BUT<\/strong> select an appropriate <strong>ACCOUNT<\/strong> <strong>CODE<\/strong> from the\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1to-zXepy6tbpJlKE8iZs2LmDor43oP8OO8eIQrf9ny4\/view\">Expense Codes guide<\/a>.\u00a0 If you are unsure of the FOAPAL that this connected to the Marketplace store, contact\u00a0<a href=\"https:\/\/www.macalester.edu\/businessservices\/staff\/#BusinessServicesSystemsManager\">Business Services Systems Manager<\/a>\u00a0for any questions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 1:<\/h3>\n\n\n\n<p>If the Marketplace FOAPAL for REVENUE is 100000-720040-717090-99, then the EXPENSE code for t-shirts would be 100000-720040-700002-65<\/p>\n\n\n\n<p>&#8230;where Revenue is 100000 (Operating Budget) &#8211; 720040 is the department,&nbsp; 717090 is the account code for Marketplace Revenue used when the FUND is 100000,&nbsp; 99 is the program code<\/p>\n\n\n\n<p>AND<\/p>\n\n\n\n<p>Expense is 100000 &#8211; (Operating Budget) &#8211; 720040 is department,&nbsp; 700002 is the account code for clothing expenses, and 65 is the department&#8217;s program code.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 2:<\/h3>\n\n\n\n<p>If the Marketplace FOAPAL for REVENUE is 258222-565860-536102-99, then the EXPENSE code for sweatshirts sold would be 258222-565860-700002-57<\/p>\n\n\n\n<p>&#8230;where Revenue is 258222 (Restricted Fund) &#8211; 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 &#8211; see <a href=\"https:\/\/docs.google.com\/document\/d\/1Plk7EMRkS4J6CY3PrK9keGQ34qwjVYAEnEP0JhDtT6o\/view\">Revenue Account Codes guide<\/a>),&nbsp; 99 is the program code<\/p>\n\n\n\n<p>AND<\/p>\n\n\n\n<p>Expense is 258222 (Restricted Fund) &#8211; 565860 is the department,&nbsp; 700002 is the account code for clothing expenses, and 57 is the department&#8217;s program code.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"argos\">Finding Marketplace Revenue in Finance Reports via Argos<\/h2>\n\n\n\n<p>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&nbsp;<a href=\"https:\/\/argos.macalester.edu\/argos\/awv\/\">Finance Reports via Argos<\/a><\/p>\n\n\n\n<p>If the Marketplace FOAPAL uses&nbsp;<strong>FUND 100000<\/strong>, the Account code will be 717090 (Account code for Marketplace Revenue)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transactions (Revenue) can be found in Finance Reports via Argos:\n<ul class=\"wp-block-list\">\n<li>Activity Code Report by Fiscal Year<\/li>\n\n\n\n<li>Budget and Transaction Expense by Fiscal year<\/li>\n\n\n\n<li>Transaction by Date Range<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>If the Marketplace FOAPAL uses a&nbsp;<strong>FUND OTHER than 100000<\/strong>, the Account code will vary depending on what the revenue is collected for (i.e. tickets, clothing, etc.).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transactions (Revenue) can be found in Finance Reports via Argos:\n<ul class=\"wp-block-list\">\n<li>Activity Code Report by Fiscal Year<\/li>\n\n\n\n<li>Transaction by Date Range<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>If the Marketplace FOAPAL has a Location Code of 9999 (indicating non-spendable) OR the FOAPAL is associated with MCSG (ÈÕº«¾«Æ· Student Government)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transactions (Revenue) can be found in Finance Reports via Argos:\n<ul class=\"wp-block-list\">\n<li>Activity Code Report by Fiscal Year<\/li>\n\n\n\n<li>Transaction by Date Range<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<section class=\"callout-resource block-container callout-resource--inner\" id=\"questions\">\n    <div class=\"callout-resource__inner\">\n        <div class=\"callout-resource__lockup-column\">\n            <div class=\"callout-resource__lockup\">\n                <div class=\"base-lockup\">\n\t\t    \t\t\t<span class=\"base-lockup__label\">Need more help?<\/span>\n\t\t    \t\t    \t\t\t<h2 class=\"base-lockup__heading\">Ask us a question<\/h2>\n\t\t    \t\t    \t\t\t<p class=\"base-lockup__copy\">Feel free to get in contact with us. We are happy to assist you!<\/p>\n\t\t                        \t\t<\/div>\n            <\/div>\n        <\/div>\n        <div class=\"callout-resource__content-column\">\n            <div class=\"callout-resource__contact\">\n                <span class=\"callout-resource__contact-header\">Contact<\/span>\n                <address class=\"callout-resource__contact-text\">\n                    <span>Business Services Systems Manager<\/span><br>\n                    2nd floor, 77 Macalester\n                    \t\t                        \t<br>651-696-6696\n                                        \t\t    \t\t\t<br><a href=\"mailto:abaxter@macalester.edu\">abaxter@macalester.edu<\/a>\n\t\t    \t\t                    <\/address>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>How to Pull Registration or Sales Reports from Marketplace First, you must have access to Marketplace,\u00a0 to add access contact the Business Services Systems Manager. How to Categorize &#8220;Product&#8221; Expenses When reconciling or categorizing expenses from the Marketplace store (i.e. invoice from the t-shirt supplier,\u00a0 cost of tickets to an event, etc.), use the SAME [&hellip;]<\/p>","protected":false},"author":44,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-425","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/pages\/425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/comments?post=425"}],"version-history":[{"count":25,"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/pages\/425\/revisions"}],"predecessor-version":[{"id":553,"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/pages\/425\/revisions\/553"}],"wp:attachment":[{"href":"https:\/\/www.macalester.edu\/accepting-payments\/wp-json\/wp\/v2\/media?parent=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}