agrē can import 3rd party credit details (like current and available balance) from a spreadsheet created by the financial institution.

I want to read the 3rd Party Credit Management white paper (with lots of screenshots).

Importing 3rd Party Credit Details  into agrē

To import 3rd party credit details:
* indicates a required field

Navigate to Accounts Receivable > Import 3rd Party Credit Details.
The Import 3rd Party Credit Details window opens.

Import Credit Details

Select the Credit Instutution and the Loan Description.

Next to File Name, select browse files  to select a worksheet to import.

(config U) Navigate to where your worksheet is stored, select the File Name*, then click Open.

Select Remove Existing Rates First to delete existing rates for all Commodity/Adjustment/Location combinations in the worksheet.
For <Company>, this will delete all the shrink percentages for all commodities in the list (if a value for shrink % is entered) before updating with new values from the worksheet.

Select Only Update Existing Rates to add or update only the rates in the worksheet and leave other rates unchanged.

Select Save.

The new rates imported and an Import Completed message appears.
Click OK to continue.