Versions Compared

Key

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

...

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.

Image Added


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

Image Added