Atrieve Finance

Year End Parameters

Year-End Parameters

Year-End Parameters must be completed before running year-end processing. This profile lets you specify the fund(s) to be processed and the surplus/deficit account for posting the revenue/expense balance.

Multi-Fund Year-End Closing

  • Inter-Fund Accounting Option: Set to 'Y' in the master profile to describe a multi-fund year-end closing.

  • If set to 'Y': Specify up to 999 funds, each with its own surplus/deficit account.

  • If not set to 'Y': Specify only a surplus/deficit account for all revenue/expense accounts in the GL.

Closing Sub-Funds

  • Define how to close sub-funds within larger funds like Endowments or Trusts.

  • Close each sub-fund to its own fund balance account.

Instructions

  • Click into the line to change or add.

  • Press <ENTER> when finished changing any displayed item on the current screen.

Fund Code

  • Enter each fund code in your GL to be closed out by year-end processing.

  • Note: The system supports a 3-digit fund code.

Surplus/Deficit Account (S/D Account #)

  • Enter the surplus/deficit account for posting the net result of closing revenue/expense accounts for each fund.

  • For funds with sub-funds, include '?'s in the account positions that define the sub-fund. The program will prompt you for the sub-fund definition.

Note: If you are using Sub-Funds, in order to get to that field you must have at least one segment of your surplus deficit account with ??? other wise you will get a message sorry you cannot move to that field yet.

Sub-Fund Definition

  • Enter '#'s for positions of the account code that don't affect sub-fund identity.

  • Enter '?'s for positions defining the unique value for each sub-fund.

  • Arrow up or down in the grid to view the next page or previous page.

  • Once satisfied with changes click update profile.

Sub-Fund Examples

  • Mask for Sub-Fund Definition: #### #### #### #### ????

    • #: Numbers that don't impact sub-fund identity.

    • ?: Wild card values that define sub-fund identity and trigger updates or creation of a Fund/Sub Fund Balance account.


Example 1

Simple account structure, no Funds or Sub Funds. Master Profile Fund Accounting = 'N'.

Project

Activity

Object

(4)

(2)

(2)

Budgetary Accounting System Year-End Profile

##

FUND

S/D Account #

001


001808LG

002

-----

---------------

003

-----

---------------

004

-----

---------------

005

-----

---------------

006

-----

---------------


Example 2

Set up using more than one element of the GL. This example uses program and object.

Budgetary Accounting System Year-End Profile

GL Element #

01

02

FUND

###

FUND

S/D Account #

Sub Fund Definition

001

00

00???899001???

##???######???

General Ledger

Fund-Program-Object-Sub Program-Location

Year-End Closing Balance

00-102-102-000-000

7.00

00-102-105-000-000

80.00

00-102-111-000-000

10.00

00-102-112-000-000

10.00

00-102-115-000-000

1,833.38

00-000-021-000-000

12.31

00-000-221-000-000

19.35

00-000-211-000-000

-1,726.17

00-000-221-000-000

1,361,543.84

Closing GLs

GL Code

S/D Account #

Balance

00102102000000

00102899001000

7.00

00102105000000

00102899001000

80.00

00102111000000

00102899001000

10.00

00102112000000

00102899001000

10.00

00102115000000

00102899001000

1,833.38

Total for S/D GL 00102899001000

1,940.80


00000021000000

00000899001000

12.31

00000022100000

00000899001000

19.35

00000211000000

00000899001000

-1,726.17

00000221000000

00000899001000

1,361,543.84

Total for S/D GL 00000899001000

1,359,849.33



Note: You can use one element of the GL or multiple elements to define your surplus/deficit accounts.