Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Performance updates have been applied to ensure the function runs more efficiently in the background and also that the information shown within the import receipts from bank statement screen loads quicker

  • The import receipts from bank statement screen has been updated to assist usability

  • New configuration options have been developed which:

    • Only match a statement item using a payment reference (held in Reapit)

    • Prevent saving when a match payment reference is not unique

    • Assign users to a statement item
      All three of the configuration options listed here are disabled by default

...

Table of Contents
minLevel3
maxLevel3
outlinefalse
styledisc
typelist
printabletrue

Import receipts from bank statement screen updates & enhancements

1. Access import receipts from bank statement screen

From Lettings/Rentals on main menu:

  • Click Daily Accounts Processes and select Import Receipts from Bank Statement

RFS main screen.png
Tip

All screen updates & enhancements are covered in the following sections

2. Pages & changing the number of items shown in each page

Statement items are now presented over multiple pages:

  • This update means that the screen can load quicker, as it is no longer attempting to present all items when launching the screen

  • Use the forward/back and skip to end/start buttons (bottom right) to scroll through each page

  • Items in page allows the number of items shown on the page to be changed

    • This limit is stored against the logged in user and is remembered when the page is re-loaded

    • Enter the required figure and press tab (on keyboard) to refresh the screen

RFS items in page.png

3. Display options

  • Display options are now offered in a drop-down menu (rather than listed on screen)

  • When selecting By Date, the date field is shown and can be changed

RFS display options.png

4. Import button

The Import statement link (previously shown top right) is now an Import button (bottom right):

  • Click to select file to import

  • Right-click for Reverse statement import option

RFS import button with right click option.png

5. ‘Assigned to’ filter option

The Assigned to filter option allows statement items to be filtered according to who they are assigned to:

  • Assigning statement items is a new configuration option which allows authorised users to assign statement items in bulk to selected users or themselves
    See next section for more information on this configuration option, including how to assign & unassign statement items

  • When statement items are initially imported to receipts from statement they are unassigned
    i.e. they are not assigned to a specific user/negotiator

  • The default view in the receipts from statement screen is to show all items that are both assigned and unassigned - use the filter menu options to view items assigned to the currently logged in user, to a specific user/negotiator or just view unassigned items

RFS assigned to menu option.png

6. Negotiator grid column

The negotiator column is related to the new assign functionality outlined in step 5 above

  • A Negotiator grid column has been added (far right) and displays who each item is assigned to

  • Blank indicates the statement item is currently unassigned

    RFS neg column.png
Tip

All other functionality previously available in this screen remains the same

Assign (& unassign) statement items - configuration option

Info

When this configuration option is enabled, a user can assign & unassign statement items in the import receipts from bank statement screen

This configuration option is disabled by default
To request for it to be enabled, click here to contact Reapit Support

1. Display items to assign or unassign

Tip

When needing to assign & unassign statement items, all items currently on display on the current page in the import receipts from bank statement screen will be assigned to the selected user/negotiator (or unassigned)

Therefore, the first step is to ensure you are displaying the items you wish to assign/unassign before choosing the assign/unassign option

From import receipts from bank statement:

  • Display the items you wish to assign or unassign using the Assigned to filter menu and/or the Items in page field to

    • To change the Items in page, enter the required figure and press tab (on keyboard) to refresh the screen

  • Click Assign then select Assign items or Unassign items, as required
    See next steps

    RFS assign button.png

2. Assign displayed items

The screen should display all items you wish to assign (as outlined in step 1):

  • Click Assign then select Assign items

  • Select the user to assign the items to and click Select

  • A pop-up message is displayed to confirm how many items are being assigned and who to, click Yes
    If the items are already assigned to another user, this will be overwritten with the newly selected user

  • A pop-up message may be displayed to highlight that you have not posted receipts for the items, if you wish to continue to assign, click Yes

  • Click Yes to assign the items to the selected user

    RFS save changes to statement items pop-up.png

3. Unassign displayed items

The screen should display all items you wish to unassign (as outlined in step 1):

  • Click Assign then select Unassign items

  • Select the user to assign the items to and click Select

  • A pop-up message is displayed to confirm how many items will be unassigned, click Yes

    RFS unassign items pop-up.png
  • A pop-up message may be displayed to highlight that you have not posted receipts for the items, if you wish to continue to unassign, click Yes

  • Click Yes to unassign the items

    RFS save changes to statement items pop-up.png

Match imported receipts strictly on payment reference - configuration option

Info

When this configuration option is enabled, in order for a statement item to match, the description of the statement item has to exactly match a payment reference in the system

This update has a huge impact on performance as the amount of background queries required in order to carry out the statement item matching process is drastically reduced

This configuration option is disabled by default
To request for it to be enabled, click here to contact Reapit Support

Tip

The ability to enter a payment reference for a tenancy, tenant, landlord or Direct Debit is already available on the system in the following locations

This is the reference used by the match imported receipts strictly on payment reference configuration option therefore, if you wish to implement this feature, you need to ensure that your payment references are entered and are unique - if more than one match is found for the reference that is entered against a statement item, then it won't match in the window and it will need to be assigned manually
e.g. if two tenants have the same reference, they will not automatically match in Receipts from Statement, and instead will need to be matched manually

A unique payment reference needs to be entered in the following locations for a tenancy, tenant, landlord or Direct Debit, as follows

Tenancy

  • Access tenancy and click Financial & Extensions tab

  • Enter Payment reference
    This field should be used if the reference is used by all tenants - if not, individual tenant references should be used instead (see Tenant section below)

    Payment Ref - tenancy.png
Note

The exclamation mark to right of field in the example above, indicates that the payment reference in use is not unique

This is just a warning flag - however, if the configuration option outlined in the next section - Prevent save when payment reference is not unique - is enabled, the record cannot be saved until the payment reference is changed

See next section for more information

Tenant

  • Access individual tenant record

  • Enter Payment reference

    Payment Ref - tenant.png

Landlord

  • Access landlord record

  • In Landlord’s Properties panel, right-click required property and select Add/Edit payment reference

    Payment Ref - landlord.png
  • Enter Payment reference and click Accept

    Payment Ref - landlord 2.png

Direct Debit

  • Access Manage Direct Debits screen

  • Enter Reference

    Payment Ref - DD.png

Prevent save when payment reference is not unique - configuration option

Info

When this configuration option is enabled, in order to save a record where a payment reference has been entered, the payment reference entered must be unique

This configuration option would only usually be used when the configuration option outlined in the previous section - Match imported receipts strictly on payment reference - is enabled, although it is not compulsory to use both options

This configuration option is disabled by default
To request for it to be enabled, click here to contact Reapit Support

When a payment reference is not unique:

  • A exclamation mark is displayed beside the payment reference

    Payment Ref - tenant with alert.png
Tip

The duplicate reference must be changed to a unique reference in order to save the record

If duplicate references already existed on the system they will remain (flagged as duplicates) and will continue to remain with the duplicate reference if no changes are made to the record
Once changes are made, the requirement to change the duplicate reference will be flagged

Filter by label (Content by label)
showLabelsfalse
max8
maxCheckboxfalse
sortmodified
showSpacefalse
reversetrue
cqllabel = "rec-from-state"

...

Excerpt
hiddentrue

The import receipts from bank statement function has been updated and enhanced - including screen usability updates, new configuration options to enhance functionality and performance and also , plus background updates to improve efficiency