Accpac Financial Report Writer

1
Accpac Financial Report Writer

• Presented by Nancy Pearce
• or Bob Mahadea

2
Help!

• Your Accpac manuals are available from Online
  Documentation, General Ledger
• User Guide
• Quick Reference

3
Tips and Tricks

• Login date defaults as the report period
• Statement Designer opens Excel with FR menu
• What are Quik Reports? QUIKBAL1, QUIKINC1
• Path of Quik reports on local drive is C\Program
  Files\Accpac\GL5x\Eng\
• Lets look at Financial Reporter

4
Print FinancialStatements

• Run predefined statements
• Cannot edit or copy
• Separate segments (departments)

5
Statement Designer

• What is different about Microsoft Excel and
  Financial Reporter (FR) ?
• Columns A to D are reserved for Financial
  Reporter
• Columns E and beyond print on the report

6
FR Menu

• FR View Report generation options
• FR Paste Tool to create formulas
• FR Clear Clear the report range
• FR Help Links to help articles

7

• Column A
• Top comments area with leading in the cell
• Blank rows print as is
• \T will repeat those rows as titles on each page
  of the report
• \\ACCTGROUP tells the report to refer to the
  Account Group as specified in the GL Account set
  up Revenue Cost Expenses, etc used in Quik
  reports
• Custom reports will usually use Column A to list
  what accounts are reported on each line

8

• Column B
• Enter criteria to restrict the range of accounts
• On custom reports it could be a specific Account
  Segment
• Column C
• Z specifies to suppress rows that have zero
  amounts, this applies to all columns including
  Budgets or Year End balances
• Column D
• T indicates consolidating a range of accounts
  into one amount on the report.
• D(ACCT) specifies to print one line per Account
  number
• D would print all accounts on separate lines

9
Account Segments Structures

• Account segments structures allow for report
  flexibility
• 4000 Sales
• 4000 100 Sales - Commercial Division
  
• 4000 100 - 10 Sales - Commercial Northern
  
• 4000 100 - 20 Sales - Commercial Southern
  
• 4000 200 Sales - Retail
  
• 4000 200 - 10 Sales - Retail Northern
  
• 4000 200 - 20 Sales - Retail Southern
• Note that Sales is the common description
  affect in FR

10

• Column A
• A single account number would be entered as
  4000 - this will print all accounts starting
  with 4000, including different segments
• A range of accounts would be entered as 40004999
  - this will print all accounts starting with
  that range of account numbers, including
  different segments
• A mixture of accounts are separated by a comma,
  such as 41104115,4150,41654175

11
Formulas

• FRTRNA("NETYTD")
• FR indicates a Financial Reporter formula
• TRN will return Transaction Details in a drill
  down feature in version 5.3B
• Note that this will only work for Net, not
  Balance types of codes, or Budgets
• AMT is the other common code used in other
  cases
• A will show debits as positive numbers and
  credits as negative numbers regardless of the
  Account Type
• If A is not used, the Account Type is referred to
  and Debit balances in Debit accounts report as
  positives Credit balances in Credit accounts
  report as positives
• The brackets contain the following information,
  but not all is mandatory
• (field name, account reference, criteria,
  currency) each of these sections must have at
  the beginning and end

12
Field Names

• FRTRNA("NETYTD")
• Field name in this case is NETYTD asking to
  report the net changes during the whole year.
• Field name prefix is commonly used to indicate
  Budgets (1) or Provisional (P) or Quantities (Q)
• Field name suffix can be used to indicate Last
  Year (.L1), a specific year (2004)

13

• Other examples of field names are
• BALY Balance of the account for the whole year
• BALYTD Balance year to date
• BALY.L1 Balance of the account for the whole
  year of last year
• 1NETP Budget 1, Net for the current period
• NETLP Net last period

14
Questions?