cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
We have received some reports of members experiencing latency when browsing Community. We are working with our engineers to fix this and will update this banner when it has been resolved.
Highlighted
Level 1

I didn't exclude duplicate transactions. Now I've paid GST on the duplicates!

I think I've made a mistake on ALL my BAS statements - GST section, as follows:
  • Quickbooks often duplicates about 2-3 transactions a month in my bankk feed. 
  • When reconciling, I untick these duplicates. I thought that was all I had to do. 
  • BUT I think I am ALSO supposed to exclude the duplicates in the account
  • Because looking at my previous BAS statements, I've paid GST on all these duplicate transactions
Questions: 
  1. Should I go through and exclude all the duplicate transactions from the account?
  2. Will this trigger a refund via the next BAS?

Thanks

3 Comments
Highlighted
QuickBooks Team

I didn't exclude duplicate transactions. Now I've paid GST on the duplicates!

Hi Jasper33, 

 

Thank you so much for reaching out. In regards to your point about excluding the transactions, yes that is correct. 

 

The For Review screen in the Banking tab will allow you to accept the correct transaction into your QuickBooks account and exclude the rest. Then when you wish to Reconcile you should be able to pinpoint any missing/extra transactions easily. Please see here for more information.

 

In regards to your questions: 

  1. Yes, you can do this. In the Categorised tab in Banking you will be able to Undo the transaction. It will then re-appear in For Review to be Excluded. Bear in mind, if any transactions you wish to exclude are reconciled you will need to undo this first. 
  2. Yes it will. The system is designed to record any changes made to a closed BAS period as an amendment/exception on your next BAS. These will then be reported to the ATO upon lodgement to trigger a refund. 

Please let me know if you have any other questions. 

 

Thanks, 

Rebecca 

 

Highlighted
Level 1

I didn't exclude duplicate transactions. Now I've paid GST on the duplicates!

Thanks Rebecca.

 

I excluded a transaction and then ran the GST amendment report. The exclude expense appears, but it says "lodged amount $14", "Current amount $14", "Amount difference $0". This doesn't seem right.  I expected the amount difference to be negative, therefore triggering a GST refund. 

 

Any ideas? Thanks for your help

Highlighted
QuickBooks Team

I didn't exclude duplicate transactions. Now I've paid GST on the duplicates!

Hi Jasper33, 

 

I would probably need to look at the file to see exactly what has happened, in this case.

 

As we cannot take personal details over Community can you please contact our Support Team and one of our experts will be happy to assist you. 

 

Thanks, 

Rebecca