The dashboard export function allows you to view all your Balancer dashboard data in either .xlsx or PDF format for an overview of all balances.
You can also export individual intercompany balances for a detailed view of transactions and interest in .xlsx format.
Balancer Dashboard Export
Go to your Balancer dashboard and click the download icon.
From the menu, select either the Excel or PDF option to start downloading the file.
In the Excel file, you will find two sheets that reflect the two views in the Balancer UI: Detail and Matrix.
Detail View: Displays detailed information on each balance, including creditor and debtor balances, discrepancies, and the FX rates used for these calculations.
Matrix View: Provides a visual representation of all intercompany balances, highlighting unbalanced items in red and balanced items in green.
Note: Balances will be exported on the date selected in the datepicker. However, the ‘Show’ and ‘Filter’ options will not affect the exported .xlsx file.
For the PDF export, you will need to export the Detail View and the Matrix View as 2 separate files, and the 'Show' and 'Filter' options will impact what is included in the export.
Intercompany Balance Transactions Export
Go to the intercompany balance you are interested in and click the download icon.
From the menu, select the Excel option to download the .xlsx file.
The downloaded file contains:
A Transactions List sheet, reflecting the transactions displayed on the balance details page.
If interest rates are set up, an additional Interest Schedule sheet, which gives a detailed breakdown of interest accrued per day for this balance.
Note: Interest for the entire month is calculated based on which entity was the creditor on the last day of that month.