[Solved] Why do my Membership Due Dates look inconsistent when I generate invoices?
The Problem
If you notice that your membership invoices have different Due Dates, it is usually because the system calculated them based on the day the invoice was actually generated, rather than the billing period.
The Solution
To ensure all invoices in a run have the same Due Date (e.g., Billing Date + Payment Term), you must adjust your Invoice settings before clicking "Send."
How to set consistent Due Dates:
When generating your LIVE invoices, use the following configuration in the Invoice Run settings:
Option 1: Due Dates based on Bill From Date: This will force the system to use the billing/invoice line's Bill From Date plus your Payment term.
- Due Date on: Select "Bill From Date"
-
Overwrite Existing Due Date: Set to "YES" ▶︎ This is critical. It forces the system to update the individual Billing Lines, and overwrite any existing Due Date.
-
This setting will only have affect when you generate LIVE emails.
-
DRAFT invoices will show the new Due Dates but they won't be saved to the Billing Line.
-
Option 2: Due Dates based on Invoice Date: The system will use the selected Invoice Date plus your Payment term.
- Due Date on: Select "Invoice Date"
-
Invoice Date: Set this as the the date you want to appear on the invoice. Billing Line reflect this date + the payment terms for each line's Due Date.
-
Overwrite Existing Due Date: Set to "YES"
💡 Pro-Tip: If you select "Invoice Date" instead of "Bill From Date," any invoices sent on different days (or even different times) may result in staggered Due Dates. Stick to "Bill From Date" for standard recurring billing.
