Search

Juris® Answer Center

Import A/R Cash Receipts

  • Updated

Cash Receipt Import lets you bring many cash receipts into Juris at once from a CSV (spreadsheet) file. It’s fastest if you start with the Cash Receipt Import report to generate a ready-to-edit CSV.

Create the CSV in Juris Suite (Recommended)

Use this when you have one large check paying many bills for a consolidated client.

Note: You can use the Alternate Method if you do not have Juris Suite. See Alternate Method — Build a CSV From Scratch.

  1. Open Juris Suite.
  2. Run the Cash Receipt Import report.
  3. Choose the consolidated client.
  4. Set Bill Start Date to Inception (or your desired date range).
  5. (Optional) Enter Deposit Date, Check Number, Check Date, and Check Amount to pre-fill the file.
  6. Click OK and Export to CSV.
  7. Open the CSV and fill in AmountToApply per line. Add Client/Matter if needed.

Do:

  • Keep the column order and column names exactly as exported.

  • Make sure applied amounts are correct for each invoice.

  • Use plain numbers (no currency symbols) for amounts.

Don’t:

  • Don’t add extra new columns.

  • Don’t use Excel formulas in cells you’ll import—paste values only.

     

Note: When you’re done, File > Save As > CSV (Comma delimited). Close the CSV before importing (some systems can’t import while the file is open in Excel).

Alternate Method — Build a CSV From Scratch

If you don’t have Juris Suite, you can still create a CSV manually in Excel.

  1. The first record of CSV files must contain Column (field) Names listed below:

Sequence Field Description Required
1 DepositDate Defaults to current date if not entered; must be in date format (mm/dd/yy OR mm/dd/yyyy OR yyyymmdd) No
2 CheckNbr Check Number; alphanumeric with a limit of 10 characters. Yes
3 CheckDate Defaults to current date if not entered; must be in date format (mm/dd/yy OR mm/dd/yyyy OR yyyymmdd) No
4 CheckAmount Amount of the check; money format with limit 99,999,999.99. Yes
5 Payor Name of the payor; alphanumeric with limit of 50 characters. No
6 BillNbr Bill number; numeric or alphanumeric with a limit of 7 characters. Yes
7 ApplytoBill Amount to apply to the bill; cannot be greater than CheckAmount. Yes
8 ClientMatter Combination of Client and Matter number (e.g., 101000010). No
  1. Enter Your Data
    1. Create a new worksheet in Excel.
    2. Enter one row per receipt application line.
    3. If a single check pays multiple invoices, repeat the same Check Number across multiple rows.

  2. Save as CSV (Comma delimited) file and follow the steps in Import the CSV.

Import the CSV

  1. Go to Cash Receipts and click Tools > Import.

  2. Click Browse and pick the CSV you saved.

  3. Click Import

  4. Juris creates an Unposted batch. The default Batch Comment is 'Import Cash Receipts', which you can edit.

Review and Fix Issues

After import, do the following before posting:

  1. Open the unposted batch.
  2. Scan for errors. If the import detects problems (e.g., invalid bill, missing required fields), you’ll be prompted to view the error report. Fix your CSV or correct entries directly in the batch.
  3. Check dates and Payor.
    • If CheckDate or DepositDate were blank, Juris will default them (today/import date). Adjust if needed.
    • Ensure Payor is present. If it’s blank and no default could be applied, Juris will prevent posting.
  4. Bank account (if needed). If the receipt needs to go to a different bank than the matter’s default (e.g., multi‑office scenarios), open the entry and change the Bank manually.
  5. Print/Edit lists as needed to verify details. When everything looks correct, Post the batch.