LAYMNU General Ledger Statement Layout File Maintenance 1

Statement Layout File Maintenance

Application Overview

 The Statement Layout File application enables you to create and modify Financial Statement Layouts. The features include:

 Add provides for the entry of financial statement layouts.

 Change provides for the modification of financial state­ment layouts.

 Delete provides for the deletion of financial statement layouts.

 Resequence permits resequencing a layout using a selected increment in cases where a layout is too long or too compact for modification.

 Copy allows copying of one layout in order to create a new layout.

 Generate permits creation of Standard Statement Of Cash Flows and additional Source and Application of Funds Statement layouts from an existing Balance Sheet layout.

 List prints an edit list of financial statement layouts on file.

 Sample prints a sample of what the financial statement will look like for a given layout.

 

Financial Statement Formats

 There are two basic formats used in financial statements, the Profit and Loss format and the Balance Sheet format.

The Standard Profit and Loss format prints two amounts for each account or subtotal, the net changes for the period and the net change year‑to‑date.  The two amounts appear in fixed columns on the statement.  If budgets or com­paratives are used, the same period last year and year‑to‑date last year or the budgeted current period and year‑to‑date figures will print in two fixed columns to the right of the actual figures.

The Standard Profit and Loss format also allows ratios.  Ratios are percentage figures based upon some larger amount such as total sales or total revenue.  These percentage figures will appear just to the right of the amount figures on the statement.

Custom Profit and Loss Statements allow the definition of up to 13 columns and may include current period, year-to-date, budget, comparative, variance or ratio data. 

For an example of a Profit and Loss format, see the Predefined General Ledger section in the System Manager manual for the Profit and Loss Format Sample Statement.

The other format, the Standard Balance Sheet, shows one amount figure for each account or subtotal.  This amount is the account balance as of the period end date.  No net change figures appear.  The Standard Balance Sheet has three columns into which the amount can print.  The print column used is selected by the user when creating the layout.  Underlines and double underlines also appear in one of three print columns.  Ratios are not allowed on a Standard Balance Sheet format.  Budget and comparative figures appear in one of three columns to the right of the actual figure.  The budget or comparative amount will print in the same rela­tive column as the actual amount.  So if the account balance prints in the first print column, the corresponding budget amount would print in the first budget column.

For an example of a Balance Sheet format, see the Predefined General Ledger section in the System Manager manual for the Balance Sheet Sample Statement.

The standard statements, which print in the Profit and Loss (or P and L) format are the Profit and Loss Statement (type P), the Profit and Loss Format Supporting Schedule (type S), the Cash Flow Report (type C), and the Components of Working Capital Report (type W).

The standard statements, which print in the Balance Sheet format, are the Balance Sheet (type B), the Balance Sheet Format Supporting Schedule (type X), and the Statement of Changes in Financial Position (type F).

Building A Financial Statement

 Once you have an idea of what you want to appear on a financial state­ment, use the Statement Layout File Load Sheet to design the layout necessary to create that statement.  Then use the add mode to enter this layout.  Print the edit list and check for errors.  Once your layout matches the one you designed print a sample statement to verify exactly how the standard financial statement will look.  Make any neces­sary adjustments until the financial statement prints exactly as desired.

The designer must use the valid layout codes to produce the desired statement.  These layout codes appear in the same order on the finan­cial statements as their sequence numbers appear on the layout.  So a layout code with sequence number ten will appear before one with sequence number twenty.

General Ledger

  1. GLMENU General Ledger Package Overview
  2. My General Ledger Interface with Other Package Is Out of Balance
  3. Can Journal Ledger Be Imported to General Ledger?
  4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
  5. How to Print a Wider Financial Statement
  6. General Journal Transaction Out Of Balance After Interface with AR
  7. How to Archive GL Data Before Year-End Closing Procedure
  8. GL Year-End Closing Checklist
  9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
  10. General Journal Transaction In Balance But Not Able to Post
  11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
  12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
  13. Error During GL Interface from Other Package and Journal Transaction Is Lost
  14. COMPRESS General Ledger Processing Compress General Ledger TRX File
  15. GLBUDMNT General Ledger Budget File Maintenance
  16. GLCMPMNT General Ledger Comparative File Maintenance
  17. GLCONSOL General Ledger Company Consolidation
  18. GLCTLMNT General Ledger G/L Setup
  19. GLDSTMNT General Ledger Distribution Code File Maintenance
  20. GLENTMNT General Ledger Financial Entity File Maintenance
  21. GLJNLLST General Ledger Journal History Report
  22. GLPRDMNT General Ledger Accounting Period File Maintenance
  23. GLPRDSCN General Ledger Period Account Balance Report
  24. GLRATSCN General Ledger Financial Ratio Report
  25. GLRECALC General Ledger Recalculate Account Balances
  26. GLRECENT General Ledger Recurring Journal Trx Processing
  27. GLSRCMNT General Ledger Source File Maintenance
  28. GLTRIALB General Ledger Trial Balance Report
  29. GLWRKSHT General Ledger Print General Ledger Worksheet
  30. INTERFAC General Ledger Interface From Other Packages
  31. TEXTMNT General Ledger Statement Text File Maintenance
  32. SRCEXREF General Ledger Source Cross Reference Report
  33. YEAREND General Ledger Year-End Procedure
  34. GLACTMNU General Ledger G/L Account File
  35. GNJINLENT General Ledger General Journal Trx Processing
  36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
  37. Budget File Maintenance Questions & Answers
  38. LAYMNU General Ledger Statement Layout File Maintenance 1
  39. LAYMNU General Ledger Statement Layout File Maintenance 2
  40. LAYMNU General Ledger Statement Layout File Maintenance 3
  41. LAYMNU General Ledger Statement Layout File Maintenance 4
  42. LAYMNU General Ledger Statement Layout File Maintenance 5
  43. LAYMNU General Ledger Statement Layout File Maintenance 6
  44. LAYMNU General Ledger Statement Layout File Maintenance 7
  45. LAYMNU General Ledger Statement Layout File Maintenance: Index
  46. STMNTMNU Select and Print Financial Statements 1
  47. STMNTMNU Select and Print Financial Statements 2
  48. STMNTMNU Select and Print Financial Statements 3
  49. STMNTMNU Select and Print Financial Statements 4
  50. STMNTMNU Select and Print Financial Statements: Index
  51. Job Code Adjustment through GL Journal Entries
  52. How to Distribute Sales to General Ledger by Warehouse Location

Feedback and Knowledge Base