Hey Kevin, great videos...helps more than you know, even two years later! One question though...I watched one of your other videos; "Import old, paid invoices...". If I want to import all of our historical data so that all reporting is accurate and shows values, for past years, can I still use this videos method? Or...am I better to use the other video to import old invoices and this one for anything current/outstanding?
Importing all data is going to be very difficult. If you just want invoices you can follow my other videos. This go live video doesn't consider historical data.
Hi Kevin, Thank you for your excellent explanation. I have one question, why do you use cleaning accounts? Wasn't it possible to enter the balances for banks, accounts receivable , accounts payables, and inventory?
Clearing accounts are used to offset your initial balance. In the case of bank accounts, when you upload your initial statement there is a starting balance that needs to be reconciled. Putting the value in the outstanding receipts allows you to do so. In the case of inventory, lets say you have $500 worth of inventory (and you are using automated inventory valuation) that value is going to double because you first put it on your balance sheet then you added the inventory with its corresponding value in the inventory module. If you excluded it from your balance sheet altogether your trial balance wouldn't have equal credits and debits which can not be.
great tutorial. one question concerning the product list and count though. I figured out how to add attributes/variants, but how would I include that in my count? I have a header for Product Attributes/Attributes (size for example). Then another column for Product Attributes/Values (they have to be typed up like Sm,Med,LG,XL,2XL), but now I have 1 external id for 5 different products with different counts and different costs (2XL cost more). Any help would be much appreciated.
what happens if your trial balance excel sheet is not balanced, would I need to create a new journal entry in undistributed profit and losses with the difference so it can balance my opening ?
You can just upload those starting balances to the appropriate accounts. You will create a the depreciation asset model as normal. For your prepayments you can create a journal entry from prepayments to accounts payable with your specific vendor attached to the the payable line and use that credit to pay the vendor bill when it arrives.
what happens if you working with multiple currencies, let's say if some of your Payables are in USD and the others in EURO. Do but your default currency is USD. Do you create separate clearing accounts for each currency type ?
THANK YOU , Now days you are the one watching daily here at office - waiting for more Mr.KEVIN
This is gold. Thank you.
Hey Kevin, great videos...helps more than you know, even two years later! One question though...I watched one of your other videos; "Import old, paid invoices...". If I want to import all of our historical data so that all reporting is accurate and shows values, for past years, can I still use this videos method? Or...am I better to use the other video to import old invoices and this one for anything current/outstanding?
Importing all data is going to be very difficult. If you just want invoices you can follow my other videos. This go live video doesn't consider historical data.
Thank you for the detailed steps
Hi Kevin, Thank you for your excellent explanation. I have one question, why do you use cleaning accounts? Wasn't it possible to enter the balances for banks, accounts receivable , accounts payables, and inventory?
Clearing accounts are used to offset your initial balance. In the case of bank accounts, when you upload your initial statement there is a starting balance that needs to be reconciled. Putting the value in the outstanding receipts allows you to do so.
In the case of inventory, lets say you have $500 worth of inventory (and you are using automated inventory valuation) that value is going to double because you first put it on your balance sheet then you added the inventory with its corresponding value in the inventory module. If you excluded it from your balance sheet altogether your trial balance wouldn't have equal credits and debits which can not be.
dear kevin Is this the product template for those products Inew products ) not in the database ?
thank you sir
If you can give set up company service for us, that would be great Please do it for us and thank you
Why my account is not showing reports? It is directly downloading the report as pdf
Do you need specific outstanding accounts per bank?
Thank you, please create more content for Odoo 17 & 18
great tutorial. one question concerning the product list and count though. I figured out how to add attributes/variants, but how would I include that in my count? I have a header for Product Attributes/Attributes (size for example). Then another column for Product Attributes/Values (they have to be typed up like Sm,Med,LG,XL,2XL), but now I have 1 external id for 5 different products with different counts and different costs (2XL cost more). Any help would be much appreciated.
Export the product variant external ID, which will be say "product.product". Whereas the product ID is the "product.template external ID"
what happens if your trial balance excel sheet is not balanced, would I need to create a new journal entry in undistributed profit and losses with the difference so it can balance my opening ?
Bravo, great job
how about if you are working with prepayments (insurance) and fixed assets with a depreciation?
You can just upload those starting balances to the appropriate accounts. You will create a the depreciation asset model as normal. For your prepayments you can create a journal entry from prepayments to accounts payable with your specific vendor attached to the the payable line and use that credit to pay the vendor bill when it arrives.
what happens if you working with multiple currencies, let's say if some of your Payables are in USD and the others in EURO. Do but your default currency is USD. Do you create separate clearing accounts for each currency type ?
The easiest approach would be to create one clearing account per currency.
@@KZAKI thanks
you are the best