Skip to main content

Set Up a Guardian Documents Import File Using iSAMS Fees Billing

Prepare the ZIP and XLSX files from Fees Billing, structure the ZIP correctly,and approve the import so guardians can access the documents.

Written by Cristina Gruita

This article explains how to prepare a guardian documents import using the Fees Billing ZIP file and the Custom Invoice Reconciliation Report.

It covers where to download the files, the required ZIP structure, how PDF filenames are matched to guardians and students, and what you must approve after import.

πŸ“ŒNote: The ZIP file must not be encrypted or password protected. Only PDF files are supported in the ZIP file.

Set Up a Guardian Documents Import File Using Fees Billing

Download the Fees Billing ZIP File

  1. In Fees Billing, go to the Invoicing tab.

  2. Depending on your version, click Invoice Publishing or Document Generation.

  3. Select the required cycle and invoice run.

  4. Once the run has been generated, download the ZIP file.

Download the Custom Invoice Reconciliation Report

  1. In Fees Billing, go to the Reports tab.

  2. Click Custom Invoice Reconciliation.

  3. Select the required fee billing cycle.

  4. For charges, select Post Invoice.

  5. Click View Report.

  6. Click the save icon, then export the report as Excel.

The import process is designed to work with the ZIP file and XLSX file downloaded from Fees Billing.


Prepare the ZIP File Structure

  1. Open the ZIP file you downloaded from Fees Billing.

  2. Check that the ZIP file contains no folders.

  3. Make sure all PDF files sit in the root of the ZIP file.

  4. Make sure the ZIP file contains one or more PDF files.

  5. Make sure the ZIP file contains only PDF files.

πŸ“Œ Note: The ZIP file must not contain more than one PDF for the same Guardian and Student combination.


Understand How Guardian Document Groups Are Created

The system uses the filename of each PDF in the ZIP file to decide which Guardian Document Group the file should go into.

Guardian Document Group names are created from the invoice document run number found in the PDF filename.

If a document matches an existing Guardian Document Group, it is added to that group automatically.

If a document does not match an existing group, a new Guardian Document Group is created automatically.

πŸ“Œ Note: If there are multiple PDFs with the same account code and the same students, only one of those documents is uploaded. Guardian Document Groups only support one document per Guardian/Student combination.


Understand How Filenames Are Matched

The system reads the PDF filename to identify:

  • The guardian account code.

  • The invoice number.

It then uses the Custom Invoice Reconciliation Report to identify which student or students the invoice relates to.

Standard invoice filename

Example:

invoiceDocument_run-23_inv-50005_acc-ABC001.pdf

In this case:

  1. The system matches the account code to a guardian record.

  2. The system uses the invoice number and the account code to look up the student or students in the Custom Invoice Reconciliation Report.

Copy invoice filename

Example:

invoiceDocument_run-23_inv-50005_acc-ZYX999_copyof-ABC001.pdf

In this case:

  1. The system matches the visible account code to the guardian record.

  2. The system uses the invoice number and the copyof account code to look up the student or students in the Custom Invoice Reconciliation Report.

The import supports both:

  • A single invoice per guardian covering multiple students.

  • A separate invoice per student.

If invoices are produced per student, the account code may be the same across multiple files, with the invoice number being the part that differs.

If invoices are grouped for multiple students, there may be one PDF but many rows in the Custom Invoice Reconciliation Report.


Check What Must Be True for Guardians to Access the Files

For guardians to access imported files, all of the following must be true:

  1. The Guardian Documents Group must be released.

  2. The guardian must have permission to access the content page associated with that Guardian Documents Group.

  3. The guardian must be linked to the corresponding student.

As part of the import process, the system performs a validation step to identify issues when linking PDF files with guardians and students.


Approve the Fee Billing Import

After the ZIP file has been processed, you must approve the import before guardians can access the documents.

  1. Log in as an Admin user, then click Admin Control Panel.

  2. Click Guardian Data, then click Guardian Document Imports Manager.

  3. Open the relevant import.

  4. Select Display documents from this import to guardians?

This releases the import itself.


Approve the Guardian Document Group

You must also approve the related Guardian Document Group.

  1. In Admin Control Panel, click Guardian Data, then click Guardian Document Groups.

  2. Open the relevant group.

  3. Select Display documents from this group to guardians?

πŸ“Œ Note: In both tools, the current visibility of each import and group is shown in the overview table.

Did this answer your question?