scotts-addins

Help users write Scott's Add-ins Excel formulas to pull data from Xero. Use this skill whenever the user says '/scott', 'scott formula', 'scotts formula', 'scotts add-in', 'scott's add-in', 'pull from xero', 'xero formula', 'xero excel', or asks how to get GL balances, account descriptions, invoice data, bill data, budget data, tracking category data, trial balance data, or transaction detail into Excel using Scott's Add-ins. Also trigger when the user mentions SCOTT.GL, SCOTT.RANGE, SCOTT.GLMULTI, SCOTT.XINVOICE, SCOTT.XBILL, SCOTT.XTRACK, SCOTT.BUDGET, SCOTT.NGL, SCOTT.DESC, SCOTT.CHART, SCOTT.LIST, SCOTT.XNI, or any =SCOTT.* function. This skill is the go-to for ANY question about pulling Xero data into Excel via Scott's Add-ins — always use it instead of guessing at syntax.

Builds finished Excel workbooks (.xlsx files) populated with Scott's Add-ins =SCOTT.* formulas — P&L, Balance Sheet, Budget vs. Actual, and custom reports — driven by a dedicated Inputs sheet. Use this skill whenever the user asks to BUILD, CREATE, GENERATE, or MAKE an Excel workbook, spreadsheet, file, model, or report that uses Scott's Add-ins, Scott's functions, or Scott's formulas. Trigger phrases include "use Scott's add-in", "use Scott's functions", "build me a P&L using Scott's", "create a balance sheet workbook with Scott's formulas", "make a budget vs. actual file in Excel using Scott's", "spin up a P&L with =SCOTT.GL", or any request for a financial report file where the user mentions Scott's. Do NOT trigger for questions about which formula to use or formula syntax with no file output — that's the `scott-formulas` skill. The deliverable for this skill is always a .xlsx file the user can open.