Trial Balance & Other Reports

G/L Project P&L Report

Prerequisite: Before creating a G/L Project P&L, you must set up one or more G/L Products (see Setup -> G/L Project Setup, and you must link a G/L Project to transactions.

Navigate to Financial Reports -> G/L Project Financial Report

Select G/L Product from the Project Dropdown

Select Financial Statement Report from Report ID Dropdown

Select Report Period from Report Period dropdown (prerequisite: Calculate and Publish Financial Period)

Report will display, showing transactions tagged with the G/L Project

Trial Balance Report

Navigate to Financial Reports -> Trial Balance Report

Select desired parameters.

• One of either Company, G/L Code Group or G/L Account are required.

• Select desired Start/End Period range

• Choose yes/no to suppress zero value lines

• Choose yes/no to include detail.

Without Details selected, trial balance summary is displayed

With Details selected, a > sign is displayed in the left column where user can expand to see transactions, and a transaction tab is displayed:

When user clicks the button download details to excel, many fields not on the screen display will be included with the download. The fields are as follows: G/L ID, G/L Name, Posted Date, Period, Source, Transaction ID, Debit Amount, Credit Amount, Client ID, Client Name, Product ID, Product Name, Comment, Project ID, Project Name, Employee ID, and Employee Name, and many more.

Some of these details are also included one the tab “Transactions”.

This trial balance report, either in summary or detailed format, often form the basis for what gets imported into a 3rd party G/L System. (Alternatively, can use the API to extract G/L details)

Please note, that if your downloaded report is > 500,000 cells, it will be downloaded as a CSV rather than an xls format. Also, if you are prompted when opening your file, that Excel wants to convert the leading zeros in a message like this, please select "Don't Convert"

G/L Transactions Report

This is a list of debit/ credit transaction report by financial period and level parameters which user chooses to narrow down the report as applicable.

Prepaid Expenses Report

This provides a list of transactions logged against the prepaid expenses GL account for a company by vendor for a period.