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

  • 1
  • Question
  • Updated 1 year ago
  • 1
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

  • 190 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
1 year ago
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 50,950 Points 50k 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.
2018-07-17T03:36:41+00:00
Photo of Sue Haddrell

Sue Haddrell

  • 190 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.
1 year ago
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.


1 year ago
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 50,950 Points 50k badge 2x thumb
Chris you can check this without excel. Hth
1 year ago
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?

1 year ago
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 50,950 Points 50k badge 2x thumb
Well I certainly could.
2018-07-17T03:38:14+00:00
Photo of Sue Haddrell

Sue Haddrell

  • 190 Points 100 badge 2x thumb
You may want to share how then
1 year ago
Photo of Tanya Briggs

Tanya Briggs, Accredited Partner

  • 952 Points 500 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.  
1 year ago
Photo of Sue Haddrell

Sue Haddrell

  • 190 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.
1 year ago
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.
2018-07-17T04:25:22+00:00
Photo of Sue Haddrell

Sue Haddrell

  • 190 Points 100 badge 2x thumb
Thanks Chris,
Hopefully he can, or I have a lot of manual work to do.
Sue
2018-07-17T05:06:36+00:00
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.
  • 1

Powered by Get Satisfaction