ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
RENTAL & BUSINESS EXPENSE TRACKER
2
PRIME CORPORATE SERVICES | Comprehensive Expense Documentation
3
SETTINGS (Update Annually)
4
IRS Standard Mileage Rate:$0.700
5
Receipt Threshold ($):$25
6
Submission Deadline (days):60
7
Return of Excess Deadline (days):120
8
9
COLOR CODING
10
Blue textHardcoded inputs — fields you type into
11
Black textCalculated formulas — do not overwrite
12
Light yellow fillUser input fields
13
Light blue fillReference values pulled from this sheet
14
15
STEP-BY-STEP GUIDE
16
Step 1Update your name, period, and approver in the gray header fields on each tab.
17
Step 2Use 'Rental Property Log' for all rental-related income and expenses (mortgage interest, repairs, depreciation, insurance, etc.).
18
Step 3Use 'Business Expense Log' for all non-rental business expenses (meals, supplies, professional services, etc.).
19
Step 4Write a SPECIFIC business purpose for every expense. Vague descriptions like 'business meal' may fail an IRS audit.
20
Step 5For meals: list ALL attendees and their business relationship.
21
Step 6Use the 'Mileage Log' tab for vehicle expenses. Log every trip with origin, destination, purpose, and miles.
22
Step 7Use 'Home Office Calculator' to substantiate home office deductions under IRS Treas. Reg. §1.280A-2.
23
Step 8Record receipt Y/N and attach physical or digital copies. Required for expenses $25+.
24
Step 9Submit within 60 days. Return unspent advances within 120 days.
25
Step 10Review the 'Summary Dashboard' monthly to ensure completeness.
26
27
IRS SUBSTANTIATION CHECKLIST
28
AmountActual dollar amount of each expense
29
DateDate expense was incurred
30
PlaceVendor name and location
31
Business PurposeSpecific business reason (not just a category)
32
AttendeesNames and business relationship (meals only)
33
ReceiptRequired for expenses $25 or more
34
Entry DateDate entered in this log (contemporaneous proof)
35
36
NON-REIMBURSABLE REMINDERS
37
CommutingHome-to-regular-office miles are NEVER reimbursable
38
Personal mealsOnly meals with a documented business purpose qualify
39
Client giftsLimited to $25/person/year under IRC §274(b)
40
EntertainmentGenerally non-deductible post-2018 TCJA
41
First class travelNot reimbursable without documented medical need
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100