I suggest you ...

API Overpayments & Prepayments

See the latest comments on this below

202 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    xeroAdminxero (Admin, Xero) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    daviddavid shared a merged idea: Creating unallocated payments  ·   · 
    started  ·  xeroAdminxero (Admin, Xero) responded  · 

    The BankTransactions endpoint now supports creating overpayments and prepayments – see http://developer.xero.com/documentation/api/banktransactions/#title7

    Note – The ability to allocate an over/payment to an invoice will be supported in a future release. This request will be kept open until this task is finished.

    The Invoices endpoint will also be improved in a future release to make it easier to identify when an over/prepayment is applied to an invoice.

    If you can now do what you need with over/prepayments, consider moving your vote(s) to another request.

    25 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • LorelleLorelle commented  ·   ·  Flag as inappropriate

        Could you please update the status of this issue?
        The comment thread seems to begin a very long time ago and as yet it is still to be completed?

      • Andy HuntAndy Hunt commented  ·   ·  Flag as inappropriate

        Any update on when it will be possible to allocate overpayments to invoices via the API?

      • Anonymous commented  ·   ·  Flag as inappropriate

        desperately need the feature of allocating pre-payments..... in the .net wrapper library would be a huge help also
        Many thanks
        Marcus

      • MartinMartin commented  ·   ·  Flag as inappropriate

        Thanks let us know when this will be implemented - don't know how this is not enabled.

        What if a customer wants to settle bulk invoices with one payment?

      • John MaceyJohn Macey commented  ·   ·  Flag as inappropriate

        This functionality is definitely required. Occassionally it is necessary to post an overpayment made by an account customer. Pre payments are part of the hospitality industry for functions and accommodation.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Can we do payment for a customer who does not have an invoice yet?
        And once the invoice is created, apply the above payment to this invoice.

        Is this possible from the API?

      • Ali Ali commented  ·   ·  Flag as inappropriate

        We want a comment from Xero on what is holding this up, as this was suggested by xero admin in the first place!!

      • Jayd LawrenceJayd Lawrence commented  ·   ·  Flag as inappropriate

        Also, when adding an invoice, you could use Prepayment tags and specify invoice_id of the prepayment item, and the amount of credit to use from that prepayment, or an option to use all available prepayment credit up to the amount of the current invoice.

      • Jayd LawrenceJayd Lawrence commented  ·   ·  Flag as inappropriate

        We really need Prepayments to work using the API.
        We are looking at other Accounting Software solutions, just because of this feature.

        As far as how the API might work.

        You can make it work exactly like the Payments just with a contact id field.

        The invoice number passed would be the one used for the new prepayment entry, the contact would be the one applied to and then the other fields that are in payments.

      • Mike RicksonMike Rickson commented  ·   ·  Flag as inappropriate

        We really need this ability too as we run a similar setup to Aaron Geiser.

        At the very least could the Overpayment appear in the same way that Payments and Credit Notes appear when GETing an invoice. At least then we have some way of knowing that the Overpayment exists.

      • Aaron GeiserAaron Geiser commented  ·   ·  Flag as inappropriate

        This one is becoming very important to me. I am currently accepting prepayments from my clients and this is the only part of the API that is missing from my current workflow.

        I am using WHMCS as a billing engine and synchronizing invoices, payments, and credits via a custom script. I want to be able to flag an invoice as a pre-payment and use the Xero API to automatically apply the invoice payment as such and disregard the actual invoice in WHMCS.

        Right now I have to manually void the prepayment invoice and then go in and manually record a prepayment - then reconcile the bank statement against the prepayment. It's pretty cumbersome.

      • RobRob commented  ·   ·  Flag as inappropriate

        Any further progress on this?

        Currently all of the invoice generation is done our side, which we then push to Xero. This is because we have dynamic renewal dates added at the bottom of the line items, that Xero did not support when we were first setup.

        We would like to be able to download overpayments that are assigned to invoices, so that we can add these to regular payments and show our staff and customers whether an invoice is paid, partly paid or due in full.

        I hope there is some movement on this soon as we raised queries back in October '12.

      • Ali Ali commented  ·   ·  Flag as inappropriate

        I have two scenarios that require this:

        1. Customers usually pay me through my bank's cash deposit machines. Since the machine doesn't accept all denominations, they often overpay and receive a refund at the time of delivery.

        2. I get multiple orders for the same customer. They make one deposit rather than two. The way I would get that into Xero is to apply the whole amount to the first invoice, and then manually allocate the remainder to the second invoice.

      • M1keM1ke commented  ·   ·  Flag as inappropriate

        For a skydiving centre: we want to take a deposit on booking, followed by a balance payment when the participant attends the centre. Because skydiving is weather dependent the customer may not jump on first attendance; we only want the invoice approved (and marked as paid) once the customer has carried out their jump.

        We originally planned to use pre-payments, then decided to edit lineitem account codes to produce the same effect, but found that cannot be done either. So either add prepayments or let LineItem codes be changed, as in the main interface, through the API.

      • Aaron GeiserAaron Geiser commented  ·   ·  Flag as inappropriate

        This feature seems like it's pretty closely tied to the credit notes request.

        http://xero.uservoice.com/forums/5528-xero-api/suggestions/874335-credit-notes-apply-as-invoice-payment-refund

        Use case #1:
        1. Customer needs a refund
        2. Create credit memo for customer
        3. Create "Credit memo payment" originating from bank account

        Use case #2:
        1. Customers pay a consulting retainer or prepays for support hours
        2. Create credit memo for customer
        3. Create invoices for customer as consulting services are rendered
        4. "Allocate credit" towards invoices (instead of issuing an invoice payment)

        Use case #3:
        1. Customer overpays an invoice
        2. Issue credit memo for the customer
        3. Create "Credit memo payment" originating from bank account

      ← Previous 1

      Feedback and Knowledge Base