Pension Claim

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #21281
    David Grima
    Participant

      Wingecarribee

      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,
      Dave

      #21282
      Tracey Walker
      Participant

        Sutherland Shire

        In 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.
        #21284
        Melissa McCulloch
        Blocked

          Central Coast

          Hi 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

          #22724
          Michael Cherry
          Participant

            Newcastle City

            Hi,

            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

            #22732
            Simone Fisher
            Participant

              Wollondilly

              Hi 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
              Simone

              #22734
              Pete Timmins
              Participant

                Shoalhaven

                Hi 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
                Pete

                #22735
                Michael Cherry
                Participant

                  Newcastle City

                  Thanks 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

                  #22742
                  David Grima
                  Participant

                    Wingecarribee

                    Hi 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 πŸ™‚
                    Dave

                    #23026
                    Pete Timmins
                    Participant

                      Shoalhaven

                      Good 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
                      Pete

                      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.

                      #23056
                      Andrea Dolan
                      Participant

                        Canterbury-Bankstown

                        Hi 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)

                        #23057
                        Avatar photoJason Symons
                        Participant

                          Hi 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

                          #23060
                          Pete Timmins
                          Participant

                            Shoalhaven

                            Thank 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.
                            #23094
                            Tracey Rigby
                            Blocked

                              Moree Plains Shire

                              Good 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 Shire

                              #23095
                              David Grima
                              Participant

                                Wingecarribee

                                Hi 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

                              Viewing 14 posts - 1 through 14 (of 14 total)
                              • You must be logged in to reply to this topic.