{"id":14316,"date":"2017-08-22T10:24:14","date_gmt":"2017-08-22T10:24:14","guid":{"rendered":"https:\/\/www.schoolmate.eu\/en\/?post_type=tutorial&#038;p=14316"},"modified":"2026-01-11T11:35:13","modified_gmt":"2026-01-11T11:35:13","slug":"transfers-import-xml-file","status":"publish","type":"tutorial","link":"https:\/\/www.schoolmate.eu\/it\/tutorial\/transfers-import-xml-file\/","title":{"rendered":"Transfers Import &#8211; XML File"},"content":{"rendered":"<p>This feature allows you to upload your bank statements into your SchoolMate account and allocate students&#8217; payments to their SchoolMate account and issue and invoices automatically.<\/p>\n<p>[vc_message]<span style=\"color: #000000;\">When checking a bank account number in the transfer, the system looks at the students&#8217; card to find a match. The students&#8217; bank account numbers are here on their card:<\/span> <a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS7.png\"><img decoding=\"async\" class=\"aligncenter wp-image-14348 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS7.png\" alt=\"Bank account numbers\" width=\"767\" height=\"71\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">There are no bank account numbers held on parents&#8217; cards, but you can place their numbers on the student card.<\/span>[\/vc_message]<\/p>\n<h2><span style=\"font-size: 12pt;\">Uploading Bank Statements and Settings:<\/span><\/h2>\n<ol>\n<li>Go to Finance Module.<\/li>\n<li>Click &#8220;Transfer Import&#8221;.<\/li>\n<li>Click &#8220;Import Transfers&#8221;.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14318 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1.jpg\" alt=\"Bank Statement Settings\" width=\"1900\" height=\"600\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1.jpg 1900w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1-768x243.jpg 768w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1-1536x485.jpg 1536w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS1-1280x404.jpg 1280w\" sizes=\"(max-width: 1900px) 100vw, 1900px\" \/><\/a><\/p>\n<h2 class=\"modal-title\"><span style=\"font-size: 14pt;\"><label>Import bank transfers<\/label><\/span><\/h2>\n<p>The following page will open:<\/p>\n<h2 class=\"modal-title\"><span style=\"font-size: 12pt;\"><label>Import bank transfers &#8211;\u00a0<\/label>Basic Information:<\/span><\/h2>\n<ol>\n<li>When you click &#8220;Upload File&#8221; your computer files will open and you can select the bank statement file to upload.<\/li>\n<li>Theses are the files types that can be uploaded.<\/li>\n<li>If, for some reason, you bank&#8217;s file does not upload, your can download a default file from the system, transfer your data to it, Then save and reupload.<\/li>\n<li>The contains two bank account numbers which it can match payments with. Select &#8220;From account&#8221; as this is the account the money was sent to you from.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS2.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14323\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS2.jpg\" alt=\"Import bank transfers\" width=\"792\" height=\"361\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS2.jpg 1107w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS2-768x350.jpg 768w\" sizes=\"(max-width: 792px) 100vw, 792px\" \/><\/a><\/p>\n<h2 class=\"modal-title\"><span style=\"font-size: 12pt;\"><label>Import bank transfers &#8211; Settings<\/label>:<\/span><\/h2>\n<p>In this section we tell the system what to do with the payment when it is added to the student&#8217;s payment card.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS15.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14430 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS15.jpg\" alt=\"Import bank transfers - Settings\" width=\"1120\" height=\"299\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS15.jpg 1120w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS15-768x205.jpg 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Automatically create transactions.<\/li>\n<li>As most payments will be for courses chose this as the default.<\/li>\n<li>If you want to create invoices automatically for the payments that are added to the student&#8217;s card, tick this. If you want the invoices to be sent automatically to the student, tick this box in <strong><strong>Finance &#8211; Settings &#8211; Additional Options:<\/strong><\/strong><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS4.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14333 \" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS4.jpg\" alt=\"\" width=\"711\" height=\"39\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS4.jpg 784w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS4-768x42.jpg 768w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Students will also need to have consent given to receiving emails on their cards:<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS14-1.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14393\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS14-1.jpg\" alt=\"Email consents\" width=\"694\" height=\"101\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS14-1.jpg 893w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS14-1-768x112.jpg 768w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<p><span style=\"color: #ccffff;\">.<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4. Select the type of invoice and the numbering system that you would like to be created.<\/p>\n<p>After you upload your file, you will get a report about the status of the transfers. If there are any errors, hover over the &#8220;i&#8221; button for an explanation. Fix any errors on the file and reupload.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS5.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14338 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS5.jpg\" alt=\"error message\" width=\"1122\" height=\"238\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS5.jpg 1122w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS5-768x163.jpg 768w\" sizes=\"(max-width: 1122px) 100vw, 1122px\" \/><\/a><\/p>\n<p>When all the transfers are correct, click &#8220;Save&#8221;.<\/p>\n<h2><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS6.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14343 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS6.jpg\" alt=\"fix errors\" width=\"1108\" height=\"424\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS6.jpg 1108w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS6-768x294.jpg 768w\" sizes=\"(max-width: 1108px) 100vw, 1108px\" \/><\/a><span style=\"font-size: 12pt;\"><strong>Results of Importing Transfers:<\/strong><\/span><\/h2>\n<p>When you upload your file there are 3 possible statuses for the transfers: &#8220;Not Matched&#8221;, &#8220;Solve Manually&#8221; and &#8220;Auto&#8221;. These are used depending on whether the amount and bank account numbers match what is in the student&#8217;s information.<\/p>\n<p>The results of the upload will appear on the right-hand side:<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14358 size-full\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1.jpg\" alt=\"Results of Importing Transfers\" width=\"1898\" height=\"599\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1.jpg 1898w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1-768x242.jpg 768w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1-1536x485.jpg 1536w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS8-1-1280x404.jpg 1280w\" sizes=\"(max-width: 1898px) 100vw, 1898px\" \/><\/a><\/p>\n<p>Now we will look at how to deal with these different statuses.<\/p>\n<h2><span style=\"font-size: 12pt;\">Solve Manually:<\/span><\/h2>\n<p>This typically happens because, even thought the bank account is linked to a student, there might be a mixture of items that the transfer could be for.<\/p>\n<ol>\n<li>Click on &#8220;Cover Transaction&#8221; and see if there are any charges for books, fees etc., on the students card. Click the transaction listed if some or all of the payment is for this.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS9.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14363\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS9.jpg\" alt=\"Solve Manually\" width=\"568\" height=\"498\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS9.jpg 776w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS9-768x674.jpg 768w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/a><\/p>\n<p><span style=\"color: #ccffff;\">.\u00a0<\/span> \u00a0 \u00a0 2. You may need to add a transaction if none exists or there is still part of the transfer to allocate. Once you have done that you can create invoices if required.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS10.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14368\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS10.jpg\" alt=\"add transaction\" width=\"727\" height=\"391\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS10.jpg 1339w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS10-768x413.jpg 768w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS10-1280x688.jpg 1280w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/a><\/p>\n<h2><span style=\"font-size: 12pt;\">Not Matched:<\/span><\/h2>\n<p>In these cases the system has not found a student that matches the transfer details. In most cases it is because the bank account number is not on, or does not match, that on the student card.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS11.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14373\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS11.jpg\" alt=\"Not Matched\" width=\"566\" height=\"496\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS11.jpg 785w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS11-768x673.jpg 768w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p>If you click on &#8220;Assign account&#8221;, you can then chose a student to link to the payment. Once you have done that you can cover or add transactions as mentioned in Solve Manually above. You should also add the bank account number to the student&#8217;s card to make future payments easier.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS12.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14378\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS12.jpg\" alt=\"Assign account\" width=\"476\" height=\"353\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS12.jpg 803w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS12-768x569.jpg 768w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/a><\/p>\n<h2><span style=\"font-size: 12pt;\">Auto:<\/span><\/h2>\n<p>This is when the bank account matches and the system is able to clearly link the payment to the student&#8217;s payment card. Invoices will be created and sent automatically and marked as paid, depending on your settings &#8211; see &#8220;<strong>Import bank transfers &#8211; Settings<\/strong>&#8221; above.<\/p>\n<p><a href=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS13.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-14383\" src=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS13.jpg\" alt=\"Assign auto\" width=\"574\" height=\"494\" srcset=\"https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS13.jpg 781w, https:\/\/www.schoolmate.eu\/wp-content\/uploads\/2024\/08\/TRANS13-768x661.jpg 768w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<hr \/>\n<h3><strong><span style=\"font-size: 12pt;\">Related Tutorials<\/span><\/strong><\/h3>\n<p><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.schoolmate.eu\/en\/tutorial\/transfers-import-bank-feed\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">Transfers Import &#8211; Bank Feeds<\/span><\/a><\/span><\/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-14316","tutorial","type-tutorial","status-publish","hentry","tutorialcategories-payments-2","tutorialcategories-online-payments"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.schoolmate.eu\/it\/wp-json\/wp\/v2\/tutorial\/14316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schoolmate.eu\/it\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/www.schoolmate.eu\/it\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/www.schoolmate.eu\/it\/wp-json\/wp\/v2\/users\/4"}],"wp:attachment":[{"href":"https:\/\/www.schoolmate.eu\/it\/wp-json\/wp\/v2\/media?parent=14316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}