Judicial Administration
Superior Court Clerk's Office
Convert ACH Excel to Xml
Main Menu
This web tool will convert the
ACH, Direct Deposit
Excel file to Xml that can be imported into JRS system.
Notes
,
The top row in the spread sheet should have the column names that are JRS's XML tag names. The order of the columns are not important.
Please make sure your JRSWin.exe is version 3.15 or later. If not, please contact
Janice Winn
.
The cells under [caseNumber] column must be Text type.
If you cannot see the Open/Save dialog box showing up, you can change the IE broswer's settings by turning off the Pop-up Blocker and following
this picture
.
ACH Excel file (
Required
):
Set Sheet(s) (Optional):
(List the sheet's names (delimited by Comma) if the data is on multiple sheets or the sheet has the customized name rather than the default name (such as 'Sheet1', 'Sheet2'))
+Edit Xml Content
Edit Xml Content
Enter Case#:
And/Or
Obligor Name:
Tips:
Click [Case Number] hyperlink to edit its record.
Click [Download XML file] hyperlink above to download the udpated xml.
Click the highlighted [Obligor Name (JRS)] to replace the [Obligor Name (DOC]).
Red
means both of CaseNum and Obligor name are matched;
Orange
means only Obligor is matched.
Case Number:
Payer Name:
Transaction Code:
Obligor Name:
Obligor Name (JRS):
Doc Number:
Transaction Amount:
Build 1.0.0.7 (PROD) Last Updated 4/15/2024
