James Allman | JA Technology Solutions LLC
Free Tools
Practical tools for developers, IT professionals, and business systems teams. Everything runs in your browser — no signup, no uploads, no data leaves your machine.
Banking, accounting, healthcare, payments, and EDI file formats. See category page →
QuickBooks Explorer
Explore and create QuickBooks Desktop QB IIF and QuickBooks Online CSV files. Parse, validate, convert, and generate — all in your browser.
Data & FinanceBAI2 File Explorer
Parse BAI2 bank statement files into structured views with type code lookup, transaction details, and CSV export.
Data & FinanceNACHA/ACH File Explorer
Parse ACH payment files into readable records. View entries, totals, and export to CSV or JSON.
Data & FinancePositive Pay Generator
Generate Positive Pay fraud prevention files from check data. Chase, BofA, Wells Fargo, and generic formats.
Data & FinanceBAI2 File Generator
Generate BAI2 bank statement test files with configurable accounts, transactions, and auto-calculated control totals.
Data & FinanceOFX/QFX Explorer
Parse OFX and QFX bank statement files. View account info, transactions, and balances. Export to CSV.
Data & FinanceSWIFT MT Explorer
Parse SWIFT MT financial messages (MT103, MT940, MT700). Block structure, field lookup, and transaction tables.
Data & FinanceBusiness Day Calculator
Count business days between dates or add/subtract business days. Includes US holiday awareness and payment term shortcuts.
Data & FinanceDepreciation Calculator
Calculate asset depreciation schedules using straight-line, declining balance, sum-of-years-digits, or MACRS methods.
Data & FinanceCheck Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceLanded Cost Calculator
Compute per-unit landed cost with freight, duty, insurance, and fees — single SKU or multi-line shipment.
Shipping & LogisticsEDI File Parser
Upload or paste any EDI file — parsed into labeled segments with export to CSV, JSON, and SIL.
Retail & POSEDI 810 Invoice Builder
Enter invoice details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 810 invoice ready to submit to a trading partner.
Retail & POSEDI 850 Purchase Order Builder
Enter PO details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 850 purchase order ready to send to a supplier.
Retail & POSEDI 856 Advance Ship Notice Builder
Build a valid X12 EDI 856 advance ship notice — nested HL shipment/order/item loops, carrier and BOL details, and one-click pre-fill from a prior 850.
Retail & POSEDI 997 Functional Acknowledgment Builder
Paste any inbound X12 document — the tool lists each transaction set so you can mark it accepted or rejected, then download a valid 997 ready to transmit.
Data & FinanceEDI 855 Purchase Order Acknowledgment Builder
Paste the inbound 850 — the tool pre-fills every line as accepted, then you mark the ones that change quantity, price, or ship date, or reject the ones you can't fulfill.
Retail & POSEDI 820 Remittance Advice Builder
Tell the payee which invoices you're paying. Load 810s to populate invoice entries, set action codes and amounts, and download a valid 820.
Data & FinanceX12 Segment Reference
Searchable EDI X12 segment and element dictionary with 43 segments, 27 transaction sets, and qualifier codes.
Data & FinanceHL7 Message Explorer
Parse HL7 v2.x healthcare messages with segment descriptions, field labels, and message type identification.
Data & FinanceFHIR Resource Explorer
Parse HL7 FHIR JSON resources with resource-specific rendering. Supports Patient, Observation, Bundle, and more.
Data & FinanceISO 8583 Explorer
Parse ISO 8583 payment card messages with MTI breakdown, bitmap visualization, and data element parsing.
Data & FinanceCSV & Delimited Text Converter — CSV, TSV, Pipe, Excel
Convert CSV, TSV, pipe-delimited, custom-delimiter text, and Excel files into CSV, TSV, pipe, JSON, JSONL, Excel, YAML, XML, Markdown table, HTML table, or SQL INSERT statements.
Data & FinanceFixed-Width ↔ CSV
Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.
Data & FinanceFile Compare & Merge
Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.
DevelopmentParquet File Explorer
View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.
Data & FinanceExcel Converter
Convert Excel workbooks to CSV, JSON, XML, and 8 other formats. Multi-sheet picker, Force Text columns.
Data & FinanceIBAN Validator
Validate IBAN check digits and decode country and BBAN structure using the ISO 13616 mod-97 algorithm.
Data & FinanceAmortization Calculator
Calculate loan amortization schedules with monthly payment, principal/interest breakdown, and extra payment analysis.
Data & FinanceMICR Line Decoder
Parse the MICR E-13B line from a check to extract routing number, account number, check number, and amount.
Data & FinanceCard Number Validator
Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.
Data & FinanceCSV to SQL Generator
Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.
DevelopmentGS1 Application Identifier Parser
Parse GS1-128 and DataMatrix Application Identifier strings into structured, human-readable fields with validation.
Retail & POSShrink & Waste Calculator
Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.
Retail & POSBarcodes, POS files, retail math, and fiscal calendars. See category page →
Check Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceBarcode Explorer
Generate, scan, and decode barcodes in 15+ formats. Camera scanning, image upload, batch detection, and CSV export.
Retail & POSMargin & Markup Calculator
Convert between margin %, markup %, cost, and selling price. Includes profit calculation and reference table.
Retail & POSRetail Fiscal Calendar (4-5-4)
Map any date to its NRF 4-5-4 retail fiscal year, quarter, period, and week number.
Retail & POSSIL File Explorer
Parse SIL (Standard Interchange Language) files into structured tables with CSV and JSON export.
Retail & POSEDI File Parser
Upload or paste any EDI file — parsed into labeled segments with export to CSV, JSON, and SIL.
Retail & POSEDI 810 Invoice Builder
Enter invoice details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 810 invoice ready to submit to a trading partner.
Retail & POSEDI 850 Purchase Order Builder
Enter PO details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 850 purchase order ready to send to a supplier.
Retail & POSEDI 856 Advance Ship Notice Builder
Build a valid X12 EDI 856 advance ship notice — nested HL shipment/order/item loops, carrier and BOL details, and one-click pre-fill from a prior 850.
Retail & POSEDI 855 Purchase Order Acknowledgment Builder
Paste the inbound 850 — the tool pre-fills every line as accepted, then you mark the ones that change quantity, price, or ship date, or reject the ones you can't fulfill.
Retail & POSGS1 Application Identifier Parser
Parse GS1-128 and DataMatrix Application Identifier strings into structured, human-readable fields with validation.
Retail & POSMeat Cutting Test Calculator
Calculate cutting test yields, cost allocation, and pass/fail against target yields for beef, pork, and poultry primals.
Retail & POSShrink & Waste Calculator
Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.
Retail & POSProduce Shrink & Rotation Calculator
Track produce lot aging by category shelf life, project shrink, and time markdowns optimally — lot-by-lot, not dollar totals.
Grocery & Fresh DepartmentsPrice-Per-Unit Comparator
Compare product prices normalized to a common unit across weight, volume, or count. Find the best value instantly.
Retail & POSPLU Code Lookup
Search all IFPS produce PLU codes by number or commodity name with organic code conversion and category filters.
Retail & POSCase Pack / Inner Pack Calculator
Calculate order quantities, days of supply, reorder points, and shelf facings from case pack and movement data.
Retail & POSDepartment Labor Scheduler
Calculate weekly labor hours and budgets by department from sales forecasts, labor targets, and hourly rates.
Retail & POSShelf Label Generator
Generate retail shelf labels with barcodes, unit pricing, sale and produce templates, and batch Avery sheet printing.
Retail & POSLarge Sign Generator
Create professional sale signs, endcap headers, and department markers with custom fonts, colors, layouts, and paper sizes.
Retail & POSMeat, produce, deli, bakery, seafood, and floral department math and operations. See category page →
Meat Cutting Test Calculator
Calculate cutting test yields, cost allocation, and pass/fail against target yields for beef, pork, and poultry primals.
Retail & POSShrink & Waste Calculator
Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.
Retail & POSBakery Scaling & Yield Calculator
Scale baking formulas with bakers' percentages, work back from finished-product targets, and account for baking loss.
Grocery & Fresh DepartmentsProduce Shrink & Rotation Calculator
Track produce lot aging by category shelf life, project shrink, and time markdowns optimally — lot-by-lot, not dollar totals.
Grocery & Fresh DepartmentsDeli Prepared Foods Recipe-to-Retail Calculator
Roll up ingredient costs with yields, add labor and packaging, and price prepared foods to a target margin.
Grocery & Fresh DepartmentsSeafood Case-Pack & Yield Calculator
Calculate whole-fish-to-fillet yield by species, factor ice and packaging, and cost the saleable pound.
Grocery & Fresh DepartmentsFloral Department Turn & Freshness Calculator
Count stems from wholesale receipts, compose bouquets, track vase life, and time markdowns on aging floral inventory.
Grocery & Fresh DepartmentsMulti-Vendor Receiving Dock Scheduler
Schedule vendor deliveries by dock capacity, truck cube, and time window — resolves conflicts and produces a daily schedule.
Grocery & Fresh DepartmentsFreight estimation, container loading, route optimization, and trade compliance. See category page →
Shipment Cost Allocator
Allocate shared freight, duty, and fees across PO lines by weight, volume, value, or equal basis.
Inventory & WarehouseHS/HTS Tariff Code Lookup
Search Harmonized System (HS) and US HTS tariff codes at the 4-digit heading and 6-digit subheading level.
Shipping & LogisticsNMFC Freight Class Estimator
Calculate density in lb/cu ft and get a density-based LTL freight class estimate.
Shipping & LogisticsPallet & Container Calculator
Calculate cases per pallet and pallets per container with weight and cube utilization checks.
Shipping & LogisticsRoute & Stop Optimizer
Optimize delivery stop order with interactive map visualization. Nearest-neighbor + 2-opt heuristic for up to 500 stops.
Shipping & LogisticsDimensional Weight Calculator
Compare dimensional weight across UPS, FedEx, and USPS with billable weight analysis.
Shipping & LogisticsFreight Rate Estimator
Estimate LTL, parcel, and truckload freight costs with class-based rates, dimensional weight, and accessorials.
Shipping & LogisticsShipping Box Calculator
Find the optimal box size from standard carrier catalogs based on your item dimensions and weight.
Shipping & LogisticsBill of Lading Generator
Generate a standard straight bill of lading with shipper, consignee, commodity lines, and print-ready output.
Shipping & LogisticsContainer Loading Planner
Pack mixed pallets into containers with first-fit-decreasing bin packing, stacking, and weight checks.
Shipping & LogisticsPallet Label Generator
Generate 4×6 GS1 pallet labels with SSCC-18 barcodes, ship-to, PO, gross weight, and case count — print single or batch.
Shipping & LogisticsLanded Cost Calculator
Compute per-unit landed cost with freight, duty, insurance, and fees — single SKU or multi-line shipment.
Shipping & LogisticsMulti-Vendor Receiving Dock Scheduler
Schedule vendor deliveries by dock capacity, truck cube, and time window — resolves conflicts and produces a daily schedule.
Grocery & Fresh DepartmentsReorder planning, cycle counting, warehouse slotting, and cost allocation. See category page →
EOQ Calculator
Compute the Economic Order Quantity that minimizes total annual inventory cost.
Inventory & WarehouseSafety Stock Calculator
Calculate safety stock and reorder point from demand and lead-time variability at any service level.
Inventory & WarehouseABC Analysis Tool
Upload SKUs with annual value and get Pareto-sorted A/B/C tiers with CSV and Excel export.
Inventory & WarehouseShipment Cost Allocator
Allocate shared freight, duty, and fees across PO lines by weight, volume, value, or equal basis.
Inventory & WarehousePallet Pattern Generator
Generate and compare pallet stacking patterns — column, interlock, pinwheel, mixed orientation — with mixed-SKU layer packing and multi-SKU layer stacking.
Inventory & WarehouseReorder Point Dashboard
Combine EOQ, safety stock, and reorder point across your SKU portfolio with CSV upload and below-ROP alerts.
Inventory & WarehouseCycle Count Planner
Generate ABC-driven cycle count schedules with configurable frequencies, daily capacity, and working days.
Inventory & WarehouseWarehouse Slotting Simulator
Assign SKU slot positions by pick velocity with hot/warm/cold zones and golden-zone scoring.
Inventory & WarehousePallet Label Generator
Generate 4×6 GS1 pallet labels with SSCC-18 barcodes, ship-to, PO, gross weight, and case count — print single or batch.
Shipping & LogisticsMulti-Vendor Receiving Dock Scheduler
Schedule vendor deliveries by dock capacity, truck cube, and time window — resolves conflicts and produces a daily schedule.
Grocery & Fresh DepartmentsCase Pack / Inner Pack Calculator
Calculate order quantities, days of supply, reorder points, and shelf facings from case pack and movement data.
Retail & POSSubnet math, MAC vendor lookup, email authentication, and WHOIS. See category page →
Subnet Calculator
Calculate network ranges, masks, host counts, and CIDR notation for IPv4 subnets.
NetworkingIPv6 Subnet Calculator
Calculate IPv6 prefixes, expanded and compressed notation, network and host portions, and total addresses.
NetworkingIP Address Converter
Convert IPv4 addresses between dotted, decimal, hex, octal, and binary representations.
NetworkingCIDR Range & Overlap Tool
Detect overlaps between CIDR blocks, merge adjacent ranges, and check IP containment.
NetworkingMAC Address Tool
Format, validate, and look up vendor for MAC addresses across all common notations.
NetworkingEmail Auth Checker
Check SPF, DMARC, DKIM, MX, and BIMI records for any domain in one place.
NetworkingWHOIS Lookup
Look up domain and IP ownership using the modern RDAP protocol — registrar, expiry, name servers, ASN.
NetworkingDNS Lookup
Query any DNS record type (A, AAAA, MX, TXT, NS, SOA, CAA, SRV, PTR) directly from your browser.
NetworkingDNS Propagation Check
Query Cloudflare, Google, OpenDNS, and NextDNS in parallel and flag any resolver whose answer differs from the majority.
NetworkingReverse DNS + FCrDNS Checker
Look up the PTR record for an IP and verify the round-trip (FCrDNS) — important for mail server reputation.
NetworkingDNSBL Check
Check an IPv4 address against 12 public DNS blacklists in parallel and see exactly which lists flagged it.
NetworkingASN Lookup
Look up ASN, AS name, announced prefix, country, and registry for any IPv4 or IPv6 address.
NetworkingHTTP Header Inspector
Fetch any URL and see its response headers, redirect chain, and a full security-header audit (HSTS, CSP, X-Frame-Options, and more).
NetworkingSSL Certificate Checker
Check HTTPS reachability and certificate history for any hostname via Certificate Transparency logs.
NetworkingFormat converters, encoders, hashes, regex, JWT, SQL, and more. See category page →
Check Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceEBCDIC to ASCII Converter
Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.
DevelopmentPacked Decimal / COMP-3 Converter
Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.
DevelopmentDDS Screen Explorer
Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.
DevelopmentDDS to SQL / SQL to DDS Converter
Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.
DevelopmentBMS Screen Explorer
Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.
DevelopmentCOBOL Copybook Explorer
Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.
DevelopmentData Diff & Compare
Compare two datasets with key-field joining. Supports CSV, TSV, JSON, XML, YAML, and Excel with automatic dot-notation flattening for nested structures.
DevelopmentFile Compare & Merge
Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.
DevelopmentData Profiler
Profile CSV data with column-level statistics, value distribution charts, quality matrix, and drill-down column detail.
DevelopmentParquet File Explorer
View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.
Data & FinanceJSON ↔ CSV
Convert between JSON and CSV formats. Paste, upload, or load sample data. Download or copy the result.
DevelopmentXML ↔ JSON Converter
Convert between XML and JSON formats. Handles attributes, CDATA, arrays, and nested elements.
DevelopmentYAML ↔ JSON Converter
Convert between YAML and JSON formats. Handles multiline strings, anchors, and flow syntax.
DevelopmentXML Formatter
Format, pretty-print, minify, and validate XML with syntax highlighting and well-formedness checking.
DevelopmentSQL Formatter
Pretty-print SQL queries with proper indentation and keyword uppercasing. Supports common SQL dialects.
DevelopmentRegex Tester & Builder
Test regex patterns with real-time match highlighting. Built-in pattern builder and syntax reference.
DevelopmentJWT Explorer
Decode, inspect, and build JWTs. View claims, check expiration, and create HMAC-signed tokens.
DevelopmentCron Expression Builder
Build and decode cron expressions visually. 12 presets, 5-field editor, and human-readable descriptions.
DevelopmentBase64 Encode/Decode
Encode text to Base64 or decode Base64 to text. Supports UTF-8.
DevelopmentHash Generator
Generate SHA-256, SHA-384, SHA-512, and SHA-1 hashes from text using Web Crypto.
DevelopmentTimestamp Converter
Convert Unix epoch timestamps to human-readable dates and back. Timezone support.
DevelopmentUUID Generator
Generate v4 UUIDs. Single or bulk generation up to 100. Copy individual or all.
DevelopmentURL Encode/Decode
Percent-encode or decode URLs and query parameters. Component and full-URL modes.
DevelopmentColor Converter
Convert between Hex, RGB, and HSL color formats. Live preview swatch and ready-to-use CSS output.
DevelopmentJSON Converter
Convert JSON arrays of objects to CSV, Excel, XML, YAML, and 7 other formats.
DevelopmentXML Converter
Extract repeating-element data from XML and convert to CSV, Excel, JSON, and 8 other formats.
DevelopmentYAML Converter
Convert YAML (array of objects, or a top-level mapping containing one) to CSV, Excel, JSON, and 8 other formats.
DevelopmentHTML Table Converter
Extract HTML <table> data and convert it to CSV, Excel, JSON, and 8 other formats.
DevelopmentSQL INSERT Converter
Extract rows from SQL INSERT statements and convert them to CSV, Excel, JSON, and 8 other formats.
DevelopmentMarkdown Table Converter
Convert GitHub Flavored Markdown tables to CSV, Excel, JSON, and 8 other formats.
DevelopmentMarkdown Preview
Live side-by-side markdown editor and rendered preview. Supports headers, lists, code, links, and more.
DevelopmentCard Number Validator
Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.
Data & FinanceConnection String Builder
Build JDBC, ADO.NET, and ODBC connection strings with a browsable property reference for 8 database platforms and 18 drivers.
DevelopmentCSV to SQL Generator
Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.
DevelopmentWSDL/SOAP Explorer
Parse WSDL 1.1 files and explore SOAP services, operations, bindings, messages, and inline XSD types.
DevelopmentXSD/XML Schema Explorer
Parse XML Schema (XSD) files and explore element hierarchies, complex and simple types, restrictions, and generate sample XML.
DevelopmentJSON Schema Validator
Validate JSON documents against JSON Schema definitions with detailed error reporting and skeleton generation.
DevelopmentEBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width. See category page →
EBCDIC to ASCII Converter
Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.
DevelopmentPacked Decimal / COMP-3 Converter
Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.
DevelopmentDDS Screen Explorer
Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.
DevelopmentDDS to SQL / SQL to DDS Converter
Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.
DevelopmentBMS Screen Explorer
Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.
DevelopmentCOBOL Copybook Explorer
Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.
DevelopmentFixed-Width ↔ CSV
Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.
Data & FinanceFile Compare & Merge
Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.
DevelopmentWSDL/SOAP Explorer
Parse WSDL 1.1 files and explore SOAP services, operations, bindings, messages, and inline XSD types.
DevelopmentAll tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.