Help Finances Property Expenses Table Entry

Table Entry

On this page, you can view your property expense entries for a given year in a table, and see how much was spent on each category in any given month. It is a useful place to view the total expenses of each category by month.

You can click on a box and enter expenses by month and category, similar to how one would enter information in an Excel spreadsheet, or Google Sheets document. You can navigate the same way you would using the arrow, tab, and return keys.

The active cell is always outlined in green, and entries will automatically round to the nearest whole number. The number on the table will appear in blue only when a box has one entry in its category for the month. When there are multiple entries in category for a given month, the number will appear in black, and you will no longer be able to edit in the table itself.

Any of the values can be immediately edited by typing over the numbers that were entered, only if they are blue.

ADDING MULTIPLE ENTRIES FOR THE SAME CELL

When you need to include more than one entry for the same month and category, it is necessary to use the green entry bar at the top to add the additional entries. After you have entered in the details and clicked the “save” icon, it will automatically update the table below, adding the new amount to the existing amount.

The updated amount in the cell will change colour from blue to black. This indicates you are no longer able to make updates directly in the table itself. Instead, to make further edits, you will need to go to the specific entries just below the green entry bar, and click on the “edit” icon.

To view all entries for a given month and category, click the respective box and scroll to view the entries underneath the green