Image 1 of 2
Image 2 of 2
Schedule C & 1099 Tracker
Hand your CPA an organized file.
Rates & Limits
Every IRS figure the workbook uses, in one place: mileage rates and the date they change mid-year, the meals percentage, the home-office rate and cap, and the self-employment tax figures. Review them once a year; every other tab reads from here.
Income
Log every income transaction. Categories cover gross receipts for services, products and other sales, returns and allowances, scrap sales, interest and finance charges, refunds and rebates, and more. The category you pick from the dropdown fills in its likely Schedule C line, for your CPA to confirm.
Expenses
Log date, payee, category, amount, and check number. Each category points to its likely Schedule C line, including Part V other expenses. Memo categories keep equipment purchases, loan principal, and owner's draw off the form lines and total them for your CPA.
Mileage Log
Business miles by trip. Each trip uses the mileage rate for its date, so a mid-year rate change splits between the two rates. Parking and tolls tracked separately. Totals carry to the car and truck line on the Summary.
1099 Tracker
Track who you paid and how much, by category and as a whole-year total per payee. W-9 and 1099-sent columns, entity type and form type recorded per your CPA.
Schedule C Summary
Totals every income and expense category to its likely Schedule C line, down to net profit. Includes cost of goods sold, itemized other expenses, a home-office helper for the simplified method, a self-employment tax estimate, and a check that every row you logged is counted.
Monthly Summary
All income and expense categories broken out by month, calculated from your log entries. Net income per month shows your seasonal cash flow, and a reconciliation shows how the monthly view ties back to net profit.
Looking for someone to manage your spreadsheets and keep your numbers up to date?
We offer an ongoing management service - we'll maintain your financial models, update your data, and keep everything organized and decision-ready so you can focus on running your operation.