Balance due on partially paid invoices

This problem has been rattling around the forums awhile, QB does not show payments on the invoice. I finally figured out how to do it. The problem is the fields that QB selects and how it handles them on the default invoice. You and I think total means what is due to the business, but QB thinks total means what was billed and does NOT include payments.

Bring up your invoice in designer, delete the “Total” block at the bottom (click in it and hit the delete key).

Click the button “Add” and select “Data Field” use the scroll bar to select “Balance Due”.

Do it again and select “Payments/Checks”.

Move those fields to where you want them, I put them toward the bottom, with balance due last. (if you have a tear off portion on the invoice the total block must be replaced by Balance Due too)

Do a print preview to make sure things line up. The invoice will show the total of all payments in the Payments block and it will show the balance due in the balance due block.

Published in:Sales and Customers |on April 29th, 2008 |No Comments »