Label a payment adjustment

A payment adjustment can be about an earlier payment. Label it on its own line.

What you'll make

In Excel: -25.00 + Recovery becomes Payment-level adjustment: -25.00; Recovery.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1ISNUMBER(A8)Checks that the amount is a real number.TRUE
2"Payment-level adjustment: "&TEXT(A8,"0.00")Writes the label and the amount with two decimals."… adjustment: -25.00"
3&"; "&Adds a semicolon and a space."…: -25.00; "
4IF(B8="","reason not supplied",B8)Adds the reason, or reason not supplied."…; Recovery"
5IF( … )Says not supplied when there's no amount, else uses parts 2 to 4."…: -25.00; Recovery"

Read it left to right. The amount is only labeled, never added to anything. All amounts are made-up.

=IF(ISNUMBER(A8),"Payment-level adjustment: "&TEXT(A8,"0.00")&"; "&IF(B8="","reason not supplied",B8),"Payment-level adjustment not supplied")

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own list. Paste each payment adjustment amount and its reason into the green columns of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Keep this off the patient's bill. An adjustment can recover an earlier payment, not a new charge.

Microsoft's help: TEXT function