Finally! Here is a book that shows you how to set up the accounting function for your real estate business in a clean and simple format. Your time is valuable—and should be used to promote your sales—not your record-keeping. Accounting
for Real Estate Agents gives you clear, simple explanations; plus the actual tools and templates you need to keep all your records.
A template is a computer file which is already set up and customized for you to enter your data. It is already prepared for your specific needs. For example, we provide a template in Excel for tracking your driving mileage and expenses—it’s already prepared for you to enter your data as you go. All you need is the Microsoft Excel program on your computer in order to take advantage of this feature. We provide similar files for Quicken and QuickBooks. In the case of those who wish to continue to use paper and pencil accounting, we have given you PDF documents you can print out and use right away. Whichever method you choose, it’s all ready to go!
Accounting for Real Estate Agents includes:
A basic overview of accounting and finance principles
which will give you a solid foundation on important terminology
and financial practices
Detailed instructions and important
tips on how to best use QuickBooks, Quicken, Microsoft
Excel, or paper and pencil methods to set up a quick
and easy accounting system
Guidance on dozens of expenses
normally incurred by real estate agents which can be
used to make even more tax deductions - which saves you
even more money
Transferable Excel, Quicken, QuickBooks
and PDF accounting templates that are available for you
to download and use immediately to help you save time
and stay organized
Screen shots of commonly used functions
so you can see how to proceed correctly
This book is sold electronically. The purchase of this book is non-refundable.
SECTION 1
Introduction
Overview
Testimonials
Files
Files Downloaded
Files on CD
IRS Publications
Record Retention Schedule
Cash or Accrual Basis
Chart of Accounts
Real Estate Agent Business
Personal and Home Office Expenses
Understanding Reports
Profit and Loss Report
Balance Sheet Report
Cash Flow Report
SECTION 2
Excel
Excel 2003 Free Training Courses
Total a column
SECTION 3
Quicken
Commission received and expenses deducted
Mileage
SECTION 4
QuickBooks
Introduction
EASY WAY TO USE QUICKBOOKS
Open RealEstateAgent.qbw
Enter Your Company Information
Password
Administrator Password
Add Users
Backup and Restore
Backup
Restore a file
Getting Around in QuickBooks
Using the Menu Bar
Home Page
Icon Bar
Viewing Your Open Windows
Closing Your Windows
Saving Transactions
HELP!
Lists and Overview
Chart of Accounts
Item List
Other Names List
Moving Other Names
Merging List Items
Add, Edit or Delete Item, Account and Lists
Customer List
Vendor List
Employee List
To Do List - Reminders
Prepare letters with envelopes
Customers
Adding Customers
Entering Commissions
Record expenses
Add a New Item
Reports
Commission received and expenses
deducted
Commissions received by customer
Commissions received more than
$10,000
Advance from a broker
Advance Received
Report – Advance received
Advance deducted from commission check
Check to pay the advance back
Vendors
Vendor Center
Add a Vendor
Address Info Tab
Additional Info
Account Prefill
Report on Vendor Contact List
Enter Bills
Report for Unpaid Bills Detail
Pay Bills
Payment Method
Payment Method: Checks
Payment Method: Credit Card
Payment Method: Online
Credit Cards
Entering Charges
Recording a Credit
Report on Credit Card Account
Enter balance on Credit Card Statements
Write a Check for Credit Card balances
Write Checks
Print single Checks
Print a Batch of Checks
Report for Written Checks
Void a check
Bounced Check
Bank NSF Fee
Report for outstanding invoices
Mileage
Reports on Mileage
Online Banking
Matching transactions
Tutorial for Online Banking
Owners Equity
Owner's Investment
Report on Investment
Owner's Draw
Report on Draw
Loans
Depositing Loans Received
Report for Loans received
Repay the Loan
Report after paying the loan
Business Expenses paid on personal accounts
Cash Expenses
Reconcile
Bank Account
Cleared transactions in Checking account
PETTY CASH ACCOUNT
Credit Cards
Reports
Memorized Reports
Standard Reports
Personal-Home Office Expense
SECTION 5
Paper and Pencil - PDF
Download these pdfs for previews
of Accounting for Real Estate Agents
Easy to use templates for common business expenses
such as business travel expenses and mileage
Testimonials
“Thank you so much for your book. I was able yesterday to recapture all my transactions since June and get my accounting done. Your
methods are very simple and logical. Yay!”
- Julie Fugate, Keller Williams Realty SW Portland,
OR
Full Product Details
ISBN: 978-0-9791240-2-0
0-9791240-2-6 Pages: 149 Format: e-book with QuickBooks, Quicken, Excel, and
PDF Template files for download Publisher: Expert Publishers, Inc. Publication Date: November 2008 Edition Number: Version 2.8