Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

To create new
Account Schedule
Financial Report
1
Go to Account Schedule than click [New]

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

account schedule name

one.

Image Removed



Image Added

2
Then input related fields. Name, Description and Default Column Layout

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.

Image Added

Image Removed

Image Added

3Choose Edit
Account ScheduleImage Removed
the financial report.

Image Added

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

Image Added

5

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

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

Image Modified

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.

Image Modified

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 press Process > Overview.click "View Financial Report"

Image AddedImage Removed


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

Image AddedImage Removed