Hi Alleah,
Let me help to break it down for you.
I try to reproduce your case, please let me know if it's correct.
- You have a bill, let's call it as BILL/2025/03/0001 as below. It's "IN PAYMENT" because you already added a Payment below.
- You have 3 bank statement lines that you received from your bank as below
- Now, you want to net off between point 3 with 2 and you want the third with the bill
The proper way (or at least the way that I do for my clients and company) is to create Payments as many as your bank statement lines. Now, you only have one which already be added to the Bill - you need to "Unreconcile" this.
Follow the steps below: we will settle the bill and net off last
- "Unreconcile" the payment on the BILL
- Create a new Payment from the BILL with the new date. Mine is 03/03/2025
- Your bill should be back to "IN PAYMENT" state. At this state, you have 3 bank statement lines and 2 payment to vendor registered.
- Let's settle your BILL first, I believe you know how to reconcile a payment. Just go back to your Reconciliation dashboard. Select the pairs, make sure you reconcile on the right dates.
- Now, create another payment through Accounting > Vendors > Payments
- Change the type to "Receive" instead of "Send". Fill the date, partner, and amount. On my case is the 02/03/2025 for Ready Mat with amount USD 6,596.4
- Now let's go back to reconciliation and wrap things up there.
- Reconcile between first payment and refund payments. Follow the steps on how we reconcile the BILL
In the end this should be your final results.
Hope this helps.
Hope this helps
Thanks very much Andry!