User can use Financial Reports to create Balance Sheet and Profit & Loss Statement that fit their use.

To create new Financial Report
1

Search "Financial Report", then click "New" to create a new one.



2

Enter the report name, description, row definition & column definiation.


User can edit the row definition and column definition for each report name.

For default Column Layout, user can use system's sample layout. Choose M-BALANCE for Balance Sheet and choose M-NETCHANGE for Profit & Loss Statement.

3Choose Edit the financial report.

4To edit the row definition, chick Insert >  Insert G/L Accounts 

5

Select the G/L Accounts to be inserted, then click OK.

For example, Balance Sheet only includes Balance Sheet G/L Accounts. 

6

For Balance Sheet, user will need to add a row to include current year's Profit & Loss figures.

For Totaling Type column, choose Posting Accounts. 

Under Totaling column, input Profit & Loss G/L Accounts.

7

For Totaling Type most commonly use are:

  • Posting Accounts gets data from posting accounts on G/L Account List.

  • Total Accounts gets data from G/L Accounts that are Total or End-Total.

  • Formula allows you to calculate use the column "Row No." (e.g. row 3130+3120).


To run Account Schedule, highlight the report user want to run, then click "View Financial Report"

Input related Date Filter and the results will show at the bottom. E.g. Income Statement