2.4 How to upload and reconcile bank transactions

1. 1. Click on Accounting

   

2. 2. Click on Bank

   

3. 3. Click on Upload

   

4. 4. Select a file from upload menu

   

5. 5. Check the File column has an appropriate Odoo Field

   

6. 6. Click on Test

   

7. 7. Click on Everything seems valid.

   

8. 8. Click on Import

   

9. 9. Select a transaction.

   

10. 10. If all details in the file are matched, Odoo will automatically suggest the invoice to be reconciled

    

11. 11. Click on Validate

    

12. 12. Select another transaction (Repeat step 9-10)

    

13. 13. The cash discount was automatically calculated based on the invoice shown in Cash Discount Tutorial.

    

14. 14. Click on Validate

    

15. 15. By default, it Will reduce the oldest invoice amount first

    

16. 16. Amend if needed. Select the corresponding invoices involved

    

17. 17. Click on Validate

    

18. 18. Click on Accounting

    

Setting up Online Bank Synchronization

1. 19. Click on Accounting

   

2. 20. Click on Configuration

   

3. 21. Click on Add a Bank Account

   

4. 22. List of bank institution available for bank synchronization on Odoo

   

5. 23. Search relevant institution. For example, Odoo Bank Sync Demo will be used

   

6. 24. Click on Connect

   

Connect with Odoo Bank Sync Demo

1. 25. Will be redirected to the appropriate institution & API for intergration.

   This is a demo/sandbox version

   

2. 26. Click on Proceed

   

3. 27. Once logged-in/synced, bank transactions will automatically be updated ready for reconcilation.

   

4. 28. Click on Dashboard

   

5. 29. Click on Fetch Transactions to fetch & update transactions to date.

   

6. 30. Updated transactions will appear ready for reconciliation.