You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

To create new Account Schedule
1

Go to Account Schedule than click [New] to create a new account schedule name.



2

Then 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.

3Choose Edit Account Schedule

4Choose 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 press Process > Overview.

Input related Date Filter and the results will show at the bottom.

  • No labels