liveBook · Manning

Payment terms

As explained in Learn AI Data Engineering

Net payment terms specify the number of days allowed between an invoice and its required payment date.

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

How Learn AI Data Engineering covers it

How deep it goes
Works through business-day due-date calculations from NET labels without specifying broader payment-policy rules.
Examples
Uses NET15, NET30, NET45, and NET60 labels in transaction records with dates and outstanding balances.
What it assumes
Assumes transaction records contain dates, payment-term labels, and balances while introducing business-day due-date calculations.
What you can do after
Apply it via Python and pandas to calculate business-day due dates in transaction data.
How it connects
Connects payment terms with accounts receivable, business days, time series transformations, fiscal calendars, and aging analysis.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Learn AI Data Engineering. The section links point to the parts of the book it draws on.