Kevin Zaki
Kevin Zaki
  • 103
  • 367 094
Inventory Accounting: First In First Out (FIFO) & Automated Valuation - Odoo 17 (Part 6 of 11)
Inventory Accounting: First In First Out (FIFO) & Automated Valuation - Odoo 17 (Part 6 of 11)
The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting books.
There are three primary goals of this course.
Teach you all of the basic accounting functions you need to perform on daily basis to run your business.
We will cover every basic accounting function including Inventory Accounting, Accounts Payable, Accounts Receivable, Reconciliation, Sales Tax, Expense Accounting, Revenue Accounting, and Asset Management. You will be exposed to all of the main accounting reports such as the Balance Sheet, Profit and Loss Statement, and Cash Flow statements. At the end of the course, you will be comfortable making manual journal entries, navigating the General Ledger, and troubleshooting any accounting errors.
Teach you how every application interacts with the accounting application.
If you have used any ERP software you know that every business decision and record you create in the system may affect your accounting books. You must understand the impact of each of your decisions. In this course, we will cover exactly how each application interacts with accounting. This includes manual and automated inventory valuation, expense management, re-invoicing expenses, collecting customer payments, dealing with multiple currencies and exchange rates, applying landed costs, and dealing with cash.
Teach you how to transition from a legacy system to Odoo Accounting.
Once you are comfortable with the software we will go over exactly how to transition your accounting books to Odoo. This process involves importing your trial balance, using clearing accounts, importing your open bills and invoices, and making sure you have all of your location-specific accounts set up such as your scrap, inventory adjustment, and Work in Progress (WIP).
This course is designed for Implementation Consultants or Business Systems analysts, Bookkeepers, Accountants, and anyone evaluating Odoo as an ERP solution. It will be incredibly helpful for anyone who wants to understand the accounting impact on every decision they make throughout the Odoo ecosystem.
During the creation of each video, I attempt to think of all the most common edge cases and bring them to your attention. I take pride in each video being as comprehensive and complete as possible. Every business has slightly different accounting needs. Nonetheless, in this course, you will touch on every accounting function in Odoo. Even if we do not directly cover an exact use case you will have the knowledge to build out your own complete solution.
The only prerequisites for this course are basic accounting knowledge and basic Odoo knowledge. This course will not teach you the fundamentals of accounting.
zhlédnutí: 557

Video

Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11)
zhlédnutí 1,8KPřed 4 měsíci
Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accoun...
Accounting Settings: Contacts - Odoo 17 (Part 5 of 5)
zhlédnutí 791Před 4 měsíci
Accounting Settings: Contacts - Odoo 17 (Part 5 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting bo...
Inventory Accounting: Costing Methods - Odoo 17 (Part 2 of 11)
zhlédnutí 760Před 4 měsíci
Inventory Accounting: Costing Methods - Odoo 17 (Part 2 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Inventory Accounting: Subcontracting - Odoo 17 (Part 11 of 11)
zhlédnutí 707Před 4 měsíci
Inventory Accounting: Subcontracting - Odoo 17 (Part 11 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Accounting Settings: Journals - Odoo 17 (Part 2 of 5)
zhlédnutí 1,9KPřed 4 měsíci
Accounting Settings: Journals - Odoo 17 (Part 2 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting bo...
Inventory Accounting: Standard Cost & Automated Valuation - Odoo 17 (Part 4 of 11)
zhlédnutí 789Před 4 měsíci
Inventory Accounting: Standard Cost & Automated Valuation - Odoo 17 (Part 4 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct...
Accounting Settings: Chart of Accounts - Odoo 17 (Part 4 of 5)
zhlédnutí 2,7KPřed 4 měsíci
Accounting Settings: Chart of Accounts - Odoo 17 (Part 4 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
zhlédnutí 376Před 4 měsíci
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
zhlédnutí 553Před 4 měsíci
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
zhlédnutí 1,8KPřed 4 měsíci
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5)
zhlédnutí 2,6KPřed 4 měsíci
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your ...
Accounts Payable: 3-Way Matching - Odoo 17 (Part 7 of 12)
zhlédnutí 484Před 4 měsíci
Accounts Payable: 3-Way Matching - Odoo 17 (Part 7 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accountin...
Accounts Payable: Price Difference - Odoo 17 (Part 8 of 12)
zhlédnutí 424Před 4 měsíci
Accounts Payable: Price Difference - Odoo 17 (Part 8 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your account...
Inventory Accounting: Inventory Adjustments - Odoo 17 (Part 7 of 11)
zhlédnutí 892Před 4 měsíci
Inventory Accounting: Inventory Adjustments - Odoo 17 (Part 7 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on you...
Accounts Payable: Accrued Expenses - Odoo 17 (Part 9 of 12)
zhlédnutí 614Před 4 měsíci
Accounts Payable: Accrued Expenses - Odoo 17 (Part 9 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your account...
Accounts Payable: Prepayments - Odoo 17 (Part 4 of 12)
zhlédnutí 628Před 4 měsíci
Accounts Payable: Prepayments - Odoo 17 (Part 4 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting b...
Accounts Payable: Documents and OCR - Odoo 17 (Part 10 of 12)
zhlédnutí 577Před 4 měsíci
Accounts Payable: Documents and OCR - Odoo 17 (Part 10 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accou...
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
zhlédnutí 745Před 4 měsíci
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
zhlédnutí 947Před 4 měsíci
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
zhlédnutí 491Před 4 měsíci
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
zhlédnutí 908Před 4 měsíci
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
zhlédnutí 590Před 4 měsíci
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
zhlédnutí 1,4KPřed 4 měsíci
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
zhlédnutí 496Před 4 měsíci
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
zhlédnutí 742Před 4 měsíci
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
zhlédnutí 594Před 4 měsíci
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Accounts Payable: Overview - Odoo 17 (Part 1 of 12)
zhlédnutí 920Před 4 měsíci
Accounts Payable: Overview - Odoo 17 (Part 1 of 12)
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
zhlédnutí 1KPřed 5 měsíci
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
zhlédnutí 1,5KPřed 5 měsíci
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)

Komentáře

  • @AdrianCortes-z7t
    @AdrianCortes-z7t Před 11 hodinami

    Thank you for the information, I found it very helpful!Do you know if there's any way to do "group by" in this case?

  • @dennispiper5062
    @dennispiper5062 Před 18 hodinami

    Great tutorial Kevin. Thank you!

  • @abrotherinchrist
    @abrotherinchrist Před 18 hodinami

    Thank you for actually clicking the MTO route and showing us the rules. No one else did that and since Odoo is very rules-based we really should understand them if we want to do anything custom.

  • @GibeonKipngeno
    @GibeonKipngeno Před dnem

    Nice

  • @WaqasGCC
    @WaqasGCC Před 2 dny

    Kevin one question though, how do we reflect the additional valuation to the respective GL Accounts of each landed cost applied? bigger companies have detailed COA's and under cost of revenue section they define shipping / custom duties accounts etc. Your illustration nets out the expenses :/

    • @KZAKI
      @KZAKI Před 2 dny

      Sounds like a good opportunity to simplify the CoAs. In my opinion, separating out CoGS by what came from shipping doesn't give you any value at the financial statement level. You can always go see how much you spent on shipping in a given month elsewhere in your GL or in your landed costs or product analysis. Imagine looking at your P&L and it shows $500,000 in Shipping CoGS. It means nothing without additional context. If you really want you can sum your debits to the Shipping Expense account originally debited for a specific period and credit General COGS and debit the Shipping COGS for that amount so you can have a pretty accurate idea. Lastly, the only time I saw this done is when a company is using standard cost or manual inventory valuation (therefore not using landed costs) and debiting the shipping bill directly to a COGS account for simplicity.

  • @ernestwaga7227
    @ernestwaga7227 Před 3 dny

    what about if i want to do revaluation as at a historical date so that the costing of a past transaction is affected by the new cost. Changing the date doesn't help at the moment

  • @ArcOfTheCovenant
    @ArcOfTheCovenant Před 8 dny

    I have a searchable excel sheet (quite complex) that currently is being used outside of odoo and requires manual lookup outside of odoo. If I wanted to have odoo use the spreadsheet to display select data related to certain products like work instruction or jig location for product (all on the soread sheet) is it possible to have odoo look up the info via the soread sheet and display certain lines from it?

  • @karangrewal
    @karangrewal Před 13 dny

    Thank you for such clear and detailed information.

  • @brrrGRr
    @brrrGRr Před 17 dny

    thank you so much, done watching part 1-5. and will be watching your other videos. i have problem in reconciling in Odoo 17, the validate button is color grey, if i click it nothings happen. but thanks for this.

    • @brrrGRr
      @brrrGRr Před 17 dny

      hope you will have more video in reconciling with this problem, thank you

  • @KLEV96
    @KLEV96 Před 17 dny

    The expense account inserted in the bill and in the landed cost seem to be both debited and credited respectively by the same value. Is the expense reflected on that account or is it only reflected in the COGS account?

    • @WaqasGCC
      @WaqasGCC Před 2 dny

      same question, kevin's illustration nets out the defined accoutns. However bigger companies keep track of their COGS.

  • @krnkbabu
    @krnkbabu Před 24 dny

    How about a scenario where we have billed the customer for around 100 different products and they are returning only 1 product? How to take in only that single product to our warehouse and create a credit note based on what was returned?

  • @ajwesseler
    @ajwesseler Před 25 dny

    Thank you for this video. Do you know a way to set the opening balances in v17? I see you have the "view" options on the CoA like I do. I've seen other videos that have "setup" as an option for each account. Thanks in advance!

  • @abdullahbabakir3150
    @abdullahbabakir3150 Před 27 dny

    much thanks, better than hozey ignasiu

  • @StanleyBlay-jk9bh
    @StanleyBlay-jk9bh Před 28 dny

    Hi my odoo doesn't show the checks part

  • @WillyWira-vv4ry
    @WillyWira-vv4ry Před 28 dny

    why mine is not showing the price?

  • @MacDaddy2point0
    @MacDaddy2point0 Před 29 dny

    Great Video!!!! Thankyou

  • @MarijnKonings-ux8vi
    @MarijnKonings-ux8vi Před měsícem

    Great video! What I do not understand is the fact that the expenses are negative, which will reduce the expenses if more are incurred. Am I right in this logic and is there an issue here or not?

  • @WAMM
    @WAMM Před měsícem

    Thanks for your video. What if my expense starts in 14-Jun-2024 to 13-Dec-2014, the generated journal entries created at the end of the month not using my start date and end date. How can I solve this?

  • @Fabfab-uu9cy
    @Fabfab-uu9cy Před měsícem

    if ocr doesnt recongnize PO number can you attach after?

  • @piusparts7699
    @piusparts7699 Před měsícem

    Hey Kevin do you do freelancing for Odoo? I am not happy with my Odoo Team they are slow and I need to get my system up and running and live I signed up with the Starter pack 6 months ago and we have not even imported all of our products

  • @jonzeininger1420
    @jonzeininger1420 Před měsícem

    I'm working on setting up Accounting. I have a call in 30 minutes with AvaTax. Hopefully they have a better way of doing sales tax than what this video shows. Although I anticipate they are on the front end to help with determining the county sales tax for which of our 72 counties have the extra .5% county sales tax. Odoo's processing of payments, including using a calculator to input the ending account balance, is mystifying to me. This is a step backwards from even the horrible bookkeeping program I'm moving away from. But it is still early in the setup as I prepare to Go Live. :)

  • @jonzeininger1420
    @jonzeininger1420 Před měsícem

    Wow! This is the first process in Odoo that I've seen that, at least at my first 3 views, is a much more complicated, time consuming and ripe for errors than even the poor bookkeeping system that I am leaving. I will watch 3 more times. Maybe I'm missing something. My current system just has a 2 line journal entry after I make an online payment to my credit card company. ??

  • @zahidmehmood2970
    @zahidmehmood2970 Před měsícem

    HI, I am getting a string payload(a dictionary as a string "{'a':1, 'b':2}" instead of a dictionary object in request.get_http_params(), how do I handle that?

  • @MustufaRahi
    @MustufaRahi Před měsícem

    Hi, I am trying to generate cost of production in my odoo 17 but it generated cost of production as whole - including raw material and work center. I am not getting how did you get it -1.90 in your case? The video at minute 10:01. Please let me know how to get the separate cost of production like demonstrated in your video?

  • @SP-ve1zz
    @SP-ve1zz Před měsícem

    Thanks for the clear & detailed explanation. After a long time trying to figure out how this feature works your video finally made me get the point!

  • @BrianCreager
    @BrianCreager Před měsícem

    Awesome work Kevin

  • @htmalmdn
    @htmalmdn Před měsícem

    💚

  • @user-se9ll9po3m
    @user-se9ll9po3m Před měsícem

    Hello Kevin, Very informative video thanks for creating this. I just have one question when employee cost is multiplied by duration why do you divide by 60? In the employee module we already set per-hour cost and duration is also in HH: MM so I guess we just need to multiply. Correct me if I am wrong please.

  • @AmanSrivastava-tm9hz
    @AmanSrivastava-tm9hz Před měsícem

    Is he using a paid version of Odoo? If yes, then how can we do the same in the free version?

  • @elainebrook2106
    @elainebrook2106 Před měsícem

    Best videos that I have found so far. He explains everything clearly and simply. They are great!

  • @jagsonar
    @jagsonar Před měsícem

    Saved my Day, I am so much greatful .. Great video .. Thanks a Billion

  • @bigboss97lnt
    @bigboss97lnt Před měsícem

    Very useful. Thanks

  • @Joseph20203
    @Joseph20203 Před měsícem

    Just top notch!

  • @kenwoychesko2163
    @kenwoychesko2163 Před měsícem

    Another great video--thank you! I notice that you never update the Sales Orders related to the refund. This would over-represent your sales. Is there anything to be done about that?

  • @javedshakir5156
    @javedshakir5156 Před 2 měsíci

    Superb 100/100

  • @YuvrajSingh-go8fm
    @YuvrajSingh-go8fm Před 2 měsíci

    These options are on visible to me when I try to make a new product category, there is no, Inventory valuation section

  • @aminrashad3887
    @aminrashad3887 Před 2 měsíci

    Thanks Kevin , wonderful presentation

  • @ihatethishate5643
    @ihatethishate5643 Před 2 měsíci

    Hello, not related to this video but I think you can help. I can't seem to get a cost to register for a budgetary position. I tag the analytic a/c in the JV a/c debited ( included as a budgetary position account)but it won't register/hit it in the project budget ??

  • @NihalHamed-pz5ee
    @NihalHamed-pz5ee Před 2 měsíci

    Great vedio

  • @SenyoGladstone
    @SenyoGladstone Před 2 měsíci

    How do you duplicate a delivery schedule? Where you don't have to "add a line" but duplicate the previous line?

  • @IsraelGross
    @IsraelGross Před 2 měsíci

    So how does translate into commission And how can I creat a list or dashboard that a sales person can see why his commission Is less because of added cost?

  • @dmvanloenen
    @dmvanloenen Před 2 měsíci

    On one database this works very well! But on other database I get an error on the 'request', any thoughts? What am I missing? Webhook #1 failed with error: Traceback (most recent call last): File "ir.actions.server(613,)", line 16, in <module> NameError: name 'request' is not defined During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 383, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "ir.actions.server(613,)", line 18, in <module> NameError: name 'request' is not defined

  • @walid3210529
    @walid3210529 Před 2 měsíci

    A CRYSTAL CLEAR DEMO 💯 Thank you so much

  • @kenyansenpai
    @kenyansenpai Před 2 měsíci

    Hi KEZ i have a question. I am doing an import of my products on odoo v17. When doing the Inventory Adjustments how do i set it for the end of the previous month because it picks todays date instead of the schedule date i set.

  • @viral_products111
    @viral_products111 Před 2 měsíci

    i got request is not defined

  • @KyleBicking
    @KyleBicking Před 2 měsíci

    Is there a way to duplicate projects that have similar structures but vary slightly. I have a project with 97 tasks inside it. Once i duplicate it the projects seem to be linked. for instance the first project needs to have a design category yet the second one doesn't. still has same stages tags assignees etc. but i need to remove a few stages. When i click delete on the copied version it tells me i need to archive all stages and tasks associated and it pulls that project and the original data. if i archive it they delete off the first project template as well.

  • @alexkogan2704
    @alexkogan2704 Před 2 měsíci

    After changing Star ranking of the contact, how do you do a soft refresh?

    • @KZAKI
      @KZAKI Před 2 měsíci

      You just need to press enter in the search bar.

  • @DinoAMAntunes
    @DinoAMAntunes Před 3 měsíci

    Hi Kevin, very good, tks a lot. There´s a way of update all BOM´s from 1 Raw A material (in your example , Parts) to Raw B. Tks in advance. PS: I have 479 Bom´s to update

  • @menodoctor
    @menodoctor Před 3 měsíci

    Hi Kevin - thanks for the video - do you know if the connector can handle multichannel fulfilment orders (MCF)?

  • @dirkvandenwouwer7453
    @dirkvandenwouwer7453 Před 3 měsíci

    Can the consumption of products be logged in a project ?? This video only talks about hours. We need materials to execute our projects. Thnaks.