Versions Compared

Key

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

This guide has been reviewed against our global client base and classed as relevant to all regions

This article explains how to import your bank statement so that you can match the bank receipts

1. Download your bank statement

  • Log into your bank and download your bank statement into CSV format

  • Save this on to your computer

...

Image Added
Tip

If your bank statement can be imported by the API skip this step

...

2. Import the statement

Click Lettings/Rentals on main menu:

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

  • Click Import Statement (top right)

    Image Added
  • Locate the saved statement on your computer

...

Image Removed

Expand
title2a. How to import a CSV file

Image Removed

...

title2b. How to import using the API

The banking API allows the system to download the bank statement directly from your bank

...

  • and import as a CSV file
    OR, if your system is set-up with the banking API - select the required statement from the list

    The API allows bank statements to be downloaded directly from your bank - to find out if your bank supports this facility, contact Reapit Support 

...

3. Matching the

...

bank receipts

...

Image Added
  • The system will auto-match the receipts to tenancies based on the reference provided on the bank statement

  • Check that the receipts have matched to the correct tenancy, as displayed in the Tenancy column

...

Tip

It is the sole responsibility of the user to ensure the receipts have been matched correctly

4. Clearing an incorrect match

...

  • If the match is incorrect, click the red cross to clear the match, click Yes to confirm

  • To match the receipt to the correct tenancy, click the magnifying glass beside Select tenancy to search for the tenant

  • When located, double-click to confirm the tenancy

Image Added

5. Other types of receipts

Sometimes you may receive money from another party - the different types are outlined below

Image Removed

...

Image Added

Landlord receipts

If the receipt is from a landlord:

  • Highlight the item and select Landlord in the Receipt For section

  • Search for the landlord record and double-click to confirm

  • You will be prompted to link the receipt to one of the landlord’s properties
    Failure to do so will result in the landlord statement defaulting to grouped

...

Company receipts

If the receipt is from a supplier:

  • Highlight the item and select Company in the Receipt For section

  • Search for the company record and double-click to confirm

...

Unknown receipts

If you are not sure who the funds belong to:

  • Highlight the item and in the Receipt For section and mark as Unknown
    This allows you to reconcile the receipt and investigate at a later date

6. Posting the receipts

...

  • All items should display a tick on the left-hand side

Note

Any receipts left un-ticked will not be able to be reconciled

  • Click Post to complete the process

  • Click Print to e-mail or post receipts

...

Image Added

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
sortmodified
showSpacefalse

...

reversetrue
typepage
cqllabel = "receipts" and type = "page" and space = "RW"
labelskb-how-to-article
Excerpt
hiddentrue

How to import your bank statement so that you can match the bank receipts