Take away forced "un-billed cost by job" when tracking cost of goods sold purchases

Hi Jenni. Thanks for the screenshot. You need to use the ITEM tab ... see the one next to the expense tab (see image).

Create an item as per my example previously. Generally a non-inventory item is fine. Link this to your COGS chart of account. When entering a BILL, select the ITEMS tab and then the COGS item you created.

Cheers,

Jason

Hi Jason

When you go to the enter bill system, the list that it is linked to is the expense account list, not the item list it is impossible to create a “item” list linking to COGS.

Regards

Jenni

Hi Jenni. Items are just a way to assign costs and sales to general ledger accounts a different way (most often used to get better reporting since ITEMS are the only thing you can used on sales forms). They also add reporting value to the job cost reports and item sales reports.

However they can also be used as in the example below. ITEM "COGS" points to the Cost of Goods Sold general ledger account. In other words, it all ends up in the same place and will show on the P&L as expected. You definitely gain better reporting and lose nothing by taking this approach.

Hi Jason

Bills are entered using the expense accounts list, not the item list so I cannot set up an item to do as you recommend.

Regards

Jenni

Hi Jenni. Thanks for mentioning COGS as I understand your issue now. The way the program was designed, and yes we don't know why it is this way, was to not to allow billable time to be adjusted against certain accounts, including accounts receivable / payable (which makes sense). Creating journals with customer names also presents an issue. Unfortunately it's so hard baked into the source code the effort to address cannot be justified at this time. That said, we will add to the bug backlog regardless.

However, there is a solution that, once set up, will not add any extra time to your data entry. Simply create an item pointing to COGS, and then enter COGS via the items tab. Using this method will allow you to select / deselect the billable option.

Hi Jason, I have been through this with reckon support, the uncheck box only shows up for expense account items, cost of goods sold items do not have a box to untick they are force added to the unbilled cost by job list by the software.

Regards

Jenni

Hi Jennifer. The items shouldn't be showing on this report unless you tick them on the bill / cheque / credit card. If you do not on-bill (on-charge) the items, the checkbox should remain un-ticked.