- Accounting Basics
-
Invoicing
-
- Join this Course to access resources
-
- Join this Course to access resources
-
- Join this Course to access resources
-
- Join this Course to access resources
-
-
Payments
-
- Join this Course to access resources
- Bank and Cash
- Taxes
- Accounting management
- Reporting
- Inventory valuation
- End of period
Import an opening balance
In this video, learn how to import existing account balances into Odoo.
Find the sample template here: https://docs.google.com/spreadsheets/d/1ezu5H3Eko4-GGFbSz2exZM2PoQ-C2Y_D/edit?gid=839582211#gid=839582211
Rating
2
4
There are no comments for now.
Join this Course
to be the first to leave a comment.
1.
What account should replace the bank account when importing a positive (debit) amount?
2.
Which of the following processes is the best way to import open invoices and bills?
Add each invoice or bill as one line in the import template with the remaining amount to be paid as the total and import to the corresponding model.
Add each line of each invoice or bill as its own line in the import template so that the invoice or bill has all of the details in Odoo and import to the corresponding model.
Import invoices and bills directly from the general ledger view by opening the action menu and clicking “Import Invoice/Bill”.
Combine them into one sheet, then import them through the Import Wizard in the Accounting Settings.
3.
What’s the purpose of replacing the receivable and payable accounts on the general ledger with the clearing account?
It’s impossible to import to receivable or payable accounts.
By importing to the clearing account, you don’t have to import your open invoices or bills.
It gives you an entry to reconcile the opening bank transaction against.
It avoids duplicating the balance in the receivable and payable accounts when importing both the general ledger and the open invoices and bills.
