Here’s the scenario I have:
- Sales invoices are entered directly in Xero (a lot)
- Initial payment of 80% is received into the bank
- Second payment of 20% is later received into the bank
These payments hit the bank in one lump sum containing multiple payments from multiple customers. An excel file is then downloaded detailing all of the payments within that one lump sum, including their Xero invoice references.
I want to be able to use the Invoice Template to mark the invoices as paid by the initial 80% and then again the following month with the remaining 20%.
However, when an invoice has a payment allocated to it, DataDear won’t let me post another payment against the partially paid invoice as it can’t edit paid/partially paid invoices.
Is there a way around this? Is there another template I could use to post the invoice payments?
I have tried the Bank Transactions template which would be perfect if I could tell it which invoices the payments relate to, however this doesn’t seem to be a feature.
Effectively I need a way to record debtor payments.
Can anyone shed some light if this is possible please?
EDIT: Looking at the Xero API - I’m definitely looking at the batch payment option: https://developer.xero.com/documentation/api/batch-payments