Importing your bank statement

Owned by Fiona Wilson
Last updated: Mar 06, 2023
3 min read

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

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)

  • Locate the saved statement on your computer 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

  • 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

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

5. Other types of receipts

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

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

  • Click Post to complete the process

  • Click Print to e-mail or post receipts