PythonBeginner
Age outstanding invoices
Bucket outstanding balances by days past their due dates relative to an explicit date.
Business utilities
25 practical automations
Business utilities
Make inventory, expenses, and office work simpler. Each guide includes full code, usage instructions, and ideas for making it your own.
Search this category ↗PythonBeginner
Allocate a shared expense by weights
Divide an explicit total among named participants using their supplied positive weights.
Business utilities
PythonBeginner
Allocate overhead by usage driver
Distribute a supplied overhead amount across groups in proportion to a numeric driver.
Business utilities
PythonBeginner
Audit inventory SKU identifiers
Find blank, repeated, and case-only duplicate product identifiers.
Business utilities
PythonBeginner
Audit user-defined break thresholds
Flag shifts exceeding your chosen duration without your chosen minimum recorded break.
Business utilities
PythonBeginner
Build an inventory reorder list
Calculate units needed to bring low-stock products up to their configured target.
Business utilities
PythonBeginner
Calculate invoice line totals
Calculate invoice subtotals from quantity, unit price, and explicit line discount percentages.
Business utilities
PythonBeginner
Calculate mileage reimbursement
Multiply recorded distances by a rate explicitly chosen by the user.
Business utilities
PythonBeginner
Calculate product gross margins
Compare unit selling prices with supplied unit costs and sales quantities.
Business utilities
PythonBeginner
Calculate project time costs
Calculate recorded time value using each row’s explicit project rate and billable flag.
Business utilities
PythonBeginner
Compare assigned work with capacity
Show remaining or excess hours from explicitly supplied person-level capacity figures.
Business utilities
PythonBeginner
Compare budget with actual expenses
Total actual expenses by category and compare them with a separate budget CSV.
Business utilities
PythonBeginner
Compare discount scenarios
Show how explicit discount percentages affect unit contribution and total gross profit.
Business utilities
PythonBeginner
Compare supplier basket quotes
Total a quoted item basket and add one stated shipping charge per supplier.
Business utilities
PythonBeginner
Consolidate purchase requests
Combine quantities for identical item-and-unit pairs from multiple requests.
Business utilities
PythonBeginner
Estimate break-even units
Calculate units needed to cover supplied fixed costs from positive unit contribution.
Business utilities
PythonBeginner
Estimate pay with configured overtime
Apply your explicit regular-hour threshold and overtime multiplier to aggregate hours.
Business utilities
PythonBeginner
Estimate stock coverage
Estimate remaining stock days from each product’s user-supplied daily usage.
Business utilities
PythonBeginner
Find invoice sequence gaps
Report missing integer sequence numbers between the minimum and maximum supplied numbers.
Business utilities
PythonBeginner
Reconcile invoice payments
Compare invoice amounts with payments linked by invoice ID and flag unmatched payment IDs.
Business utilities
PythonBeginner
Summarize expense categories
Count expense records and sum amounts for each exact category.
Business utilities
PythonBeginner
Summarize invoices by client
Total invoiced, paid, and outstanding amounts for each supplied client name.
Business utilities
PythonBeginner
Summarize stock movements
Add signed quantity changes per SKU and flag negative running balances.
Business utilities
PythonBeginner
Summarize timesheet hours
Total shift durations minus explicit unpaid breaks by person.
Business utilities
PythonBeginner
Value an inventory snapshot
Multiply each product quantity by its supplied unit cost and total the result.
Business utilities