Setting Invoice Total Due to Match Invoice Payments Made (negative Balance Due)

In some cases when an invoice has a negative Balance Due, you have actually collected funds correctly and need to adjust the invoice Total Due to match the Payments Made rather than using the Zero Balance function (which changes the Payments Made to match the Total Due--See above).

 

Follow the steps below--they are a little cumbersome, but they get the job done.

 

  1. Begin with a negative balance Paid invoice, such as the one shown below:

    inv00098.jpg


    In this case we actually collected $150, so want to edit the invoice to change the Total Due to $150.00.

  2. Click the "Mark as Unpaid" link in the top Action menu.
    NOTE: You cannot edit an invoice with a "Paid" Status, so we need to mark the invoice as unpaid in order to change it.

  3. You are returned to the Invoices table. The invoice Status is now "Unpaid" and the Balance is $100.00.

    inv00098-up.jpg
  4. Select "Edit invoice" from the Action button menu to open the invoice in edit mode.

    00098-edit.jpg
  5. With the invoice open, click "add another line" in the Goods and Services section.

    00098-aal.jpg
  6. Add an Invoice Balancing Item to the invoice. (Alternately, you can simply edit the Price of an Item to the desired amount. If you do this, go to step 8.)
    NOTE: These steps assume you do not have an Invoice Balancing Item saved. If you do, go to step 7.

    1. Select "Add New Item" from the Name drop-down box.

    2. In the Add Goods & Services modal, enter "Invoice Balancing" as the Item name, include a Description, and enter a holding Price of $1.00)

      add-ib.jpg
    3. Click the "save and select" button.

  7. The Invoice Balancing Item is now added to the invoice. In the Price field, enter the adjustment amount. In this example, we are adding $50 to the invoice in order to get a Total Due of $150.00.

    00098-edited.jpg
  8. Click the "save and re-send" button to save the invoice. Then on the Collect Invoice Send Options screen, click the "send invoice" button.

  9. You are returned to the Invoices table, with the Invoice Status set to "Unpaid," the Amount set to $150, and the Balance set to $150.

    inv00098-2.jpg
  10. Select "Mark as Paid" from the Action button menu, and in the modal leave the "Full amount" radio button selected and click "submit."

    inv00098-map.jpg
  11. The invoice Status updates to "Paid" and there is again a negative Balance. (Don't worry, we're about to fix that.)

    inv-00098-paidn.jpg
  12. Click the linked Inv.# to open the invoice.

  13. Click "zero balance" in the top Action navigation bar.

    inv00098-zb.jpg
  14. You are returned to the Invoices table, and the invoice now has a Balance of $0.

    inv-00098-matched.jpg
  15. When you view the invoice, it now reflects the desired Total Due, Payments Made, Balance Due, and Status, as well as the Invoice Balancing Item (if used).

    inv-00098-2.jpg

 

Next Section: Managing Recurring Invoices >