How Do I Perform Record Keeping for Rental Income and Expense Amounts?
After you have set up real estate income and expense categories and also created classifications for tracking the properties you own, you will find it very easy to do your bookkeeping with Money. You just need to make sure that you use the appropriate real estate income category to categorize any rent checks you receive as deposits. And, similarly, you need to use the appropriate real estate expense category to record any checks you write or other account withdrawals that are made because of expenses
associated with owning, operating, or maintaining the property.
The other point you need to remember is that you also need to classify income and expense transactions associated with a real estate property by providing the property classification when you record the transaction.
A deposit transaction looks the same as any other deposit transaction. You enter the number, if needed, the date, the "from" information, the amount, the category (which is a real estate income category), and a memo description if needed. Note, however, that Money also provides a
Properties list box in the transaction entry area. After you have added a Properties classification, Money adds these boxes. To use them, simply click the box's button and select the property. For example, if you are recording a rent check from a tenant at a property for which you set up the classification "Rose Hill Manor," select the Rose Hill Manor property from the Properties list box.
Recording a rental expense works in the same way. The transaction entry form area includes a check number, the check date, the name of the
individual or business you are paying, the category information (using real estate expense categories, of course), and a memo description. However, the transaction entry form area also provides Properties boxes that you use to identify the property for which the expense was incurred. If a check is written to pay some expense for the property "Kirkland Square," for example, this information is recorded by selecting the Kirkland Square entry from the Properties list box.
By using the appropriate real estate income and expense categories as well as classifi- cations for each of the properties you own and manage, Money collects the data needed for producing reports that summarize the income, deductions, and cash flow by prop- erty. This information also lets you easily prepare any year-end income tax forms required of a real estate investor.
How do I keep track of outstanding rent payments?
Money doesn't provide the sophisticated accounts receivables features that are avail- able in full-blown business accounting programs. As a result, Money doesn't provide any formal tools for you to use for tracking the amounts that tenants owe you.
You can, however, create a recurring deposits transaction. If you create a recurring deposits transaction for each tenant payment you are owed, Money will remind you to record this deposit-say, at the rent due date. This reminder, in effect, will work as an accounts payable aging. In other words, if you are notified on the 10th of every month that you should record a check from one of the tenants in your Rose Hill Manor building, this reminder will alert you when you haven't been paid.
To set up a recurring deposits transaction, take the following steps:
1. Display the checking account register you usually use for recording real
estate income and expense information.
Click the Accounts & Bills link, and then select Account List. When Money dis-
plays the Pick An Account To Use window, double-click the name of the bank
account you use for this record keeping and checking activity.
2. Indicate that you want to set up a recurring deposit.
To tell Money that you want to set up a recurring deposit for some tenant rent
payment you expect to record every month, click the Deposit tab. Then click the Common Deposits button, choose Recurring Deposits, and then choose Create A New Recurring Deposit from the submenu. Money then displays the Create New Scheduled Deposit dialog box.
3. Describe the tenant rent payment.
Describe the tenant rent check that you are owed. For example, when the dialog box asks "Who is this deposit from?", you answer by providing the tenant name. When the dialog box asks "How often does the deposit occur?", indicate that the deposit frequency is monthly because the tenant pays his rent monthly. When the dialog box asks for the total amount of the deposit, obviously, you enter the rent amount.
After you have provided this information, Money will prompt you to record the rent check each month, if you haven't already recorded it. This means that if Money prompts you to record a rent check, it is probably past due or at least due.
Related Tags: microsoft money
CPA Stephen L. Nelson is the author of do it yourself kits for Incorporating in Michigan, Michgam S corporation, and Michigan limited liability company.
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Generating Astonishing Amounts Of Free Traffic In Any Market At Will...
Important note: The example sites & rankings in this video are using a proprietary method to achieve - Real Estate Accounting - Choosing Most Suitable Services for Your Business
<!-- @page { size: 8.5in 11in; margin: 0.79in } P { margin-bottom: 0.08in } --> Just like any - Affiliate Programs, Air Filtration by Electrostatic Precipitators
Oleg Systems Co. make all types of industrial dust collection systems. Dust collecting equipment - Wealthy Singles Online Personals
Single rich men are unique in the international dating world. There are lots of men who show their r - Is Fear of Spelling Getting in Your Way?
According to Julia Cameron, author of The Artist's Way, the fear of being a bad speller is a remar - How Your Personality Can Grow Your Business
The other day, a colleague of mine told me about a new marketing agency and sent me a link to thei - Getting the Small Business Start Up Help That You Need
When you first decide to start your own small business, you realize you can use all the start up he - 7 Things Small Business Owners Should Know About Payroll Tax Problems
Past due payroll taxes can cause you to lose your business and in some cases, your freedom. The IRS - Are You Learninig Based?
Are you learning based? Does the economic climate have you feeling threatened? With all of the c - Make the Irs Pay Your Gas Bill With Good Recordkeeping!
A disturbing trend is emerging from the IRS-- they are targeting more and more small businesses for
Most viewed articles in this category:
- Discover How to Entertain on a Budget
To most people these two words, entertain and budget, are miles apart. But they don't have to be. Wh - Six Reasons the Merlin Magix is Ideal for your Business
Why the Merlin Magix Phone System Integrated Phone System is ideal as your business phone system - Indian IT's Off-shore Gains
recent revised guidance of Satyam Computer Services (Satyam), the over $1-billion Indian IT se - 7 Sure-Fire Time Management Tricks To Get More Done
Do you know why you don't get all the stuff on your to-do list done? Sometimes it's as sim - How to be Successful in Business
Starting a business and making it work is the primary purpose for having a business to begin with. I - Setting Up a Decorative Painting Portfolio - How Do You Do It?
Setting up a professional looking portfolio is essential to impressing and obtaining clients as they - Home Business Taxes-How To Stop Taxes In Your Home Business From Sneaking Up On You
"Sixty thousand dollars? You guys are joking right?" I had just completed my first year of being fai - The #1 Small Business Phone System
T h e N o . 1 s m a l l - b u s i n e s s phone s y s t e m . . . s i m p l y p o w e r f u l . . .p - Training Employees Within A Budget
Businesses have spent a lot on employee training and their development in order to improve sales, cu - Hollander Consultants Ends 2006 with its Second Highest Year Ever
Hollander Consultants Also has Second Highest 4th Quarter Ever Tualatin, OR: Hollander C

