Software that posts COGS?

Software that posts COGS?

Didn't find your answer?


Our business is considering using a different accounting software package but there are two additional requirements on top of what we already have.

The inventory/product codes must have the ability to deal with multiple locations and the COGS must be posted when the sales invoice is posted.

We currently use Sage 50 and this can only cope with 1 location and does not post COGS. You have to do journal at the end of the month to account for your stock movement. Is there any software out there that posts COGS when the invoice is posted?

Thanks

Replies (13)

Please login or register to join the discussion.

avatar
By The Innkeeper
12th Nov 2015 13:38

please translate

what is a COG ( other than part of a gear wheel)

Thanks (0)
By Tim Vane
12th Nov 2015 13:42

Cost of Goods Sold (I'm assuming)

Thanks (0)
Replying to Tax Dragon:
avatar
By Billy1965
12th Nov 2015 13:58

Indeed.

I would normally use Cost of Sales but it was a term that was used to me

Thanks (0)
avatar
By 3569787
03rd May 2016 15:57

Yes there is

.

Thanks (1)
Replying to tom123:
avatar
By Billy1965
12th Nov 2015 14:18

Thank you

Thanks (0)
avatar
By The Innkeeper
12th Nov 2015 14:22

thank you

that's what comes when you mainly do tax !!!!

Thanks (0)
avatar
By juliestevens
12th Nov 2015 15:05

Also Brightpearl

Does COGS and multiple locations

Thanks (1)
Routemaster image
By tom123
12th Nov 2015 15:38

Sage 200

I use Sage 200 - which does post cost of sales. We don't use the manufacturing module, so it only posts costs for items merchanted out of stores.

We do use analysis codes for our major projects in WIP though, so it is easy to keep track of WIP transactions and then post the total out.

A lot more flexibility than L50 in that it is a proper period based system.

I think you can upgrade your L50 data when doing the install - but you will need Sage resellers to do this part.

 

You can run warehouses, which I presume could be used for your locations.

Thanks (1)
avatar
By paul.k2
12th Nov 2015 19:18

No shortage of choice

Billy I wouldn't consider any of those requirments unusual.

Most half decent systems will accomodate your needs. Do you have anything more specific that you need from the system?

 

Paul

Thanks (0)
Replying to DJKL:
avatar
By Billy1965
13th Nov 2015 17:19

Me neither Paul but we've made do with sage50 up until now, which doesn't cope with that functionality.
I want more automatic reporting on the various locations instead of updating spreadsheets or waiting until the end of the month before knowing COS. other than that, any other functionality is a bonus for now

Thanks (0)
avatar
By Robjoy
26th Nov 2015 11:35

QuickBooks posts average cost automatically with a sales invoice. It astonished me to discover, some years ago, that the basic versions of Sage didn't do that - how could it call itself a stock-capable accounting system if the stock value isn't affected by sales?

For multiple locations you'd need the Premier edition.

Thanks (1)
Replying to thestudyman:
avatar
By JKnight
26th Nov 2015 13:43

Product sales invoices

Robjoy wrote:

QuickBooks posts average cost automatically with a sales invoice. It astonished me to discover, some years ago, that the basic versions of Sage didn't do that - how could it call itself a stock-capable accounting system if the stock value isn't affected by sales?

Product sales invoices in Sage 50 Accounts and Sage Instant do reduce the quantity held in stock and affect the stock value. Have done for years.

 

Thanks (0)
avatar
By jonathan.kempson
26th Nov 2015 12:13

Sage 200 - additional comments

As a previous comment states Sage 200 (disclaimer - I work for a Sage 200 reseller) does the things that you want.  A couple of additional comments:

It is significantly more capable than Sage 200 (over and above the points that concern you), but is also significantly more expensive.  There are subscription options, though, that may make the difference less painful.
 There is a migration tool for your Sage 50 data, but it's also very common to reorder and tidy up account numbers and other details
 Sage 200 supports multiple warehouses, and also multiple locations within a warehouse for a single product

There is also a third party Sage 50 add on (from Adept) that supports multiple locations, but not COGs.  It has limitations (especially if you have lots of products and locations), but may do a job for you.

Jonathan

http://www.protronics.co.uk

Thanks (0)