This guide has been reviewed against our global client base and classed as relevant to the following regions: UK, APAC, UAE
Where card payments are used, it is common for those payments taken within a day to be grouped together and shown as one statement item in Reapit Agency Cloud
That statement item can either be a single positive or negative figure but could actually be comprised of multiple items
The Import Negative Multiple Receipt tool is designed to allow the user to reconcile both positive and negative statement items within an overall negative figure - as it is not classified as a receipt overall, it won’t hit the Receipts from Statement screen as usual
The daily bank statement has been imported and on the statement is one item - a negative of £141.54
This represents a payment that has left the account, however, the payment actually consists of multiple line items
Breakdown
| Credits | Debits | |
|---|---|---|
| +£358.56 | -£707.69 | |
| +£619.23 | -£511.64 | |
| +£100.00 | ||
| Total | £1077.79 | £1219.33 |
The cumulative total of credits less debits is -£141.54
Each of the credits and debits were likely to have been made from/to a different landlord or tenant ledger
1. Check debits The debits should be checked to confirm they have been processed - they are refunds, so the funds should be on account in the system and can be searched for using the Bank Statement Analysis tool
| |
2. Import negative multiple receipts From Receipts from Statement:
| |
3. Populate the breakdown Populate the breakdown as you would a normal multiple receipt but also include the negatives by (use the – key to indicate this) The negatives should be marked as Unknown but they will not actually be posted there Positive figures should be allocated and matched like any other receipt in the screen (although this is not the case for the example on right)
|
|
4. Bank Reconciliation The statement item will show a duplicate (by design) – you can still reconcile normally
Left side
Right side
| |
Related articles