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

2a. How to import a CSV file

Image Removed

...

  • 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 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