Skip to main content

Batch Import

Important

Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.

From the Import Batch page, transaction data can be imported from the Transaction Import Table or from an external source file.

. Source Data
  1. Select Data Source. Select the file and mapping template, then preview the data to be imported.

  2. Preview & Edit Data. Review the imported data, enter the batch description and date, and make updates to any rows with errors.

  3. Confirm Batch Details & Finish. Review a summary of the batch to be created and start the import process. The process runs in the background, so you can continue working in J1 Web. You'll receive a notification when the process is complete and batch is created.

. Import Table
  1. Select Import Table. Use the worksheet to add individual transactions to create the batch you want to import. Review the imported data and make updates to any rows with errors before continuing.

  2. Confirm Transaction Details & Finish. Review the import settings and options and start the import. The process runs in the background, so you can continue working in J1 Web. You'll receive a notification when the process is complete and batch is created.

Jenzabar provides several roles for managing batches, and each role can be associated with different source codes. The table below describes which source codes are associated with each role.

Batch Type

Associated Source Codes

Accounts Payable

Note

These batches are generated in the Procurement Hub.

IM - Immediate check invoices

IV - Regular check invoices

MN - Manual check invoices

RF - Refunds from vendors

VD - Void check invoices

Adjustment

JL - Journal entries

MA - Monthly adjustments

Charge

Note

Some of these batches are generated in the Accounts Receivables Hub.

CG - Student charges (automatically created)

FC - Finance charges

IT - Interest earned

TP - Tuition paid in advance

Conversion

CV - Conversion necessary

Customized

Any custom source codes your school creates.

Development

GF - Development gifts

Disbursement

Note

These batches are generated in the Accounts Receivables Hub.

DB - Disbursements

Financial Aid

FA - Financial Aid

LD - In-House Disbursement

LO - Financial Aid Loan

Fixed Asset

FX - Fixed assets

GST Credits

TX - GST tax credits

Miscellaneous

Note

These batches are generated in the Accounts Receivables Hub.

MS - Miscellaneous transactions

Payroll

FR - Fringe benefits - Payroll

LB - Labor distribution - Payroll

Preliminary

@C - Preliminary student charges

@F - Preliminary financial aid

Receipt

Note

These batches are generated in the Accounts Receivables Hub.

RC - A/R Receipts

Tip

With a few exceptions, the permissions and associations apply to each batch access role.

Permissions and Associations

You'll need to add users to the appropriate batch access roles for each type of batch you want your user to be able to work with.

Note

Users will also need to be in a General Ledger Accounting GL Account access role with access to the GL accounts associated with batch transactions.

Permissions

Each batch role will have similar permissions for how you can work with a particular type of batch.

Each batch role will include all or most of the following permissions:

  • Can view batches

  • Can edit batches and generate Print Edit reports

  • Can create and import batches

  • Can delete batches

  • Can download to Excel

  • Can post batches and generate Post reports

  • Can post batches they created

  • Can unlock batches

  • Can summarize batches

  • Can reverse batches

Batches Generated Outside of the General Ledger Accounting Hub

Batches for certain source codes are generated by processes in the Procurement and Receivables Management hubs. In most cases, batches for these source codes cannot be created in the General Ledge Accounting hub.

  • Accounts Payable batches. Invoice batches (IM, IV, MN) are created when invoices are created or imported from the Procurement Hub. RF and VD batches are created when invoices are refunded or voided. These batches cannot be created in the General Ledger Accounting hub.

  • Charge batches. CG, FC, and TP batches are created when the generate charges, generate finance charges, and transfer student deposits processes are run in the Receivables Management hub. These batches can be created in the General Ledger Accounting hub.

  • Disbursement batches. DB batches are generated when the Create Payment process is run from the Procurement hub. These batches can be created in the General Ledger Accounting hub.

  • Miscellaneous charge batches. MS batches are generated during the Create Miscellaneous Charges process in the Receivables Management hub. These batches cannot be created in the General Ledger Accounting hub.

  • Receipt batches. RC batches are created when receipts are created or imported. These batches cannot be created in the General Ledger Accounting hub.

Module Access

This tab allows you to enable/disable access to different interactions and workflows. Codes are associated with interactions and workflows when they are defined and created. Jenzabar provides access codes based on Jenzabar modules and you can create custom ones on the Access Codes page. If a user belongs to multiple roles, they’ll have access to the interactions and workflows available with each.

Users

Use this tab to see a list of the users assigned to this role. You can add or remove users and view user details

Associations

The Associations tab is only available for select roles and options vary by role. It lets you control access to constituents and information in the system based on the user's relationship to them. Source codes are enabled for what the user should have access to.

User-Defined Fields (UDEF)

The User-Defined Fields tab controls permissions for viewing, editing, and configuring user-defined fields (UDEF) across the system. Users that belong to multiple roles will have access to the user-defined features enabled with each. Use the levels of permissions to determine what users can do with user-defined fields.

There are two options for this process. You can upload a file containing the transactions you want turned into a batch, or you can manually add transactions to the worksheet and post the batch.

J1 Web uses data mapping templates to import data from external files such as Excel spreadsheets. The template tells the system which database fields are to be populated with the imported data. Only templates associated with batches can be selected during the import batch process.

Note

Your school may create Excel templates that you can use for the import process. That Excel template should have all the required columns to import data. If you have issues importing data with your file, contact your IT administrator.

After selecting a template, choose the file to upload. The file you import into the system must contain all the columns defined in the selected template and the column names must match exactly.

Tip

Source files are limited to the following extensions: .xls, .xlsx, .csv.

When you choose the Import Table data source, you will need to work on the spreadsheet to enter transactions. You can use the copy/paste options or enter data into the fields manually. Any errors or warnings will appear in red and must be fixed before clicking Save & continue.

Warning

If you choose the Import Table data, you will skip Step 2. Be sure to review and update the transactions entered on the worksheet before continuing to the Confirm Batch Details & Finish step.

After the batch file has been uploaded and validated, you can make updates to the data on the Preview & Edit Data step of the wizard. On this step, you'll also enter the following information.

  • Description: this description is used for the batch that is created when the imported transactions are created.

  • Date: this date is assigned to the imported batch and to any transactions that didn't have a date when they were imported into the system.

The columns visible on this step may vary based on the mapping template selected in Step 1. The system validates the imported data and highlights fields that need to be corrected. You must complete the corrections before continuing.

This final step allows you to view and select options for how your batches will be imported into the system. Depending on the options you selected in Step 1, you will either see the Confirm Batches or Confirm Transactions options.

The Confirm Batch Details & Finish step displays a summary of the transactions that will be included in the batch created during the process. You can view the number of batches that will be created and total amounts for each.

When you click the Import button to start the process, the system performs a final validation to confirm all required information was entered. The process runs in the background so you can keep working in J1 Web. You'll receive a notification when it's complete with links to view the batches and batch details.

The Confirm Transaction Details & Finish step displays options so you can determine how the batches will be imported during this process.

When you click the Import button to start the process, the system performs a final validation to confirm all required information was entered. The process runs in the background so you can keep working in J1 Web. You'll receive a notification when it's complete with links to view the batches and batch details.

Choose which transactions will be included in the import:

  • All Transactions from the Import Table: each row you enter on the Import Table will be imported in the system.

  • Selected Transactions: this option allows you to select a Source Code and Batch Number to limit the transactions included in the import.

If you want the transactions you added to the Import Table to be cleared after the import process is run, select the Clear selected transactions from import table after import checkbox.

Choose how the transactions will be added to the system during the import process:

  • Source Code: Do you want the source code of the new transactions to remain as you entered them into the table, or do you want to change all of the incoming transactions to have a new source code? If you select Use A Different Source Code, you will be able to select a code from a drop-down.

  • Transaction Date: Would you like to keep the the transaction dates as they were entered into the table, or would you like to make all transaction have a new date? If you select Use A Different Date, you will be able to choose a date from the calendar drop-down.

  • Transaction Grouping: Would you like to have all transactions with the same source code grouped into the same batch or would you like them in separate batches?

  • Description: Write a brief description for the batch that is created when they are imported to the system.

If the transactions being imported are connected to your students, you can make sure the Populate Student ID Number based on SSN checkbox is selected so the correct student IDs are added to the transaction details.

Import Batches

  1. From the Finance General Ledger Accounting Hub options, select Import batches. The Import Batches page opens.

  2. From the Select Data Source options, select Source File.

    1. Select a Source Code. Required.

    2. Click in the Mapping Template field and select an option from the list. Only templates associated with the selected source code are available for selection. Required.

      1. Under the File to Import section, click the Choose file button.

      2. In the pop-up, navigate to and select the import file (allowable file types are .xls, .xlsx, and .csv), then click Open.

    3. To view the imported data:

      1. Click the Preview data button below the imported file. A pop-up opens with a read-only table of the header and columns from the imported file.

      2. Click the Close button or the x in the top right corner to close the pop-up.

    4. Click Save and continue to move to the Preview & Edit Data step.

  3. On the Preview & Edit Data step, review and update imported data. All the columns from the selected mapping template are displayed in the details spreadsheet. Most can be edited and some are required.

    Tip

    Required fields will depend on the type of batches you're importing. As you review the content, any errors will appear in red along with a highlighted area above the spreadsheet with a count of the errors.

    1. Enter a Description (up to 40 characters). The system uses this description when batches are created in the final step. Required.

    2. The Date defaults to today's date and can be changed if needed. This date populates the Transaction Date column in the details spreadsheet if a transaction date wasn't included in the import data and is used as the batch date. The date must be within the current or future fiscal year. Required.

    3. Make updates to any of the editable columns in the details spreadsheet.

    4. Click the Save & continue button to move to the Confirm Batch Details & Finish step.

  4. In the Confirm Batch Details & Finish step, review the batch summary information.

    1. Review the information in the Batch Debit & Credit Totals section. If there are any issues, click the Preview & Edit Data link to go back and make changes.

    2. Click the Import button. The process runs in the background so you can continue working in J1 Web. When it's complete, a notification appears with links to access the batch details and the details for each batch that was created.

  1. From the Finance General Ledger Accounting Hub options, select Import batches. The Import Batches page opens.

  2. From the Select Data Source options, select Import Table.

    1. Use the worksheet to add transactions that you would like imported into the system as a batch. You can manually enter data or copy and paste.

    2. Click Save Worksheet_Save.jpg.

    3. Data entered into your worksheet will be validated and any errors or incorrect entries will be highlighted red. Be sure to review and update your data accordingly.

    4. Click Save & continue to move to the Confirm Transaction Details & Finish step.

  3. On the Confirm Transaction Details & Finish page, review the options for the transactions you want to import.

    1. Select Transactions to Import: this section allows you to choose which transactions entered in the table will be imported into the system. You can also choose to clear the table when the process is done to avoid including processed transaction in another batch.

    2. New GL Transaction Selections: use these settings to choose how the transactions will import into the system. Source codes, transaction dates, groupings, and descriptions can be updated in this section.

    3. Additional Transaction Details: select the Populate Student ID Number based on SSN checkbox if the transactions being imported are connected to students.

    4. Click Continue. The process runs in the background so you can continue working in J1 Web. When it's complete, a notification appears with links to access the batch details and the details for each batch that was created.

Tip

Permissions to view and manage mapping templates are typically reserved for IT administrators and those who manage the database.

  1. On the Import Batches page, click the Manage Mapping Templates link. The Data Mapping Templates page opens with a list of templates for the selected source code.

  2. To view and edit details about an existing template:

    1. Click the Actions button for a row and click Edit. The Edit Mapping Template pop-up opens.

    2. In the Batch Details Columns section, you can remove and select new values in the Source File Column to map data from the imported file to the database Column.

    3. Select the Make Required checkbox for columns that must contain a value.

    4. Click the Show details button at the top right of the pop-up to view and update the template Name, Description, or Modules allowed access.

    5. Click Save and close or click the x at the top right corner.

  3. To create a new data mapping template, see Data Mapping Templates.

The file you import must have the same columns as the selected mapping template and the column names must match the template exactly. Your school creates customized data mapping templates, so contact your module manager or IT administrator if your file doesn’t match the mapping template parameters.

After the process is complete, you can click the link in the notification to access batch details. You can also access the Notification Center from the universal toolbar and enter "Import batches" in the Keyword filter to access links to batches. Open the notification and click the link to the batch. From the batch, you can open the individual transaction details.

Mapping templates are defined and managed in the Campus-wide Definitions Hub, usually by your school's IT administrator. If you have permission and access, a Manage Mapping Templates link on the Import wizard page lets you access the Data Mapping Templates page to view, add, or update templates. The Edit Data Mapping Template pop-up shows which database columns the imported values are mapped to. The file you import into the system must contain all the columns defined in the selected template and the column names must match exactly.

For more information about mapping templates, see Data Mapping Templates.