Blog Archives

Rental Workbook FY2018 Tax Year Update – FREE DOWNLOAD for current subscribers

Now that everyone is pressing on with the new financial year, don’t forget to download and process your FREE update to your Rental Workbook so that it has the latest tax year updates. Excel 2016 (Office 365), Excel 2010 and

Posted in Uncategorized Tagged with: , , , ,

Tax Time Financial Year End June 2017

It’s that time of year again, and we are busy creating our tax update for you. Among all of the bits & pieces that the government has updated, is a change to some things we can or can’t claim with

Posted in Uncategorized

Upgrade or Renew?

A common question asked at this time of year, is whether to Upgrade the Rental Workbook, or to Renew.  The upgrade is completely separate to the renewal. Your renewal may be due at any time during the year – it

Posted in Uncategorized

Enable Macros / Protected View

In Office, to open any files that contain Macros, you will need to make sure that your Excel settings are not too strict, as the Rental Workbook will not open correctly otherwise. Rather than Enabling All Content (Not recommended), we

Posted in Uncategorized

An error has occurred within WritePropertyToDb

We often see this type of query – please refer to the screen shot below if you see n particular, you have possibly tried to use the program from “inside” the zip folder, as it is only looking in a

Posted in Uncategorized

Common Issues and Solutions

Since we upgraded to the Excel plus Database file solution back in 2014, there have been a few common queries, most of which are easily solved. The new system is based around TWO files. RentalWorkbook VersionNumber.xslm  – This is the

Posted in FAQ, New Version, Uncategorized Tagged with: , , , , , , ,

Upgrade or Renewal Tax Year 2014 and onwards

Version 14 is now available, ready for Tax Year 2014 (July 2013 to June 2014) – Yes we missed out 13… because we created a MAJOR upgrade involving a new database and separate Excel file – this means you will

Posted in Home, New Version, Uncategorized Tagged with: , , , , ,

Office 2013 or not 2013

So where was I? … Ah yes, last year seems so very far away, however I had to set work aside to look after family – all now good, and Excel can have its day again! Recently, we’ve had a

Posted in Uncategorized Tagged with: , , ,

Getting Complex with Dates – Part 2

Having dealt with normal date calculation, and then working days, it’s time to look at some of the other date functions that are often used. This week, we’ll look at Weekday.  Here’s a scenario: If you want to check some dates to

Posted in Uncategorized Tagged with:

Getting Complex with Dates

After last week’s note about dates, a few people asked me about different ways to deal with dates and calculations. Excel has a variety of different functions to use, and the most commonly used is NETWORKDAYS.  The syntax for the

Posted in Uncategorized Tagged with: