OK, a variation on the old split-payments question…
I sell cycle tours. Normally when someone books for a tour I generate an invoice for a deposit payment, email it to them, and they pay it - sometimes by bank transfer, sometimes via the Stripe integration. I will hold their place on the tour for up to two weeks without payment, so the due date on the deposit invoice is always ‘two weeks from today’.
I use project tags to help me analyse the profitability of each tour and to monitor outstanding payments for a given tour, and so that my independent trustee has a clear overview of who’s paid what for which tour. So each invoice has a project tag tying it to the right tour. (To meet government regs, there is a trust fund that contains enough money for the trustee to reimburse customers should my company become insolvent before they get their tours.)
Now, I have a client who’s booked for three tours and to make things simple for him I’d like to send him one invoice for all three deposits so that he just has to make one payment. However I can’t allocate specific project codes to individual items on a single invoice.
So the most obvious way I can think of to do this is…
- Create separate invoices for each deposit, mark them as sent but don’t send them to the client.
- Create a new invoice for the full amount (call it the combined deposits invoice).
- Send him the combined deposits invoice.
- He pays it via the Stripe link, so the payment gets automatically allocated to the combined deposits invoice.
- I delete the combined deposits invoice, but not the associated payment (I think that’s possible?).
- I allocate the payment to his account as a ‘prepayment held on account’.
- I use that prepayment on account to pay off each of the individual deposit invoices.
Would that work? Have I missed an easier way? I don’t entirely like it because until I do steps 5-7 it looks in the accounts as if he owes me twice as much as he really does.
I think this also works if he pays via bank transfer - in fact it should be easier for me as the payment and the combined invoice don’t automatically get matched up.
Thanks