COGS has tax invoices
Comments
-
If the invoice has items, perhaps you have such items associated with an account code that is cogs instead of an income account. Change the associated account , on the item list. Then refresh the item inside the offending invoice. Gary0
-
Thanks for your comment. The invoice does have items but the items are set up with an income code & a cogs code which are both correct0
-
That’s how inventory items work. When the sale is made and an invoice done the cost of the goods is posted to the COGS account, unless inventory tracking is essential I use non inventory items to avoid this.0
-
As Kris has explain Jonathan - this is how inventory items work - when you purchase the stock - it goes to your Balance Sheet Asset account for Stock on Hand (DR entry) .... as each items is sold - the cost of the item reduces the stock on hand balance (CR entry) and increases your Cost of Goods sold account (DR entry)... this happens in the background of the tax invoice for the sale - so the entries you are seeing are the ones that should be there... Provided you have setup your inventory items correctly and are purchasing them correctly with their unit prices etc - then all will be well.0
-
That is very confusing. I checked other Softwares as QBO and Xero and I only can see bills in COGS and not Tax Invoices as in Reckon Hosted. I am worried that the BAS Amount is incorrect as we claim the GST on the goods purchased which are sitting in the Asset Account and we are paying GST on the Sales. If the Sales e.g. Tax Invoices show up again in COGS isn't this a double up on GST on Sales?
Thank you for your answer.
Gitta
0 -
Hi Gitta
There are a few things to consider ...
1 is the Tax Code - Unlike some of the other software, RA/RAH has separate tax codes to distinguish between incoming (sale/income) & outgoing (expense/purchase) transactions. This allows the integrated BAS within the software to populate the correct figures at the correct BAS labels. You will get a warning if you use a sales tax code on a purchase transaction & vice versa. In fact, if you have your system setup optimally, it will actually prevent this happening:
If you are just using the Tax Reports only (& not the integrated BAS), fortunately the program recognises when sale/purchase tax codes have been used incorrectly & will still show the sale & purchase amounts in the correct sections. On the Tax Code Summary report, this will show the tax code with a -S or -P indicating the tax code has been incorrectly used on a Sale or Purchase.
The 2nd is the Item setup - When you create an Item that you wish to use on both purchase & sale transactions, it's very important to ensure you set up BOTH sides with the appropriate accounts:
If you're seeing double-ups, your issue is likely related to assigning the wrong account on Item setup. Luckily, you can correct ALL affected transactions by changing the account allocation accordingly! 😊
Lastly, the COGS account tracks how much you pay for Inventory that you eventually sell. It is automatically affected & adjusted when you sell an Inventory Item. This is why there are Tax Invoices under it 😁
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
Hi Shaz,
this is how we have set it up:
I also think I have worked out how it works in Reckon Hosted:
When I look at the Inventory Asset Account only the Bills have NCG as the GST Code. The Tax Invoices have no code at all.
The COGS account has no GST codes at all.
When I look at the Profit & Loss Report in cash accounting the COGS is actually correct. It only shows what has been sold so far.
Hope this makes sense.
Gitta
Gitta's Bookkeeping & BAS Services
gittasbkbs@bigpond.com
1 -
Hi Gitta
As long as Bagged Products is an Income account, all is well there ☺️
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
yes Bagged Products is an Income Account Shaz :)
1
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 37 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 28 Reckon Mate App
- 2.7K Reckon One
- 13 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 22 Reckon Insights
- 98 Reckon API
- 309 Point of Sale
- 1.9K Personal Plus and Home & Business
- 70 About Reckon Community