How to set up Home & Business for GST

Jon_1902808

I recently (today!) registered for GST and now wish to set up Home & Business 2018 for the the new regime. I've enabled tax-tracking, but when I go to edit existing line items there are no tax codes in the item's tax drop-down list! Have I missed a step? All help much appreciated.

Jon_1902808

And if I try and type in a GST code I'm told that "Transactions using a newly created tax code will not appear in the BAS report".  :-( So that's not an option.

Jon_1902808

Image to show lack of tax codes.

Jon_1902808

The Invoice and Bill Accounts are both set to track tax.

Jon_1902808

Another thing... no Split button on my Transactions (Customer Invoices account)

John G

Hi Jon,

Where did you turn on Tax Tracking?

Was it on the Bank Account? right-click Bank Account > Edit account, and select Yes to Tax-Tracking enabled.
This will create a Tax Control account in your Business module which will then show on your Account List.





If this is still a problem create a new file and check whether the tax codes are available.



Hope this helps.

regards,
John

Jon_1902808

All SEEMS to be in order? I enabled tax tracking on both the Customer Invoices and the Business Bills accounts. But no Tax Control acct has been created (hence no tax codes and no split button?)
I'll try creating a new acct (is that what you meant by a 'new file'?)

Jon_1902808

And yes, I did turn on tax tracking as you described. Thanks for chiming in John :-)

Jon_1902808

oo - my acct type above is 'invoice'... problem? And now when I create a new test acct I can't see 'invoice' as an option type!? I wonder how I selected 'invoice' in the past when creating my 'Customer Invoices' acct?

Anyway, here's a test acct screenshot. Still no Tax Control acct and no tax codes under 'edit category', but I do have a split button.

Shisir

Hi Jon

It is strange how it got the type as 'Invoice' for an account. I'm not quite sure how this has happened. However I would like to do some test and see if that will resolve the issue.

Can you please create a new Data file and see if the phenomenon is replicable there?

1. Go to file menu on the top and click on new.
2. Select new file.
3. And follow the prompt to create a new file.
4. 
   
5. See if the tax codes appears here.

This will tell us if the issue is local to your file or if in installation. If you can see the tax codes in the new file you just created, means something wrong on the file, maybe in the way it was setup. Can you please let us know how long have you been using this file for? When was it first created? From which version?

Regards

Shisir

Jon_1902808

Hi John - I have responded but created new replies instead of using the 'comment' button, which may have alerted  you.

Jon_1902808

Hi Shisir

Boom! The new data file has tax codes!



I have been using the problem file since Nov 2007 (my first invoice :'-}  )
It was created in Quicken Premiere Home & Business 2005 :-0

Shisir

Ah  good, that means it is not a installation issue but file related.

Can you please try making a copy of the file Jon, use a new file and see if the resolves the issue.

1. Open your own data file.
2. Go to file menu -> File Operations -> and select copy.
3. You will be prompted with 'Copy file' window.
4. Click on browse, and select a different location for your new file. (maybe create a new folder in document library and use it)
5. Press OK.
6. After the copy is done, you will get a prompt to use 'original file' or 'new copy', select 'New Copy'. 
7. This will now open a new copy of the file, see if the tax codes is available now.

Regards
Shisir

Jon_1902808

oooooo I was so hopeful, but no, there are no tax codes :-(

Shisir

I see.

Let me investigate more and come back to you.

Thanks

Shisir

Jon_1902808

Would importing my data into a new data file be an option?

Shisir

Hi Jon

Yes that would be one solution. You can start a new file and start using that file.

You can do the opening balance transactions on the new file for all your relevant accounts. Keep the old file for history record viewing.

I'm not sure yet if the old file you are using can be fixed, perhaps if I get a copy of your file (no details of transaction needed, just delete all the transactions), it might help me more on investigation. If you wish to send me a copy, please email it to community@reckon.com. (Please make sure you delete all the transactions before sending it, I just need to see the file)

Thanks

Shisir

Robyn Kelly (Partner)

Jon - I have a feeling you upgraded your data file from a previous version & that's why you have an "invoices" type account??  Would that be correct??

Also have you tried to make the "bank account" tax tracking enabled & then tried to enter a transaction & SPLIT the transaction - are the tax codes available then - in the split screen?

Regards, Robyn

Shisir

O and forgot to mention, Please make a backup of the file, before deleting anything from it.
Regards
Shisir

Jon_1902808

In order to send you an empty file (I'll send the copy that I made above) is there a quick way to delete the transactions? If I shift-click a range of invoices, ctrl-D only deletes the first one.

Jon_1902808

Robyn - yes my file was created in Nov 2007 (my first invoice :'-}  )
It was created in Quicken Premiere Home & Business 2005 :-0 In the past few days I have enabled tax tracking on this account, but no tax codes are available. And no split button either.

However, If I create a totally new data file, it has tax codes and just now I created an invoice to which I added an item to which I was able to select and apply the GST code. At that point the Tax Control account was automatically created.

So it does appear that it is my file (the descendant of the original created in 2007) that is having a mismatch with H&B 2018, or that has a corruption. New data files, or the example files supplied with the software, work fine, so the software itself is OK.

Robyn Kelly (Partner)

Did you try a validate & super validate Jon?

Also are you trying to add a GST code to the "invoices" account.  I'm wondering if you could try a transaction in a "bank" account instead please as the "invoices" account is not the same.

Thank you

Jon_1902808

Thanks Robyn - Yes I was trying to add GST to the Invoices acct.

The "totally new data file" that I mention, just above your most recent reply, is a "bank" account and all works as it should. I don't know the difference between the two account types (oh to have taken bookkeeping at school instead of physics :-D  ), but I'll probably go with what works. It would be nice to be able to import my client lists, transactions, items and categories from the old file but I guess I can recreate things as I encounter them.

What is " validate & super validate " and how does one carry that out?

Robyn Kelly (Partner)

In the data file you already have can you please set up a new account as a bank account, making sure it is Tax Tracking enabled.  Then try to enter a transaction and SPLIT the transaction to see if you are able to add a tax code in the transaction.

Validate and then SuperValidate your datafile.

1.    File > File Operations > Validate

2.    To super Validate, same steps but hold down Ctrl key with Validate.

Regards, Robyn

Robyn Kelly (Partner)

Try "Delete" - not Ctrl-D - on the keyboard after selecting all the transactions (next to page down on my keyboard).

Shisir

Thanks for your input Robyn.

Jon, to delete multiple transactions, Highlight them using Shift keys and right click on it.

Select Delete from the option.

Regards
Shisir

Shisir

Hi Jon,

I was checking your account in our system and found that your account do not have 2005 version allocated. I did further Googling and found the product you mentioned "Quicken Premiere Home & Business 2005" is actually US version product. So that explains why there is 'Invoice' type account and no tax control account

It appears, somehow the file from US version was successfully opened from our AU version product but hasn't been converted to AU version yet. The file still holds the US structure in the database.

One thing we have not tested here, yet, is a as Robyn mentioned, If you create a new 'bank account' (In your actual file), are you able to create it like a bank account? And if you can, does it create the tax control account? If yes that might solve the issue.

If it still does not create the tax control, the best solution here is, as you said, to start a new file in Reckon Home & Business and use it as we do not have any other way to convert the file to AU version.

Apologies for the inconvenience.

Regards

Shisir

Jon_1902808

Neither validation routines found fault in my data file.

When I create a tax enabled bank account within that data file, no tax codes are available.



However if I create an entirely new data file containing a tax enabled bank account, tax codes are available and the first transaction creates a Tax Control account. So the fault would appear to lie in the original data file.

Jon_1902808

The physical delete key removes any selected text on the transaction (and I can't select a transaction without a text element such as the date, customer or memo being selected), and cutting or deleting from the right-click menu still only removes the first transaction in a selected group. Weird.

Jon_1902808

The physical delete key removes any selected text on the transaction (and I can't select a transaction without a text element such as the date, customer or memo being selected), and cutting or deleting from the right-click menu still only removes the first transaction in a selected group. Weird.

Jon_1902808

Hi Shisir - I believe you have identified the problem; I arrived in Australia with a US version of the software and just assumed that it would 'work' in Australia. That assumption has come back to bite me! So I'll proceed with using a new data file. Should it be possible to import any info from my old file to the new one? Or should I just recreate elements (customers, items, categories, form layouts... ) as I encounter the need for them. That would not be difficult as they are few.

Shisir

Hi Jon,

Unfortunately, you will have to create them in new file as you go. There is no option to import or export the items, categories etc.

Regards

Shisir

Jon_1902808

Thank you John, Shisir & Robyn for all your help with this mysterious behavior. In the end it made sense given the files lineage. The tax side of things is new to me so no doubt I'll be back with more questions from time-to-time :-)