{"id":7272,"date":"2023-02-27T11:25:38","date_gmt":"2023-02-27T11:25:38","guid":{"rendered":"https:\/\/ccbill.com\/doc\/?p=7272"},"modified":"2024-05-29T07:36:46","modified_gmt":"2024-05-29T07:36:46","slug":"lookup-report","status":"publish","type":"post","link":"https:\/\/ccbill.com\/doc\/lookup-report","title":{"rendered":"Lookup Report"},"content":{"rendered":"\n<p>The Lookup Report is used to search for customer subscription details using website data or the consumer\u2019s personal or payment information.<\/p>\n\n\n\n<p>To access the Lookup report:<\/p>\n\n\n\n<p>1. Log in to the <a href=\"https:\/\/admin.ccbill.com\/megamenus\/ccbillHome.html\" target=\"_blank\" rel=\"noreferrer noopener\">Admin Portal<\/a>.<\/p>\n\n\n\n<p>2. Click <strong>Reports<\/strong>.<\/p>\n\n\n\n<p>3. Select <strong>Lookup<\/strong>.<\/p>\n\n\n\n<p>4. Click <strong>Open Report<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"750\" height=\"619\" src=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg\" alt=\"Steps to access the Lookup report in the CCBill Admin.\" class=\"wp-image-7276\" srcset=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg 750w, https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill-300x248.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<p>Enter consumer information in the available fields. Enter any of the search parameters to lookup.<\/p>\n\n\n\n<p>5. (Optional) The <strong>Lookup Customers From <\/strong>section allows you to search using any of the following criteria:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Billing Type dropdown menu.<\/strong> Select a billing type for the declines you wish to see.<\/li>\n\n\n\n<li><strong>Days to look back<\/strong>. Enter the number of days prior to the current date for which you want to conduct your search.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"750\" height=\"502\" src=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/lookup-cutomers-from.jpg\" alt=\"The Lookup Customers From section\" class=\"wp-image-7277\" srcset=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/lookup-cutomers-from.jpg 750w, https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/lookup-cutomers-from-300x201.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<p>Click <strong>Lookup<\/strong> if you do not want to use additional parameters for the search.<\/p>\n\n\n\n<p>6. (Optional) The <strong>Client Information<\/strong> section allows merchants to search declines by subaccount and affiliate number. Merchants can enter any or all parameters for their search.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Subaccount. <\/strong>Use the dropdown menu to select a specific subaccount.<\/li>\n\n\n\n<li><strong>Affiliate<\/strong>. Enter the account number of the referring affiliate.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"750\" height=\"502\" src=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/client-information-lookup.jpg\" alt=\"The Client Information section \" class=\"wp-image-7274\" srcset=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/client-information-lookup.jpg 750w, https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/client-information-lookup-300x201.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<p>Click <strong>Lookup<\/strong> if you do not want to use additional parameters for the search.<\/p>\n\n\n\n<p>7. (Optional) Merchants can search customer transactions using the customer\u2019s <strong>Payment Information<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Subscription<\/strong>. Enter a subscription ID number.<\/li>\n\n\n\n<li><strong>BIN (first six digits \/ Last four. <\/strong>The first six and last four digits of the customer\u2019s card number.<\/li>\n\n\n\n<li><strong>Bank Routing Number<\/strong>. Enter the bank routing number (check payments only).<\/li>\n\n\n\n<li><strong>Bank Account Number<\/strong>. Enter the bank account number (check payments only).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"750\" height=\"545\" src=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/payment-information-customer-lookup2.jpg\" alt=\"Enter customer payment information to look up transaction.\" class=\"wp-image-8911\" srcset=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/payment-information-customer-lookup2.jpg 750w, https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/payment-information-customer-lookup2-300x218.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<p>Click <strong>Lookup<\/strong> if you do not want to use additional parameters for the search.<\/p>\n\n\n\n<p>8. (Optional) Merchants can search declined transactions using information collected from the customer in the <strong>User Information<\/strong> section:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>First Name<\/strong>. Enter the user's first name.<\/li>\n\n\n\n<li><strong>Last Name<\/strong>. Enter the user's last name.<\/li>\n\n\n\n<li><strong>Zip code.<\/strong> Enter the user's Zip code address.<\/li>\n\n\n\n<li><strong>Email<\/strong>. Enter the user's email address.<\/li>\n\n\n\n<li><strong>Username.<\/strong> Enter the user's Username.<\/li>\n\n\n\n<li><strong>IP Address<\/strong>. Enter the user's IP address.<\/li>\n\n\n\n<li><strong>Phone #. <\/strong>Enter the user's phone number.<\/li>\n\n\n\n<li><strong>Confirmation. <\/strong>Enter the user's order confirmation number.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"750\" height=\"668\" src=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-information-lookup-personal.jpg\" alt=\"Search declined transactions in Lookup Report.\" class=\"wp-image-7275\" srcset=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-information-lookup-personal.jpg 750w, https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-information-lookup-personal-300x267.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<p>9. The consumer information, once located, will display as a blue hyperlinked subscription number. You can click this hyperlink to access functions such as refunds, voids, subscription cancel, and username\/password updates (for User Management System Users).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How do I refund or void a&nbsp;transaction?<\/h2>\n\n\n\n<p>Once you locate the subscription using the Lookup report:<\/p>\n\n\n\n<p>1. Click the hyperlinked subscription ID.<\/p>\n\n\n\n<p>2. Click&nbsp;<strong>Refund\/Void Transaction<\/strong>&nbsp;at the bottom right of the subscription page.<\/p>\n\n\n\n<p>3. Enter a reason for the cancellation.<\/p>\n\n\n\n<p>4. Click&nbsp;<strong>Submit<\/strong>.<\/p>\n\n\n<div class=\"notice-warning\">\n<div class=\"notice-text\"><p>The refund process may take several days. The consumer can expect the funds to be visible in their account in 7-10 business days.<\/p>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-white-color has-alpha-channel-opacity has-white-background-color has-background\"\/>\n","protected":false},"excerpt":{"rendered":"<p>This guide explains how to search CCBill's system for individual transactions using the customer's personal and payment information.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"kk_blocks_editor_width":"","_kiokenblocks_attr":"","_kiokenblocks_dimensions":"","footnotes":""},"categories":[46],"tags":[],"class_list":["post-7272","post","type-post","status-publish","format-standard","hentry","category-admin-portal"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Lookup Report - CCBill Doc<\/title>\n<meta name=\"description\" content=\"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ccbill.com\/doc\/lookup-report\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lookup Report - CCBill Doc\" \/>\n<meta property=\"og:description\" content=\"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ccbill.com\/doc\/lookup-report\" \/>\n<meta property=\"og:site_name\" content=\"CCBill Doc\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-27T11:25:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-29T07:36:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg\" \/>\n<meta name=\"author\" content=\"Vladimir Kaplarevic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vladimir Kaplarevic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ccbill.com\/doc\/lookup-report\",\"url\":\"https:\/\/ccbill.com\/doc\/lookup-report\",\"name\":\"Lookup Report - CCBill Doc\",\"isPartOf\":{\"@id\":\"https:\/\/ccbill.com\/doc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg\",\"datePublished\":\"2023-02-27T11:25:38+00:00\",\"dateModified\":\"2024-05-29T07:36:46+00:00\",\"author\":{\"@id\":\"https:\/\/ccbill.com\/doc\/#\/schema\/person\/2cc5b50e34ee63ed498ac333a25840ad\"},\"description\":\"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ccbill.com\/doc\/lookup-report\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage\",\"url\":\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg\",\"contentUrl\":\"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg\",\"width\":750,\"height\":619,\"caption\":\"Steps to access the Lookup report in the CCBill Admin.\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ccbill.com\/doc\/#website\",\"url\":\"https:\/\/ccbill.com\/doc\/\",\"name\":\"CCBill Doc\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ccbill.com\/doc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ccbill.com\/doc\/#\/schema\/person\/2cc5b50e34ee63ed498ac333a25840ad\",\"name\":\"Vladimir Kaplarevic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ccbill.com\/doc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d4609e99e6aecc69ce049e18d45f033?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d4609e99e6aecc69ce049e18d45f033?s=96&d=mm&r=g\",\"caption\":\"Vladimir Kaplarevic\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lookup Report - CCBill Doc","description":"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ccbill.com\/doc\/lookup-report","og_locale":"en_US","og_type":"article","og_title":"Lookup Report - CCBill Doc","og_description":"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.","og_url":"https:\/\/ccbill.com\/doc\/lookup-report","og_site_name":"CCBill Doc","article_published_time":"2023-02-27T11:25:38+00:00","article_modified_time":"2024-05-29T07:36:46+00:00","og_image":[{"url":"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg","type":"","width":"","height":""}],"author":"Vladimir Kaplarevic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vladimir Kaplarevic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ccbill.com\/doc\/lookup-report","url":"https:\/\/ccbill.com\/doc\/lookup-report","name":"Lookup Report - CCBill Doc","isPartOf":{"@id":"https:\/\/ccbill.com\/doc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage"},"image":{"@id":"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage"},"thumbnailUrl":"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg","datePublished":"2023-02-27T11:25:38+00:00","dateModified":"2024-05-29T07:36:46+00:00","author":{"@id":"https:\/\/ccbill.com\/doc\/#\/schema\/person\/2cc5b50e34ee63ed498ac333a25840ad"},"description":"Use the Lookup report to search for customer subscription details consumer\u2019s personal or payment information.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ccbill.com\/doc\/lookup-report"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ccbill.com\/doc\/lookup-report#primaryimage","url":"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg","contentUrl":"https:\/\/ccbill.com\/doc\/wp-content\/uploads\/2023\/02\/customer-lookup-ccbill.jpg","width":750,"height":619,"caption":"Steps to access the Lookup report in the CCBill Admin."},{"@type":"WebSite","@id":"https:\/\/ccbill.com\/doc\/#website","url":"https:\/\/ccbill.com\/doc\/","name":"CCBill Doc","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ccbill.com\/doc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ccbill.com\/doc\/#\/schema\/person\/2cc5b50e34ee63ed498ac333a25840ad","name":"Vladimir Kaplarevic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ccbill.com\/doc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d4609e99e6aecc69ce049e18d45f033?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d4609e99e6aecc69ce049e18d45f033?s=96&d=mm&r=g","caption":"Vladimir Kaplarevic"}}]}},"_links":{"self":[{"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/posts\/7272"}],"collection":[{"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/comments?post=7272"}],"version-history":[{"count":4,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/posts\/7272\/revisions"}],"predecessor-version":[{"id":8912,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/posts\/7272\/revisions\/8912"}],"wp:attachment":[{"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/media?parent=7272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/categories?post=7272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccbill.com\/doc\/wp-json\/wp\/v2\/tags?post=7272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}