602-357-3275

info@taxgoddess.com

Mon - Fri: 9am - 4pm (AZ)

Rental Property Income and Expense Tracking Sheet (Excel)

December 27, 2023
Himanshu

[featured_image]

Download

Download is available until [expire_date]

Version
Download 0
File Size 74 KB
File Count 1
Create Date December 27, 2023
Last Updated January 8, 2024

Rental Property Income and Expense Tracking Sheet (Excel)

download transactions / input by hand as needed
categorize the transactions
reconcile & balance the accounts (bank, credit cards, loans)
input all payroll information
reconcile payroll accounts, payments, withheld taxes, etc.
review client monthly correspondence for outstanding items / other questions
review client draw account for business expenses
review business expenses for client draws
allocate meals properly between deductible / non-deductible portions
allocate all items to “classes” if function use in the files
allocate all items to various states if multi-state entity
split other tax specific items (depreciation, amortization, interest, accruals, etc.)
compare to previous month in last year for issues
compare to previous month in current year for issues
review for tax changes needed (raise wages, decrease wages)
review for new asset purchases & properly classify
prepare internal workpapers for audit backup if ever necessary
prepare sales tax & file (if applicable)
review need for 1099’s / w-9’s from contractors – request from client
review against overall tax projections (if applicable) to ensure we are “on track”
Analyze any “over arching” issues (audit flags, etc)
review by senior bookkeeper
review by CPA
send final “all OK” or “need changes” email to client.