It is possible for the client to map and upload files via LendScape’s externally facing Client manager application (v7.4+).

Tip
 The screenshots that follow are not branded so may look slightly different. The functionality remains the same regardless of branding.

The mapping and upload panels are functionally the same as the Open Accounting Connector mapping panels. The Client Manager functionality only allows the client to map and upload their files. The client manager user cannot track the progress of the file after it is submitted.

If the Client Manager integration with Open Accounting Connector is enabled then the following menu option should be displayed.

Client Manager

The top half of the panel displays the five file types available to map and upload against. Select a file type

Selecting a file type (i.e. Debtors Items) displays any previous mappings for that file type. If there are none then the only row below will invite the user to click and create a mapping.

It is possible to view an existing mapping and check which columns in the client’s file format have been mapped to which Open Accounting Connector data field.

View Exisitng Mapping

Files can be uploaded and mapped. The first step is to provide some information about the format of the file about to be uploaded.

Tip
 If no existing mappings have been provided for the file type then click on the file type in the top half of the panel and in the first row in the bottom panel click on the * Select to create a new file mapping * this will initialise a new file mapping.
File Metadata
Tip
 If the file has been mapped before then subsequent uploads will default to this mapping and pre-populate the mapping panel based on the last mapping provided. This can be edited.

Once the metadata has been provided the columns in the file can be mapped to the available Open Accounting Connector data fields.

Map File

Conversion values can be provided (if requested by the Open Accounting Connector data field)

Conversion
Table 1. Open Accounting Connector Item Types
Open Accounting Connector Type Description

INV

Invoice

CRD

Credit Notes

PAY

Payment - ie. Cash, Cheque

CRA

Credit Adjustments

DBA

Debit Adjustments

When the fields are all mapped the file contents can be reviewed against the mapping.

File Review

If happy then 'Finish' can be pressed. This will create or update the mapping AND send the file to Open Accounting Connector for processing.