Overview

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.

email the author with your comments or questions

Features

Table of Contents

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

Table of Contents
Accounting Resources
Sample Reports
Sample Task Completion

Easy to use templates for common business expenses such as business travel expenses and mileage

Testimonials

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