Pension Claim
- This topic has 13 replies, 10 voices, and was last updated 2 years, 8 months ago by
David Grima.
-
AuthorPosts
-
August 11, 2021 at 9:16 am #21281
Hello all,
So it’s that time of the year and I have again received a request from the Audit Office for our claim to be in their required format.
Pathway doesn’t even go close to giving me the data in the format they require.
Wondering whether you can confirm if:-
– you are with Audit Office and have received this request
– whether you intend submitting your claim in their format
– what you did last year (i.e. did you submit in their format or not)
If you are not with the Audit Office, I would be interested to know if you have received a similar request from your contract auditor, and if you have, whether you intend complying with their request.
Thank you,
DaveAugust 11, 2021 at 9:48 am #21282In answering your question we are with the audit office and we received the request for the information.
Last year we submitted everything they asked for and it took time to pull together which was a rush as it was a short time frame that they provided.
This year I have completed the format by using MS query to extract the data required out of Pathway admittedly I had to use multiple tables to get it all which still took time.
The only thing we havenβt supplied is the delegation for approving the rebates (write offs as they call it)
-
This reply was modified 4 years, 9 months ago by
Tracey Walker.
August 11, 2021 at 10:07 am #21284Hi David
We had that request last year from the AO as well. We are still running Authority and Pathway.
I attempted to get the information from both systems in the format requested but it took too long.
We will not be in a position to re-format to any format different to what comes out of the systems this year.
Mel
October 20, 2022 at 12:08 pm #22724Hi,
To those Councils who use the Audit Office did they request your Pension Claim information again this year in a specific format?
If so – what was the requested format?
Thanks so much
Mick
October 21, 2022 at 4:26 pm #22732Hi Mick,
We’re with the Audit Office & they didn’t ask us for the claim to be in any specific format. I have always provided them with our Centrelink Pensioner Verification saved in Excel & an Excel query from Authority of the subsidy claim data table which gives them a list of all of the assessments & claim amounts in the PDF audit report so this may have been enough to satisfy them.
Thanks
SimoneOctober 24, 2022 at 2:18 pm #22734Hi Mick,
We are also with the Audit Office and since August 2020 have been providing the following information as per their request.
An excel sheet (refer to tab: Detailed spreadsheet of claims) listing in columns:
– Pensioner Name
– Pensioner ID number
– Property address where concession claimed
– Property ID number – Annual Ordinary rates for the year for the property
– Amount written-off for ordinary rates
– Amount written-off for water rates
– Amount written-off for sewerage rates
– Total amount written-off
– Period of claim (from and to)
– Pensioner matched to Centrelink report [Yes / No].* The details for each pensioner should be entered into rows and a separate line used for each pensioner for each year of their claim.
* The total of that spreadsheet must equal the Application for Pensioner Concession Subsidy, the amount noted on the General Managers Certificate and the documents supporting the amount written-off by the delegated officer or Council resolution. Each pensioner must be validated by the Council as a valid pensioner, if the pensioner is not validated by the Centrelink report, other evidence must be provided to audit for each of those pensioners.Matching report (ie Department of Veteran Affairs and Department of Social Services), which matches the sheet for the rating year.
* If there are any unmatched pensioners, reasons must be provided together with supporting documentation, such as copies of pensioner applications and copies of pensioner cards to support why a rebate was provided to them.
I am very interested to know that not every council is being asked to provide the same detail. As you can appreciate this is very time consuming not only to extract the rates details but to then merge our water and sewer details into the spreadsheet as well.
Regards
PeteOctober 24, 2022 at 2:57 pm #22735Thanks Peter and Simone for the feedback. We are back with the Audit office from next year so am just making arrangements to minimize shocks.
Thanks again
Mick
October 27, 2022 at 8:37 pm #22742Hi all,
I moved from Bayside to Wingecarribee which meant a change from Pathway to P&R.
P&R does do the claim so much better (almost in the format they requested) but unfortunately it did not negate the need for them to ask me stupid questions π
DaveJuly 31, 2023 at 2:14 pm #23026Good afternoon Rating Professionals,
We are still with the Audit Office and since August 2020 have been providing the information detailed below as per their request.
I am very interested to know if:
i) you are requested to provide the same information?
ii) do you comply or provide them with the information as provided by your rating system?
iii) are you with Audit NSW or an ASP (Audit Service Provider)?Thank you in anticipation.
Regards
PeteAn excel sheet (refer to tab: Detailed spreadsheet of claims) listing in columns:
β Pensioner Name
β Pensioner ID number
β Property address where concession claimed
β Property ID number β Annual Ordinary rates for the year for the property
β Amount written-off for ordinary rates
β Amount written-off for water rates
β Amount written-off for sewerage rates
β Total amount written-off
β Period of claim (from and to)
β Pensioner matched to Centrelink report [Yes / No].* The details for each pensioner should be entered into rows and a separate line used for each pensioner for each year of their claim.
* The total of that spreadsheet must equal the Application for Pensioner Concession Subsidy, the amount noted on the General Managers Certificate and the documents supporting the amount written-off by the delegated officer or Council resolution. Each pensioner must be validated by the Council as a valid pensioner, if the pensioner is not validated by the Centrelink report, other evidence must be provided to audit for each of those pensioners.Matching report (ie Department of Veteran Affairs and Department of Social Services), which matches the sheet for the rating year.
* If there are any unmatched pensioners, reasons must be provided together with supporting documentation, such as copies of pensioner applications and copies of pensioner cards to support why a rebate was provided to them.
August 15, 2023 at 4:33 pm #23056Hi Pete,
We are with the Audit office and since their first request a few years ago, where we refused to provide it in an altered state, they haven’t asked for it again. Although, we have a new team this year, so they may ask this time. But my answer will be the same. Our software (Pathway) does not provide the data in an excel or csv format, and we will not be altering the reports and jeopardising the integrity of the data.
Andrea
Canterbury-Bankstown (CBCity)August 15, 2023 at 4:53 pm #23057Hi Pete,
I agree with Andrea.
We submit our documents in PDF format, and have never had an issue after their first request to provide it in the format they wanted.
At that time we had an acting CFO who was previously an auditor. He said the auditors have the capability and resources required to pull the data out of the format provided and into the format they require.
Cheers
Jason
August 16, 2023 at 4:38 am #23060Thank you Andrea and Jason, I will be refusing to provide the additional information except for samples. Our CFO was also previously an auditor.
Regards
Pete-
This reply was modified 2 years, 9 months ago by
Pete Timmins.
September 25, 2023 at 3:20 pm #23094Good afternoon Rating Professionals,
I have a ratepayer applying for a rebate on a commercial caravan park that he owns and resides at. Does he qualify for the rebate being rated as a commercial property?
Tracey
Moree Plains ShireSeptember 26, 2023 at 9:25 am #23095Hi Tracey,
Provided the property is registered in his name and that he can prove it is his principal place of residence, I don’t see why not.
Dave -
This reply was modified 4 years, 9 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.