This is how to reconcile some incoming council payments that also deducts a refund for another tenant.

• Create all rent payments from the relevant lease page. Make sure to insert same date and account that the payment was paid out to you by the council.
• Open the lease page for the tenant that was refunded.
• Create a refund with the same date and account as the council payment.
• Once the refund is created, you can apply the previous overpayment to the refund so they settle each other. (You can apply a payment to a refund the same way you apply it to any invoice)
• Under Banking, find the bulk council payment.
• Next to the payment, click the search dropdown and select Batch Payment.
• Under the Existing Payment dropdown select all the payments and the refund that you've just created. (Make sure to select the outgoing payments first, then the incoming payments).
• The total payment amount should now match the bank amount.
• Click Save.