Payment terms specify how long an invoice may remain unpaid. NET30, NET60, and similar labels become due-date calculations attached to transaction records. section 7.4
Use payment terms in an accounts-receivable transformation workflow:
- Read the term label from each transaction, such as NET30 or NET60. section 7.4
- Apply the corresponding number of business days to the transaction date rather than counting calendar days. section 7.4 section 7.5
- Use the resulting due dates for payment forecasting, aging analysis, and collection prioritization. section 7.4
Transaction-level due dates
A transaction dated 2025-01-31 with terms NET30 should receive a due date calculated 30 business days after its transaction date. A second transaction marked NET60 uses 60 business days. section 7.4
Listing 7.9 Python - Time Series and Date-Time Transformations
transactions = [
{"account": "A001", "transaction_date": "2025-01-31T16:00:00Z", "terms": "NET30", "amount_due": 1200},
{"account": "A001", "transaction_date": "2025-02-28T12:45:00Z", "terms": "NET60", "amount_due": 800},
{"account": "A001", "transaction_date": "2025-03-15T09:30:00Z", "terms": "NET30", "amount_due": 1500},
{"account": "A001", "transaction_date": "2025-06-01T11:00:00Z", "terms": "NET15", "amount_due": 950},
{"account": "A001", "transaction_date": "2025-07-04T10:00:00Z", "terms": "NET30", "amount_due": 700},
{"account": "A002", "transaction_date": "2025-01-10T14:00:00Z", "terms": "NET45", "amount_due": 300},
{"account": "A002", "transaction_date": "2025-02-12T08:30:00Z", "terms": "NET30", "amount_due": 600},
{"account": "A002", "transaction_date": "2025-03-29T17:15:00Z", "terms": "NET60", "amount_due": 1100},
{"account": "A002", "transaction_date": "2025-04-20T13:00:00Z", "terms": "NET30", "amount_due": 950},
{"account": "A002", "transaction_date": "2025-06-15T07:00:00Z", "terms": "NET30", "amount_due": 800},
{"account": "A003", "transaction_date": "2025-03-01T18:30:00Z", "terms": "NET30", "amount_due": 400},
{"account": "A003", "transaction_date": "2025-04-01T09:00:00Z", "terms": "NET90", "amount_due": 2500},
{"account": "A003", "transaction_date": "2025-05-15T11:30:00Z", "terms": "NET30", "amount_due": 600},
{"account": "A003", "transaction_date": "2025-07-01T08:00:00Z", "terms": "NET60", "amount_due": 1000},
{"account": "A003", "transaction_date": "2025-08-05T16:45:00Z", "terms": "NET30", "amount_due": 750},
{"account": "A004", "transaction_date": "2025-02-20T15:00:00Z", "terms": "NET15", "amount_due": 900},
{"account": "A004", "transaction_date": "2025-03-15T10:45:00Z", "terms": "NET30", "amount_due": 850},
{"account": "A004", "transaction_date": "2025-04-10T14:15:00Z", "terms": "NET45", "amount_due": 1200},
{"account": "A004", "transaction_date": "2025-06-30T09:00:00Z", "terms": "NET30", "amount_due": 1000},
{"account": "A004", "transaction_date": "2025-09-01T13:20:00Z", "terms": "NET60", "amount_due": 1300}
]
Browse the transaction fixtures containing account identifiers, timestamps, balances, and NET payment-term labels. section 7.4
Listing 7.10 Python - Time Series and Date-Time Transformations
import pandas as pd #A
from pandas.tseries.offsets import BDay #A
import pytz #A
from datetime import datetime #A
# Load transaction data into a DataFrame #A
df = pd.DataFrame(transactions) #A
df["transaction_date"] = pd.to_datetime(df["transaction_date"], utc=True) #A
# A: Plain date without time #B
df["date_only"] = df["transaction_date"].dt.date #B
# B–D: Timestamps converted to PST, EST, and GST respectively #B
df["timestamp_pst"] = df["transaction_date"].dt.tz_convert("US/Pacific") #B
df["timestamp_est"] = df["transaction_date"].dt.tz_convert("US/Eastern") #B
df["timestamp_gst"] = df["transaction_date"].dt.tz_convert("Asia/Dubai") #B
# E: Extracted month and year for reporting breakdowns #B
df["month"] = df["transaction_date"].dt.month #B
df["year"] = df["transaction_date"].dt.year #B
# F: Custom fiscal quarter based on internal calendar (Q1 = Feb–Apr) #C
def get_fiscal_quarter(date): #C
fiscal_month = (date.month - 1) % 12 + 1 #C
if fiscal_month in [2, 3, 4]: return "Q1" #C
elif fiscal_month in [5, 6, 7]: return "Q2" #C
elif fiscal_month in [8, 9, 10]: return "Q3" #C
else: return "Q4" #C
df["fiscal_quarter"] = df["transaction_date"].apply(get_fiscal_quarter) #C
# 2: Due date calculation using business days only #D
def get_due_date(row): #D
term_days = int(row["terms"].replace("NET", "")) #D
return row["transaction_date"] + BDay(term_days) #D
df["due_date"] = df.apply(get_due_date, axis=1) #D
# 3: Percent contribution of each transaction to its account's total balance #E
account_totals = df.groupby("account")["amount_due"].transform("sum") #E
df["contribution_pct"] = (df["amount_due"] / account_totals * 100).round(2) #E
# Display key columns for verification #F
display(df)
Browse the pandas transformation listing that prepares transaction dates and imports business-day arithmetic support. section 7.4
