# Preparing a custom report **URL:** \ **Category:** Uncategorized\ **Created:** [November 18, 2022, 6:15pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106 "2022-11-18T18:15:29Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![RAM93](https://avatars.discourse-cdn.com/v4/letter/r/ecd19e/32.png) [@RAM93](https://forum.manager.io/u/RAM93)\ **Post date:** [November 18, 2022, 6:15pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/1 "2022-11-18T18:15:30Z")
Good Day Sir, i am creating a custom report so that all the below fields shown inside the red border mentioned in the screen- shot will appear. However, I can’t be able to understand which columns to choose in the definition. In particular i am unable to get the highlighted sub-total amount to appear. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/3/23e18e7e98908be1cd8a89c993ca7916aad42961.png) Please find below definition of snapshot. i am trying all combinations to achieve the result, but to no avail. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/e/be5253b24feea54739c77b0db5a69dfca538afa9.jpeg) Request your assistance as need to submit the report to my boss on Sunday pls. Thanks!! ---
**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:** [November 18, 2022, 9:07pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/2 "2022-11-18T21:07:56Z")
That’s because it isn’t a “single value” in the sense that subtotals are dynamic and could mean anything. In fact in your given example, you have two instances of “sub-total” appearing on a single invoice. If I understood you correctly, I think you were trying to get the total value of the invoice amount. If that’s the case, why not show the following columns: - `Sales Invoice` \> `Total amount in base currency` - `Sales Invoice` \> `WithholdingTaxAmount` Then, you can copy to clipboard and do the subtraction in a spreadsheet. ---
**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:** [November 18, 2022, 10:38pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/3 "2022-11-18T22:38:55Z")
Adding to what @Ealfardan already said, any displayed transaction contains processed information from the database. The processing is encoded in the transaction view itself. The results of the processing—the subtotals, etc.—are not stored in the database. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [November 18, 2022, 11:15pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/4 "2022-11-18T23:15:03Z")
The custom report will need to calculate the (sub)totals. - Sort then Group by is used to do this - I have not checked if Manager custom reports can separate out then group by individual components of compound tax codes.It probably can’t. What are you actually trying do do / problem to solve ---
**Author:** ![RAM93](https://avatars.discourse-cdn.com/v4/letter/r/ecd19e/32.png) [@RAM93](https://forum.manager.io/u/RAM93)\ **Post date:** [November 19, 2022, 8:21am UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/5 "2022-11-19T08:21:27Z")
Hi, thank you fo the various input. I was able to achieve the below report. However, If i collapse the group the receipt date does not appear in the report. I want the receipt date to show as well along with the sub-total value. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/5/75ea86f9d324dde5b7f5eeebf8c66957bc5cf321.png) ![Screenshot 2022-11-19 134348](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/e/2ef8c945a23b474614b91396977cd4265984ffde.jpeg) Below report with groups collapsed: - ![Screenshot 2022-11-19 134804](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/b/7b11e71f3b55c7874348f09cb966bb091a771d70.jpeg) Kindly guide. Thank you. ---
**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:** [November 19, 2022, 1:59pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/6 "2022-11-19T13:59:04Z")
Every line item on a custom report represents one general ledger transaction. So you will never get a sales invoice and corresponding receipt showing on the same line. Additionally, a receipt is a credit, and you have selected only debits. ---
**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:** [July 5, 2026, 8:09pm UTC](https://forum.manager.io/t/preparing-a-custom-report/44106/7 "2026-07-05T20:09:34Z")
Uncategorized topics older than 3 years with no recent activity