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 to the "Generating Chart of Accounts Report" guide if needed.
Access the Reports Tab
- On the Accounting Bi dashboard, click on the "Reports" tab.
Select the Balance Sheet Report
- In the "Reports" tab, click on "Balance Sheet Report."
Configure Report Options:(Select Organisation First then)
- To: Enter the end date of the month.
- Periods: Enter the number of periods back you want the report to cover.
- Month Parameter: Select "Month".
- Standard Layout: Select "Yes".
Select Tracking Categories (Optional)
- If you want to include tracking categories, select the appropriate tracking categories in the extra section.
Submit the Request
- Click the "Submit" button to request the Balance Sheet Report.
Confirmation Notification
- A notification will appear at the bottom of the screen indicating that your request has been successfully submitted.
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.
Fetch the Report
- After the report is completed, you can fetch the Balance Sheet Report in Excel and Power BI formats.
Related Articles
Generating Profit and Loss Report(With and Without Tracking Categories)
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 Balance Sheet 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 ...