TPAR - Supplier Credits


The report is showing a higher amount paid and not picking up the credit's.
How can I fix prior to lodging without changing prior period transactions (GST) already lodged?
Comments
-
Hi Kylie
Unfortunately, this is a limitation of the integrated TPAR feature as it can only pick up Cheque & Bill Payment transactions.
I have a memorised report I create specifically for TPAR which I cross-reference my TPAR-feature-generated data with this as this report is more accurate.
TIP: If your report Preferences are set to Net, edit the Preference to Gross for the purposes of this report. (You can change it back to Net again once the report is modified & memorised as it will retain it)
- Do a “Find” on your applicable TPAR-related account(s) for the last FY
- Generate it into a report & add/remove columns as required (I have Type, Date, Num, Description, Paid Amount & Tax Amount – in that order)
- In “Modify Report”, make sure you have “Cash” basis selected & select “Supplier” for Total by, “Date” for Sort by & select to Sort in “Ascending order”
- On the Header/Footer tab, type in “Annual TPAR Report” as the Report Title
- Click OK to save/update
- If necessary, re-order any columns as preferred then when happy with the layout, click on Memorise (I have it memorised under my “Suppliers” Report Group)
If you have any Suppliers which you have both (non-incidental) Labour AND Materials from, I’d recommend setting up 2 Suppliers.
All the details can be identical, except for the List Name – eg 1 could be called “ABC (Lab)” & the other would be “ABC (Mat)”
This allows you to separate the components for TPAR reporting accuracy.
(It’s now possible to enter the TPAR Suppliers directly into the Portal so if there are only a handful & the integrated TPAR feature data isn’t correct, I do this rather than uploading an TPAR Export File)
Shaz Hughes Dip(Fin) ACQ NSW, MICB
Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)
Accounted 4 Bookkeeping Services
Ballajura, WA
0422 886 003
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
Hi Shaz,
Thanks for this. I have written report. All good but I think Reckon should review this to include Credit's in the totals.
Cheers Kylie1