MIP fund accounting uses a definition file to perform the import of payments from GovCollect.  The file below is a CR Cash Receipts file.  That means when imported into MIP, the user will find it in their cash receipts section to view and post NOT in the journal voucher section.


CHANGE FOR EACH CUSTOMER

The only thing that has to be changed for each customer is the GL Account segment portion of the definition file.  It is in red below. The segments are in MIP admin chart of accounts setup.  The name and segment positions must match for the import to locate the correct GL Account.


Below is the standard def file contents.  Review it.  You will see positions 1, thru 11 defined in the CSV file we export from GovCollect.  Position 10 is the payment receipt number.  Position 11 is the deposit number.  This will allow the user to match up between products for a great audit trail.


NOTE - AR entries use a different file layout and are imported as a journal voucher into MIP.



FILE,SESSION,C:\MIP Share\Import\Master Def files\nameit.csv

CONTEXTIDPOSITION,1

TRANSACTION_READ,3

CLEANLINE_READ,1

SUPPRESSWARNINGS

FILETYPE,CSV

CONTEXT,SESSION,HEADER,HSESSN

SESSION_SESSIONNUMID,,AUTONUM

SESSION_STATUS,,BP

SESSION_CURRENCY_TYPE,,USD

SESSION_DESCRIPTION,,Imported GovCollect

SESSION_SESSIONDATE,7,,MM/DD/YYYY

SESSION_TRANSSOURCEID,,CR

ENDCONTEXT

REM,----------------------------------------------------------------------------

REM, Document Header Information

REM,----------------------------------------------------------------------------

CONTEXT,TRANSENTRY,HEADER,HDOC

TEDOC_SESSION

TEDOC_TRANSOURCE,,CR

TEDOC_DOCNUM,10

TEDOC_DESCRIPTION,2

TEDOC_DOCDATE,7,,MM/DD/YYYY

TEDOC_DUEDATE,7,,MM/DD/YYYY

TEDOC_MISCINFO,11

ENDCONTEXT

REM,----------------------------------------------------------------------------

REM, Document Transaction Lines Information

REM,----------------------------------------------------------------------------

CONTEXT,TRANSENTRY,DETAIL,DDOC

TETRANS_SESSIONNUMID

TETRANS_DOCNUM,10

TETRANS_DESCRIPTION,5

TETRANS_ENTRY_TYPE,,N

TETRANS_EFFECTIVEDATE,7,,MM/DD/YYYY

TETRANS_SEGMENT_Fund,1,,,1,3

TETRANS_SEGMENT_Account,1,,,5,6

TETRANS_SEGMENT_Location,1,00000,,13,5

TETRANS_DEBIT,8,0,,,,0 

TETRANS_CREDIT,9,0,,,,0

ENDCONTEXT


Instructions on where to look in MIP (Sage) to find unposted batch in MIP.


The transactions were imported (not posted yet)

1. On their menu they go to TRANSACTIONS / cash receipts

2. From their they locate the unposted batch, review it and post.  They have to know how to do that.

3. Once posted, in the BANK REC they will see us on the DEPOSIT tab.