GIFI Excel workpaper
Aggregated GIFI balances based on the engagement’s current Map Table assignments.
Map accounts to T2 schedules, review GIFI assignments, and generate tax workpapers.
Save the T2 destination and Schedule 1 adjustment rule for each account.
| Account | GIFI | Balance | T2 schedule | T2 line | Sign | Addback % | |
|---|---|---|---|---|---|---|---|
| 1000 Cash on Hand / Petty Cash | 1001 Cash | 0.00 | |||||
| 1005 Operating Bank Account | 1001 Cash | 61,800.00 | |||||
| 1200 Accounts Receivable | 1060 Accounts receivable | 14,250.00 | |||||
| 1250 Allowance for Doubtful Accounts | 1062 Allowance for doubtful accounts | 0.00 | |||||
| 1300 Inventory | 1120 Inventory | 0.00 | |||||
| 1400 Prepaid Expenses | — | 0.00 | |||||
| 1500 Furniture & Fixtures | — | 88,000.00 | |||||
| 1510 Accumulated Depreciation - Furniture | — | -31,450.00 | |||||
| 1600 Computer Equipment & Hardware | — | 0.00 | |||||
| 1610 Accumulated Depreciation - Hardware | — | 0.00 | |||||
| 1700 Leasehold Improvements | — | 0.00 | |||||
| 2010 Accounts Payable | 2620 Accounts payable and accrued liabilities | -11,400.00 | |||||
| 2100 Credit Card Payable | — | 0.00 | |||||
| 2200 Payroll Liabilities | — | 0.00 | |||||
| 2300 Sales Tax Payable | — | -2,210.00 | |||||
| 2400 Deferred / Unearned Revenue | — | 0.00 | |||||
| 2500 Bank Loan Payable (Long-term) | 3140 Long-term debt | -46,000.00 | |||||
| 3010 Owner's / Common Equity | 3500 Common shares | -100.00 | |||||
| 3020 Owner's Draws / Distributions | — | 0.00 | |||||
| 3050 Retained Earnings | 3600 Retained earnings/deficit | -53,620.00 | |||||
| 4010 Product Sales Revenue | 8000 Trade sales of goods and services | 0.00 | |||||
| 4020 Service / Fee Revenue | 8000 Trade sales of goods and services | -412,300.00 | |||||
| 4030 Subscription Revenue | 8000 Trade sales of goods and services | 0.00 | |||||
| 4090 Sales Discounts & Returns | — | 0.00 | |||||
| 5010 Cost of Goods Sold - Materials | 8520 Cost of sales | 0.00 | |||||
| 5020 Direct Labor | — | 0.00 | |||||
| 5030 Subcontractor / Freelance Fees | — | 61,200.00 | |||||
| 6010 Advertising & Marketing | — | 0.00 | |||||
| 6050 Bank & Merchant Processing Fees | — | 0.00 | |||||
| 6100 Insurance Expense | — | 8,400.00 | |||||
| 6200 Office Supplies & Software | 8810 Office expenses | 9,900.00 | |||||
| 6300 Professional Fees (Legal & Accounting) | 8860 Professional fees | 6,150.00 | |||||
| 6400 Rent & Facility Expense | — | 48,000.00 | |||||
| 6500 Salaries & Wages (Administrative) | 8620 Employee benefits | 231,480.00 | |||||
| 6550 Payroll Taxes & Benefits | 8620 Employee benefits | 0.00 | |||||
| 6600 Utilities & Telecommunications | — | 9,820.00 | |||||
| 6700 Travel & Entertainment | — | 0.00 | |||||
| 6800 Depreciation Expense | 8670 Amortization of tangible assets | 18,080.00 | |||||
| 8010 Interest Income | — | 0.00 | |||||
| 9010 Interest Expense | — | 0.00 | |||||
Aggregated GIFI balances based on the engagement’s current Map Table assignments.
Create a GIFI import file for tax-preparation software using the firm’s business number.
Excel workpaper showing accounting income, linked additions and deductions, and net income for tax purposes.