How to Prepare 1099s in Xero with AI
The short answer: You prepare 1099s in Xero with AI by connecting Xero so the workspace pulls the contact list and payment history, identifies which vendors cross the reporting threshold, flags missing W-9 data, and drafts the amounts per box. In OCTA Flow, you pick the 1099 Preparation Skill, run it against the client's Xero data, review findings by severity, and file yourself.
What 1099 season costs your firm today
Every January, 1099 prep turns into a scramble. Xero does not track W-9 status natively, so someone has to comb the contact list, figure out which vendors are reportable, total the payments made by cash or check (not card), confirm a taxpayer ID exists, and split amounts into the right boxes on the 1099-NEC or 1099-MISC. The data is scattered across bills, spend money transactions, and manual payments, and one missing W-9 or a payment miscategorized to a non-reportable account throws the whole return off. It is deadline-driven, repetitive work across your entire client base at once — the definition of a task that should be assembled for you and only checked by a human before filing.
How to prepare 1099s in Xero with OCTA Flow (step by step)
- Connect Xero. Authorize Xero so Flow reads the contact list, bills, payments, and the general ledger directly — no manual export.
- Pick the 1099 Preparation Skill. A pre-built Skill that already knows the reporting thresholds, which payment types count, and how amounts map to 1099-NEC and 1099-MISC boxes.
- Select the client and tax year. Flow pulls every vendor payment for the year and the contact records behind them.
- Run it. The agent identifies reportable vendors, excludes card payments that the processor reports, totals amounts by box, and flags vendors missing a W-9 or taxpayer ID, logging every step.
- Review findings by severity. A reportable vendor with no taxpayer ID on file is flagged Critical; a vendor just under the threshold worth a second look is Low. You resolve, request the missing W-9, or override with a reason.
- Handle exceptions and corrections. Flow drafts any reclass entries where a reportable payment was coded to a non-reportable account. It does not post them to Xero — you review and post them yourself.
- Sign off and file. Once the vendor list and box amounts are confirmed, you approve, then file through your 1099 e-file provider. The engagement locks with a full audit trail.
What Flow produces
The deliverable is a review-ready 1099 workpaper: a list of reportable vendors with taxpayer IDs, total payments split by box, an exceptions tab flagging missing W-9s and possible miscodings, and a locked audit trail. It is the schedule you would hand a reviewer before filing — already assembled and tied to the payment records.
Who stays in control
The AI does the work; your partner signs the name. Every action is logged, Quality Gates check the output before your review, and you cannot sign off while a Critical finding — like a reportable vendor with no taxpayer ID — is unresolved. Flow surfaces who is reportable and why; you make the calls that carry filing risk. That is the difference between AI that gives an answer and AI you can rely on at a deadline.
Xero specifics
Flow reads Xero's contact records and payment history through the integration, so it can separate cash and check payments (reportable) from card payments (reported by the processor) rather than lumping them together. Because Xero has no native W-9 tracking, Flow builds the missing-taxpayer-ID list for you to chase. Write-back is deliberate: Flow proposes any reclass entries, you post them in Xero, and you file the returns through your own provider. The underlying vendor data also feeds vendor reconciliation automation and your AP aging analysis.
Frequently Asked Questions
Does Flow file the 1099s for me? No. Flow prepares the reportable-vendor list and box amounts and flags exceptions; you review and file through your own 1099 e-file provider. Nothing is filed or posted without your action.
How does it know which vendors are reportable? It reads payment history and contact records through the Xero integration, applies the reporting thresholds, excludes card payments, and flags vendors missing a taxpayer ID for you to confirm.
How accurate is AI 1099 preparation? In independent testing across 200+ accounting scenarios, Flow scored 83% versus 55% for a general Opus model and 33% for ChatGPT — and every 1099 workpaper is reviewed before filing.
Prepare this year's 1099s on your own Xero data — free for 30 days. → Start your trial