accpac financial report writer l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Accpac Financial Report Writer PowerPoint Presentation
Download Presentation
Accpac Financial Report Writer

Loading in 2 Seconds...

play fullscreen
1 / 14

Accpac Financial Report Writer - PowerPoint PPT Presentation


  • 725 Views
  • Uploaded on

Accpac Financial Report Writer Presented by Nancy Pearce or Bob Mahadea Help! Your Accpac manuals are available from Online Documentation, General Ledger User Guide Quick Reference Tips and Tricks Login date – defaults as the report period Statement Designer – opens Excel with FR menu

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Accpac Financial Report Writer' - adamdaniel


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
accpac financial report writer

Accpac Financial Report Writer

Presented by Nancy Pearce

or Bob Mahadea

slide2
Help!
  • Your Accpac manuals are available from Online Documentation, General Ledger
  • User Guide
  • Quick Reference
tips and tricks
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
print financialstatements
Print FinancialStatements
  • Run predefined statements
  • Cannot edit or copy
  • Separate segments (departments)
statement designer
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
fr menu
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

slide7
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
slide8
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
account segments structures
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

slide10
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
formulas
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
field names
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)
slide13
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