QuickBooks Tax-Line Mapping Table
|
QuickBooks Tax-Line Mapping
|
Business Returns to Which the Tax-Line Mapping Applies
|
Line in the Business Return to Which Data Flows
|
|
Income: Gross receipts or sales
|
1120, 1120S, 1065
|
Income Statement, Line 1a
|
|
Income: Returns and allowances
|
1120, 1120S, 1065
|
Income Statement, Line 1b
|
|
Income: Interest Income
|
1120
|
Income Statement, Line 3a
|
|
Income: Gross rents
|
1120
|
Income Statement, Line 4a
|
|
Income: Gross royalties
|
1120
|
Income Statement, Line 5
|
|
Income: State tax refund
|
1120
|
Income Statement, Line 8h
|
|
Income: Other income
|
1120, 1120S, 1065
|
Income Statement, Line 8h
|
|
COGS-Schedule A: Purchases
|
1120, 1120S, 1065
|
Income Statement, Line 9a
|
|
COGS-Schedule A: Cost of labor
|
1120, 1120S, 1065
|
Income Statement, Line 9b
|
|
COGS-Schedule A: Section 263A depreciation
|
1120
|
Income Statement, Line 9c
|
|
COGS-Schedule A: Add’l section 263A costs
|
1120, 1120S, 1065
|
Income Statement, Line 9c
|
|
COGS-Schedule A: Meals and entertainment
|
1065
|
Income Statement, Line 9c
|
|
COGS-Schedule A: Other costs
|
1120, 1120S, 1065
|
Income Statement, Line 9c
|
|
Deductions: Comp. of Officers -Schedule E
|
1120
|
Income Statement, Line 30a
|
|
Deductions: Compensation of shareholder/officers
|
1120S
|
Income Statement, Line 30a
|
|
Deductions: Shareholder medical insurance
|
1120S
|
Income Statement, Line 21
|
|
Deductions: Shareholder life insurance
|
1120S
|
Income Statement, Line 21
|
|
Deductions: Shareholder disability insurance
|
1120S
|
Income Statement, Line 21
|
|
Deductions: Compensation of other officers
|
1120S
|
Income Statement, Line 30a
|
|
Deductions: Salaries and wages
|
1120, 1120S
|
Income Statement, Line 30b
|
|
Deductions: Other salaries and wages
|
1065
|
Income Statement, Line 30b
|
|
Deductions: Guaranteed payments-use of capital
|
1065
|
Income Statement, Line 20
|
|
Deductions: Guaranteed payments-partners
|
1065
|
Income Statement, Line 20
|
|
Deductions: Guaranteed pmts-medical insurance premiums
|
1065
|
Income Statement, Line 37
|
|
Deductions: Repairs and Maintenance
|
1120, 1120S, 1065
|
Income Statement, Line 29
|
|
Deductions: Bad debts
|
1120, 1120S, 1065
|
Income Statement, Line 13
|
|
Deductions: Rents
|
1120, 1120S, 1065
|
Income Statement, Line 28
|
|
Deductions: State taxes
|
1120
|
Income Statement, Line 32b
|
|
Deductions: State franchise or inc. tax
|
1120S, 1065
|
Income Statement, Line 32b
|
|
Deductions: Local property taxes
|
1120, 1120S, 1065
|
Income Statement, Line 32d
|
|
Deductions: Payroll taxes
|
1120, 1120S, 1065
|
Income Statement, Line 32d
|
|
Deductions: Other miscellaneous taxes
|
1120, 1120S, 1065
|
Income Statement, Line 32d
|
|
Deductions: Licenses
|
1120, 1120S, 1065
|
Income Statement, Line 24
|
|
Deductions: Interest expense
|
1120, 1120S, 1065
|
Income Statement, Line 22a
|
|
Deductions: Charitable contributions
|
1120
|
Income Statement, Line 15
|
|
Deductions: Depletion
|
1120, 1120S, 1065
|
Income Statement, Line 17b
|
|
Deductions: Advertising
|
1120, 1120S
|
Income Statement, Line 11
|
|
Deductions: Retirement plans/etc.
|
1065
|
Income Statement, Line 27
|
|
Deductions: Pension/profit-sharing/etc.
|
1120, 1120S
|
Income Statement, Line 27
|
|
Deductions: Employee benefit programs
|
1120, 1120S, 1065
|
Income Statement, Line 19
|
|
Deductions: Employee medical insurance
|
1120S, 1065
|
Income Statement, Line 21
|
|
Deductions: Employee disability insurance
|
1120S, 1065
|
Income Statement, Line 21
|
|
Deductions: Meals and entertainment (subj to 50% l
|
1120S
|
Income Statement, Line 25a
|
|
Deductions: Meals and entertainment(subj to 50% li
|
1120, 1065
|
Income Statement, Line 25a
|
|
Deductions: Meals and entertainment (100% deductib
|
1120S
|
Income Statement, Line 25c
|
|
Deductions: Meals and entertainment(100% deductible
|
1120, 1065
|
Income Statement, Line 25c
|
|
Other Deductions: Accounting
|
1120, 1120S, 1065
|
Income Statement, Line 10
|
|
Other Deductions: Advertising
|
1065
|
Income Statement, Line 11
|
|
Other Deductions: Auto and truck
|
1120, 1120S, 1065
|
Income Statement, Line 35
|
|
Other Deductions: Bank charges
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Business gifts
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Commissions
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Continuing/professional education
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Credit & collection costs
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Discounts given
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Dues and subscriptions
|
1120, 1120S, 1065
|
Income Statement, Line 26
|
|
Other Deductions: Independent contractors
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Insurance
|
1120, 1120S, 1065
|
Income Statement, Line 21
|
|
Other Deductions: Janitorial & cleaning
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Laundry
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Legal & professional fees
|
1120, 1120S, 1065
|
Income Statement, Line 23
|
|
Other Deductions: Office expenses
|
1120, 1120S, 1065
|
Income Statement, Line 31
|
|
Other Deductions: Parking
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Postage and Delivery
|
1120
|
Income Statement, Line 37
|
|
Other Deductions: Postage & delivery
|
1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Printing
|
1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Printing & copying
|
1120
|
Income Statement, Line 37
|
|
Other Deductions: Security
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Supplies
|
1120, 1120S, 1065
|
Income Statement, Line 31
|
|
Other Deductions: Telephone
|
1120S, 1065
|
Income Statement, Line 34
|
|
Other Deductions: Telephone/Internet
|
1120
|
Income Statement, Line 34
|
|
Other Deductions: Tools
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Other Deductions: Travel
|
1120, 1120S, 1065
|
Income Statement, Line 33
|
|
Other Deductions: Utilities
|
1120, 1120S, 1065
|
Income Statement, Line 34
|
|
Other Deductions: Other deductions
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Schedule K-Rentals (not Fm 8825): Income-rental
|
1120S, 1065
|
Income Statement, Line 4b
|
|
Schedule K-Rentals (not Fm 8825): Expenses-rental
|
1120S, 1065
|
Income Statement, Line 37
|
|
Schedule K-Portfolio Inc (Loss): Interest income-Bank, CDs, etc.
|
1065
|
Income Statement, Line 3b
|
|
Schedule K-Portfolio Inc (Loss): Interest income-CD’s/etc.
|
1120S
|
Income Statement, Line 3b
|
|
Schedule K-Portfolio Inc (Loss): Interest income-US Treasury obligation
|
1065
|
Income Statement, Line 3c
|
|
Schedule K-Portfolio Inc (Loss): Interest income-U.S. Treas
|
1120S
|
Income Statement, Line 3c
|
|
Schedule K-Portfolio Inc (Loss): Dividend income
|
1120S, 1065
|
Income Statement, Line 2a
|
|
Schedule K-Portfolio Inc (Loss): Royalty income
|
1120S, 1065
|
Income Statement, Line 5
|
|
Schedule K-Portfolio Inc (Loss): Other income
|
1065
|
Income Statement, Line 8h
|
|
Schedule K-Other Income (Loss): Other income
|
1120S
|
Income Statement, Line 8h
|
|
Schedule K-Deductions: Charitable contributions
|
1120S, 1065
|
Income Statement, Line 15
|
|
Schedule K-Deductions: Other deductions
|
1120S, 1065
|
Income Statement, Line 37
|
|
Schedule K-Inv. Interest: Int. exp. on investment debts
|
1065
|
Income Statement, Line 22b
|
|
Schedule K-Inv. Interest: Int. exp.-investment debts
|
1120S
|
Income Statement, Line 22b
|
|
Schedule K-Foreign Tax: Total foreign taxes
|
1120S, 1065
|
Income Statement, Line 32c
|
|
Schedule K-Other items: Sec. 59(e) expenses
|
1120S
|
Income Statement, Line 37
|
|
Schedule K-Other items: Section 59(e) expenses
|
1065
|
Income Statement, Line 37
|
|
Schedule K-Other items: Tax-exempt interest income
|
1120S, 1065
|
Income Statement, Line 3d
|
|
Schedule K-Other items: Other tax-exempt income
|
1120S, 1065
|
Income Statement, Line 8g
|
|
Schedule K-Other items: Nondeductible expenses
|
1120S, 1065
|
Income Statement, Line 36c
|
|
B/S-Assets: Cash
|
1120, 1120S, 1065
|
Balance Sheet, Line 1, End of Year
|
|
B/S-Assets: Accts. Rec. and trade notes
|
1120S, 1065
|
Balance Sheet, Line 2a, End of Year
|
|
B/S-Assets: Accts. Rec. and trade notes.
|
1120
|
Balance Sheet, Line 2a, End of Year
|
|
B/S-Assets: U.S. government obligations
|
1120, 1120S, 1065
|
Balance Sheet, Line 4, End of Year
|
|
B/S-Assets: Tax-exempt securities
|
1120, 1120S, 1065
|
Balance Sheet, Line 5, End of Year
|
|
B/S-Assets: Other current assets
|
1120, 1120S, 1065
|
Balance Sheet, Line 12, End of Year
|
|
B/S-Assets: Loans to stockholders
|
1120
|
Balance Sheet, Line 6, End of Year
|
|
B/S-Assets: Loans to shareholders
|
1120S
|
Balance Sheet, Line 6, End of Year
|
|
B/S-Assets: Mortgage/real estate loans
|
1120, 1120S, 1065
|
Balance Sheet, Line 7, End of Year
|
|
B/S-Assets: Other investments
|
1120, 1120S, 1065
|
Balance Sheet, Line 12, End of Year
|
|
B/S-Assets: Buildings/oth. depr. assets
|
1120, 1120S, 1065
|
Balance Sheet, Line 8a, End of Year
|
|
B/S-Assets: Accumulated depreciation
|
1120, 1120S, 1065
|
Balance Sheet, Line 8b, End of Year
|
|
B/S-Assets: Depletable assets
|
1120, 1120S, 1065
|
Balance Sheet, Line 9a, End of Year
|
|
B/S-Assets: Accumulated depletion
|
1120, 1120S, 1065
|
Balance Sheet, Line 9b, End of Year
|
|
B/S-Assets: Land
|
1120, 1120S, 1065
|
Balance Sheet, Line 10, End of Year
|
|
B/S-Assets: Intangible assets
|
1120, 1120S, 1065
|
Balance Sheet, Line 11a, End of Year
|
|
B/S-Assets: Accumulated amortization
|
1120, 1120S, 1065
|
Balance Sheet, Line 11b, End of Year
|
|
B/S-Assets: Other assets
|
1120, 1120S, 1065
|
Balance Sheet, Line 12, End of Year
|
|
B/S-Liabs/Cap: Accounts payable
|
1065
|
Balance Sheet, Line 14, End of Year
|
|
B/S-Liabs/Cap: S-T Mortgage/note/bonds pay
|
1065
|
Balance Sheet, Line 15, End of Year
|
|
B/S-Liabs/Cap: Other current liabilities
|
1065
|
Balance Sheet, Line 19, End of Year
|
|
B/S-Liabs/Cap: All nonrecourse loans
|
1065
|
Balance Sheet, Line 16, End of Year
|
|
B/S-Liabs/Cap: L-T Mortgage/note/bonds pay
|
1065
|
Balance Sheet, Line 18, End of Year
|
|
B/S-Liabs/Cap: Other liabilities
|
1065
|
Balance Sheet, Line 19, End of Year
|
|
B/S-Liabs/Eq.: Accounts payable
|
1120, 1120S
|
Balance Sheet, Line 14, End of Year
|
|
B/S-Liabs/Eq.: S-T Mortgage/note/bonds pay
|
1120, 1120S
|
Balance Sheet, Line 15, End of Year
|
|
B/S-Liabs/Eq.: Other current liabilities
|
1120, 1120S
|
Balance Sheet, Line 19, End of Year
|
|
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay
|
1120, 1120S
|
Balance Sheet, Line 18, End of Year
|
|
B/S-Liabs/Eq.: Other liabilities
|
1120, 1120S
|
Balance Sheet, Line 19, End of Year
|
|
B/S-Liabs/Eq.: Loans from stockholders
|
1120
|
Balance Sheet, Line 17, End of Year
|
|
B/S-Liabs/Eq.: Loans from shareholders
|
1120S
|
Balance Sheet, Line 17, End of Year
|
|
B/S-Liabs/Eq.: Capital stock
|
1120S
|
Balance Sheet, Line 21b, End of Year
|
|
B/S-Liabs/Eq.: Capital stock - Preferred Stk
|
1120
|
Balance Sheet, Line 21a, End of Year
|
|
B/S-Liabs/Eq.: Capital stock - Common Stk
|
1120
|
Balance Sheet, Line 21b, End of Year
|
|
B/S-Liabs/Eq.: Paid-in or capital surplus
|
1120, 1120S
|
Balance Sheet, Line 22, End of Year
|
|
B/S-Liabs/Eq.: Treasury stock
|
1120S
|
Balance Sheet, Line 28, End of Year
|
|
B/S-Liabs/Eq.: Cost of Treasury stock
|
1120
|
Balance Sheet, Line 28, End of Year
|
|
Schedule M-1: Depreciation per books
|
1120, 1120S, 1065
|
Income Statement, Line 18
|
|
Schedule M-1: Expenses on books not on return
|
1120, 1120S, 1065
|
Income Statement, Line 37
|
|
Schedule M-1: Income on books not on return
|
1120, 1120S, 1065
|
Income Statement, Line 8h
|
|
Schedule M-1: Tax-exempt interest income
|
1120
|
Income Statement, Line 3d
|
|
Fm 8825-20a: Income-other rental real estate
|
1120S, 1065
|
Income Statement, Line 8h
|
|
Fm 8825-A: Gross rents
|
1120S, 1065
|
Income Statement, Line 8h
|
|
Fm 8825-A: Advertising
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Auto and travel
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Cleaning and maintenance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Commissions
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Insurance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Legal and other prof. fees
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Interest expense
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Repairs
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Taxes
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Utilities
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Wages and salaries
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Other misc. rental expenses
|
1065
|
Income Statement, Line 37
|
|
Fm 8825-A: Other miscellaneous expenses
|
1120S
|
Income Statement, Line 37
|
|
Fm 8825-B: Gross rents
|
1120S, 1065
|
Income Statement, Line 8h
|
|
Fm 8825-B: Advertising
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Auto and travel
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Cleaning and maintenance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Commissions
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Insurance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Legal and other prof. fees
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Interest expense
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Repairs
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Taxes
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Utilities
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Wages and salaries
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Other misc. rental expenses
|
1065
|
Income Statement, Line 37
|
|
Fm 8825-B: Other miscellaneous expenses
|
1120S
|
Income Statement, Line 37
|
|
Fm 8825-C: Gross rents
|
1120S, 1065
|
Income Statement, Line 8h
|
|
Fm 8825-C: Advertising
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Auto and travel
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Cleaning and maintenance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Commissions
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Insurance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Legal and other prof. fees
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Interest expense
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Repairs
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Taxes
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Utilities
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Wages and salaries
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Other misc. rental expenses
|
1065
|
Income Statement, Line 37
|
|
Fm 8825-C: Other miscellaneous expenses
|
1120S
|
Income Statement, Line 37
|
|
Fm 8825-D: Gross rents
|
1120S, 1065
|
Income Statement, Line 8h
|
|
Fm 8825-D: Advertising
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Auto and travel
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Cleaning and maintenance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Commissions
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Insurance
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Legal and other prof. fees
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Interest expense
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Repairs
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Taxes
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Utilities
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Wages and salaries
|
1120S, 1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Other misc. rental expenses
|
1065
|
Income Statement, Line 37
|
|
Fm 8825-D: Other miscellaneous expenses
|
1120S
|
Income Statement, Line 37
|
|
Dividends: Div.--< 20% owned corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--20% or > corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--debt-financed stk
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--< 20% pref. stk
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--20% or > pref. stk
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--< 20% foreign. corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.--20% or > foreign corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.-wholly owned foreign
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.-domestic corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.-affil group members
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Div.-from FSC’s
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Other div.-foreign corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Inc.-controlled foreign corps
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Foreign dividend gross up
|
1120
|
Income Statement, Line 8h
|
|
Dividends: IC-DISC and former DISC div
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Other dividends
|
1120
|
Income Statement, Line 8h
|
|
Dividends: Ded.-div. paid on pref. stk
|
1120
|
Income Statement, Line 37
|
|
Tax/Payments: Estimated Qtrly Payment #1
|
1120
|
Estimated Tax Payments Worksheet
|
|
Tax/Payments: Estimated Qtrly Payment #2
|
1120
|
Estimated Tax Payments Worksheet
|
|
Tax/Payments: Estimated Qtrly Payment #3
|
1120
|
Estimated Tax Payments Worksheet |