Import tenant payments into Affinity from a CSV file or an An Post Household Budget / Billpay data file. Affinity matches each receipt to a tenant and applies the selected allocation rules. Payments that need tenant identification or a fee-allocation decision can be completed through the review list.
Supported file formats
- CSV (.csv): use the column order below.
- An Post data file (.dat): Household Budget and Billpay files are supported. Import the original data file without converting it to CSV.
CSV column order
- Receipt Date (dd/mm/yyyy)
- Tenant Name
- Tenant account number
- Payment Medium, e.g. BACS
- Receipt value
- Description (optional)
- Receipt Source (optional)
Keep the columns in this order. Columns 2 and 4 are not used by Affinity, but their positions must be retained. If Receipt Source is populated, use one of these values:
- Standing Order
- Direct Debit
- Online Payment
- Household Budget
- An Post Transfer
- Bank Transfer
- Credit Card
- Debit Card
- Cash Payment
- Retail Pay Point
Import a payment file
- Go to Bank > Import Payments.
- Select the bank account into which the payments were received.
- Select the appropriate file format: CSV or the An Post / Household Budget option for a Household Budget or Billpay data file.
- Select the Payment Type. Tenant Payment identifies payments made by tenants; Benefit Payment identifies payments from a benefit agency.
- Select the Charge Type. Auto uses each tenant's charge schedule and the normal allocation rules. Alternatively, select a specific charge type to allocate the receipts to that type during normal processing.
- Click Choose File, select the file, then click Add.
- If a fee-review summary appears, choose how to process the file as described below.
- Check the results and complete any payments requiring action.
Optional review of outstanding fees
An authorised user can enable Review imported tenant payments for outstanding fees in Settings > Finance.
This setting is off by default. When it is off, imports and subsequent tenant matching use the normal allocation rules. Outstanding fees do not cause receipts to be held, and no fee-review confirmation is added.
When the setting is on, incoming tenant payments for tenants with active, unpaid fees can be retained for review. Partially paid fees are included; fully paid or inactive fees do not trigger review. This optional workflow applies to tenant receipts from CSV and An Post files, not benefit payments or refunds.
Choose how to process the file
If matched receipts have outstanding fees, Affinity displays counts and values for matched receipts without outstanding fees, matched receipts with outstanding fees, and unmatched receipts. Any rejected records are also shown.
- Review fee allocations: process straightforward receipts now and retain affected receipts for an allocation decision.
- Use normal allocation for this file: process matched receipts using the normal rules without paying outstanding fees through this review workflow.
The choice also applies to unmatched receipts identified later. If no matched receipts need fee review, no additional confirmation is shown, but the file's review policy is still retained for later matching.
Changing the organisation setting afterwards does not change the policy saved with an imported file or automatically complete payments already awaiting review.
Understand the import results
The updated results page shows a card for each state, with the number of records and their total value:
- Completed: processing and allocation are complete.
- Tenant identification required: the receipt is awaiting a tenant match.
- Allocation required: the tenant is known, but a decision is needed about allocating the receipt.
- Rejected: the record could not be processed. Read the explanation in the record details.
- Deleted / reversed: the imported payment has subsequently been deleted or reversed.
Click a card to open records filtered to that file and state. Completed, rejected and deleted/reversed records are read-only in this view.
The Payment records section lists individual results. Select Action required: Review payments to open the file's pending payments. The processed date and transaction dates use a format such as 07-Oct-2026. Download source file downloads the original file.
Find payments requiring review
Open Payments Requiring Review from Reports > Bank, or use the results-page button or state cards. This shared list extends the previous Unmatched Transactions report.
Filter by Import file ID, Tenant name and Payment state, then click Apply Filter. Your selections are retained for the session when you leave and return. Reset Filter clears the saved selections and restores the pending-payment list. The print option uses the displayed filters.
Identify an unmatched tenant
Affinity tries the account number supplied in the file against the tenant's Payment Reference, then account number, then Reference.
- Find a payment marked Tenant identification required.
- Click Identify tenant.
- Search for and select the correct tenant account, select the property where required, and click Match.
- If the file's review policy applies and the tenant has outstanding fees, continue to allocation review. Otherwise, the receipt follows the normal matching and allocation process.
A payment can therefore need both steps: tenant identification first, followed by an allocation decision. Once the tenant is known, the payment is shown as Allocation required, rather than unmatched.
Allocate a payment with outstanding fees
- Click Allocate beside a payment marked Allocation required.
- Check the tenant, receipt amount, date and payment details at the top of the screen.
- Review the Current balances and Recurring charges panels. Recurring charges show the current schedule's tenant and benefit amounts, totals and rental period. They are not a preview of how this receipt will be allocated.
- In Outstanding fees, enter the amount to pay against each fee. Do not exceed a fee's unpaid balance or the total receipt amount.
- Leave all fee amounts at zero if none of the receipt should pay fees. Any remainder is allocated using the same normal recurring-charge rules as Bank > Tenant Transactions.
- Click Complete allocation. Affinity checks the balances again before completing the payment.
Fees are only paid when you explicitly allocate an amount to them. Affinity does not automatically prioritise fees simply because they are outstanding.
Use Back to review list to leave the payment pending and return later. Amounts entered on the allocation screen are not completed until you click Complete allocation.
Pending payments and corrections
A retained receipt is already included in the bank balance, but its tenant allocation is still pending. Completing the allocation does not add the bank receipt again and preserves the original payment date and reconciliation status. Do not re-import the file or enter another receipt to complete a pending payment.
Review rejected records individually and correct the reported problem. For an incorrect pending transaction, use the existing deletion controls only where appropriate and permitted. Locked or reconciled transactions remain subject to the usual restrictions.
Related guidance: Allocating Receipts to One-off Charges and Tenant Transactions – Receipts.
Comments
0 comments
Please sign in to leave a comment.