{"id":6411,"date":"2018-12-30T15:57:03","date_gmt":"2018-12-30T15:57:03","guid":{"rendered":"http:\/\/www.schoolmate.eu\/?post_type=tutorial&#038;p=6411"},"modified":"2024-03-18T13:21:25","modified_gmt":"2024-03-18T13:21:25","slug":"how-can-i-create-a-report-on-students-in-debt","status":"publish","type":"tutorial","link":"https:\/\/www.schoolmate.eu\/es\/tutorial\/how-can-i-create-a-report-on-students-in-debt\/","title":{"rendered":"How can I create a report on students in debt?"},"content":{"rendered":"<p>In the Reports Module you can check whether students are in arrears with payments and\u00a0you can create a student debt report.<\/p>\n<h2><span style=\"font-size: 12pt;\"><strong>How to generate a student debt report:<\/strong><\/span><\/h2>\n<ol>\n<li>Go to the Reports Module.<\/li>\n<li>Click Select\u00a0report.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1645.png\"><img decoding=\"async\" class=\"aligncenter wp-image-6412 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1645.png\" alt=\"How to generate a student debt report\" width=\"1340\" height=\"481\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1645.png 1340w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1645-768x276.png 768w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1645-1280x459.png 1280w\" sizes=\"(max-width: 1340px) 100vw, 1340px\" \/><\/a><\/p>\n<p>From the list of reports that appears select \u00ab<strong>Students \u2013 payment plan in groups\u00bb<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1649.png\"><img decoding=\"async\" class=\"aligncenter wp-image-6413 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2018-12-30_1649.png\" alt=\"Students \u2013 payment plan in groups\" width=\"645\" height=\"219\" \/><\/a><\/p>\n<p>Once the Report is displayed we need to apply filters which are at the bottom of the page:<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1328.png\"><img decoding=\"async\" class=\"aligncenter wp-image-8180 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1328.png\" alt=\"Filters\" width=\"1034\" height=\"121\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1328.png 1034w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1328-768x90.png 768w\" sizes=\"(max-width: 1034px) 100vw, 1034px\" \/><\/a><\/p>\n<p>This is the filter control:<\/p>\n<ol>\n<li>This will give all past Payment Due items.<\/li>\n<li>This second one makes it between the two dates.<\/li>\n<li>\u00abLeft\u00bb, \u00abGreater\u00bb the \u00ab0\u00bb will exclude those students who have paid the full installment and the report will show only those who have not paid.<\/li>\n<li>Click Search and Close to view the report.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1332999.png\"><img decoding=\"async\" class=\"aligncenter wp-image-8183 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1332999.png\" alt=\"Add search fields\" width=\"652\" height=\"293\" \/><\/a><\/p>\n<h2><span style=\"font-size: 12pt;\">Create a Debtors Report Template:<\/span><\/h2>\n<p>Using the same logic as above you could create a report on debtors over a certain number of days late, rather than based on dates.<\/p>\n<ol>\n<li>As the system records the number of days late in payment as a negative, we have to put \u00abLess or equal\u00bb.<\/li>\n<li>This excludes those who have paid.<\/li>\n<li>After clicking \u00abSave template\u00bb you will be asked to give it a name.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_135099.png\"><img decoding=\"async\" class=\"aligncenter wp-image-8189 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_135099.png\" alt=\"debtors template\" width=\"651\" height=\"212\" \/><\/a><\/p>\n<p>Here you can see the template saved in Reports:<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1358.png\"><img decoding=\"async\" class=\"aligncenter wp-image-8192 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2018\/12\/2020-01-02_1358.png\" alt=\"Template\" width=\"647\" height=\"207\" \/><\/a><\/p>\n<p>[vc_message color=\u00bbsuccess\u00bb message_box_style=\u00bbsolid-icon\u00bb message_box_color=\u00bbsuccess\u00bb icon_fontawesome=\u00bbfa fa-check\u00bb]<span style=\"color: #333333;\">Remember there is also a debtors list in the <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.schoolmate.eu\/en\/tutorial\/debtors\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">Finance Module<\/span><\/a><\/span> where you can send email reminders.<\/span>[\/vc_message]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":0,"template":"","meta":{"_acf_changed":false,"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":""},"class_list":["post-6411","tutorial","type-tutorial","status-publish","hentry","tutorialcategories-finance-faqs-2"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.schoolmate.eu\/es\/wp-json\/wp\/v2\/tutorial\/6411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schoolmate.eu\/es\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/www.schoolmate.eu\/es\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/www.schoolmate.eu\/es\/wp-json\/wp\/v2\/users\/4"}],"wp:attachment":[{"href":"https:\/\/www.schoolmate.eu\/es\/wp-json\/wp\/v2\/media?parent=6411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}