Blitz Report Excel Add-in Skills
For business users: run Oracle EBS analysis, period close readiness and upload actions from Excel through the Blitz Report add-in.
Install
- Add the Enginatics marketplace in Claude Code.
/plugin marketplace add enginatics/ai-skills - Install the plugin.
/plugin install blitz-report-excel-addin-ai-skills@enginatics - Install the Blitz Report Excel add-in AI skills into Claude in Excel or Microsoft 365 Copilot in Excel, update them, and explain which skill fits a task.
/blitz-report-excel-addin-ai-skills:excel-skills-setup
Without Claude Code: download a single skill from the table below, or all Excel skills at once.
43 skills (download all Excel skills)
| Description | Download | ||
|---|---|---|---|
Anomaly Detection br-anomaly-detection | Find unusual or suspicious rows in a Blitz Report dataset — outlier transactions, duplicate invoices, abnormal amounts, data-quality errors — using robust statistics, Mahalanobis distance, Benford's Law, and duplicate detection. | Analytics, Excel | br-anomaly-detection.zip SKILL.md |
Clustering br-clustering | Segment a Blitz Report dataset into natural groups using K-Means or DBSCAN, then profile and name each segment in plain business language. | Analytics, Excel | br-clustering.zip SKILL.md |
Data Dashboard br-data-dashboard | Build an interactive dashboard on top of any tabular data sheet — KPI cards, charts, and slicers — without modifying the source columns. | Analytics, Excel | br-data-dashboard.zip SKILL.md |
Forecasting br-forecasting | Forecast a time series from a Blitz Report — future demand, sales, GL trend, AR collections, cash, or inventory — using Excel's native FORECAST.ETS (Holt-Winters) with seasonality detection, confidence intervals, and a backtest accuracy check. | Analytics, Excel | br-forecasting.zip SKILL.md |
RFM Analysis br-rfm-analysis | Score customers (or vendors) on Recency, Frequency, and Monetary value from a transactional Blitz Report and map them to named segments like Champions, Loyal, At Risk, and Hibernating. | Analytics, Excel | br-rfm-analysis.zip SKILL.md |
EBS Audit Trail & Access Review br-audit-trail | Answer "who changed what, when" across Oracle EBS setups and access: mine the FND Audit Trail reports for setup and profile changes by record and column, correlate with user login history and responsibility assignments, and produce a reviewable change narrative for an audit window or an incident. Read-only. | Audit and Security, Excel | br-audit-trail.zip SKILL.md |
Instance Diff br-instance-diff | Compare Oracle EBS instances through Blitz Reports in Excel: run the same report with the same parameters against two configured environments (DEV/TEST/PROD, pre/post-upgrade, source/clone) and explain the differences — row counts, missing and extra keys, changed values by column — or diff the two instances' report catalogs. | Audit and Security, Excel | br-instance-diff.zip SKILL.md |
Cash & Working-Capital Orchestrator br-cash-working-capital | Orchestrate a full Oracle EBS cash & working-capital review in Excel: run the duplicate-payment recovery, AR collections worklist, and AP payment-run optimizer, cross-check the open duplicate invoices against the recommended pay-run (so you don't pay a duplicate you're about to claw back), then assemble one master scorecard with the total cash opportunity by lever (recover / protect / capture discounts / collect / DPO headroom), a combined net-cash-by-week view, and the ranked cross-lever action list. | Cash and Working Capital, Excel | br-cash-working-capital.zip SKILL.md |
Cash Management Reconciliation Readiness br-ce-recon-readiness | Assess Oracle EBS Cash Management bank reconciliation / period-close readiness in Excel: have the br-run-reports skill extract unreconciled bank statement lines and the GL cash reconciliation, then give a red/amber/green verdict with remediation and build a CE reconciliation-readiness scorecard. | Cash Management, Excel | br-ce-recon-readiness.zip SKILL.md |
FA Period Close Readiness br-fa-close-readiness | Assess Oracle EBS Fixed Assets period-close readiness in Excel: have the br-run-reports skill extract the mass-additions backlog, depreciation/reserve status, and FA-to-GL reconciliation, then give a red/amber/green verdict with remediation and build an FA close-readiness scorecard. | Fixed Assets, Excel | br-fa-close-readiness.zip SKILL.md |
Finish a Spreadsheet Server / GL Wand conversion br-fsg-conversion-review | Finish a financial statement workbook converted from Spreadsheet Server or GL Wand to Blitz FSG: read its Conversion Log sheet, fix in the workbook what the converter could not (period cells read by other formulas, formula-driven format and segment cells, hierarchy suffixes, unsupported currency types, cells left unconverted), ask the user about the rest, and mark every log line. | General Ledger, Excel | br-fsg-conversion-review.zip SKILL.md |
GL Account Coding Assistant br-gl-account-coder | Suggest GL account coding from the ledger's own history: given transactions to code (or re-code), mine GL Account Analysis for how this entity has historically coded the same supplier, source, category or description, and propose the account combination with a confidence level and the precedent shown. Optionally stage approved corrections as a journal via the GL Journal Upload — only on explicit user confirmation. Updates EBS | General Ledger, Excel | br-gl-account-coder.zip SKILL.md |
GL Period Close Readiness br-gl-close-readiness | Assess Oracle EBS General Ledger period-close readiness in Excel: have the br-run-reports skill extract GL period statuses, unposted/error journals, and the trial balance, then give a red/amber/green verdict with remediation and build a GL close-readiness scorecard. | General Ledger, Excel | br-gl-close-readiness.zip SKILL.md |
Analytics Standards br-analytics-standards | Shared performance and coding standards for all br_ analytics skills (br-ap-holds-analysis, br-ap-close-readiness, br-ar-close-readiness, br-gl-close-readiness, br-fa-close-readiness, br-inv-cost-close-readiness, br-ce-recon-readiness, br-subledger-gl-reconciliation, br-close-process-monitor, br-month-end-readiness). | Getting Started, Excel | br-analytics-standards.zip SKILL.md |
Blitz Report Finder br-report-finder | Find the right Oracle EBS Blitz Report by MEANING, not by name: load the full report library once into the workbook, then match the user's business question ("which report shows unapplied receipts by operating unit?") against every report's name, category and description, explain the top candidates, and hand the chosen one to br-run-reports. | Getting Started, Excel | br-report-finder.zip SKILL.md |
Excel Skills Setup excel-skills-setup | Install the Blitz Report Excel add-in AI skills into Claude in Excel or Microsoft 365 Copilot in Excel, update them, and explain which skill fits a task. | Getting Started, Excel | SKILL.md |
Run Blitz Reports in Excel br-run-reports | Find, run, and analyze Oracle EBS Blitz Reports in Excel (GL, AP, AR, INV, PO, WIP, FA, HR and concurrent-program data). | Getting Started, Excel | br-run-reports.zip SKILL.md |
Run Blitz Uploads in Excel br-run-uploads | Create, load or update Oracle EBS records from Excel with Blitz Uploads via the BLITZ REPORT ADD-IN (the br_* worksheet functions) - journals, invoices, purchase documents, items, suppliers, customers, assets and more (GL, AP, AR, PO, INV, WIP, HR, FA, CE). Updates EBS | Getting Started, Excel | br-run-uploads.zip SKILL.md |
INV Cycle Count Planner br-inv-cycle-count-planner | Plan and steer Oracle EBS cycle counting: analyse count accuracy history, find never-counted and overdue items, recommend count priorities by value/velocity/accuracy (ABC-weighted), and surface the approval and adjustment backlog. Read-only — recommendations feed the customer's own cycle count scheduling in EBS. | Inventory, Excel | br-inv-cycle-count-planner.zip SKILL.md |
Inventory / Costing Period Close Readiness br-inv-cost-close-readiness | Assess Oracle EBS Inventory/Costing period-close readiness in Excel: have the br-run-reports skill extract pending inventory transactions, missing WIP/receiving accounting, and pending cost adjustments, then give a red/amber/green verdict with remediation and build an Inventory close-readiness scorecard. | Inventory, Excel | br-inv-cost-close-readiness.zip SKILL.md |
INV Exception Triage br-inv-exception-triage | Triage Oracle EBS Inventory exceptions in Excel: have the br-run-reports skill extract negative on-hand balances, stuck interface/error transactions, and cycle counts pending approval, then rank everything by severity with a recommended owner and fix, and build one exception dashboard. | Inventory, Excel | br-inv-exception-triage.zip SKILL.md |
INV Stock Level Optimizer br-inv-stock-optimizer | Recommend min/max quantities, reorder points and safety stock per item and subinventory in Oracle EBS from actual demand history and on-hand position — then, only on explicit user confirmation, apply the approved recommendations back to EBS via the INV Item Subinventory Upload or INV Safety Stock Upload. Updates EBS | Inventory, Excel | br-inv-stock-optimizer.zip SKILL.md |
BOM Accuracy Validator br-bom-validator | Validate Oracle EBS bill-of-material accuracy against how the shop floor actually consumes material: compare BOM structures with WIP component requirements and shortages, flag suspect components (never issued, always short, quantity drift), and stage approved BOM corrections via the BOM Bill of Materials Upload — only on explicit user confirmation. Updates EBS | Manufacturing, Excel | br-bom-validator.zip SKILL.md |
WIP Job & Variance Analysis br-wip-variance-analysis | Analyze Oracle EBS WIP job health and cost exposure in Excel: have the br-run-reports skill extract job statuses, WIP value, and component shortages, then rank stuck and past-due jobs, surface value concentration and close candidates, and build one WIP analysis dashboard. | Manufacturing, Excel | br-wip-variance-analysis.zip SKILL.md |
AP Duplicate Invoice Hold Placement br-ap-duplicate-hold | Stop payment of suspected duplicate AP invoices from Excel: take the unpaid duplicates a br-ap-duplicate-payments run identified, place a payment-blocking hold on each suspect copy via the "AP Invoice Hold Upload", and record the duplicate evidence in the hold reason — only on the user's explicit confirmation. Updates EBS | Payables, Excel | br-ap-duplicate-hold.zip SKILL.md |
AP Duplicate Payment Recovery br-ap-duplicate-payments | Find duplicate and overpaid Oracle EBS Accounts Payable invoices/payments in Excel: have the br-run-reports skill extract the AP invoice universe, fuzzy-match it for duplicate-entry patterns (same supplier + amount, re-keyed invoice numbers, transposed digits, duplicate vendor masters, cross-OU double entry), separate recoverable (both paid) from preventable (one still open), and build a ranked recovery worklist with $-at-risk. | Payables, Excel | br-ap-duplicate-payments.zip SKILL.md |
AP Intelligence Dashboard br-ap-intelligence | Build a live AP intelligence dashboard in Excel from Oracle EBS: run the "AP Cash Requirement" Blitz Report and lay out the five payables KPIs (invoices on hold, total AP outstanding, overdue 30+ days, approved due within 7 days, unapproved due within 15 days), a ranked AI action summary, an AI commentary per KPI, drill-down lists, due-bucket and supplier tables, and answer follow-up questions as new KPI cards. | Payables, Excel | br-ap-intelligence.zip SKILL.md |
AP Invoice Hold Release br-ap-hold-release | Release Oracle EBS AP invoice holds from Excel: take the holds that qualify for release, pre-populate the "AP Invoice Hold Upload" grid with the correct release reason per hold, validate it, show the user exactly what will be released, and — only on their explicit confirmation — submit it so Payables releases the holds. Updates EBS | Payables, Excel | br-ap-hold-release.zip SKILL.md |
AP Invoice Holds Analysis br-ap-holds-analysis | Analyze Oracle EBS AP invoice holds in Excel: run the "AP Invoice on Hold" Blitz Report, categorise and age the holds, flag anomalies, build a holds dashboard, flag RELEASE CANDIDATES and offer to hand them to br-ap-hold-release for action. | Payables, Excel | br-ap-holds-analysis.zip SKILL.md |
AP Invoice Upload from documents br-ap-invoice-upload | Create Oracle EBS AP invoices from source documents using the BLITZ REPORT ADD-IN (the br_* worksheet functions) — supplier invoices, reimbursement vouchers, freight bills, utility statements, expense receipts — by reading the documents, running the AP Invoice Upload, filling its sheet, then validating against real EBS and self-correcting. | Payables, Excel | br-ap-invoice-upload.zip SKILL.md |
AP Payment-Run Optimizer br-ap-payment-optimizer | Optimize an Oracle EBS Accounts Payable payment run in Excel: have the br-run-reports skill extract the AP cash requirement (due invoices, available early-pay discounts, due dates, payment priority), classify each invoice as capture-discount / pay-to-avoid-late / defer-to-due / priority-must-pay, select the best pay run within a cash constraint by discount ROI, quantify the discount $ captured and DPO impact, and build a payment-run dashboard. | Payables, Excel | br-ap-payment-optimizer.zip SKILL.md |
AP Payment Actions br-ap-payment-actions | Act on a br-ap-payment-optimizer run from Excel: produce the prioritized pay-run list for the invoices to pay now (discount capture), and — on explicit confirmation — place payment-blocking holds via the "AP Invoice Hold Upload" on the invoices the user chooses to defer. Updates EBS | Payables, Excel | br-ap-payment-actions.zip SKILL.md |
AP Period Close Readiness br-ap-close-readiness | Assess Oracle EBS Accounts Payable period-close readiness in Excel: have the br-run-reports skill extract "AP Period Close Exceptions", summarise the blockers by exception type, give a red/amber/green readiness verdict with the remediation for each blocker, and build an AP close-readiness scorecard. | Payables, Excel | br-ap-close-readiness.zip SKILL.md |
Close Process Monitor br-close-process-monitor | Monitor the Oracle EBS concurrent programs that drive a period close in Excel: have the br-run-reports skill extract recent Create Accounting / Transfer to GL / Cost Manager / Depreciation / Journal Import / AutoInvoice request status, flag errored, stuck, and long-running close jobs, and build a close-process monitor dashboard. | Period Close, Excel | br-close-process-monitor.zip SKILL.md |
Month-End Close Readiness Orchestrator br-month-end-readiness | Orchestrate a full Oracle EBS month-end close readiness assessment in Excel: run the per-module readiness checks (AP, AR, Inventory/Costing, FA, GL), the close-process monitor, and the subledger-to-GL reconciliation, then assemble one master scorecard with a per-module red/amber/green status, the ranked blockers, and the recommended close sequence. | Period Close, Excel | br-month-end-readiness.zip SKILL.md |
Subledger-to-GL Reconciliation br-subledger-gl-reconciliation | Reconcile Oracle EBS subledgers to the General Ledger in Excel: have the br-run-reports skill extract AP, AR, Inventory and FA control balances and tie each to its GL control account, surfacing the variance per subledger with a red/amber/green verdict. | Period Close, Excel | br-subledger-gl-reconciliation.zip SKILL.md |
PO 3-Way Match Exception Triage br-po-match-exceptions | Triage Oracle EBS 3-way match exceptions — invoices held because PO, receipt and invoice disagree on quantity or price — explain the root cause per hold (not received, over-billed, price change, receipt discrepancy), and route each to the right resolver: receiving, buyer, or AP. Read-only. | Purchasing, Excel | br-po-match-exceptions.zip SKILL.md |
PO Period Close Readiness br-po-close-readiness | Assess Oracle EBS Purchasing period-close readiness in Excel: have the br-run-reports skill extract the AP/PO accrual reconciliation, the aged uninvoiced receipts, and the period status, then give a red/amber/green verdict with remediation and build a PO close-readiness scorecard. | Purchasing, Excel | br-po-close-readiness.zip SKILL.md |
Supplier Risk Scoring br-supplier-risk-scoring | Score Oracle EBS suppliers on risk in Excel: have the br-run-reports skill extract spend, holds, price variance and delivery history, then combine dependency, reliability, price stability and anomaly signals into a ranked supplier risk register with a named driver per supplier. | Purchasing, Excel | br-supplier-risk-scoring.zip SKILL.md |
AR Collections Note Logging br-ar-collections-notes | Log collection notes into Oracle EBS Advanced Collections from Excel: take the ranked customers and drafted dunning messages a br-ar-collections-worklist run produced, stage one note per customer via the "IEX Collection Note Upload", and — on the user's explicit confirmation — submit them so the collections team sees the worklist as logged activity. Updates EBS | Receivables, Excel | br-ar-collections-notes.zip SKILL.md |
AR Collections Worklist br-ar-collections-worklist | Build a prioritized Oracle EBS Accounts Receivable collections worklist in Excel: have the br-run-reports skill extract open AR aging, past-due detail and disputes, score each customer by collectible-$-at-risk (aging severity), exclude disputed balances, assign a dunning tier, draft the reminder text per tier, and build a collections dashboard. Payment-behaviour (receipt-history RFM) re-ranking is an add-on that runs only when the user asks for it. | Receivables, Excel | br-ar-collections-worklist.zip SKILL.md |
AR Credit Risk & DSO Analysis br-ar-credit-risk | Score customer credit risk and analyse DSO from Oracle EBS Receivables: combine credit limits and utilization, aging severity, payment behaviour and balance trend into a per-customer risk grade with the drivers named, plus a DSO decomposition showing which segments and behaviours move it. Read-only. | Receivables, Excel | br-ar-credit-risk.zip SKILL.md |
AR Period Close Readiness br-ar-close-readiness | Assess Oracle EBS Accounts Receivable period-close readiness in Excel: have the br-run-reports skill extract unaccounted AR transactions, AutoInvoice interface errors, and the AR-to-GL reconciliation, then give a red/amber/green verdict with remediation and build an AR close-readiness scorecard. | Receivables, Excel | br-ar-close-readiness.zip SKILL.md |
No skills match. Try fewer words.