GST 101 report gives different total to Detail Cash Tax report

My GST 101 report gives a different total to the Detail Cash Tax report. I have narrowed the problem down to the exact date of the discrepancy and it seems to be related to a payment of $1706.44 received from a customer on 17/12 that was applied as $366.85 to invoice 3218 (full payment) plus $1339.59 to invoice 3212 (part payment). The Cash Tax Report gives the correct total of GST as $222.58, however the 101 Report adds $4.80 more to the total ($227.38). When I zoom in on the 101 report total it simply gives the same total and details of the Cash tax report and not the actual total on the 101 report for that date. The figure on 101 report is getting data from somewhere else - but where? I do not want this to be a recurring problem resulting in an unreconcilable GST account at the end of the financial year. I have tried Verify Data and Rebuild Data. Attached are the 3 different reports.

Does anyone have any ideas? Thanks.

GST Reports 17 Dec comparison.docx

Comments

Joydeep Singh

Hi @Jenny_9381306 As you are running the reports on Cash basis and you have made partial payments to the invoices. Please check the date of the payments and the partial amounts applied on the invoice. Depending on the partial amounts applied and the date you run the report, the Cash tax report would show the tax amounts. Please ensure that you are running the tax detail reports including the payment date of the invoices and the payments are applied to the correct invoices. Here is a knowledge base article which may help you → https://help.reckon.com/article/f9ensq3zbk-kba-2870-why-is-my-cash-basis-tax-detail-report-showing-payments-that-have-not-been-applied .

Jenny_9381306

Hi Joydeep, Thank you for your reply. I have checked the Customer Payment transaction and the payment has been allocated correctly as per my email above (part payment to invoice 3212 + full payment to invoice 3218.) The reports have been run with the correct date range to include the payment made on 17/12/2024 as per Cash basis GST return for Nov-Dec 2024

The GST 101 report total is incorrect. How can I fix it?

Acctd4

Hi @Jenny_9381306

This is a known issue on a Cash basis when either mixed tax codes are used or part-payments are applied. It's due to the detail reports trying to apportion the applicable GST percentage across multiple lines. If you add the Tax column to that detail report, you will likely see a peculiar tax amount displayed on these particular lines (often, for more than the line amount itself!)

The Tax Summary reports however, are unaffected by this so these are the accurate reports to rely on. I use the detail report purely for checking correct tax code allocation only 😊

Jenny_9381306

Hi https://community.reckon.com/profile/Acctd4

Thank you for your response. However, in my case the Tax Detail report is actually showing the correct total of $222.58 being the 15% tax included in the payment of $1,706.44 ($1,483.86 + 15% = $1,706.44).

The Tax Summary report and the GST 101 report both show the incorrect tax amount of $227.38

I have checked the two related invoices created and the GST Payable GL account, and the correct gst amount has been posted from the two invoices to the GL ledger.

There is some bug in the Tax Summary and GST 101 reports. I have tried doing a Rebuild Data but nothing changes. If I pay the tax amount suggested on the Tax Summary or GST 101 reports, my GST would not reconcile at year end. What can I do to fix the problem or stop it recurring ?

Thanks for your help,

Jenny

Acctd4

Hi @Jenny_9381306

It looks like you're in NZ so there may be some variation in some program terminology but it looks like your "GST 101" report is the equivalent of our Tax Liability report:

I always use the Tax (Code) Summary instead, because it's totalled more closely in line with our BAS labels (Note: Our GST rate here is 10%) :

I've highlighted above the summary total GST on purchases & the resulting overall GST payable (which is correct).

With Tax Detail reports, on a Cash basis, the system generates separate reports for the main transactions ("Tax Detail report (Cash Net)") v the GST on those transactions ("Tax Detail Report (Cash Tax)"), whereas I prefer to just add the Tax Amount column to the main (" … (Cash Net)") one, so it's all in one report.

By comparison to the summary screenshot above, below is an example of how the detail report - for that same period - skews the GST calculations (in this case, due to partial (Bill) payments):

(I modify - incl column preference/re-organising, report renaming & removing cents as the BAS is whole dollars only - & memorise my set of BAS reports for each company file, in a created "BAS Reports" Group)

Is your Tax FastZoom screenshot on a Cash basis ?

Jenny_9381306

Hi @Acctd4

Thank you for your reply. However in my case it is the reverse of what you are suggesting…my Tax Summary report is INCORRECT and my Tax Detail report is CORRECT. The total GST collected on Sales for the date with the affected transaction (17th December 2024) should be $222.58 (our tax rate is 15%). However, my Tax Summary report is giving $227.38 ($4.80 too high).

I am now unable to rely on my Tax Summary or GST 101 report for any tax owing calculations going forward.

I hope you can now see the problem?

(FYI - the above Tax Zoom report is given when clicking on the "Total GST collected" total $227.38 on the GST 101 report.)

Thank you for your time and I look forward to your response.

Jenny

Datarec

Hi @Jenny_9381306

For the two transactions (Num 3212 and 3218) in the Tax FastZoom report, can you edit them and remove all the tax codes on each line then save the transaction.

Then go back into the transaction, edit it again, this time adding a tax code to one line, saving the transaction and then compare the reports to see if the recorded tax amount and subsequent tax totals match what you expect them to be.

Then repeat that process of adding in the correct tax code to each line and saving the transaction, comparing the reports to see if it is any specific lineitem that may be affecting the tax amount/tax total figures.

Jenny_9381306

Hi @Datarec

Thank you for your help. By going through the process above I discovered that it was invoice 3218 that was affected. The process of removing the tax code and saving, and then re-entering the tax code for each line has fixed the problem. The item code used on the invoice was the same for each line. I still have no idea why the 101 Report and Summary report gave the wrong total before, but they are both showing the same total as the Tax Zoom report after re-entering the invoice with the exact same details as previous.

The only strange thing is some sort of rounding error as the total payment received on17/12 was actually $1706.44 (incl GST $222.58) but the reports have rounded to .01 cent less (Total sales $4706.43 and GST $222.57). I'm not worried about fixing 0.01 cent after all the time I have spent on this bug already.

I prefer an explanation, but it annoyingly seems like one of those times when something stops working and you take it all apart then put it all back together the same and it works again!

Thank you for your time,

Jenny

Datarec

Hi @Jenny_9381306

Glad to hear that the suggestion has helped resolved the issue.

Acctd4

Good to hear it's now sorted @Jenny_9381306 ! Thanks for letting us know 👍🏻