F9 Financial Report Writer - PowerPoint PPT Presentation

f9 financial report writer n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
F9 Financial Report Writer PowerPoint Presentation
Download Presentation
F9 Financial Report Writer

play fullscreen
1 / 99
F9 Financial Report Writer
204 Views
Download Presentation
kamal
Download Presentation

F9 Financial Report Writer

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. F9 Financial Report Writer Edward Kwang President

  2. What is F9 Financial Report Writer? • It is not a general purpose report writer like Crystal Reports. • It is a special purpose Financial Report Writer for General Ledger. • F9 pick up where Elliott GL left off • Presentation • Detail Analysis • It is spreadsheet base and supports: • Excel • Lotus 123 • Quatro Pro

  3. What Can F9 Do? • Create any financial report you want. • Professional WYSIWYG report creating • Never type another general ledger figure into your spreadsheet again. • Play with What If Scenario. • Create an Executive Information System • Budget Preparation & Write Back

  4. Installation of F9 • For Excel Users, do not use the default path for Office. Use C:\F9 instead. • Use Tools -> Add-Ins -> Browse and choose C:\F9\F9.XLL. • Delete WBTRV32.DLL from C:\F9 directory.

  5. Choose Excel 2000 if you are using Excel 2002 (Office XP)

  6. For Excel users, do not use the Microsoft Office directory that suggested by the system.Use C:\F9 as the Installation Path

  7. Choose Add-Ins under Tools

  8. Click “Browse” Button

  9. Browse to C:\F9 and choose F9.XLL

  10. Click OK to confirm F9 Add-In

  11. The F9 Tool Bar

  12. Rename WBTRV32.DLL in C:\F9

  13. Setup F9 • Setup Elliott directory • Choose the Company Number • Set the current year.

  14. Choose Setup under F9 Menu

  15. Setup Directory, Comp No & Year

  16. F9 Basic Formula • =GL( Account, Period ) in Excel • @GL( Account, Period ) in Lotus 123 • Cell Referencing • A3 (relative cell, change as copying) • $A3 (column is fixed, row is relative) • C$1 (column is relative, row is fixed) • $A$1 (both column and row are fixed)

  17. The Simple Way of Referencing to a Chart of Account & Period

  18. Reference Another Cell in =GL

  19. Use Copy & Paste

  20. Reference Both Chart of Account & Period to Other Cells

  21. Copy & Paste – It Doesn’t Work

  22. Make A column fixed by using $A

  23. Copy & Paste to the Right Cells – It Works

  24. Copy & Paste to the cell below – It doesn’t work

  25. Change B1 to B$1 to make sure it always reference to row 1

  26. GL($A2,B$1) can be copied to all other cells and still work

  27. Use F9 Chart Function • We normally use the 12 Periods option. • Adjust Column Width • Click on the spread sheet top right corner to highlight the entire spread sheet. • Move mouse in between the column until you see the special icon appear and click • Use “Freeze Panes” function to make it easy to navigate. • Find the cell that its top left corner meet the intersection of the freeze panes

  28. Choose Chart under F9 Menu

  29. Setup Chart for the 1st time • Make sure point to the right company • Make sure Year is correct. • Change Period from This Month to All Period.

  30. Change to “All Periods”

  31. Click “Find” for Chart of Account

  32. Accounts are copied to clipboard

  33. Paste Accounts at Cell A1

  34. Highlight entire spread sheet & auto adjust column width

  35. Freeze Panes under Windows

  36. The left & top stay static – make it easy for you to navigate

  37. Apply GL Function to Chart • Taking the next step and apply GL function to each cell. • Use Copy and Paste • You’ll see the result is the same • What’s the benefit of applying GL function? • Next Month, the figure will update automatically. • If it is a static value (as the previous one), you need to use the same procedure next month. • Do not Interrupt F9 Calculation • Spreadsheet may freeze • Turn off “Always Calculation” in F9 Option

  38. Apply GL function, Copy & Paste

  39. Choose Options under F9

  40. Turn off “Always Calculate” • Don’t Interrupt F9 Calculation. • No Keyboard Entry • No Mouse Click • If you do, F9 may freeze. • “Always Calculate” make it difficult to predict when the F9 calculation will take place. It’s easy to freeze F9 accidentally. • Turn off “Always Calculate” – Need to press F9 key to re-calc. • Since you know when the calculation will take place, you can wait for the calculation to finish without interrupting.

  41. Access Last Year Data • Use more parameters in GL function • =GL( Account, Period, CompNo, Year ) • Make CompNo & Year stored in one of your spreadsheet cell.

  42. =GL($A4,C$2,$A$1,$B$1)

  43. Copy & Paste – No Change

  44. Change Year in Cell B1 to 1998

  45. Use NGL (Negative GL) function • In Elliott General Ledger • Debit: Store as a positive number • Credit: Store as a negative number • If you do not want to see negative number with normally credit account. • Apply =NGL( Account, Period….) function • Change Cell data type to Number • Apply number with “,” like 1,000.00 • Display Negative as Red

  46. Change the 1st Cell of Liability Account Range to =NGL(….)

  47. Copy & Paste NGL formula to all Liability & Sales Account

  48. Change Cell to Number Format

  49. The cells with red color require attention

  50. Using F9 Wizard • You need the new ELIOTT.DLL (v4.0.0.4) to make F9 Wizard to work with Elliott. • You can download it by visiting http://www.elliott.com support area and choose “Utilities” under the download area.