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 ScheduleFinancial Report
1

Go to Account Schedule than click [New] Search "Financial Report", then click "New" to create a new account schedule nameone.



Image RemovedImage Added

2

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


User can edit the row definition and column definition for each report nameThen input related fields. Name, Description and Default Column Layout.

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 Schedulethe financial report.

Image AddedImage Removed

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

Image RemovedImage 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