Calculate working days in Excel

Posted by Datasift on 9 March 2019

Often in Excel models we need to calculate the number of working days between two dates.

For example we have a sales figure generated between two dates and we want to calculate the sales per day so

that we can test our forecast for reasonableness.

For this we can use the function NETWORKDAYS.

 

The function has three components - Start_date and End_Date are fairly obvious, but what is the Holidays component?

It is simply a list of days that you need excluded from the calculation, for example public holidays.

In the example below, we have used a list of public holidays and created a named range called Hols2019 across cells Q4:Q13

By including the range in the formula, those dates that fall between our start and end dates are excluded to give an answer of 59 days,

Whereas in the second line we have just used start and end dates to get an answer of  63 days.

 

 

Posted in: Top Tip  

Less than 6 Months to prepare.....

Posted by Datasift on 13 February 2019

Single touch payroll is coming to small companies of under 20 employees on 1 July 2019.

So. What will that mean to you? Should you be worried?

No. See it as an opportunity to embrace some of the technology you have been hearing about.

If, like many of you are, Xero is your preferred software for keeping your accounting records straight, you already have access to a compliant payroll.

 

This really is not the big scary monster that you might be thinking it is! A couple of hours of guidance from a trusted advisor should see you confident and competent and if you still do not like the idea, you can always pay someone to take on JUST payroll.

 

Remember that reducing pay frequency from weekly to monthly will save you BIG.

 

We are here to help, should you just want to talk through the options. 08 6141 3371

Posted in: News  

Instant asset write-off

Posted by Datasift on 4 February 2019

Start Planning your year end to take advantage!

On January 29, 2019 the Prime Minister announced that the instant asset write-off would be extended to 30 June 2020 and that the threshold would be increased to $25,000.

These changes take effect from January 29, 2019.

For more information refer to the Minister for Small and Family Business, Skills and Vocational Education media release.
Posted in: News  

Single Touch Payroll Update

Posted by Datasift on 16 January 2019

On Friday 7th December 2018, the ATO issued a clarification in relation to the legislation to extend Single Touch Payroll to all employers from 1st July 2019.

 


Please note that this legislation has not yet passed the Parliament, despite some public commentary that suggests it has.


The Treasury Laws Amendment (2018 Measures No.4) Bill 2018 was passed by the Senate this week with proposed amendments to other measures contained in the Bill.

The Bill has now been referred back to the House of Representatives to consider those amendments.
As the Parliament has finished sitting for the year, the next opportunity for the House to hear the Bill will be 12th February 2019.


The ATO advise that their focus has not changed. They remain committed to supporting larger employers to transition to STP reporting,

encouraging employers with deferrals ending to start reporting and promoting STP to those employers who can voluntarily come on board.


The ATO will be working with those companies who intend to build low-cost STP solutions for micro employers (14 employees).


See www.ato.gov.au/STPsolutions for more information.

Posted in: News  

Money. Money. Money.

Posted by Datasift on 4 January 2019

Cash. A small word that is massive to a business. If your cashflow is bad, it can drag the whole business down faster than most other things.

 

Consider doing some practical things to help your cashflow get better. Formulate a credit policy. Communicate it to your customers, they are more likely to pay you on time if you tell them what your terms are!

Try automating your reminders and do not be afraid to stop credit if a customer is not paying.

If you need practical advice that WORKS, give us a call.

Datasift - helping you make cents of your data

Posted in: Top Tip