TPAR issue - contractors on profit loss report do not match TPAR

  • 1
  • Question
  • Updated 2 months ago
Hello,

In generating my TPAR, I have noticed it hasn't picked up two contractor payments. I can see that the difference is these payments were processed through the 'write cheque' field rather than 'enter/pay bills'
They have still gone to the same account (contractor: abcd locksmiths)
I am assuming there is a setting in generating the report that needs to be changed to include these payments?
Can someone please help?
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Hi Beth,

It maybe that when setting up the contractor, the "include in taxable payments report" wasn't ticked in their details.

Regards,

Sue Renouf
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
https://community.reckon.com/reckon/topics/taxable-payments-reporting

Really well illustrated by Kay at KLM bookkeeping...
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb
Thanks Sue. I should have mentioned, they do have those boxes ticked (and have showed on previous years TPAR)
It is more that the report hasn't seemed to pick up the payments for these two contractors due to the way they were entered in Reckon (via 'write cheques' {as they were paid on a credit card reconciliation} rather then 'enter/pay bills')
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
I don't have that problem Beth so I don't think that is it. What date is on the write cheques?
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
So there is your problem perhaps? It can't pick up the name?
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Or do you end up writing a cheque that has their name on it?
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb
No, the cheque is made out to NAB and the amounts are accounted to the contractor: abcd locksmith account, exactly the same as they would in enter bills.
You may be right as the only difference is the name made out to, between write cheque and enter bills. I'm just unsure how to rectify.
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Do you have a Clearing Account Bank Account? 
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Petty Cash bank account?

Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
If not, you could try a journal entry. Using the same date as the original cheque,
Cr Subcontractors account with GST or NCG code or NCF or FRE (depending what you use and whether they charge GST) and leave the name blank on that line
Dr Subcontractors with GST or NCG code but on this line put the subcontractors name in the Name field.
Try the TPAR again after you try the first one.
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Good idea Beth. I just got to test out my journal entry theory on the sample company data file and it doesn't work! Sorry.
Cheers,
Sue
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb
Thank you so much for all of your time and effort anyway, Sue.
It is still unresolved at this stage. I spent over an hour on the phone with Reckon with no resolution.
I will try again next week when I have more time and energy!
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Hi Beth, I am pretty sure the problem is the name. If you could set up a pretend bank account and call it Clearing Account. Go to the original entry and instead of the expense subcontractor, in the Account field,put in Clearing Account, no tax code and make sure the gross amount is transferred across. Go to the Clearing Account and use the write cheque form to write a pretend cheque to the subcontractor using their name and put it to the subcontractor expense account with the correct GST code. Then look at the TPAR.

Sue
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb
This works, Sue! I can't thank you enough.
Should I do this in future for all contractor payments paid via credit card?
Photo of Sue Renouf

Sue Renouf

  • 532 Points 500 badge 2x thumb
Well done following those instructions! Yes, you need the name of the supplier in the transaction so it seems to be the way to go.
Glad it helped.
Cheers, Sue
Photo of Kathryn

Kathryn

  • 226 Points 100 badge 2x thumb
Hi Beth

Rather than enter as a credit card charge - could you enter the bill then pay the bill via credit card.  That is how we do all of our contractor payments by credit  card and no issue with our TPAR reports.
Photo of Beth Zielinski

Beth Zielinski

  • 336 Points 250 badge 2x thumb
Hi Kathryn,
Thank you for your reply. Do you still enter your credit card reconciliation via 'write cheques'?
There are maybe 70+ transactions that come under the one credit card payment, which is why they have been done in 'write cheques', with the bank name at the top (as they are who debit the entire amount for the month), with the list of individual transactions and accounts underneath.