Versions Compared

Key

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

User can use Account Schedule 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 Added

Image Removed
3Choose Edit
Account Schedule

Image Removed

the financial report.

Image Added

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

Image Added

Image Removed
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 click "View Financial Report"

Image Added


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

Image Added