-
190 Points
Posted 1 year ago
Kevin Russell, Accredited Partner
-
53,078 Points
-
170 Points
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.
Kevin Russell, Accredited Partner
-
53,078 Points
-
170 Points
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?
Kevin Russell, Accredited Partner
-
53,078 Points
Tanya Briggs, Accredited Partner
-
982 Points
-
190 Points
-
170 Points
-
190 Points
Hopefully he can, or I have a lot of manual work to do.
Sue
-
170 Points
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.
Related Categories
-
Accounts Hosted
- 5432 Conversations
- 1638 Followers
Sue Haddrell