When customizing Financial Reports, how can I look up the ID's of the account types? Expenses = 15 but where is this shown/stored?

Question

I'm trying to customize my balance sheet and P&L

I know that this is referring to my Expenses journal, but how can I verify this?
Where does it show that 15 = Expenses Journal?
[('account_id.user_type_id', '=', 15)]

Caribbean Data Challengers · Accepted Answer

A better answer would be to show you how you can find this information yourself. The account types are in the database in table account_account_type, but you cannot find that list in a menu, so you can not simply export them with their ID's. But you CAN export the Chart of Accounts and make sure  Account Type and Account Type ID are included in the fields.
Go to your chart of accounts in list view  select all rows click on the gear icon > select export  include Account Type and Account Type ID E

Chris TRINGHAM · Answer

These are the IDs for Odoo 13

*ID
* *Account Type
* *Type
*
1
Receivable
Receivable

2
Payable
Payable

3
Bank and Cash
Liquidity

4
Credit Card
Liquidity

5
Current Assets
Regular

6
Non-current Assets
Regular

7
Prepayments
Regular

8
Fixed Assets
Regular

9
Current Liabilities
Regular

10
Non-current Liabilities
Regular

11
Equity
Regular

12
Current Year Earnings
Regular

13
Income
Regular

14
Other Income
Regular

15
Expenses
Regular

16
Depreciation
Regular

17
Cost of Revenue
Regular

1

This question has been flagged

Enjoying the discussion? Don't just read, join in!

ID	Account Type	Type
1	Receivable	Receivable
2	Payable	Payable
3	Bank and Cash	Liquidity
4	Credit Card	Liquidity
5	Current Assets	Regular
6	Non-current Assets	Regular
7	Prepayments	Regular
8	Fixed Assets	Regular
9	Current Liabilities	Regular
10	Non-current Liabilities	Regular
11	Equity	Regular
12	Current Year Earnings	Regular
13	Income	Regular
14	Other Income	Regular
15	Expenses	Regular
16	Depreciation	Regular
17	Cost of Revenue	Regular
18	Off-Balance Sheet	Regular