Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
  1. Courses
  2. Accounting and Invoicing
  3. Import an opening balance
Nav
Home └Accounting and Invoicing └Import an opening balance

Accounting and Invoicing

0 %

Completed

Course content
  • Accounting basics
    • Getting started 60 xp
      • Join this Course to access resources
      • Quiz
    • Chart of accounts 60 xp
      • Join this Course to access resources
      • Quiz
    • Update your chart of accounts 40 xp
      • Quiz
    • Import an opening balance 80 xp
      • Quiz
  • Invoicing
    • Issue a customer invoice 60 xp
      • Join this Course to access resources
    • Customer invoice from sales order 60 xp
      • Join this Course to access resources
    • Issue a credit note 80 xp
      • Join this Course to access resources
    • Register a vendor bill 60 xp
      • Join this Course to access resources
    • Vendor bill digitization 60 xp
      • Quiz
    • Payment terms & terms and conditions 40 xp
      • Quiz
  • Payments
    • Payments and outstanding accounts 80 xp
      • Quiz
    • Online payments 60 xp
      • Quiz
    • Customer payment follow-up 60 xp
      • Join this Course to access resources
    • Cash discounts 60 xp
      • Quiz
  • Bank and cash
    • Bank configuration 60 xp
      • Quiz
    • Bank transactions & bank synchronization 40 xp
      • Quiz
    • Bank reconciliation 60 xp
      • Quiz
    • Reconciliation models 40 xp
      • Quiz
    • SEPA Credit Transfer 60 xp
      • Quiz
    • SEPA Direct Debit 80 xp
      • Quiz
    • Loan management 60 xp
  • Taxes
    • Taxes and VAT 60 xp
      • Quiz
    • Cash basis 60 xp
      • Quiz
    • Fiscal Positions 60 xp
      • Quiz
    • Tax return 60 xp
      • Quiz
  • Accounting management
    • Extra Taxes (ecotax, alcohol, luxury,...) 60 xp
      • Quiz
    • Asset creation and management 60 xp
      • Quiz
    • Asset models and automation 60 xp
      • Quiz
    • Expense and revenue recognition and one-shot entries 60 xp
      • Quiz
    • Analytic accounting 60 xp
      • Quiz
    • Analytic budgets 60 xp
      • Quiz
    • US Tax Compliance - Avatax 40 xp
      • Quiz
  • Reporting
    • Multi-company and branch management 60 xp
      • Quiz
    • Financial reports 60 xp
      • Quiz
  • Inventory valuation
    • Inventory valuation 80 xp
      • Quiz
    • Inventory valuation (Continental) 60 xp
      • Quiz
    • Inventory valuation (Anglo-Saxon) 80 xp
      • Quiz
  • End of period
    • Multi-currency - Realized Gains/Losses 60 xp
      • Quiz
    • Multi-currency - Unrealized Gains/Losses 40 xp
      • Quiz
    • Closing the fiscal year 80 xp
      • Quiz

Import an opening balance

80 XP
Prev Next
Fullscreen Share
  • About
  • Comments (0)

In this video, learn how to import existing account balances into Odoo. 

Access the sample template.

Rating
5 9

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?
The suspense account The outstanding payments account The outstanding receipts account The cash account
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.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now