GROUP SALES

Question asked by Mustapha Awudu 7 years ago

Hello Good morning, i will like to know how i can group the sales under various headings. we have 3 categories of classification and i will like to know how to capture each sale under each category.

22 Replies

Hi Mustapha,

When creating a bill, ensure you choose Cost of Sales in the Account drop down and select the relevant project.

Tommy

HI Mustapha,

I would suggest using our Projects feature for each heading, this can be accessed by heading to Tools > Projects > Create Project. Once this is done, when creating an invoice, you are then able to assign each invoice to a particular project.

I hope this helps!

Tommy

hello, i still dont have the feature. i have been given the permissions by the administrator but i still cant see the PROJECTS.

secondly , why cant i have access to the payroll?

Hi Mustapha,

Ah my apologies, you may not have this toggled on, please head to Settings > Configure System > Toggle Features > Tick on Projects. Unfortunately, we currently do not support non-UK companies for our Payroll software.

All the best,

Tommy

Good morning Tommy. what you gave me worked perfectly but again i have a problem. i can only see the revenue but not the breakdown of Sales- cost of sales = profit. i will like to know when i can get to see that.

Good morning Mustapha,

You are able to view a Profit and Loss for each report by clicking on the icon shown below:

file

I hope this helps!

Tommy

i get that but the cost of sales doesnt hit it. its just revenue. why is that?

Hi Mustapha,

Cost of Sales should be picked up on this, please see example below:

file

Can you ensure those bills coded to Cost of Sales are allocated to the correct project?

Thanks,

Tommy

Good morning Tommy, i will like to answer draw your attention to with-holding tax issue in Ghana. there is a with-Holding Tax law that requires a tax element of 3% to be withheld when our clients are making payments to us. eg. for 10,000 worth of supply, they pay us 9,700 with 300 being the tax withheld. how do i apply this on payments and at the same time create a column for such taxes withheld?

Hi Mustapha,

Unfortunately, we do not have a direct feature for withholding tax, the best workaround would be to create a withholding tax account code by heading to Settings > Accounting > Account Codes > Create Account Code. From here, you would have to work out the 3% manually and include this on the payment. Also, we do advise you to speak with an accountant to confirm that this is the best way to process this.

Thanks,

Tommy

hi Tommy, i have created the account. but my problem is in case lets say the 9,700 has been received with 300 withheld as Tax, i will then apply the 9700 but the balance of 300 will be left as unpaid. that is what i will want to move to the new Account code created as "withholding Tax "account. makes sense to you now? how to allocate it to tax is the issue now as there is no option as such.

Hi Mustapha,

I do apologise for the confusion! In fact, you must first toggle on our Withholding Tax feature by heading to Settings > Configure System > Toggle Features > Accounting > Tick Withholding Tax. Once this is done, you can then create a Withholding Tax account code with the relevant percentage; please ensure that the Show in Sales box is ticked and saved.

After this, you can then create the invoice for 10,000 coded to the Withholding Tax account. The system would then calculate the Withholding Tax amount based on the rate you've entered when creating the account code. Lastly, when you receive the tax back, you should create an invoice for this amount and code it to Withholding tax account.

I hope this helps!

Tommy

look at the presentation for the overall PROFIT & LOSS

file

kindly see below. i mean the cost of sales shows in P & L for the overall sales but not on Projects.

secondly , is there no way Profit can show on each Invoice?

Hi Mustapha,

I have removed the initial screenshot to avoid sharing confidential information with the public. But after reviewing this, the project currently has no bills coded to cost of sales and therefore would not show up on the Project Profit and Loss. You can double check this by running a transaction report by heading to Reports > Popular Reports > Transactions and filtering by the appropriate project.

Please let me know if there are any further issues.

Tommy

i dont think you still get my point. what i want is where i can see each project and its profitability. REVENUE LESS COST OF SALES on a project by project basis.

Hi Mustapha,

As previously stated, you can view each Project's profitability by heading to Tools > Projects > Click on the Profit and Loss icon as shown below:

file

According to your initial screenshot, the system is not showing Cost of Sales as there are no bills for that project.

Tommy

i have done that. but all it brings is the TOTAL REVENUE. NO COST OF SALES. IT DOESNT DEDUCT THE COST OF SALES.

Hi Mustapha,

This is because there are NO bills coded to Cost of Sales for this project.

Tommy.

how do i code the bills to the cost of sales?

Hi Mustapha,

When creating a bill, ensure you choose Cost of Sales in the Account drop down and select the relevant project.

Tommy

Thanks tommy, i have done that and its working great but theres another challenge. the items that are in Stock that forms part of the invoice doesnt reflect here.

Hi Mustapha,

Please email into contact support with your business name so I can investigate this further for you.

Thanks,

Tommy

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are