How to Effectively Use Analytic Accounts to Streamline Financial Reporting in Odoo 16

[@jonathanwilson5801]

Can we allocate product costs associated with a sales order to an analytic thus being able to get true margin against a project?

[@hectorherrera4193]

Very comprehensive and well explained! Thanks for sharing

[@EMADGAMATI]

Thanks a Lot ... very simple clarification for me as a technical specialist and not accountant background... Thanks again ,,, Quick question, how can I follow POS's in my shops with analytic accounts?

[@EdgarTriias]

Hi Kevin, thanks for the video. Do you have any material about analytic accounting at the payroll module?

[@mrfilmschlumpf]

We are a construction company and each job we do, small or large is a project where job cost analysis is very important. Most are estimated and accepted, but a handful are T&M. I was thinking to divide the sales into residential and commercial categories, and then further divide them into repair, replace and Preventative Maintenance, tracking each of these categories, profitability. It sounds like I can set up parent and child relationship analytic accounts. Does that sound right?

[@ramibakkar4358]

Hello Kevin, As a new user to Analytical Accounting in Odoo I feel a bit lost with the cocktail of terminologies available (Budgetary Positions, Budgets, Analytical Plans, Analytical Accounts, Analytic Tags)!!! Would you be kind enough to make a video on the meaning and the use of each of these

[@SaverioBartalini]

Dear Kevin, thanks a lot for your explanation. However I would like to tell you a difficulty that I am having with respect to what I used to do in v15. Very simple example: we have two product lines, Prod1 and Prod2, and we want to analyse costs on these two lines by keeping the possibility of selecting if a cost is for production or for R&D. In v15 I had two analytic accounts ("Prod1" and "Prod2") and two analytic tags ("Production" and "R&S"), and I was able to filter, for example, the vendors bills in the "invoice analysis" view with any combination of account/tag: for ex. "Prod1" + "R&S" etc. Now I can not find a similar way to do the same, even if I have created two different analytic plans: one in "Activities" (with "Production" and "R&S") the other is "Lines" (with "Prod1" and "Prod2"). Could you explain me how can I combine the filtering across these two plans in a pivot view, for example? In other words: analytic filtering based on the operation (“Account A” AND “Account B”) is no longer working in v16, while I have been extensively using it in v13, v14 and v15, by combining "Analytic Account A" AND "Analytic Tag B". Please refer to the document that I have prepared, and confirm that this is an issue (I am still hoping I am wrong...): drive.google.com/file/d/1ByjFf5VLr7T0Msp9nS04OVhv4x1eOZSm/view?usp=share_link Thank you, Saverio

[@lewy7601]

at 18:13, scenario for purchase

[@rafwenger]

Hi Kevin. Thanks for the great video. My use case is one company but multiple branches. I need to split sales/invoicing per branch. A customer "belongs" to one branch. It seems likes using Partner Category like in your B2C and B2B examples is the way to go (with some automation thrown in to assign partner category on creation). Can you please confirm the above or suggest a more suitable way to achieve this? Cheers!

[@KZAKI]

That seems like a logical approach. With some of the automation, you might consider doing it based on users if users will always be in the same branch. You can also split it up by warehouses if they are separate warehouses that would always have to be set on the purchase and sales order levels already.

[@franciscomulwana8063]

Hello Kevin, kindly guide on how I can apply analytic accounting to point of sale for various locations.

[@KZAKI]

You cannot use analytic accounts with POS at this time. However, you can do it after by going to your journal items and filtering by the POS. This way you can manually apply the analytic account. You can also probably set it using automated actions.

[@franciscomulwana8063]

@@KZAKI Thank youbfor the feedback. I have a company with about 30 branches and I would like to track their financial statements per branch. I would like to use analytic accounting but it's limited to the income statement only. I would like to use multi-company features but they would me many companies. Kindly advise on this, thank you.

[@KZAKI]

@@franciscomulwana8063 If the branches have different tax id's they should be different companies. If they are simply branches under the same tax entity then it can get a bit confusing the manage. I've heard that Odoo is looking to creating branches or business unit feature in the future. This should solve your problem. In the meantime, is each branch a different POS/retail location?

[@franciscomulwana8063]

@@KZAKI Thank you for the feedback, I think the branch/business unit feature would effectively solve my problem. But currently, I have 30 POS locations under the same company with the same Tax ID and I would like to capture each location separately and then up with consolidated financial statements but I'm still confused on what to do. I was thinking of multi-company but it would be hectic.

[@KZAKI]

@@franciscomulwana8063 There isn't really a great way to separate out all 30 retail stores. The best thing I can suggest is to make sure you have a different journal for each location. From this you can filter your financial statements by journal, mainly your profit and loss statement.

[@fabricationxtream5885]

Nice tutorial just need to upgrade the sound

[@KZAKI]

Finally upgraded sound quality in my latest video.

[@EsmatAliMohamed]

Thank you

[@ramibakkar4358]

Why did we use "Subplans" in projects and not Analytic Accounts

[@KZAKI]

I used sub plans because we have different types of project and each project will have its own analytic account. This will allow me to filter my financial reports at the subcategory level (sub plan) or each individual project level.

[@ramibakkar4358]

@@KZAKI seems that I'm at a very basis level still.....I'm very interested to educate myself on this, if you find it rewarding to train a fellow Odoo user please suggest a training curriculum :)

[@zkhater63]

Legend

[@sepashaghighi3165]

Unlike many other comments, I didn't find this video very good. I was expecting some explanations about what each of these terms mean and why do we use them, instead of just creating them super fast.

[@KZAKI]

www.odoo.com/documentation/16.0/applications/finance/accounting/reporting/analytic_accounting.html Thank you for your feedback. The reason I don't spend too much time defining terms is because that information is readily available on the official documentation. I try to show more advanced use cases or go over things that are not available elsewhere.