Home Forums Support Question about invoicing goods / Gross Profit

This topic contains 4 replies, has 2 voices, and was last updated by  kylegp 2 weeks, 5 days ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #23823

    kylegp
    Participant

    Hi there,

    I run a computer repair business.

    In a typical situation, the customer needs a part to repair their device so I would charge for the part and labour. I would typically add a bit of profit margin onto the part too.

    So lets say I need to order a battery and it costs $100 but I want to sell it for $120. I would therefore make $20 profit.

    I would also add my labour fee onto the invoice, something like “Repair Labour”, $50 for example. So in this example, the invoice total would be $170 but I would only make $70 profit.

    I want to know how to correctly use invoiceninja and structure my invoices so when I view reports for profit and loss, I can see what my real profit is excluding those goods (gross profit).

    How can I achieve this?

    #23824

    Hillel Coren
    Keymaster

    Hi,

    Sorry, it isn’t currently supported.

    As a workaround you may be able to add a custom field to track the actual cost. You’d need to export the data to analyse it though.

    #23924

    kylegp
    Participant

    Thanks for the reply.

    I added a custom field which I added under Task Fields. This way I can enter the cost price that won’t appear on the PDF invoice.

    However, when I export the CSV I don’t see the data in the custom fields so I can’t work with the data.

    How can I get the custom field to appear in exported CSV reports?

    #23925

    kylegp
    Participant

    I found that if I run a CSV report for “Product” and not “Invoice” I can see the custom field data I’m after and analyse it in excel.

    #23926

    kylegp
    Participant

    Ignore my reply about the task field. I wasn’t understanding before how the custom fields work but now I see you can create a custom field for each section…Invoice, Expense, Task etc. and you can choose whether or not that appears on the invoice or not. So by adding a custom product field (cost price) and not showing it on the invoice, when exporting the CSV report for product and doing some math to deduct it from the sale price, it works as I intended. Would be great to have the ability for cost price/sale price in the future built right into InvoiceNinja, but for now I can export reports and calculate my gross/net profit manually. Thanks for the help.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Posted in: