QBO → Tax Bridge
Maps QuickBooks Online bookkeeping data to IRS tax schedules and generates tax-ready workpapers.
Core Capabilities
- QBO Category → IRS Schedule Mapping — Translate chart of accounts to Schedule C, E, F, 1120S, 1120, 1065 line items
- Trial Balance → Workpaper Generation — Export QBO trial balance and format into tax-ready supporting schedules
- Reclassification Identification — Flag misclassified transactions that need adjustment before filing
- Crypto Cost Basis Tracking — Calculate FIFO/LIFO/HIFO cost basis for crypto assets recorded in QBO
- Schedule Line Mapping Reference — Authoritative line-by-line crosswalk tables
Workflow
Step 1 — Export QBO Trial Balance
- In QBO: Reports → Trial Balance
- Set date range to the full tax year (Jan 1 – Dec 31)
- Customize → Show Non-Zero rows only
- Export as Excel or CSV
- Also export: Profit & Loss (by month) and Balance Sheet (year-end)
QBO Export Path:
Reports > Standard > Trial Balance > Export (Excel icon, top right)
Step 2 — Entity + Schedule Selection
Identify the filing entity type to determine the correct IRS schedule:
| Entity Type | Primary Schedule | Supporting |
|---|---|---|
| Sole Proprietor / Single-Member LLC | Schedule C (Form 1040) | SE, 4562 |
| Rental Activity | Schedule E (Page 1) | 4562, 8582 |
| Farm | Schedule F | 4562, SE |
| S-Corporation | Form 1120-S + K-1 | 4562, 4797 |
| C-Corporation | Form 1120 | 4562, 4797 |
| Partnership / Multi-Member LLC | Form 1065 + K-1 | 4562, 4797 |
Step 3 — Schedule C Mapping (Sole Proprietors)
Income Accounts → Schedule C, Part I
| QBO Account Name (Common) | Schedule C Line | Notes |
|---|---|---|
| Sales / Revenue | Line 1 (Gross receipts) | Exclude returns |
| Returns and Allowances | Line 2 | Deducted from gross |
| Cost of Goods Sold | Line 4 (via Part III) | COGS detail required |
| Other Income | Line 6 | Non-operating income |
Expense Accounts → Schedule C, Part II
| QBO Account Name | Sch C Line | IRS Description |
|---|---|---|
| Advertising | Line 8 | Advertising |
| Bank Charges | Line 27a (Other) | Bank service charges |
| Car & Truck Expenses | Line 9 | Requires Form 4562 or actual method |
| Commissions | Line 10 | Commissions and fees |
| Contract Labor | Line 11 | Non-employee compensation (1099-NEC trigger) |
| Depreciation | Line 13 | Form 4562 required |
| Dues & Subscriptions | Line 27a | Other expenses |
| Employee Benefits | Line 14 | Health insurance, retirement |
| Insurance (Business) | Line 15 | Not health insurance here |
| Interest - Mortgage | Line 16a | On business real property |
| Interest - Other | Line 16b | Business loans |
| Legal & Professional | Line 17 | Attorney, CPA, consultants |
| Meals (Business) | Line 24b | 50% deductible — apply haircut |
| Office Expense | Line 18 | Supplies vs. equipment distinction |
| Rent (Equipment) | Line 20a | Equipment rentals |
| Rent (Property) | Line 20b | Office/workspace rent |
| Repairs & Maintenance | Line 21 | Maintenance only; improvements → capitalize |
| Payroll Taxes | Line 23 | Employer portion FICA/FUTA |
| Wages (Employees) | Line 26 | W-2 wages (not owner draws) |
| Utilities | Line 25 | Business portion only |
| Home Office | Line 30 | Form 8829 required |
| Travel | Line 24a | Business travel (not commuting) |
| Telephone | Line 27a | Business portion of phone/internet |
| Software Subscriptions | Line 27a | Business software |
⚠ Meals Haircut: Apply 50% reduction to QBO Meals balance before reporting on Sch C Line 24b.
Step 4 — Schedule E Mapping (Rental)
Per-Property Tracking Required
| QBO Account | Schedule E Line | Notes |
|---|---|---|
| Rental Income | Line 3 | Gross rents received |
| Advertising (Rental) | Line 5 | Vacancy advertising |
| Auto & Travel (Rental) | Line 6 | Property management travel |
| Cleaning & Maintenance | Line 7 | Cleaning between tenants |
| Commissions | Line 8 | Leasing agent fees |
| Insurance (Rental) | Line 9 | Property insurance |
| Legal & Professional (Rental) | Line 10 | Eviction, lease drafting |
| Management Fees | Line 11 | Property management company |
| Mortgage Interest (Rental) | Line 12 | From 1098 |
| Other Interest (Rental) | Line 13 | HELOC on rental, etc. |
| Repairs (Rental) | Line 14 | Repairs only; improvements → capitalize |
| Supplies (Rental) | Line 15 | Small supplies |
| Property Taxes | Line 16 | Real estate taxes |
| Utilities (Rental) | Line 17 | Landlord-paid utilities |
| Depreciation (Rental) | Line 18 | Form 4562; 27.5-yr residential |
| Other Expenses | Line 19 | HOA, snow removal, etc. |
Step 5 — Form 1120-S / S-Corp Mapping
Income → Form 1120-S, Page 1
| QBO Account | 1120-S Line | Notes |
|---|---|---|
| Gross Receipts / Sales | Line 1a | Net of returns |
| Cost of Goods Sold | Line 2 | Schedule A detail |
| Other Income | Line 5 | Interest, rents, royalties |
Deductions → Form 1120-S, Lines 7-19
| QBO Account | 1120-S Line |
|---|---|
| Compensation of Officers | Line 7 |
| Salaries & Wages | Line 8 |
| Repairs & Maintenance | Line 9 |
| Bad Debts | Line 10 |
| Rents | Line 11 |
| Taxes & Licenses | Line 12 |
| Interest | Line 13 |
| Depreciation | Line 14 |
| Depletion | Line 15 |
| Advertising | Line 16 |
| Employee Benefit Programs | Line 17 |
| Other Deductions | Line 19 |
K-1 Pass-Through Items (Schedule K)
| QBO Account | K-1 Box | Description |
|---|---|---|
| Ordinary Business Income | Box 1 | Net income from operations |
| Interest Income | Box 4 | Taxable interest |
| Dividends | Box 5a/5b | Ordinary vs. qualified |
| Net Rental Income | Box 2 | Rental real estate |
| Section 179 | Box 11 | Must track separately |
| Charitable Contributions | Box 12a | Separately stated |
| Meals (50%) | Box 16C | Must track and separate |
Step 6 — Crypto Asset Cost Basis (QBO-Tracked)
QBO Setup for Crypto:
- Create a separate Other Current Asset account per crypto type (e.g., "Bitcoin Holdings", "Ethereum Holdings")
- Record purchases as asset debits; sales as credits with gain/loss to Other Income or Other Expense
Cost Basis Methods:
| Method | Description | IRS Compliance |
|---|---|---|
| FIFO | First purchased = first sold | Default, IRS-accepted |
| LIFO | Last purchased = first sold | Accepted but must be consistent |
| HIFO | Highest cost = first sold | Accepted; minimizes gains |
| Specific ID | Choose exact lot | Requires documentation |
Crypto Workpaper Template (per asset):
Asset: Bitcoin (BTC)
QBO Account: Bitcoin Holdings
Date | Type | Units | Price | Cost Basis | Proceeds | Gain/Loss
-----------|----------|----------|----------|------------|----------|----------
2025-02-14 | Purchase | 0.50000 | $48,000 | $24,000 | — | —
2025-06-01 | Purchase | 0.25000 | $62,000 | $15,500 | — | —
2025-09-15 | Sale | 0.25000 | $71,000 | $12,000* | $17,750 | $5,750 ST
2025-11-30 | Sale | 0.25000 | $95,000 | $12,000* | $23,750 | $11,750 LT
*FIFO basis from 2025-02-14 purchase
Short-term gains: $5,750 → Schedule D, Part I / Form 8949 (held < 1 year)
Long-term gains: $11,750 → Schedule D, Part II / Form 8949 (held > 1 year)
QBO Journal Entry for Crypto Sale:
DR Checking / USD Received $23,750
CR Bitcoin Holdings (cost) $12,000
CR Long-Term Capital Gain $11,750
DeFi / Staking Income:
- Record staking rewards as Other Income at FMV on date received
- Taxed as ordinary income (not capital gains) at receipt
- Future sale creates capital gain/loss from FMV basis
Step 7 — Reclassification Identification
Run these checks against QBO trial balance before workpaper finalization:
Common Misclassifications:
| Issue | Check | Fix |
|---|---|---|
| Capital improvements coded as repairs | Single transaction > $2,500 in Repairs & Maint. | Reclassify to Fixed Assets; depreciate |
| Owner draws in payroll | Distributions in wage accounts | Move to Owner's Draw / Equity |
| Personal expenses in business | Mixed personal charges | Reclassify to Due from Owner / Shareholder |
| Meals coded as Entertainment | Pre-2018 habit; Entertainment 0% deductible | Separate Meals (50%) from Entertainment (0%) |
| Loan proceeds in Income | Deposit from business loan coded as revenue | Reclassify to Liability account |
| Prepaid expenses expensed | Subscriptions paid for future periods | Pro-rate; book prepaid asset |
| Security deposits as income | Refundable deposits in revenue | Reclassify to Liability |
Threshold Rules:
- Section 179 / Bonus Depreciation: Fixed assets ≥ $2,500 (safe harbor) → track in 4562
- 1099-NEC Trigger: Any contractor receiving ≥ $600/year → verify W-9 on file
- Meals Documentation: Receipt + business purpose required for deductibility
Step 8 — Trial Balance → Workpaper Output Format
Workpaper Header (required per SSVS standards):
Client: [Business Name]
EIN: XX-XXXXXXX
Tax Year: 2025
Prepared By: [Preparer Name], PTIN: PXXXXXXXXX
Reviewed By: [Reviewer Name]
Date Prepared: [Date]
Purpose: Supporting schedule for [Form/Schedule]
Standard Workpaper Tabs (Excel):
TB— Trial Balance (direct QBO export, unadjusted)AJE— Adjusting Journal Entries (reclassifications, accruals)ATB— Adjusted Trial Balance (TB + AJE)Sch-Cor1120-S— Schedule mapping with line referencesFixed-Assets— 4562 depreciation scheduleCrypto— Cost basis tracker (if applicable)1099— Contractor payment summary for 1099-NEC filing
Quick Reference: Common QBO → IRS Line Crosswalk
QBO Account → IRS Form/Line
─────────────────────────────────────────
Advertising → Sch C L8 / 1120-S L16
Bank Charges → Sch C L27a (other)
Car & Truck → Sch C L9 (+ 4562 or actual)
Commissions → Sch C L10
Contract Labor → Sch C L11 (1099-NEC!)
Depreciation → Sch C L13 / 1120-S L14
Dues & Subscriptions → Sch C L27a
Health Insurance (self) → 1040 L17 (not Sch C)
Insurance (business) → Sch C L15
Interest (mortgage) → Sch C L16a
Interest (other) → Sch C L16b
Legal & Professional → Sch C L17
Meals (50%) → Sch C L24b (50% of QBO balance)
Office Expense → Sch C L18
Payroll Taxes (ER) → Sch C L23
Rent (equipment) → Sch C L20a
Rent (space) → Sch C L20b
Repairs → Sch C L21
Travel → Sch C L24a
Utilities → Sch C L25
Wages (W-2) → Sch C L26
Home Office → Sch C L30 (+ 8829)
Negative Boundaries (When NOT to Use)
- ❌ Filing tax returns — This skill maps and prepares workpapers; actual filing requires licensed tax software (Drake, UltraTax, ProConnect) and a licensed preparer
- ❌ Legal tax advice — Specific tax strategies, elections, or planning require CPA/EA/attorney opinion
- ❌ Replacing CPA review — Workpapers always require professional review before filing
- ❌ Non-QBO accounting systems — Mappings assume QBO chart of accounts; adapt for Xero, Wave, or FreshBooks
- ❌ International tax (non-US) — IRS schedules only; no VAT, GST, or foreign jurisdiction guidance
- ❌ State tax returns — State conformity varies; this skill covers federal only
- ❌ Real-time QBO API access — This is a workpaper and mapping skill, not a live QBO integration (see qbo-automation skill for API work)
Examples
Example 1 — Sole Prop Workpaper Summary
Client: Jane Smith Photography, LLC (SMLLC)
EIN: 87-1234567 | Tax Year: 2025 | Schedule C
QBO Trial Balance (Adjusted):
Revenue $142,500
COGS (equipment rental) ($18,200)
Gross Profit $124,300
Schedule C Expenses:
L8 Advertising $3,400
L9 Car & Truck $4,200 (actual method, Form 4562 attached)
L13 Depreciation $2,800 (camera equipment, Form 4562)
L15 Insurance $1,200
L17 Legal & Prof $2,500
L18 Office $890
L24b Meals $1,450 (QBO balance $2,900 × 50%)
L25 Utilities $600
L27a Other $1,100 (software subscriptions)
Total Expenses $18,140
Net Profit (Line 31): $106,160
SE Tax (Sch SE): $14,993
Example 2 — Crypto Reclassification
Issue found: Client coded $15,000 ETH sale proceeds as "Sales Revenue"
Fix: Reclassify to Long-Term Capital Gain (held 14 months)
AJE: DR Sales Revenue $15,000 / CR LT Capital Gain $15,000
DR LT Capital Gain $8,200 / CR Cost Basis (ETH Holdings) $8,200
Net: $6,800 LTCG → Form 8949, Part II → Schedule D, Line 8
Example 3 — S-Corp K-1 Prep
Form 1120-S → Schedule K Items to Separately State:
Box 1: Ordinary Income $87,400
Box 4: Interest Income $320
Box 12a: Charitable Contrib $2,500
Box 16C: Meals Disallowed $1,800 (50% of $3,600 meals)
Per-shareholder K-1 (50% ownership):
Box 1: $43,700
Box 4: $160
Box 12a: $1,250
Box 16C: $900
Related Skills
- qbo-automation — QBO API integration, bank rules, chart of accounts setup
- crypto-tax-agent — Advanced crypto tax calculations, DeFi, NFTs, multi-chain
- financial-analysis-agent — Ratio analysis, variance reporting, management reporting