QBO → Tax Bridge#

Maps QuickBooks Online bookkeeping data to IRS tax schedules and generates tax-ready workpapers.

---

Core Capabilities#

1. QBO Category → IRS Schedule Mapping — Translate chart of accounts to Schedule C, E, F, 1120S, 1120, 1065 line items
2. Trial Balance → Workpaper Generation — Export QBO trial balance and format into tax-ready supporting schedules
3. Reclassification Identification — Flag misclassified transactions that need adjustment before filing
4. Crypto Cost Basis Tracking — Calculate FIFO/LIFO/HIFO cost basis for crypto assets recorded in QBO
5. Schedule Line Mapping Reference — Authoritative line-by-line crosswalk tables

---

Workflow#

Step 1 — Export QBO Trial Balance#

1. In QBO: Reports → Trial Balance
2. Set date range to the full tax year (Jan 1 – Dec 31)
3. Customize → Show Non-Zero rows only
4. Export as Excel or CSV
5. Also export: Profit & Loss (by month) and Balance Sheet (year-end)

text

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 TypePrimary ScheduleSupportingSole Proprietor / Single-Member LLCSchedule C (Form 1040)SE, 4562Rental ActivitySchedule E (Page 1)4562, 8582FarmSchedule F4562, SES-CorporationForm 1120-S + K-14562, 4797C-CorporationForm 11204562, 4797Partnership / Multi-Member LLCForm 1065 + K-14562, 4797

---

Step 3 — Schedule C Mapping (Sole Proprietors)#

Income Accounts → Schedule C, Part I

QBO Account Name (Common)Schedule C LineNotesSales / RevenueLine 1 (Gross receipts)Exclude returnsReturns and AllowancesLine 2Deducted from grossCost of Goods SoldLine 4 (via Part III)COGS detail requiredOther IncomeLine 6Non-operating income

Expense Accounts → Schedule C, Part II

QBO Account NameSch C LineIRS DescriptionAdvertisingLine 8AdvertisingBank ChargesLine 27a (Other)Bank service chargesCar & Truck ExpensesLine 9Requires Form 4562 or actual methodCommissionsLine 10Commissions and feesContract LaborLine 11Non-employee compensation (1099-NEC trigger)DepreciationLine 13Form 4562 requiredDues & SubscriptionsLine 27aOther expensesEmployee BenefitsLine 14Health insurance, retirementInsurance (Business)Line 15Not health insurance hereInterest - MortgageLine 16aOn business real propertyInterest - OtherLine 16bBusiness loansLegal & ProfessionalLine 17Attorney, CPA, consultantsMeals (Business)Line 24b50% deductible — apply haircutOffice ExpenseLine 18Supplies vs. equipment distinctionRent (Equipment)Line 20aEquipment rentalsRent (Property)Line 20bOffice/workspace rentRepairs & MaintenanceLine 21Maintenance only; improvements → capitalizePayroll TaxesLine 23Employer portion FICA/FUTAWages (Employees)Line 26W-2 wages (not owner draws)UtilitiesLine 25Business portion onlyHome OfficeLine 30Form 8829 requiredTravelLine 24aBusiness travel (not commuting)TelephoneLine 27aBusiness portion of phone/internetSoftware SubscriptionsLine 27aBusiness 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 AccountSchedule E LineNotesRental IncomeLine 3Gross rents receivedAdvertising (Rental)Line 5Vacancy advertisingAuto & Travel (Rental)Line 6Property management travelCleaning & MaintenanceLine 7Cleaning between tenantsCommissionsLine 8Leasing agent feesInsurance (Rental)Line 9Property insuranceLegal & Professional (Rental)Line 10Eviction, lease draftingManagement FeesLine 11Property management companyMortgage Interest (Rental)Line 12From 1098Other Interest (Rental)Line 13HELOC on rental, etc.Repairs (Rental)Line 14Repairs only; improvements → capitalizeSupplies (Rental)Line 15Small suppliesProperty TaxesLine 16Real estate taxesUtilities (Rental)Line 17Landlord-paid utilitiesDepreciation (Rental)Line 18Form 4562; 27.5-yr residentialOther ExpensesLine 19HOA, snow removal, etc.

---

Step 5 — Form 1120-S / S-Corp Mapping#

Income → Form 1120-S, Page 1

QBO Account1120-S LineNotesGross Receipts / SalesLine 1aNet of returnsCost of Goods SoldLine 2Schedule A detailOther IncomeLine 5Interest, rents, royalties

Deductions → Form 1120-S, Lines 7-19

QBO Account1120-S LineCompensation of OfficersLine 7Salaries & WagesLine 8Repairs & MaintenanceLine 9Bad DebtsLine 10RentsLine 11Taxes & LicensesLine 12InterestLine 13DepreciationLine 14DepletionLine 15AdvertisingLine 16Employee Benefit ProgramsLine 17Other DeductionsLine 19

K-1 Pass-Through Items (Schedule K)

QBO AccountK-1 BoxDescriptionOrdinary Business IncomeBox 1Net income from operationsInterest IncomeBox 4Taxable interestDividendsBox 5a/5bOrdinary vs. qualifiedNet Rental IncomeBox 2Rental real estateSection 179Box 11Must track separatelyCharitable ContributionsBox 12aSeparately statedMeals (50%)Box 16CMust 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:

MethodDescriptionIRS ComplianceFIFOFirst purchased = first soldDefault, IRS-acceptedLIFOLast purchased = first soldAccepted but must be consistentHIFOHighest cost = first soldAccepted; minimizes gainsSpecific IDChoose exact lotRequires documentation

Crypto Workpaper Template (per asset):

text

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:

text

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:

IssueCheckFixCapital improvements coded as repairsSingle transaction > $2,500 in Repairs & Maint.Reclassify to Fixed Assets; depreciateOwner draws in payrollDistributions in wage accountsMove to Owner's Draw / EquityPersonal expenses in businessMixed personal chargesReclassify to Due from Owner / ShareholderMeals coded as EntertainmentPre-2018 habit; Entertainment 0% deductibleSeparate Meals (50%) from Entertainment (0%)Loan proceeds in IncomeDeposit from business loan coded as revenueReclassify to Liability accountPrepaid expenses expensedSubscriptions paid for future periodsPro-rate; book prepaid assetSecurity deposits as incomeRefundable deposits in revenueReclassify 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):

text

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):

1. TB — Trial Balance (direct QBO export, unadjusted)
2. AJE — Adjusting Journal Entries (reclassifications, accruals)
3. ATB — Adjusted Trial Balance (TB + AJE)
4. Sch-C or 1120-S — Schedule mapping with line references
5. Fixed-Assets — 4562 depreciation schedule
6. Crypto — Cost basis tracker (if applicable)
7. 1099 — Contractor payment summary for 1099-NEC filing

---

Quick Reference: Common QBO → IRS Line Crosswalk#

text

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#

text

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#

text

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#

text

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