Property Management Software

FAQ > Data Entry On The Worksheet

1. What is a worksheet?
2. How should I use the worksheet?
3. How can I enter my transactions?
4. How do I enter multiple transactions for the same expense or income row in a month?
5. Why is Insurance and Taxes in the Loan Section?
6. How can I enter a one-time transaction that is not on the worksheet?
7. How can I delete my transaction?
8. How can I enter date for a transaction?
9. How can I add notes to a transaction? Where do these notes show up?
10. How can I attach receipts/documents to my transactions?
11. How can I split a transaction?
12. Why can't I split an income transaction?
13. What is "Adding Recurring Rules" do?
14. How do I cancel a rule?
15. How do I track utility amounts to be collected from tenant that are paid by me?

2. How should I use the worksheet?

Simplify'em will record all your transactions as they are entered. Your payments can be entered directly into the cells on the worksheet, or using the ledger located near the bottom left of the screen. Transactions may also be recorded using "Recurring Rules", which automate the recording process by tracking recurring items intuitively. See details on-
" How do I enter transactions on the worksheet? "

.

3. How can I enter my transactions?

Simplify'em will record all your transactions as they are entered.

You can record transactions using any of the following simple ways:

1. You can enter your payments directly in to the cells on the worksheet.
When you record a payment this way, the transaction date is defaulted to the 1st of the month.

2. If you want to enter details for the transaction like a different date other than the 1st of the month or notes, you should click on the "Edit Transaction" icon:

Clicking on the icon will bring up the "Record" window that will allow you to change the amount, date and add details for this transaction.


3. If you are the person who has a bunch of receipts and want to enter all your transactions fast, you should use the ledger located near the bottom left of the screen .

As you keep adding transactions using this ledger, SimplifyEm will record them on the worksheet and even create multiple transactions in a month. If the row does not exist on the worksheet, SimplifyEm will create a row you as well!

4. How do I enter multiple transactions for the same expense or income row in a month?

SimplifyEm allows you to enter multiple payments within a month. You can do this by:

2. Now, click on the "Record Another Payment" link which will create a new row on the window. You can then enter the transaction amount and other details and save.

Once you save the multiple payments, the worksheet will show the cell with a multi tag indicating there are multiple transactions recorded within this month.

5. Why is Insurance and Taxes in the Loan section?

On the Customize page for a property, under the "Loan, Tax & Insurance" section, Insurance and Taxes appear with the Loan.



The reason for this is some loans may include payments for taxes and insurance. Simplify'em provides guidance in setting up your loan to reflect how the actual payments are made.

6. How can I enter a one-time transaction that is not on the worksheet?

Everyone has certain unexpected transactions - like emergency plumbing repairs and other unpredictable events - these can easily be entered on the Worksheet as one time payments. You can use the ledger located near the bottom left of the screen to enter them.



Once you add your transaction, SimplifyEm will create a one time payment row on the worksheet under the appropriate month.

7. How can I delete my transaction?

You can delete your transaction two ways in SimplifyEm:

If you have multiple transactions recorded in a cell for a month or the cell is grayed out because it has a 'Alloc' or 'split' next to it, and you want to delete a transaction that cell do the following:

a. Select the cell you want to delete the transaction for. (If you have multiple transactions recorded, the cell will have a Multi tag next to it).

b. Click on the "Edit Transaction" icon next to the cell. This will open the "Record" window showing you the multiple transactions.

c. Click on the delete button next to the transaction you want to delete and then click Save. This will delete the transaction.

8. How can I enter date for a transaction?

To enter date other than the 1 st of the month for a transaction, click on the "Edit Transaction" icon:

9. How can I add notes to a transaction? Where do these notes show up?

To enter notes for a transaction, select the cell and click on the "Edit Transaction" icon:



Clicking on the icon will bring up the "Record" window that will allow you to change the amount, date and add details for this transaction. These notes will show up on the Income and Expense Report.

10. How can I attach receipts/documents to my transactions?

To attach a receipt/document to a transaction, click on the "Attach File" icon next to the selected cell.



This will open the attach file window. Click on the "Choose File" button to browser through your computer and locate the file you want to attach to the transaction. Remember, attaching a file is a premium service, so you will need to upgrade to premium.

11. How can I split a transaction?

SimplifyEm allows you to split all expense and income transactions (except rent received) across properties, IRS categories, and time periods. For example, you send $5000 to your property manager for two of your rentals - the amount can be split and allocated to the specific properties. You cannot split a transaction into another year.

You can split a transaction by:

2. Enter the amount you want to split in to the amount field and then clicking on the Split link next to it.



3. This will open the “Split Transaction” window. You can now split the transaction on this window.

12. Why can't I split a rent transaction?

If you have a lease setup for a tenant, SimplifyEm will not allow you to split a transaction. Instead, it allows you to allocate the rent payment you receive to the month you received it for. See "How does SimplifyEm track my of rents work?" for more details.

13. What is "Adding Recurring Rules" do?

Simplify'em can save a lot of time by automatically tracking your payments. If you create "Rules" for expected/recurring transactions like mortgage, Simplify'em will know how and when to record these payments for you.

You can add a recurring rule for a row as follows:

1. Click on “Add Rule” link next to the row name you want to setup a rule for



2. Add the amount you want SimplifyEm to record for you, the "Start Date" you want SimplifyEm to record the amounts from and for the frequency of months the amounts should be recorded and save.

When you do this, Simplify'em will record these payments for you on the worksheet starting from the start date you setup. No more repetitious data entry!

A Recurring tag is placed next to the row name on the worksheet to indicate a rule has been setup.

14. How do I cancel a rule?

Cancel a recurring rule from the Rule menu on the worksheet:



The rule will be canceled from "today's date" and all previous amounts are kept.

15. How do I track utility amounts that I pay that need to be collected from tenant?

For example you paid $200 for utilities in July for the tenant. The tenant will be paying you the $200 in August.

Below are the steps you can take to track utilities paid for tenant and then bill to tenant:

1. Go to the "Customize Worksheet" page for the selected property.

2. Under the "Other Income" section for Rents Received, click on "Add New Items"link. This will create a new item name.

Rename this row to - "Utilities from Tenant" and select it. This will create a row under your Income section on the Worksheet.

3. Since you paid $200 for utilities in July for the tenant, enter it as an expense in July for your Utility row.

See " How do I create rows on the worksheet? " to learn how to create a utility expense row.

4. When you get the $200 in August from the tenant for the utility bill, enter that amount in the August cell for the utility income row for this tenant that you created in step 2.

NOTE: If you get a single check from tenant for both the rent and utilities ($800), enter $600 in rent row and $200 in utilities row.