Can't find what you're looking for? Still have questions? Contact customer support
Run Balance Sheet Report
The following article provides steps for running a balance sheet report.
Go to General Ledger → Financial Reports
Select “BALANCE SHEET”
Select the heading and detailed level. In most instances this is set to level 2 and 3 as the balance sheet accounts uploaded by TPH are set to this level. Alternatively check the chart of accounts and look at what the header and detail accounts are set to there for the correct inputs. Now select the Currency. Native amounts will return a result of the exact numerical value entered whereas setting a base currency will complete a currency conversion using the exchange rate set in Currencies under the Control Table.
Next go to the Report Range/Options tab
Select the currency, location and episode to run the report over. These selections will be chart codes from the chart of accounts.
Now leave the PROD, DETL and SETN as listed above to run the report over all accounts or amend them as shown below to filter the report to present chart codes from a specific range.
In our example we are going to run the report to only return accounts from 1000 to 5999. All that is required is to enter 1000 in the “from” field and 4999 in the “to” field.
Other parameters that can be included are listed below with a short description
Include zero accounts - This will include accounts with a zero balance
Exclude zero budget_efc - All zero budget and efc accounts will be excluded
Exclude zero period variance - All zero period variance accounts will be excluded
Exclude blank notes - All blank notes accounts will be excluded
Exclude non postable accounts - All accounts listed as non postable will be excluded
Exclude zero fringe - All accounts with a zero fringe will be excluded
Consolidate - All accounts with the same chart code will be consolidated together
Flag Filters - Return a report for transactions flagged with a specific letter or number. This field work similar to the filter for chart codes. The filter will require a “from” and “to” entry, which will return a total for all transaction with the flags in the account.
Include unposted batches - include unposted transaction in the report
Sort - Sort accounts by normal, block or set
To further break down the chart codes into groups, click on the Sequence Range tab. See the article below for further explanation on this feature option.
Go back to the Report Details tab, click Save and then click OK to run the report.