Reading list Switch to dark mode

    Odoo Accounting Excel Reports

    Updated 10 June 2020

    INTRODUCTION

    Excel reports are used as a standard guidelines for financial and accounting functions. Excel reports are easy to manipulate data with pivot tables, these reports are easy to formulate, charts data quickly, create tables quickly etc. Now, you can view your Odoo acconting reports in neatly arranged excel sheets with the help of the module named ” ODOO ACCOUNTING EXCEL REPORTS”

    Odoo Accounting Excel reports module allows you to print various accounting reports in excel format. This module helps you to generate excel reports for every financial compilation such as Trial balance, Aged partner balance , Balance sheet, partner ledger etc. In odoo reports can be generated in pdf format, but Odoo accounting excel report module allowing the printing financial reports in excel format. User can add new entries easily, make new calculations in the excel report without any extra efforts.

    FEATURES

    1. The module facilitates the generation of accounting reports in the excel format.
    2. For any required period of time interval financial reports can be generated.
    3. The user can print Print Sale/Purchase Journal report and Profit & Loss report.
    4. Print General Ledger report and Print Partner Ledger report.
    5. Trial Balance report and Balance Sheet report can also be generated.
    6. The excel file is automatically downloaded and saved in the system.

    INSTALLATION

    1. Once you purchase the App from Webkul store, you will receive the link to download the zip file of the module.
    2. Extract the file on your system after the download finishes. You will be able to see a folder named- ‘account_excel_reports’.
    3. Copy and paste this folder inside your Odoo Add-Ons path.
    4. Now, open the Odoo App and click on the Settings menu. Here, click on Activate the Developer Mode.
    5. Then, open on Apps menu and click on ‘Update Modules List’.
    6. In the search bar, remove all the filters and search ‘account_excel_reports’.
    7. You will be able to see the module in the search result. Click on ‘Install’ to install it.

    WORKFLOW

    1. Firstly, login to the Odoo database to go to the invoicing module.
    Invoicing
    1. Go to the reporting tab and click on the Journal audit.
    Financial reports
    1. Add start date and end date to print the report for defined period of interval otherwise it prints the overall report. Click on rhe print excel tab and print the report.
    Print Excel
    Journal
    1. Go to the reporting tab and click on partner ledger.
    Financial reports
    1. Click on the print excel button to print the overall report without adding date and print partner ledger.
    Print excel
    Partner ledger
    1. Go to the reporting tab and click on the general ledger.
    Financial reports
    1. Click on the print excel button and print general ledger.
    Print excel
    General ledger
    1. Go to the reporting tab and click on trial balance.
    Financial report
    1. Click on the print excel button and print trial balance.
    Print Excel
    Trial balance
    1. Go to the reporting tab and click on the balance sheet.
    Financial reports
    1. Click on the print excel button and print balance sheet.
    Print excel
    Balance sheet
    1. Go to the reporting tab and click on profit & loss.
    Financial report
    1. Click on the print excel button and print profit & loss report.
    Print excel
    Profit and loss
    1. Go to the reporting tab and click on aged partner balance.
    Financial reports
    1. Click on the print excel button and print the report.
    Print Excel
    Aged partner balance

    NEED HELP?

    Hope you find the guide helpful! Please feel free to share your feedback in the comments below.

    If you still have any issues/queries regarding the module then please raise a ticket at https://webkul.uvdesk.com/en/customer/create-ticket/

    For any doubt contact us at [email protected].

    Searching for an experienced
    Odoo Company ?
    Read More

    Thanks for paying attention!!

    Current Product Version - 1.0.0

    Supported Framework Version - Odoo V13, V12, V11

    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    Be the first to comment.

    Back to Top

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home