How to export and filter your trial balance report within lease accounting.
In order to export your trial balance reports, navigate to “Trial Balance” under the lease accounting module:
Once you are on this page, you must select the beginning and ending period and legal entity. The trial balance will not populate until these three selections are made.
If you wish, you can further refine your trial balance by clicking filter and then filtering by Accounting Lease or Account Segment:
You can also see your balances per lease by clicking "By Lease"
In the "Accounting Lease" drop down, all your "Completed" leases will populate. You can select one or multiple leases to include in the trial balance analysis. Leases selected will be included in the total balances in the trial balance
If you choose to utilize Account Segment, this will populate all "Completed" leases based on the Account Segment selected. Only one Account Segment can be selected at a time.
Once you are satisfied with the report parameters, you can export the trial balance into excel by selecting "Export" on the right hand side, Two options are available, "Summary" or "By lease":
Note- Each account name is associated with a account type.
Income Statement (also known as the Profit & Loss Statement) reflects a company's performance over a specific period.
Balance Sheet shows the company’s financial position at a specific point in time, detailing assets, liabilities, and shareholders' equity
To learn how to change the Account Type, refer to the article here. For more general information on Account Type, please click here.