FYI....BAS Tracking,& Jnl entries don't work in Reckon One.. the ongoing Saga of Reckon One

  • 3
  • Problem
  • Updated 2 months ago
  • Acknowledged
Well frustrated with this product again.... after spending hours on the phone waiting for and talking to a lovely Tech support guy, he now understands my previous post months ago that there is no way to enter a BAS in Reckon one Properly (GST collecet/paid) by either a 'make payment' or billl as the GST accounts don't appear in the drop down list.
https://community.reckon.com/reckon/topics/pay-bas-entry-in-reckon-one-totally-frustrated-with-this-... 

So the only way to enter a BAS is via JNL entry, and of course if you want to be able to pay the BAS off, JNL entreis,can't be made to Accts Payable (or Receivable) as you all know, they don't show up in "allocation" to be able to make a payment against them (or receive a payment).

This leaves you with one choice, creating a dummy account called ATO Client account, and you have to jnl the BAS difference to this account.... (how totally inadequate)....then when you make payments to the ATO you have to transfer the money from the actual bank to the dummy ato bank account to know how much you still owe etc....then this brings another set of problems with any Interest from ATO,instead of doing a simple bill you again have to jnl from the expense account to the ATO dummy bank acct...and of course another problem that the debt to the ATO doesn't show up on an Accts Payable report, so you never get a full picture of what you owe or your company position.

And it gets better............  Jnl entries don't track to the GST report (BAS), regardless of them haveing a tax code, they just never appear on the report.....so this means you run the GST summary report, and the Tax code report and make manual adjustments to the GST summary report before you can lodge your BAS, and of course run the P&L and manually calculate the GST (because there is no incl. gst P&L) to make sure your sales balance.

And it still gets even better.... in that little go nowhere section where you tick off that the BAS has been lodged, it shows the details of the BAS for that period.....wrong....it can't handle BAS refunds, if the BAS for that period is a refund it shows a NIL in red....

Oh, why oh why do we have this program....a 10  min BAS job for a client has just turned into 1/2 to 3/4 hr, and that is if  you are lucky enough that everything balances and you don't have to go and fix anything.

This is like a step back into the dark ages, the only advantage is invoicing from an app, nothing else works well.

I am so hoping to talk this client into moving to Hosted, you can't do an app invoice but hey at least it works.... and I can get him inv2go or any other app inv. program.
  • 3
Ok.... just finished entering all the jnl entries for 6 BAS and creating a dummy ATO bank account so the client can pay his BAS off..... Grrr

Can anyone see the problem with the below snap shot????????

Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Sounds nasty.......
Photo of Rav

Rav, Community Manager

  • 84,560 Points 50k badge 2x thumb
Hi Kim,

Thanks for your post. The issues you've expressed here need to be looked at by our Product Development team.

I've passed this on to the team this morning and will update you as soon as I hear back.

Thanks,
Rav
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb

Hi Kim

This can be a bit of an issue with most software, in that you need to create another Account, mainly being either Current Liability or Other Current Liability.  I set up generally an Current Liability Account (I call it) ATO - Integrated Client Account.  You then Journal the BAS as per normal, full amount being allocated to ATO - Integrated Client Account.  Then each payment is via a Make payment.  

Creating a Liability Account allows payment from the Make payment Window.

Hope this helps.

Kind Regards

Kim Chapman

Accredited Partner

Kim I think you  missed the point, yes an ATO account can be set up, but is shouldn't have too, a simple core module CAN'T make a payment to the GST liab. account, nor can a bill,  nor can a payment be made against a jnl entry.

Not to mention seeing what is wrong with the GST Liab. acct showed above.

I will give you a clue, in the most basic systems a header acct reflects the balance of it's sub accounts.

If an accounting program cannot handle a basic BAS, there is a serious problem.

It has nothing to do with tax codes on the jnl or not, if you read the rest, a tax code on a jnl doesn't even track to the BAS either.
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb

Hi Kim

Just need to check have you entered a tax code on the Journal Entry lines, as this does not automatically pull through from the Chart of Accounts.


Kind Regards

Kim Chapman

Accredited Partner

Photo of Shannon Sciuto

Shannon Sciuto

  • 2,090 Points 2k badge 2x thumb
Hi Kim, 

I would recommend Quickbooks Online - its owned by Intuit (as is Reckon mostly) and its years ahead of Reckon One and a bucketload cheaper - especially if you sign up as a partner (which you don't have to pay for *cough cough*) and you can give them a 50% discount for the life of the subscription. 
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,144 Points 10k badge 2x thumb
In the interests of reporting correct information on a public forum Shannon, please see Reckon share buyback announcement

Please also note that our Reckon One Advisor program is free in line with competitor products in the cloud space.

As you would know, Reckon One is a relatively new product in the market, however we are comfortable where we are after nearly 2 years compared with where our competing products were after 2 years in their development cycle. For example, QBO is a mature product.

We also feel our pricing model (not discounted) is a clear differentiator.

However, as a new product we realise there is work to be done, so going back to this original issue we have flagged this with the dev team and hopefully we can provide an update ASAP.



Regards,
Jason Hollis
(Edited)
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Jason.... You're Reckon One product is 2 years old, its time to stop calling it new. How many more years are you going to call Reckon One new for? I think its time has come and time to stop using it as a 'new product' as a excuse for its failing.... 2 years on, still no REAL customizable layout of invoices, still no statements.....
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,144 Points 10k badge 2x thumb
New in terms of competitors that we have been compared to in this post Andrew.

Happy to compare notes and discuss product life cycles. My email is jason.hollis@reckon.com
(Edited)
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Thanks for the offer Jason, but I've said all I have to say on the topic. We'll have to agree to disagree on what is classed as 'new'.
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb

Shannon,

Interesting comment, as I had the exact same problem mentioned above with posting to BAS Liability account from the payments window in OBO only today. At even the current discounted price, its still dearer than Reckon One for the Core version.

Every Software has its disadvantages and advantages, and it is more a matter of finding the software that suits the Client.

Kind Regards

Kim Chapman

Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Not really comparing 'apples with apples' are you Kim? Comparing anything full featured to Reckon core is a little unfair. Cough cough What about invoicing? Payroll?

If 'free' is more your style, then check out https://www.waveapps.com/ cloud accounting package. Its free, has bank fees, even mobile apps for invoicing! Handles GST. Supports Australia. Everything is offset by some ads. Works very nicely!

Even has credit card payments for invoicing built in!
(Edited)
Photo of Kym Harris

Kym Harris

  • 80 Points 75 badge 2x thumb

Hi Kim,

It's doing my head in trying to understand how to journal my client's BAS in Reckon One.  I'm used to just setting up a bill from the ATO to shift the liability to AP from GST/PAYGW Payable, then recording the payment (or part payment) against AP.  So what are the steps involved in Reckon One please?

I have the following liabilities as a result of entering everyday data:

GST Collected     5472

GST Paid                                    2127

PAYGW               1145

Net payable $4490

Client has made two $1000 payments towards this obligation - how do I record this please?

I should add that the client uses bank data feed and one payment was via EFTPOS.  I have tried to follow your explanation and have set up an Other Current Liability called ATO Integrated Client Account and have coded the $1000 EFTPOs payment to this account and added the ATO as the contact.

(Edited)
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb
Hi Kym

In that instance, you still enter the Journal. Rather than posting the net amount to the bank account set up a liability account called something like ATO - Integrated Client Account. You can then make payments using Make Payments directly to the new Liability Account that you created.

This new 'Integrated Client Account' Liability Account is reconcilied just like a loan account. And your statement come directly from the ATO Integrated Client Account. Available from the Client/Agent Portal.

Hope this helps.

Kind Regards
Kim Chapman
Comparing cheese & chees,  the Jnl entry problem & a basic BAS entry as a payment after it's paid or a bill so it can be paid off is a major design problem.

This client used to use Inv2go, it works fine, xero works well, QBO seems to have the same problem....Mmmmmm

this product was supposed to be tested before hitting market, how can you miss Jnl entries not coming up in allocate or be able to enter a bas, or even the gst header not working.

Tech support have sent it to developement.
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Have you tried QBO yourself to verify this issue is valid or just taking someone else's word? (Hint free trial could be helpful).

QBO is doing a MASSIVE push into the OZ space so shocked something like this would be overlooked. One of the QBO advantages is it a shared code with the USA/world, so not reinventing the wheel.
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
Hi Kim,

Interesting post, you have raised some good stuff.

I have read both of your posts & understood each of the issues mentioned except for this one...

Jnl entries don't track to the GST report (BAS), regardless of them haveing a tax code, they just never appear on the report.

For myself, I can see journal enties on the BAS. Could you please give an example of a journal configuration where it doesn't flow through to the BAS?

Thanks,
Q.
(Edited)
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,104 Points 10k badge 2x thumb
I too can get GST in journals to track on the BAS. More detail and screen shots for examples would be appreciated Kim so we can get to the bottom of this.

The only aspect sent to dev is the ability to pay the GST liability to the ATO directly from that GL account.


Regards,
Jason
Photo of Qwerty

Qwerty

  • 7,906 Points 5k badge 2x thumb
Just an update to one of the issues Kim raised in this thread regarding the Activity Statement (BAS) screen incorrectly showing the refund total as $0. This issue is now fixed with yesterday's (03/12/15) Reckon One release/update.
Photo of Sarah Jane

Sarah Jane

  • 374 Points 250 badge 2x thumb
Is this still the best method please?

Hi Sarah

sorry I too have been flat chat this time of year and haven't been able to devote time to the forum. 

Since I did the original post, I also confirm that some of the BAS/Jnl issues have been fixed.

However if you pay off your BAS/IAS then you still need to setup the ATO client bank account - name 'ATO" make supplier & customer.

You still need to do the jnl entry as described to enter the BAS bill from the ATO client bank acct.  ref: bas mth  -  I set up gst collectd & paid as sub accounts of the gst system generated account -

a payment / bill    + gst collected  - gst paid  + PAYG withhold - Fuel credits + PAYG installments  (all to the cent)  +/- rounding.

All these have separate accounts in RO.

When you pay the amount in full or pay off you do a transfer from the bank to the ATO client acct.

You add interest as a bill, then you can reconcile the ATO client account to the ATO statement.

Hope this helps: if you need anymore help email me:  kim@kwikbooks.com.au                                       
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb
Hi Kim

In Australia, Reckon One has a default liability account already setup for paying off the BAS.  Thus does not require a 'New Bank Account'.  

This default Liability account is called 'ATO - Integrated Client Account'.  The Account where you pay off the BAS with the ATO is also called an 'Integrated Client Account'.

https://www.ato.gov.au/Tax-professionals/BAS-Agent-Portal/Using-the-BAS-Agent-Portal/Client-accounts-and-tax-types/client-accounts/

Hope this clarifies your confusion.
Hi Kim Chapman

This statement is confusing, my Reckon one did not come with a default supplier account or bank account called ATO or Client account - it did come with a GST Liability account & I stated I added sub accounts to this.  If you pay your BAS outright there is no need for the bank account you simply make a payment using the multi entries to gst/payg etc. as the payment comes out of the bank.

However, we were talking about paying the bill off and being able to reconcile to the ATO each month.  This does require a 'bank account' type set up as this is the only type of account that you can reconcile. 

Not sure what the link to the ATO BAS portal/client accounts & tax types has to do with RO.
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb
I prefer not to clog up the Bank Accounts with unnecessary accounts. I reconcile the liability account using the Account enquiry report.

Early books did not have this liability account by default. I think it was introduced about 2 or 3 years ago.

There has never been a default supplier, even now I am pretty sure you still have to add the ATO. I always setup the ATO as 'ATO - Australian Taxation Office' (tick both Supplier and Customer) this way if the user enters ATO or tax etc it will bring up the same contact. Minimising duplications of contact cards.

There are many different ways things one can do the same job.

The link was to show you that the BAS Loan account (or bank Account as you refer to it) has an official name, it is called the Integrated Client Account. Thus you will be then able to identify the default account in R1 that was designed for this purpose.

Best of luck, I now have to get back to EFY work.

Kind regards
Kim Chapman
This is exactly what I said, no default supplier, name needs to be created, tick both, yes we are all fully aware of the official name "integrated client account' sometimes this doesn't fit so ATO client acct works, does the same job, has the same meaning, lets not get bogged down with words and confuse the issue.

Yes, printing reports for liab. to reconcile only works for accrual basis gst reporting and yes can be done for payg, super etc.

But you cannot 'reconcile' as in the sense of the word, add interest bills, transfer payments from one acct to the other, which was the option best applied for a person not experienced in R1, or jnl entries, who pays off the ATO with regular payments or part payments.

If the new default ATO client account now avail. is the same for the other reckon products it needs to be made inactive as it tracks every tax entry in R1 system and not helpful if you want to track what has been lodged with the ATO client account, therefore will still need the bank account set up for this.  I will look at this after the EOFY.
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb
Hi Sarah

Not sure what you are referring to as there are a lot of threads to this post.  But I will try to cover a few:
a.  BAS does calculate if you use a Journal, as long as you have tax codes assigned.
b.  BAS Payments and refunds can now and have been able to be entered as a 'Make Payment' or 'Receive Money' for quite some time.  Payment - GST Collected (positive), GST Paid (negative), PAYG Withheld (positive) etc.
c.  ATO Integrated Client Account (Liability Account) - this is what should be used for 'paying off BAS'.

I hope this answers your question.

Kind Regards
Kim Chapman
www.cosbiz.com.au

Photo of Sarah Jane

Sarah Jane

  • 354 Points 250 badge 2x thumb
Apologies, I posted a question a month ago that no one answered so thought I'd ask in this thread what the best method is since it seemed related.  Just wondering how you allocate a BAS payment from your bank transactions once it has been paid - is that what you mean by c?
Photo of Kim Chapman - COS Business Solutions

Kim Chapman - COS Business Solutions, Accredited Partner

  • 4,968 Points 4k badge 2x thumb
No B for everyday BAS payments.

C is If you enter into a payment plan, I think you would have to journal the transaction for option c.

Sorry, I struggle to keep up with the forum posts this time of year, I have to leave it to Rav. As I have to tend to my Clients and business first.

Hope this helps

Kind regards
Kim Chapman
www.cosbiz.com.au
Photo of Sarah Jane

Sarah Jane

  • 354 Points 250 badge 2x thumb
Fair enough!  So it sounds like it's still the same as descrbed in the original OP then