Getting the Correct End-of-Month Billing Date in Certinia

One blank field is the reason your December billing date shows the 30th instead of the 31st.

Have you ever generated a Billing Schedule in Certinia and noticed the billing date is just... off? Not wildly off — just one day short of where it should be. December shows 30-Dec instead of 31-Dec. It looks like a rounding error, but it's not. Here's what's actually happening, and the two-minute fix.

The Problem

While creating a Billing Schedule from a Billing Contract Line Item, the Billing Date wasn't landing on the actual end of the month. For example, for December 2025, the schedule showed a billing date of 30-Dec-2025 instead of the correct 31-Dec-2025.

It's a small discrepancy on paper, but in billing, a one-day-off date can throw off proration, revenue recognition timing, and reconciliation against the contract terms.

The Root Cause

The culprit is a single field on the Billing Contract Line Item: Recurring Billing Term.

When this field is left blank (null), Certinia has no explicit instruction for how to calculate the end of each billing period — so it doesn't default to the actual calendar end-of-month date. The result is a billing date that's consistently a day short of where it should land.

The Fix

Set the Recurring Billing Term field on the Billing Contract Line Item to Soft End Date. Once that value is set, any Billing Schedule generated from that line item afterward will correctly calculate the billing date as the true end of the month.

Prevention Checklist

Before generating a Billing Schedule, it's worth confirming:

• Recurring Billing Term is populated on the Billing Contract Line Item (not left blank)
• Recurring Billing Term is set to Soft End Date where end-of-month billing is expected
• Generated billing dates are spot-checked against the calendar, especially for months with 30 vs. 31 days

Adding this to your Billing Contract Line Item setup checklist prevents a whole category of "why is my invoice date wrong" tickets later.

The Takeaway

A billing date that's one day short of month-end almost always traces back to a blank Recurring Billing Term field. Set it to Soft End Date, and Billing Central handles the rest correctly.

Part of an ongoing series on real-world Certinia Account Management issues and fixes.