FAQ
New Tax Year
Each tax year brings a fresh update to the Rental Workbook. One of our Frequently asked questions is “I can’t see the new tax year – how can I get it there?”.
Every July, we obtain the new Tax Table information from the ATO, add the details to the RW and begin work on testing. Near the end of July, we issue all existing users with instructions on how to upgrade their files. If you are an existing subscriber, make sure we have your up to date email contact information so that you receive this vital update.
Investors Club Members Discount
Are you an Investors Club member? Ask your Support Member for your discount code, and get $25.00 off the RRP!
Line of Credit Extra lines
For all those people who want to record every transaction on their Line of Credit, we’ve created a free Line of Credit Calculator.
This allows input of up to 1,000 transactions per property per year and generates monthly totals that can then be input into the Rental Workbook, or simply provided to your accountant.
It’s particularly useful if you use your LOC for both personal and investment purposes as it automatically splits transactions into each type and tracks the balances.
Free download from our downloads page at http://www.excelaustralia.com.au/downloads/
Lost Data after Upgrade or Renew
Normally, when data is lost or missing, it is because properties were not saved before the upgrade. This is an important step and is not the same as saving the file.
Please check that you have followed the upgrade or renew steps fully and correctly.
If you have followed all steps and you are still losing data on the upgrade or renewal then send us your old Rental Workbook with an email explaining what you have tried to:
support@excelaustralia.com.au
Upgrade or Renewal – Detailed instructions
Important – Please read before upgrading
Before you upgrade, you should properly prepare your existing Rental Workbook.
Renewal problems
Our renewal process is always set to run on the most up to date version of the Rental Workbook. – We issue a new version every July to include all of the new Financial Year updates.
Upgrade or Renewal problems – Excel 2007 user
If you are using Excel 2007, you may have saved your original Rental Workbook as an Excel 2007 file type (e.g. WorkbookName.xlsx)
In order that the Rental Workbook is compatible with most versions of Excel, we use the Excel 97-2003 file type (e.g. WorkbookName.xls) › Continue reading
Excel 2007 or 2010- Setting up Excel for the Rental Workbook
If you’re using Excel 2007 or 2010, you may not have all of the Rental Workbook program working due to the macros not being ‘enabled’.
With these versions of Excel, there are a few extra steps needed to make sure all the macros are accepted – Microsoft have made lots of security enhancements which means that programs that use the security sections (like us) have to work a little harder!
CAUTION: In Excel 2010; If you do not enable Macros when you first open the RW, and have then saved as an Excel Workbook, you may have removed all the programming code! Excel 2010 has a built-in feature that keeps your settings for a particular file. With normal use, this means you won’t have to keep ‘Enabling Macros’ every time you pen the Rental Workbook.
Renew, Rollover and Upgrade – What’s the difference?
There are three separate processes to explain
1) Renewal – This is your annual subscription. Once payment has been processed, we send you a renewal document that runs through a process that gives you another 12 months usage of the Rental Workbook. Always save each of your properties (Rental Workbook > Property > Save) before running a renewal; and then save a backup copy of your Rental Workbook. If you need to renew your Rental Workbook, visit our website and purchase your downloadable renewal at http://www.excelaustralia.com.au/purchase/
How do I enter expenses that cover more than one property?
You can either apportion these between each property, or enter each property’s share of the total on its expense sheet; alternatively, you can simply choose one property as your “default” property and put the whole expense into that property’s sheet. › Continue reading
