1 / 48

Financial Report Writer

Financial Report Writer. Aubrey Wood Accounting Support Program Liaison (SPL) 877-359-5492 xt 1306 Aubrey@tenmast.com. What will we cover?. Creating a New report Creating and Editing the Row format Selecting the Column format Reviewing Existing Reports Modifying Reports

william-doyle
Download Presentation

Financial Report Writer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Financial Report Writer Aubrey Wood Accounting Support Program Liaison (SPL) 877-359-5492 xt 1306 Aubrey@tenmast.com

  2. What will we cover? • Creating a New report • Creating and Editing the Row format • Selecting the Column format • Reviewing Existing Reports • Modifying Reports • Printing Financial reports • Becoming familiar with FRW .net, The Plus of FRW • Column format revised

  3. The Purpose of FRW • Designed to produce financial reports where the user has control over the style of output Row format style controlled in WT2 Column format standard in WT2 Full access for user definition in WT2+

  4. Financial Reports • Located in the GL Reports Menu • User-Defined Report Titles • Multiple fund Selections

  5. Access FRW Designer

  6. FRW Designer

  7. Access Edit Row Format + Add option from here will start a new blank row format for you to create your own customized Row Format.

  8. Edit Row Format Add, Delete, and Move options

  9. FRW Row Format Row Formats define the report lines that will be printed on the financial report. 1. Line Text determines what wording prints on the report 2. Line Type is used to format the report, there are many 3. Print is a yes no option to print the line (no for summary) 4. Is Currency to show as a $ value 5. Get From is for handling calculations 6. Sum To also for calculations

  10. FRW Row Format Line Types

  11. Add lines to Row Format Sign Reversal changes the sign of value for calculation purposes

  12. Line Type Account Code Run Master Account Listing in Reports to validate Account Types

  13. Major Account Type Detail Account Types

  14. Where do other line types pull from?

  15. Calculations Get From & Sum To

  16. Calculations Get From & Sum To

  17. Calculations Get From & Sum To

  18. FRW Column Formats • Income Statement – Budget Comparison • Used to show an Income or Revenue and Expense style report format. This type of column format shows account activity in the form of beginning balances, debit, credits and ending balance. • Income Statement – Prior Year Comparison • Used to show an Income or Revenue and Expense style report format. This type of column format shows account activity in the form of beginning balances, debit, credits and ending balance. • Income Statement – Four column • Used to show an Income or Revenue and Expense style report format. This format limits to the account, its description, Current period, & YTD ending balance.

  19. FRW Column Formats • Balance – Current Period and YTD • Used to show account balances used for a balance sheet style report • Balance – YTD • Balance Sheet style columns with only the current Year To Date balances • Balance – YTD with Prior Year Comparison • Balance Sheet style columns with only the current Year To Date balances and Prior year balances • Budget Comparison – Current Period • Used to show current account balances compared to budgeted amounts in the current period only

  20. FRW Column Formats • Budget Comparison – Current Period with YTD • Used to show current period and Year to Date account balances compared to budgeted amounts. • FDS Report • Used to consolidate multiple funds into a HUD specific FDS column format. Account balances are placed into columns based on the Fund Type of the fund used by the account.

  21. Column Format Edit or Add report Wizard

  22. Column Format Selection

  23. Edit/Add Report

  24. Edit/Add Report

  25. FRW Report This filter option removes lines with no values

  26. Editing Shared Row Formats Editing one row format edits it for ALL reports that use it Tenmast Support can copy row formats so that you may make them unique so they may be edited singularly

  27. FRW.net WT2+

  28. Financial Report Writer • Report • Date • 13 and or 14 • Fund • Cost Center (new) FRW Main Report Selections

  29. Form Security – Access to FRW

  30. Authorization Setup

  31. Cost Centers Cost Center is a part of the account segment

  32. FRW Columns and Layout Note: All columns are drag and drop for removal or position moves

  33. Saving a Layout Note: You can always change back to the full set of column choices by going back to the default layout option.

  34. Formatting Right click on any column header for all these formatting options

  35. Format option Group by this column

  36. Column Header Sort Left click on a header sort by that column

  37. Column Chooser Any removed column is available to be added back to the report

  38. Filter Editor

  39. Filter Editor

  40. Filter Editor

  41. Filter Editor To exclude zeros of a column filter by not equal to zero

  42. Show Find Panel

  43. Show Auto Filter Row Filter row appears under column headers entering numbers or letters quickly filters the report by that column containing that information

  44. Filter directly from column headerLeft click in the upper right corner of any column will give you a list of that columns contents

  45. Filter directly from column headerAscending or Descending order

  46. Print Preview Save your print preview to export to excel

  47. What Questions would you like to ask?

  48. Aubrey Wood Accounting Support Program Liaison 1-877-359-5492 ext. 1306 aubrey@tenmast.com

More Related