# Custom Reports

**URL:** <https://forum.manager.io/t/custom-reports/27157>\
**Category:** Uncategorized\
**Created:** [February 29, 2020, 7:30pm UTC](https://forum.manager.io/t/custom-reports/27157 "2020-02-29T19:30:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Umair\_Noor](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/umair_noor/32/23525_2.png) [@Umair\_Noor](https://forum.manager.io/u/Umair_Noor)\
**Post date:** [February 29, 2020, 7:30pm UTC](https://forum.manager.io/t/custom-reports/27157/1 "2020-02-29T19:30:26Z")

</div>

Is there any database where users of Manager have made their own reports and are available for use of others? I am trying to make a report where i can link sale of a product with its related cost and discount so that I can evaluate profit margin on each order. While trying to make custom report when I select Sale Invoice, the only columns available to me are the customer details instead of contents of the sale invoice like product, sale price, discount and any associated cost which I would like to incorporate. Many thanks if anyone can guide me on this.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [February 29, 2020, 8:15pm UTC](https://forum.manager.io/t/custom-reports/27157/2 "2020-02-29T20:15:44Z")

</div>

There is a Inventory Profit Margin report

---

<div class="post-metadata">

**Author:** ![AJD](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@AJD](https://forum.manager.io/u/AJD)\
**Post date:** [March 1, 2020, 7:10am UTC](https://forum.manager.io/t/custom-reports/27157/3 "2020-03-01T07:10:22Z")

</div>

I think that what you require is possible, but a bit convoluted.  
First you need to go to settings=\>chart of accounts and add a unique inconspicuous character to the end of each of the income/expense accounts that are relevant. (In the example below I have used a semi-colon ;).

The relevant accounts in your case are Inventory - sales, Inventory - cost and Discount expense.

That done, create a Custom Report with the following settings (note the semi-colon in the account name contains parameter):

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/c/9c720241e88012760fe20d67ffe2bb7fd7df17eb.png)

This is a sample of the output (the invoices in this case have items divided into 2 lines for tracking code purposes CGT/Non CGT so is reported correctly and not duplicated):  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/3/2338a89795e1f561b48c5276fc970a84b268d98a.png)

I hope that this is helpful. Cheers

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [March 1, 2020, 5:41pm UTC](https://forum.manager.io/t/custom-reports/27157/4 "2020-03-01T17:41:06Z")

</div>

To answer your first question, there is no such database.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:56pm UTC](https://forum.manager.io/t/custom-reports/27157/5 "2023-01-18T14:56:35Z")

</div>