GST Reconciliation Report - Save the filed amounts entries
AU There was a discrepancy between GST ac balance at EOQ on the Balance Sheet & the GST refund for the end of quarter BAS. Using the GST Reconciliation report would be a lot more helpful if the Filed Amounts could actually be saved and continuously show the correct unfiled running balance amount and the section "GST Account Summary " for unfiled GST was actually correct as a cumulative balance. I just did 3.5 years worth of GST Reconciliations and nothing saved so all the running balances are wrong and don't flow correctly from one year to the next - even though I "published" them & hard copy printed each one as I went. The lack of GST reporting for periods where the "activity statement" has already been filed/lodged really should be improved as a priority.
Julia Williams
shared this idea
Thank you for your candid feedback and engagement on this idea. The good news is we're actively working on a complete rebuild of this report on our new reporting platform ✨. This project is a top priority and is specifically designed to solve the issues you've raised. The new report will automatically pull in filed return amounts, allow you to drill down into transactions, and always show a correct, cumulative unfiled balance. We're in the development phase, and we’re also actively gathering feedback on the ability to make manual adjustments in the new report, which we know is a critical requirement. We are committed to delivering a report that makes this essential part of your workflow easier and more reliable. We'll be back with another update as we make progress 😊
-
Dave Trayner
commented
I also hit this problem and reported it to Xero Support. It took 7 replies with various suggestions to me over a period of 2 weeks before it was finally revealed to be a failing of the Xero Software.
Xero fails to recognize or record any manual entries made to the GST Reconciliation Report and wipes them ALL on rolling forward to a New Year. It is UNACCEPTABLE that the GST Reconciliation Report is NOT FIT FOR PURPOSE !
And completely ridiculous to be expected to manually enter all GST Filed totals from the start of organisation to be able to use the report.
The enhancement needs to be escalated as it is a major failing of the Xero Reporting.
At our recent ATAINZ Regional Meeting all 14 members present stated they are unable to use this report in its present useless format -
Diane Mathers
commented
This is the most rubbish and useless report in Xero. If I spend time reconciling it one month, there is no option to save it. It's like groundhog day.....
-
Bonnie Coulle
commented
Yes the GST Rec report needs more options - when we override the FILED Column we need to be able to save and lock it in - very frustrating - I rely on the GST Rec report for all my clients BAS work - I haven't converted to the Simpler BAS Option as that is even worse when correlating with the gst report .Please spend some budget on updating the gst rec report with more functions for Advisor use maybe only
-
Henrik Maier
commented
This are some answers I go from Xero and the feature is a joke as they expect you every time to fill in the Filed amount for all the years going back since you started with Xero.
"... The GST Reconciliation report is designed to be run for all Activity Statement periods, for example from your Conversion Date or from the very 1st transaction entered in Xero. We plan to revise the report so it can be run for a specified period, but we don't have a time-frame for when this will be available.
In your case, you need to always run the GST Reconciliation report from 1 Jul 2020. Selecting this date means that the opening balances are 0.00, and the report should balance.
Furthermore, when using the new Activity Statement, the default GST Reconciliation report will not automatically populate the filed amounts. These will need to be entered manually in the "Filed" column. ..."
-
Henrik Maier
commented
I absolutely agree. This is a joke that the filed amount entries are not save after publishing the report or by some other means. Without saving them the whole GST reconciliation feature is unusable as for the current year you see invalid unfiled amount accumulated from past years.
In addition they should be prefilled with the lodged amounts.
-
ALISON WILLETTS
commented
Yes I just did the same and as soon as I published it all the values disappeared, and I am back to square one! Frustrating!
If GST is FILED from Xero, why can it not automatically populate at that point?