Kevin Zaki
Kevin Zaki
  • 102
  • 423 794
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.
Переглядів: 946

Відео

Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11)
Переглядів 3,1 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 1,4 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 3,4 тис.7 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
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)
Переглядів 4,2 тис.7 місяців тому
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)
Переглядів 6637 місяців тому
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Переглядів 1 тис.7 місяців тому
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Переглядів 3 тис.7 місяців тому
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5)
Переглядів 3,7 тис.7 місяців тому
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)
Переглядів 7647 місяців тому
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)
Переглядів 6537 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
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)
Переглядів 1 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 1 тис.7 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Переглядів 1,8 тис.7 місяців тому
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Переглядів 8937 місяців тому
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Переглядів 1,8 тис.7 місяців тому
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Переглядів 1 тис.7 місяців тому
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Переглядів 2,6 тис.7 місяців тому
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Переглядів 8797 місяців тому
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Переглядів 1,5 тис.7 місяців тому
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Переглядів 1,1 тис.7 місяців тому
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Переглядів 1,4 тис.8 місяців тому
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
Переглядів 2,1 тис.8 місяців тому
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
Manufacturing Accounting: Journal Entries - Odoo 17 (Part 2 of 4)
Переглядів 2,7 тис.8 місяців тому
Manufacturing Accounting: Journal Entries - Odoo 17 (Part 2 of 4)

КОМЕНТАРІ

  • @KhizarShahan
    @KhizarShahan 12 годин тому

    Hi, I am currently setting up odoo for my beverage distribution business. I have three small storage locations in different regions and they generate their own purchase orders daily. At the end of the day the vendor sends me a single cumulative invoice for all the purchases made in a day. What I do is create a single bill for all those purchase orders but the order lines don't merge and it wastes all of time in reconciling it with the vendors invoice. Is there any way to resolve this issue

  • @limitless6572
    @limitless6572 14 годин тому

    Webhooks for inventory?

  • @TomRubino
    @TomRubino 2 дні тому

    @ 2:16 you mention journal entries are created when items move into or out of virtual locations. This does not seem to be the case for Virtual Production accounts. It seems the journal entries are only created AFTER the MO has been completed. Is there a way to show the intermediary movements in the valuation journal? i.e. Product pulled from warehouse to production should create an inventor journal entry, after item has been manufactured, another journal entry should be created when it moves to stock. Any ideas? Thanks!

  • @TomRubino
    @TomRubino 2 дні тому

    It would seem there is no way to create automatic inventory valuation moves for work in progress. We would like Items pulled from warehouse stock, to move into a temporary "work in progress" account from an inventory valuation perspective. It seems Odoo only creates these entries after the MO is complete. How can we capture the physical inventory moves from stock to "in progress"?

  • @trashdape2065
    @trashdape2065 2 дні тому

    W mans

  • @mohamedmesawer8769
    @mohamedmesawer8769 6 днів тому

    Hi Kevin I have a problem that vendor bill entry From cost of goods sold To payables That make a big value of stock interim account. Please help

  • @Nishant3540
    @Nishant3540 7 днів тому

    How Can I use multiple source locations on Manufacturing Order. Let's say I want to reserve the components stock from multiple locations in a single MO.

  • @shabanashummer8383
    @shabanashummer8383 8 днів тому

    Thank you very much , This is the best explanation for the consolidation module !!!!

  • @mohamedmesawer8769
    @mohamedmesawer8769 11 днів тому

    The vendor bill make journal From cost of goods sold To payable What should I do

  • @BrandonBrief
    @BrandonBrief 12 днів тому

    Thank you!! Im hoping you can help, Im trying to make this to only show numbers based off a paid invoice. I just cant figure it out, Could you help?

  • @AhmedElsayed-tm2cz
    @AhmedElsayed-tm2cz 13 днів тому

    his case involves Anglo-Saxon pricing and standard pricing. It also pertains to the continental approach and average retext. Please provide more details or a specific focus

  • @RojinaAmla
    @RojinaAmla 18 днів тому

    Martinez Larry Perez Larry Johnson David

  • @PedroMunizMagalhaes
    @PedroMunizMagalhaes 20 днів тому

    Saved my day! Thanks

  • @amersaeed4
    @amersaeed4 21 день тому

    while viewing the partner ledger account, i found that Landed cost is payable to the Partner/Supplier/Vendor. Why the landed cost payable to supplier?

  • @erikswanson3441
    @erikswanson3441 22 дні тому

    ok but what does this sync? only orders? i am trying to achieve a complete sync of all amazons fees and such being imported to the correct accounts

  • @admin.account-w2m
    @admin.account-w2m 24 дні тому

    watching you from long time, one of my best teacher in ODOO jounry, waiting for some more compelx scenairo disccsuions. Thank you Mr.Zaki

  • @PeterStuart-wj1wu
    @PeterStuart-wj1wu 25 днів тому

    Great explanation thanks for doing this!

  • @MuhammadUmarAkram4
    @MuhammadUmarAkram4 26 днів тому

    can we use webhook to download a report in odoo studio?

  • @HosamElNawasany
    @HosamElNawasany 27 днів тому

    Resupply from .. i can not see it

  • @MohamedAdel-fw9lx
    @MohamedAdel-fw9lx Місяць тому

    Thanks, it is very helpful

  • @ryanfelps509
    @ryanfelps509 Місяць тому

    amazing video. what would you change if we were doing installations for customer jobs?

  • @sarcastic_shits
    @sarcastic_shits Місяць тому

    On point. thank you

  • @lewy7601
    @lewy7601 Місяць тому

    at 18:13, scenario for purchase

  • @brrrGRr
    @brrrGRr Місяць тому

    thank you for your videos, thrilled to watch more

  • @EdgarTriias
    @EdgarTriias Місяць тому

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

  • @10x3
    @10x3 Місяць тому

    How do you record a donation in odoo accounting (ver 17) and how do you create a budget

  • @wimkumpen3769
    @wimkumpen3769 Місяць тому

    Great tutorial. I'm able to make a connection with the command line. But when trying to connect with pgAdmin or DbVisualizer I get "unable to connect to server: ERROR: permission denied for view pg_settings" or "ERROR: permission denied for table pg_database"

  • @karangrewal
    @karangrewal Місяць тому

    Thank you, please create more content for Odoo 17 & 18

  • @jamesbartlett1345
    @jamesbartlett1345 Місяць тому

    Thanks very much for this explanation!

  • @davidseamal
    @davidseamal Місяць тому

    The best explanation I've seen about it! Amazing jog. Thx

  • @tiffanydoris3
    @tiffanydoris3 Місяць тому

    The inventory valuation and the balance sheet are supposed to match but ours don't. Do you what could cause that? It is a pretty significant difference.

  • @burnaviour-l4r
    @burnaviour-l4r 2 місяці тому

    what if company want to hid accounts when doing internal tranfers

  • @mossdee
    @mossdee 2 місяці тому

    A thumbs up was not enough :) Great thanks!

  • @MicroYape
    @MicroYape 2 місяці тому

    Hi Kevin Zaki, very good video for my reference, may I know how to activate the inbox notification after creating the message?

  • @hitomimizugaki4425
    @hitomimizugaki4425 2 місяці тому

    Excellent tutorial! I have not found a way to create a separate pipeline for each product or service. Do you know any workarounds for this?

  • @tripleclamp
    @tripleclamp 2 місяці тому

    Odoo docs indicates the connector syncs inventory with Amazon. Is it only for the initial set up or is it supposed to keep Amazon inventory in sync with Odoo ? In our experience the connector finds the products "offers" but does not update Amazon as our inventory changes in Odoo. Using Odoo 16.0 and FBM

  • @OdooMates
    @OdooMates 2 місяці тому

    thanks for the video :) Using payload variable we can receive the passed values in the automated action, without installing the website application: ua-cam.com/video/9KWuFFd7tEw/v-deo.html and to create record inside odoo: ua-cam.com/video/KrVyiSoM1UY/v-deo.html

  • @kitpawornmillco.ltd.8248
    @kitpawornmillco.ltd.8248 2 місяці тому

    Best video❤🎉

  • @MartinPishpecki
    @MartinPishpecki 2 місяці тому

    Thank you very much - this is very useful.

  • @btzhanmay4932
    @btzhanmay4932 2 місяці тому

    Please help, create a new menu for reports in studio

  • @iwanmembumi
    @iwanmembumi 2 місяці тому

    Nice explanation and simulation

  • @christophersantillanolivar6878
    @christophersantillanolivar6878 2 місяці тому

    Thanks bro🤝

  • @AdrianCortes-z7t
    @AdrianCortes-z7t 2 місяці тому

    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 2 місяці тому

    Great tutorial Kevin. Thank you!

  • @abrotherinchrist
    @abrotherinchrist 2 місяці тому

    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.

  • @WaqasGCC
    @WaqasGCC 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    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 3 місяці тому

    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 3 місяці тому

    Thank you for such clear and detailed information.

  • @brrrGRr
    @brrrGRr 3 місяці тому

    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 3 місяці тому

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