Skip to main content

Post to Accounting

Overview

The Jenzabar SONIS Post to Accounting utility allows administrators to export transactions performed in SONIS to their accounting software for record-keeping and further processing. Once these transactions have been posted, they can no longer be edited in SONIS.

Accounting Software

Before payments can be posted, SONIS must be configured for whichever accounting software the institution uses. If the school has not done so, they should inform SONIS Support of which software they're using so this configuration can be loaded behind the scenes. Currently, SONIS supports Abila MIP GL, AccPac GL, Financial Edge (CSV), Great Plains/MS Dynamics (CSV), MediTech GL, MS Dynamics (tab-delimited), QuickBooks GL, QuickBooks Online, and Sage InAcct. Once SONIS Support has configured the system for the specific software being used, the file created via this process should transfer properly.

Sample Files

Abila MIP

Abila MIP2

ACCPAC

Great Plains

Meditech GL

MS Dynamics

MS Dynamics Tab-Delimited

QuickBooks Desktop

Sage IntAcct

SONIS Default

Creating Transactions

Before transactions can be posted, they must first be created in other parts of the SONIS system. These transactions must have the proper Transaction Codes and Campus Codes attached to them in order for the system to categorize them correctly.

Posting to Accounting

New Batch

To create a new batch, first select a Batch Description, either Payments or Receivables. Leave this menu blank to include both.

Post_to_Accounting_18.png

Next, set the Post Date for the batch. The field defaults to the current date but can be altered to back or forward date the post.

Post_to_Accounting_19.png

Currently, the following formats utilize the post date option and can have their date changed: SONIS Default, Blackbaud Financial Edge Nxt, Microsoft Dynamics (CSV), Sage 300 (AccPac), Sage Intacct, MIP Fund Accounting v1, MIP Fund Accounting v2, Microsoft Dynamics (Tab-Delimited), and Intuit QuickBooks Desktop.

The Meditech GL, Intuit QuickBooks Online, and PeopleSoft GL export files do not recognize post date changes at this time.

Select one or more options each from the School Year and Semester menus. This designates the school year and semester that the transaction applied to, not necessarily the school year and semester when it took place. For example, a student payment for a Spring course made during the prior Fall semester would be listed under Spring. Multi-select can be used to select multiple options from either table.

Post_to_Accounting_20.png

Next, choose a Begin Date and/or End Date. Only transactions performed within these dates will be listed. These fields can also be left blank to include all unposted transactions that fall within the other criteria.

Post_to_Accounting_21.png

Select a T-Code, Division, and Campus or leave this field blank to include all unposted transactions that fall within the other criteria regardless of the t-code, division, and campus.

Post_to_Accounting_22.png

Finally, select one or more Operators. The list of operators contains every user who's performed a transaction in SONIS. Administrative level users have their name listed in parentheses while users who do not have admin accounts have a Non-Admin notation. This field can also be left blank to include all unposted transactions that fall within the other criteria regardless of the operator.

Post_to_Accounting_23.png

Click the Search button to continue. A New batch created notification will appear. The created batch will now be listed in the Available Batches dropdown where it can be selected for posting.

Post_to_Accounting_24.png
Post_to_Accounting_25.png

Available Batch

Administrators also have the option to select a previously created batch from the Available Batches dropdown. Batches are marked with the date they were created along with UP in parentheses for unposted batches and P for posted batches.

Post_to_Accounting_26.png

Click the Search button to display the selected batch.

Post_to_Accounting_27.png

On the following page, groups of transactions are listed along with their Transaction Code, Campus, Account, Accounting Code, BB Code, and the cumulative Amount. Click on the link in the Transaction Code column to view the individual transactions that make up the specified group.

Post_to_Accounting_28.png

The following page lists the Name on the account that created the transaction, that user's SONIS ID Number, the Transaction Number, the Transaction Reference (which describes the transaction in greater detail), the Semester, the School Year, the Date, and the Amount. The total amount is listed again as well. Click the Return button to return to the batch.

Post_to_Accounting_29.png

If these transactions were batched in error, click Free Transactions From Batch. Clicking this button deletes the batch and frees the transactions listed to be part of a future batch.

Post_to_Accounting_30.png

Click the Print Summary link to create a summary of the batch in PDF form in a new window. This PDF can be printed to create a hard copy or saved to create an easily readable electronic backup of the batch.

Post_to_Accounting_33.png
Post_to_Accounting_15.png

The complete the post to accounting process, click Post From Batch. Posting the batch saves a file in the specified batch folder for export and prevents the listed transactions from being edited again in SONIS.

Post_to_Accounting_31.png
Post_to_Accounting_32.png

Individual Export File Details

When an export file is created in Post to Accounting, the data included is specific to the defined third-party product. Sample files are provided on MyJenzabar.

Financial Edge

SONIS will produce a .CSV in the format required by Financial Edge. All standard Post to Accounting settings are honored and mappings must still be defined in Business: Transaction Code Mappings. The Journal and Project fields can be modified by the user. All others will populate as described in the table below.

Export Header Label

SONIS Data Source

Description

Batch Import ID

Auto-generated by SONIS; cannot be edited. It is a unique batch number created with the date and a random number as the suffix. The format is MMDDYYxxxx.

Account number

Business: Transactions Code Mapping > Account

The account number associated with the transaction.

Post Date:

Date the export is created in SONIS. The format is MM/DD/YYYY.

Encumbrance Status

Hard-coded to Regular.

Type

Business: Transaction Code Mappings > Accounting Code

If the Accounting Code is 60, C displays in the export. If it is 10, D displays in the export. This is necessary to indicate whether the transaction(s) are debits or credits.

Journal

Business: Transaction Code Mappings > Source

Journal Reference

Hard-coded to be SONIS plus 6-character date: SonisMMDDYY.

Amount

Amount of the debit or credit transaction group.

Project ID

Business: Transaction Code Mappings > Project

Displays the data that is in the field.