{"id":158131,"date":"2026-10-26T09:23:04","date_gmt":"2026-10-26T09:23:04","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/settling-overpaid-invoices\/"},"modified":"2026-11-11T13:26:43","modified_gmt":"2026-11-11T13:26:43","slug":"settling-overpaid-invoices","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/","title":{"rendered":"Settling Overpaid Invoices"},"content":{"rendered":"
\n

An Overpaid<\/strong> invoice is an invoice whose total recorded payments exceed its total value. For example, if an invoice totals 1000 and has payments of 1200 recorded against it, the excess amount is 200.<\/p>\n

This guide explains why this status appears, how to find overpaid invoices, how to settle them so they become Paid<\/strong>, the difference between the two settlement options, and the effect of each on the Treasury, Journal Entries, and the client’s balance.<\/p>\n

\n
Required permissions<\/span>Permission to edit invoices and their payments, which you set up in Roles<\/strong><\/a>.<\/span><\/div>\n
How to access<\/span>Manage Invoices<\/strong><\/a> > open the overpaid invoice; the settlement window appears automatically.<\/span><\/div>\n<\/div>\n
\n

Table of Contents<\/p>\n

    \n
  1. Why an Invoice Appears as Overpaid<\/strong><\/a><\/li>\n
  2. Viewing Overpaid Invoices<\/strong><\/a><\/li>\n
  3. Steps to Settle the Invoice<\/strong><\/a><\/li>\n
  4. Settlement Options and the Differences Between Them<\/strong><\/a><\/li>\n
  5. Effect on the System<\/strong><\/a><\/li>\n
  6. Settling a Large Number of Invoices<\/strong><\/a><\/li>\n
  7. Manual Settlement from the Payment<\/strong><\/a><\/li>\n
  8. Error Messages and Solutions<\/strong><\/a><\/li>\n
  9. Avoiding Overpaid Invoices<\/strong><\/a><\/li>\n
  10. Frequently Asked Questions<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n

    Why an Invoice Appears as Overpaid<\/h2>\n\n\n\n\n\n\n
    Cause<\/th>\nExample<\/th>\n<\/tr>\n
    Editing the invoice after it was paid<\/strong><\/td>\nAn invoice was fully paid with an amount of 1000, and then an item was deleted, a quantity was reduced, or a discount was added, so its total became 800.<\/td>\n<\/tr>\n
    Recording the payment twice<\/strong><\/td>\nRecording the same payment transaction twice on the invoice.<\/td>\n<\/tr>\n
    A payment larger than the remaining amount<\/strong><\/td>\nRecording a payment of 500 on an invoice with 300 remaining.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n

    \ud83d\udec8<\/span><\/p>\n

    Note:<\/strong> An invoice is not considered overpaid if the excess is 0.03 or less, and the status is not calculated for draft invoices.<\/p>\n<\/div>\n

    Viewing Overpaid Invoices<\/h2>\n
      \n
    1. Open Manage Invoices<\/strong><\/a>.<\/li>\n
    2. Open the advanced search, and under Payment Status<\/strong>, select Overpaid<\/strong>.<\/li>\n
    3. Click Search; all overpaid invoices appear.<\/li>\n<\/ol>\n

      Steps to Settle the Invoice<\/h2>\n
        \n
      1. Open the overpaid invoice.<\/li>\n
      2. The Overpaid Invoice<\/strong> window appears automatically and displays: the invoice total, the total payments recorded against it, and the excess amount.<\/li>\n
      3. Choose one of the two options: Remove the excess amount (the amount).<\/strong> or Convert the excess amount to client credit to automatically pay new invoices.<\/strong> (Details are in the next part).<\/li>\n
      4. Click Settle<\/strong>.<\/li>\n
      5. The invoice status changes to Paid<\/strong>.<\/li>\n<\/ol>\n

        If you close the window without settling, it appears again each time you open the invoice, as long as the invoice remains overpaid.<\/p>\n

        Settlement Options and the Differences Between Them<\/h2>\n\n\n\n\n\n\n\n
        <\/th>\nRemove the Excess Amount<\/th>\nConvert the Excess Amount to Client Credit<\/th>\n<\/tr>\n
        What happens<\/strong><\/td>\nThe excess amount is deducted from the last payment on the invoice. If the payment is smaller than or equal to the excess, it is deleted, and the settlement continues with the next payment.<\/td>\nThe excess amount is separated from the invoice and becomes a payment on the client’s account that is not linked to an invoice. The invoice remains paid for its exact value only.<\/td>\n<\/tr>\n
        Amount in the Treasury or bank<\/strong><\/td>\nDecreases by the excess amount.<\/td>\nDoes not change.<\/td>\n<\/tr>\n
        Client balance<\/strong><\/td>\nDoes not change.<\/td>\nThe client has a credit balance equal to the excess amount, which is automatically used to pay their new invoices.<\/td>\n<\/tr>\n
        When to choose it<\/strong><\/td>\nIf the excess is a recording error and the client did not actually pay it, such as a duplicate payment or an amount entered by mistake.<\/td>\nIf the client actually paid the excess amount and you want to keep it on their account.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n

        \ud83d\udec8<\/span><\/p>\n

        Note:<\/strong> The settlement starts with the client credit<\/strong> payments recorded on the invoice first, then with the most recent payment by date.<\/p>\n<\/div>\n

        \n

        Example<\/p>\n

        An invoice totals 800 and has a cash payment of 1000. With Remove the excess amount<\/strong>, the payment becomes 800 and the Treasury balance decreases by 200. With Convert to client credit<\/strong>, 800 remains on the invoice, and 200 becomes a payment on the client’s account that is used on their next invoice.<\/div>\n<\/div>\n

        Effect on the System<\/h2>\n\n\n\n\n\n\n\n\n\n
        Area<\/th>\nRemove the Excess Amount<\/th>\nConvert to Client Credit<\/th>\n<\/tr>\n
        Invoice<\/strong><\/td>\nBecomes paid.<\/td>\nBecomes paid.<\/td>\n<\/tr>\n
        Payments<\/strong><\/td>\nThe payment is adjusted or deleted.<\/td>\nThe payment is split: one part applies to the invoice, and the other becomes a payment on the client’s account.<\/td>\n<\/tr>\n
        Journal Entries<\/strong><\/td>\nThe payment’s Journal Entry is adjusted or deleted.<\/td>\nThe payment’s Journal Entries are updated according to the split.<\/td>\n<\/tr>\n
        Treasury<\/strong><\/td>\nIts balance decreases by the excess amount.<\/td>\nNo change.<\/td>\n<\/tr>\n
        Client Statement<\/strong><\/td>\nPayments decrease by the overpaid amount.<\/td>\nThe overpaid amount appears as a credit balance for the client.<\/td>\n<\/tr>\n
        Activity Log<\/strong><\/td>\nThe payment edit or deletion is recorded.<\/td>\n\u2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Settling Many Invoices<\/h2>\n

        Currently, there is no action to settle all overpaid invoices with one click; you settle each invoice individually. To speed up the process:<\/p>\n

          \n
        1. Display the overpaid invoices from Payment Status<\/strong>, as described in Viewing Overpaid Invoices<\/strong><\/a>.<\/li>\n
        2. Open the first invoice, select the appropriate option, and click Settle<\/strong>.<\/li>\n
        3. Go back to the list and repeat with the next invoice until you reach the end of the list.<\/li>\n<\/ol>\n

          Settling Manually from the Payment<\/h2>\n

          Instead of using the settlement window, you can open the overpayment from the Payments section of the invoice and edit its amount or delete it. This is useful when you want to choose a specific payment yourself instead of the last payment.<\/p>\n

          Error Messages and Solutions<\/h2>\n\n\n\n\n\n
          Message That Appears<\/th>\nCause<\/th>\nSolution<\/th>\n<\/tr>\n
          You cannot add, edit, or delete a transaction on this day (date), within a closed period<\/strong><\/td>\nThe invoice date falls within a closed period.<\/td>\nReopen the closed period or ask the accountant to do so, then settle the invoice.<\/td>\n<\/tr>\n
          You must select an option<\/strong><\/td>\nYou clicked Settle without selecting either option.<\/td>\nSelect one of the two options, then click Settle<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Avoiding Overpaid Invoices<\/h2>\n
            \n
          • To reduce the value of a paid invoice, issue a Credit Note<\/strong> or a Return<\/strong> instead of editing its items.<\/li>\n
          • Check the remaining amount on the invoice before you Add Payment<\/strong>.<\/li>\n
          • If the client pays more than the invoice amount, record the excess as a payment to the client’s account instead of adding it to the invoice.<\/li>\n<\/ul>\n

            Frequently Asked Questions<\/h2>\n

            How do I settle all overpaid invoices with one click?<\/h3>\n

            Currently, there is no bulk action. Display the overpaid invoices from Payment Status<\/strong>, and settle each invoice from the settlement window that appears when you open it.<\/p>\n

            Which option should I choose?<\/h3>\n

            If the excess amount is a recording error, choose Remove the excess amount<\/strong>. If the client actually paid it, choose Convert to client balance<\/strong>.<\/p>\n

            Does the settlement affect the Treasury?<\/h3>\n

            If you remove the excess amount, the Treasury balance decreases by the excess. If you convert it to the client balance, the Treasury balance does not change.<\/p>\n

            Where can I find the amount converted to the client balance?<\/h3>\n

            It appears in the Client Statement as a credit balance, and it is automatically used to pay the client’s new invoices.<\/p>\n

            Why doesn’t the settlement window appear?<\/h3>\n

            Because the invoice is a draft, or because the excess is 0.03 or less.<\/p>\n

            Why does the window appear every time I open the invoice?<\/h3>\n

            Because the invoice is still overpaid, settle it so that it disappears.<\/p>\n<\/div>\n","protected":false},"author":38,"featured_media":0,"template":"","categories":[2149,2155,2151],"tags":[30147,30153,30152,30151,30146,30155,30154,21275,30150,30149,30148,30145],"class_list":["post-158131","tutorial","type-tutorial","status-publish","hentry","category-invoices-and-estimates","category-sales-invoice","category-invoices-operations","tag-convert-excess-amount-to-customer-balance","tag-customer-balance","tag-duplicate-payment","tag-excess-payment","tag-invoice-overpaid","tag-overpaid-en","tag-overpaid-invoice","tag-payment-status-en","tag-reconcile-all-overpaid-invoices","tag-reconcile-overpaid-invoices","tag-reconciliation","tag-remove-excess-amount"],"yoast_head":"\nSettling Overpaid Invoices - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Settling Overpaid Invoices - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"An Overpaid invoice is an invoice whose total recorded payments exceed its total value. For example, if an invoice totals 1000 and has payments of 1200 recorded against it, the excess amount is 200. This guide explains why this status appears, how to find overpaid invoices, how to settle them so they become Paid, the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-11T13:26:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/\",\"name\":\"Settling Overpaid Invoices - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2026-10-26T09:23:04+00:00\",\"dateModified\":\"2026-11-11T13:26:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Settling Overpaid Invoices\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Settling Overpaid Invoices - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/","og_locale":"en_US","og_type":"article","og_title":"Settling Overpaid Invoices - Daftra Knowledge Base","og_description":"An Overpaid invoice is an invoice whose total recorded payments exceed its total value. For example, if an invoice totals 1000 and has payments of 1200 recorded against it, the excess amount is 200. This guide explains why this status appears, how to find overpaid invoices, how to settle them so they become Paid, the […]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-11T13:26:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/","name":"Settling Overpaid Invoices - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2026-10-26T09:23:04+00:00","dateModified":"2026-11-11T13:26:43+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/settling-overpaid-invoices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Settling Overpaid Invoices"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/38"}],"version-history":[{"count":2,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158131\/revisions"}],"predecessor-version":[{"id":158133,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158131\/revisions\/158133"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=158131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=158131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=158131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}