Generating Profit and Loss Report(With and Without Tracking Categories)

Generating Profit and Loss Report(With and Without Tracking Categories)

  1. Connect Your Organization

    • Ensure your organization is connected to Accounting Bi. If not, follow the guide "Connecting Accounting Bi to Xero".
  2. Generate the Chart of Accounts Report

    • Ensure the Chart of Accounts report has already been generated. Refer to the "Chart of Accounts Report" guide if needed.

Generating the Profit and Loss Report

  1. Access the Reports Tab

    • On the Accounting Bi dashboard, click on the "Reports" tab.
  2. Select the Profit and Loss Report

    • In the "Reports" tab, click on "Profit and Loss Report."
  3. Configure Report Options

    • From: Enter the starting date of the month.
    • To: Enter the ending date of the month. Ensure you select a full 31-day month.
    • Periods: Enter the number of months back you want the report to cover.
    • Standard Layout: Not to select.
    • Month Parameter: Not to select.

  4. Select Tracking Categories (Optional)

    • If you want to include tracking categories, select the appropriate tracking categories in the extra section.
         
  5. Submit the Request

    • Click the "Submit" button to request the Profit and Loss Report.

  6. Confirmation Notification

    • A notification will appear at the bottom of the screen indicating that your request has been successfully submitted.
  7. Monitor Report Status

    • A popup notification will appear to inform you about the status of your report.
    • Once the report is completed, the popup will indicate that the process is complete.
  8. Fetch the Report

    • After the report is completed, you can fetch the Profit and Loss Report in Excel and Power BI to analyze Financial Data.

    • Related Articles

    • Generating the Balance Sheet Report(With and Without Tracking option)

      Connect Your Organization Ensure your organization is connected to Accounting Bi. If not, follow the guide "Connecting Accounting Bi to Xero". Generate the Chart of Accounts Report Ensure the Chart of Accounts report has already been generated. Refer ...
    • Generating Chart of Accounts Report

      Connect the Organization Ensure your organization is connected to Accounting Bi as per the connection guide on "Connecting Accounting Bi to Xero". Access the Report Section On the Accounting Bi dashboard, click on the "Reports" section. Select the ...
    • Calling Profit and Loss Reports

    • Excel-Add-in-Template Method

      Using Templates: Step 1: Access Templates Go to https://accounting.bi/template-dashboards/. Open the template that contains the desired data for Profit and Loss or Balance Sheet. Step 2: Configure the Bearer Token Click on the Bearer Token Popup ...
    • Excel Add-in-Blank File Method

      Method 1: Using a Blank File Step 1: Install the Excel Add-in For Single Users: Open Excel Desktop or Excel Web. Navigate to the Home tab. Go to the Add-in section and click on "+More Add-ins". Search for "Accounting.Bi" and install the Accounting Bi ...