GST not automatically calculated for in check register
Brent Coker
Member Posts: 10
I set the supplier tax code to GST. But when I manually add transactions to the register, I have to go through half of the transactions and manually adjust them to GST (most just show as no gst added). Bloody annoying and time consuming. After all these years I still havn't found a suitable work around for this issue.
0
Comments
John L G
in support of John's suggestion, (which is always on the money!), I agree with John.
I've never bothered with separating the GST codes at a supplier level (or customer level). I haven't had a need to look at that since the days of Sales Tax, where we had to worry about some customers that were Sales tax Exempt from the 22%.
Like John, I set up the proper GST (for Income accounts), NCG (for business expenses), and CAG (for asset accounts), and then each transaction naturally follows the tax rule for allocating that tax percentage (as per that tax code) whenever a bill (or sales invoice) hits that CoA account. That's the situation for Reckon Accounts, ever since it was Quickbooks Premier v7.4 back in 2001.
NOTE: When there was an exceptional situation, like say, COGS for food products that are possibly "FRE" (like meat or single dairy products), then in such exceptional cases, I'd overwrite the default of NCG. Same for Loan Accounts to Directors who have used business facilities for private use, the whole lot goes as NCF to the loan, all driven by the rules in the CoA account settings (not the supplier or customer in question, giving rise to the transaction hitting that ACCOUNT)
Gary
Under Edit> Preferences> General - there is an option to "Automatically remember account or transaction information" with a couple of options underneath that. In my case I have selected the option for "Automatically recall last transaction for this name". When you have this option selected, whenever you go to write a cheque (or enter a bill), the previously recorded transaction for that person will be automatically recalled for you. As, in many cases the information on subsequent transactions will be similar, it would then only be necessary to amend any dissections with new amounts and new descriptions. Whatever the tax codes you used previously will automatically be brought forward, again without you having to think about it. All you then need to do is be aware as to whether or not any of those GST codes need amending e.g. one might have been NCG last time but it is NCF this time around.
There is also a further suggestion that I have for you. If you have a regular supplier with different invoices for different purposes e.g. Telstra with an invoice for the office phone, another invoice for broadband and another invoice for mobiles, you can memorise these transactions using a slightly different name such as Telstra (Mobile), Telstra (Broadband) etc. That way you can recall a previous transactions with specific general ledger accounts and specific GST codes for re-use, time and time again, without the need to try and remember what general ledger account might be applicable. Memorising transactions is a great way to cover specific situations for suppliers etc which may vary from time to time with relevant general ledger accounts and GST codes.
John L G.
Where this is not working for you, go and have a look at your chart of accounts, look at the ?Tax? column and see how many of your accounts have been set up with a tax code. If a lot of say your expense accounts don't have a code set up, there is your answer.
On another front, is it the same expense account/s that are not calculating, or is it random? If it is the same account/s, the answer is in my previous paragraph.
Even if no tax codes have been input, it would be simply a matter of entering NCG in the Tax column on your cheque and it should calculate.
Are you perhaps indicating that even though you specify or input a tax code when entering a cheque, it still doesn't calculate? Or is it a case of when you enter the expenditure account, nothing appears? Again, the answer is as above.
John L G