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\ • Let’s 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 4000:4999 - 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: 4110:4115,4150%%,4165:4175

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?