# Custom report of income by currency **URL:** \ **Category:** Uncategorized\ **Created:** [September 16, 2020, 11:44pm UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639 "2020-09-16T23:44:36Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [September 16, 2020, 11:44pm UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/1 "2020-09-16T23:44:36Z")
I would like to create a custom report to show income by currency for a specified period. Thanks to [some help](https://forum.manager.io/t/report-to-assess-income-by-currency/30108/3) from @lubos in a similar topic of mine, I feel like I am pretty close: ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/3/d36f6e34e38ababaa1fc50fe99108e37f7d9edab.png) But there are several problems: 1. This only shows income from sales invoices. 2. Amounts are tax inclusive, whereas amounts in the built-in _Profit and Loss Statement_ report that I’m cross-checking against are tax exclusive. Some background: We are allowed to trade in ZWL and USD. Profit and loss are calculated in our base currency (ZWL), but taxes are to be paid in both currencies according to the proportion of income generated from each. So, I have the built-in _Profit and Loss Statement_ report that I can use for the assessment of profit and loss, but this doesn’t show the currency break-down, which is where this custom report comes in. You can see in my report definition above I have included both `AccountAmount` and `Amount`. This allows me to see the amount in the currency of the transaction, and also the base currency equivalent amount. So, attempting to solve problem number 1 above I tried: - removing `SalesInvoiceAsTransaction` and replacing it with `Payment or Receipt` `is empty` (after seeing payments and receipts appearing). This then means that credit notes and journal entries are included. But it’s still not a complete picture of income, and the totals don’t match the sum of _Inventory - sales_ and _Sales_ from the built-in _Profit and Loss Statement_ report. - using _Where …_ `General Ledger Account` `IsProfitAndLossAccount` `is checked` and multiple exclusions to try to get rid of anything that isn’t income. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/6/460a71abbb2f5e6eebc584836fccb778196cfa30.png) But this shows everything in ZWL, with no USD amounts, and the total doesn’t match the income total in the _Profit and Loss Statement_ report. Attempting to solve problem number 2 above, I tried adding various tax-related fields to see if I could get the amounts exclusive of tax: ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/4/24f4c1d4a0d2e7f61cc75248242d3e1cf8b40648.png) But in the resulting report, the `SalesTaxAmount`, `Tax Amount`, and `TaxComponent` columns are empty, and the `TaxExclusiveSalesAmount` column shows the total tax-inclusive amount for the transactions (with a minus sign in front). So, I’m very confused, and would welcome any guidance towards creating the report I want, if it’s possible. ---
**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:** [September 17, 2020, 12:30am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/2 "2020-09-17T00:30:55Z")
Have you tried going back to the design of your chart of accounts and creating different income accounts for ZWL and USD sales? Then you could design simpler custom reports that looked at transactions posted to the respective accounts. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [September 17, 2020, 1:56am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/3 "2020-09-17T01:56:14Z")
> [@Tut](#): > > creating different income accounts for ZWL and USD sales That sounds like a sensible idea to me. @GrahamvdR if you append " (USD)" or " (ZWL)" to the respective Manager accounts then you could use the filter `Where General Ledge Account Name contains " (USD)"` By the way, the complexity of your “Where” search is probably related to all search “Where” terms must be met (search term 1 “and” search term 2 “and” …). Manager does not support search conditions 1 “or” search conditions 2 The work around is to put a common but unique string in the account names as described above. If you also want another group of accounts, adding a punctuation character is useful such as “.” ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [September 17, 2020, 7:19am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/4 "2020-09-17T07:19:55Z")
> [@Tut](#): > > creating different income accounts for ZWL and USD sales Thanks @Tut. That sounds like a good plan, and seems obvious now that you mention it. I think it could help me in other ways too, and might even mean I don’t need custom reports at all. > [@Patch](#): > > all search “Where” terms must be met Yes, I had hoped to do an “or” filter to include just the accounts I wanted (sales invoices or credit notes or journal entries…), but because the lines behave as “and” criteria I had to rather specify all the accounts I didn’t want, as shown in my second screenshot. > [@Patch](#): > > put a common but unique string in the account names as described above Thanks, this hadn’t occurred to me. > [@Patch](#): > > If you also want another group of accounts, adding a punctuation character is useful such as “.” I don’t understand this. Would you mind elaborating, please? ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [September 17, 2020, 7:45am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/5 "2020-09-17T07:45:33Z")
> [@Tut](#): > > different income accounts for ZWL and USD sales If I do this, how do I assign sales of inventory and non-inventory items to the right account? It looks like the account is linked directly to the item, so once I’ve chosen the item I can’t change the account when I’m creating a sales invoice. I know I can specify for each item if I want it to use a custom income account, but does that mean I have to have duplicates of all items? I have approximately 700 inventory items now, and this number will keep growing, so I don’t think having duplicates is a viable option. Also, I don’t know how that would work with purchasing and stock tracking. To clarify: when customers make a purchase, they can choose which currency they want to use. They could even use a combination of the two. This means I have a ZWL and a USD customer in Manager for most of my real customers, and when they tell me how they’d like to pay I choose the appropriate one for the transaction. ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [September 17, 2020, 8:19am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/6 "2020-09-17T08:19:42Z")
[This topic](https://forum.manager.io/t/custom-income-account-not-available-in-sales-invoice/21366) clarifies that custom income accounts for inventory items are defined for the items and are not selectable when creating a sales invoice. So I don’t see how I can use multiple custom income accounts efficiently in my scenario. I’d be happy to be proven wrong. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [September 17, 2020, 8:30am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/7 "2020-09-17T08:30:02Z")
> [@GrahamvdR](#): > > Would you mind elaborating, please Punctuation characters are typically not use in account names. Adding a punctuation character to a group of account names enables you to then find transactions a group of accounts, simulating the “or” operator. For example with the following account names: - Red - Orange. - Yellow; - Green. - Blue. - Indigo; - Violet; Enables searching for transactions in accounts Orange or Green or Blue by `Where General Ledge Account Name contains "." ` And we can select transaction in accounts Yellow or Indigo or Violet by `Where General Ledge Account Name contains ";" ` ---
**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\ **Post date:** [September 17, 2020, 8:49am UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/8 "2020-09-17T08:49:46Z")
Ah, got you. Thanks. ---
**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:** [September 17, 2020, 12:13pm UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/9 "2020-09-17T12:13:00Z")
> [@GrahamvdR](#): > > I have approximately 700 inventory items now, and this number will keep growing, so I don’t think having duplicates is a viable option. You are probably correct. It will be a lot of work. You had not previously explained the characteristics of your business. ---
**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:53pm UTC](https://forum.manager.io/t/custom-report-of-income-by-currency/30639/10 "2023-01-18T14:53:22Z")