TPAR - I would like to export a TPAR report to excel. Is that possible with Accounts Hosted

  • 1
  • Question
  • Updated 1 month ago
My accountant is asking for a the annual TPAR report in excel or pdf format.  I am using Reckon Accounts Hosted and I can't seem to find anywhere that will allow me to do this.  Does anyone know if this is possible????
Photo of Sue Haddrell

Sue Haddrell

  • 160 Points 100 badge 2x thumb

Posted 1 month ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,734 Points 20k badge 2x thumb
Why on EARTH is he asking for that? You might want to ask. Seems to me he doesnt know what he is doing.
Photo of Sue Haddrell

Sue Haddrell

  • 160 Points 100 badge 2x thumb
Accountant definitely knows what he is doing.  We haven't submitted before and he is helping me capture all that I have to capture.  An excel sheet would help me as well.
Photo of Chris

Chris

  • 170 Points 100 badge 2x thumb

Hi Sue,

I can see why your Accountant would want the TPAR report in excel format as quite often the total of the subcontractors on the TPAR report ( which we have to add up manually) do not agree with the total of subcontractors shown in Reckon. The reasons for such could be that the subcontractor has not been selected to be included in the TPAR or payments are made to subcontractors for materials are incorrectly included in the TPAR.


Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,734 Points 20k badge 2x thumb
Chris you can check this without excel. Hth
Photo of Chris

Chris

  • 170 Points 100 badge 2x thumb

I would use excel to obtain the total on the TPAR which often contain in excess of 100 subcontractors. Without knowing the TPAR total I would not be able to reconcile the TPAR with the total of subcontractors showing in Reckon. Are you able to get the TPAR total without manually adding up the subcontractors?

Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 37,734 Points 20k badge 2x thumb
Well I certainly could.
Photo of Sue Haddrell

Sue Haddrell

  • 160 Points 100 badge 2x thumb
You may want to share how then
Photo of Tanya Briggs

Tanya Briggs, Accredited Partner

  • 382 Points 250 badge 2x thumb
When you generate the TPAR, after exporting a page appears on your screen with the TPAR on it.  There is a Print icon at the top of the report.  Use this to print to PDF for your accountant.  It doesn't have totals on it, but you don't mention that your accountant has requested totals.  
Photo of Sue Haddrell

Sue Haddrell

  • 160 Points 100 badge 2x thumb
He does actually want the total, which is why he has asked if it can be in excel format.  Our TPAR report is well in excess of 100, probably close to 300.
Photo of Chris

Chris

  • 170 Points 100 badge 2x thumb
Hopefully Rav from Reckon can provide a simple solution to exporting the TPAR in excel format or how to produce a report in the current format with the totals in place.
Photo of Sue Haddrell

Sue Haddrell

  • 160 Points 100 badge 2x thumb
Thanks Chris,
Hopefully he can, or I have a lot of manual work to do.
Sue
Photo of Chris

Chris

  • 170 Points 100 badge 2x thumb
Hi Sue,
An alternative is to export the Reckon ledger account for contractors in excel format and then sort by alphabetical order. Once done get a total for each contractors and compare this with the the total for each contractor shown on the TPAR.