Skip to main content
hbscoresby@optus
January 28, 2022
Question

How do I reconcile a bank transaction to the ATO for GST which was submitted via BAS before we commenced with Quickbooks

  • January 28, 2022
  • 14 replies
  • 0 views
Original commenter did not share additional details

14 replies

IntuitSheila
January 28, 2022

Hello hbscoresby@optus,

 

You can add the bank transaction as an expense under the taxes paid category to be able to reconcile your bank account in QuickBooks Online. Under For review of Banking page, you can select Expense as the transaction type, and under the category select the taxes paid or choose an account on how you wanted to track the BAS payment.

 

For the usual process on how to prepare and lodge the BAS in QuickBooks Online, after you've prepared and lodged a BAS period you record a BAS payment, and then match the BAS payment to the bank transaction. You can also check this article to learn more: How to lodge a BAS or IAS in QuickBooks Online.

 

Furthermore, we'd also recommend contacting your accountant to get more information on how to account the bank transaction to the ATO to not mess up your books.

 

You can always post your questions here anytime. We'll be sure to get back and help you.

hbscoresby@optusAuthor
February 1, 2022

Hi thank you for responding,however I'm having difficulty in following your instructions.iI you have time could you please advise step by step what journal entries I need.So the problem again is I submitted a BAS manually to the ATO before I joined Quickbooks online,it was $690, a few weeks later the Bank feed came in and I have been unable to reconcile it via journal entries,If i allocate to the ATO Clearing account it just creates a negative balance,it would let me reconcile direct into the GST liability account,i get an error messgage!.I have seen many recommended solutions on help pages but none of them seem to work.I either end up with a -$690 in the ATO Clearing account or the GST Liability account depending which way I structure the Journal entries.The next BAS I submitted just recently was submitted via Quickbooks online and I was able to reconcile the bank feed without any issues.I spent nearly an hour on the phone with the Quickbooks help desk and despite trying numerous ways to fix it nothing worked.I believe the person is escalating the matter but in the the meantime I happy to get any help as this is very frustrating.

IntuitSheila
February 1, 2022

Thanks for your update, hbscoresby@optus.

 

I understand the need to be able to reconcile your BAS in QuickBooks Online. Here's how you can record the GST paid while you're not using the GST center in QuickBooks Online.

 

  1. Click on the + New button.
  2. Click on Journal Entry.
  3. Fill out details like date and etc.
  4. On the first line item, under Debit column use GST Liabilities Payable account and enter the amount.
  5. Next line is under Credit and choose the Bank account the payment went out and enter the amount.
  6. GST code is Out of Scope.
  7. Click Save and Close.

 

Then, you should be able to match the Journal entry to the payment in the bank feeds. You can check this link for a more detailed step on how to record the Journal entry when not using the GST center To record a GST Payment when you don't use the Lodge BAS function in the GST Centre.

 

Feel free to reply to this thread if you have more questions. We'll be sure to get back and assist you. Have a nice day!

 

 

IntuitAika
February 2, 2022

Thanks for your reply, hbscoresby@optus.

 

Just to confirm, do you have any transactions imported or recorded for that BAS period you're trying to record in QuickBooks Online? Please know that the steps provided here will zero out the the GST Liabilities Payable and ATO Clearing account if you have transactions recorded in QuickBooks Online and have not use the lodge BAS function. 

 

If there are no transactions recorded for that period, you can record the tax payment as an expense transaction and allocate it to a Taxes Paid account.

 

Feel free to drop a comment below if you have any other questions. 

hbscoresby@optusAuthor
February 2, 2022

NO I explained all that previously,the only thing I have is a bank feed for the payment amount.The BAS was NOT submitted via quickbooks online.I have done those journal entries on numerous occassions and it doesnt clear.Also  as I said previously there is nothing to add to in the GST menu.It seems we are going around in circles!.

So if I do record the tax payment as an expense transaction and allocate it to a Taxes Paid account will it show on the balance sheet or P&L? I was hoping to avoid that as all our other figures are ex GST and I will need to explain to our auditors/members that it was a glitch in quickbooks online.

IntuitSheila
February 2, 2022

Hello hbscoresby@optus,

 

I understand you just wanted to reconcile the BAS paid before using QuickBooks Online. Since there are no transactions recorded in QuickBooks Online for the period you wanted to reconcile the BAS payment, you can add the bank feed as an Expense transaction and allocate it to taxes paid (expense account). The expense will show in your P & L report as it is using an expense category. 

 

As you can see the effect of using the journal entry giving you a negative balance of the BAS period you're paying is due to there are no transactions for the payment to balance to.

 

We'd also recommend reaching out to your accountant to get more information about how to record these journal or transaction to not mess up your books moving forward.

 

You can always reply to this thread if you have more questions. We'll make sure to get back to you as soon as we can.

Terms & ConditionsAccessibility statement