ConnectCarolina Chartfield Foundations in SPH
C
C
HARTFIELD
HARTFIELD
F
F
OUNDATIONS
OUNDATIONS
This
This
is
is
a
a
5-unit
5-unit
module
module
that
that
explores
explores
the
the
new
new
ConnectCarolina
ConnectCarolina
chartfield
chartfield
structure
structure
.
.
Note
Note
:
:
this
this
presentation
presentation
is
is
designed
designed
for
for
ConnectCarolina
ConnectCarolina
users
users
in
in
SPH
SPH
only
only
as
as
it
it
is
is
customized
customized
for
for
SPH-specific
SPH-specific
chartfields
chartfields
.
.
UNC Gillings School of Global Public Health
#1 C
ORE
C
HARTFIELDS
After
After
completing
completing
this
this
unit
unit
,
,
learners
learners
will
will
:
:
2
/19
Understand
t
he
c
omponents
t
hat
m
ake
u
p
t
he
c
ore
c
hartfields
.
Understand
t
hat
t
hese
c
hartfields
a
re
a
r
econfiguration
o
f
t
he
s
ame
i
nformation
t
hat
i
s
c
urrently
c
aptured
i
n
o
ld
a
ccounting
s
ystem
(
F
RS
)
c
odes
a
nd
t
heir
r
elated
a
ttributes
.
Understand
t
he
r
equired
c
ore
c
hartfields
f
or
a
ll
t
ransactions
.
OLD A
CCOUNTING
(FRS) –
N
EW
A
CCOUNTING
(C
ONNECT
C
AROLINA
)
Think
a
bout
h
ow
y
ou
c
urrently
r
ecord
t
ransactions
.
We
a
llocate
p
ersonnel
a
nd
c
harge
c
osts
t
o
A
ccounts
(
w
here
m
oney
i
s
c
oming
f
rom
)
a
nd
O
bject
c
odes
(
f
or
w
hat
)
Account
Object
3
/19
OLD A
CCOUNTING
(FRS) –
N
EW
A
CCOUNTING
(C
ONNECT
C
AROLINA
)
Think
a
bout
h
ow
y
ou
c
urrently
r
ecord
t
ransactions
.
We
a
llocate
p
ersonnel
a
nd
c
harge
c
osts
t
o
A
ccounts
(
w
here
m
oney
i
s
c
oming
f
rom
)
a
nd
O
bject
c
odes
(
f
or
w
hat
)
Behind
t
he
s
cenes
a
re
m
any
a
ttributes
:
Accounts
b
elong
t
o
a
s
pecific
l
edger
c
orresponding
t
o
a
m
ajor
F
und
t
ype
(
S
tate
,
F
&
A
,
C
ontracts
&
G
rants
,
U
niversity
T
rust
)
.
Account
Object
Fund
4
/19
OLD A
CCOUNTING
(FRS) –
N
EW
A
CCOUNTING
(C
ONNECT
C
AROLINA
)
Think
a
bout
h
ow
y
ou
c
urrently
r
ecord
t
ransactions
.
We
a
llocate
p
ersonnel
a
nd
c
harge
c
osts
t
o
A
ccounts
(
w
here
m
oney
i
s
c
oming
f
rom
)
a
nd
O
bject
c
odes
(
f
or
w
hat
)
Behind
t
he
s
cenes
a
re
m
any
a
ttributes
:
Accounts
b
elong
t
o
a
s
pecific
l
edger
c
orresponding
t
o
a
m
ajor
F
und
t
ype
(
S
tate
,
F
&
A
,
C
ontracts
&
G
rants
,
U
niversity
T
rust
)
.
Accounts
a
re
a
ssigned
t
o
a
D
epartment
.
Account
Object
Fund
Department
5
/19
OLD A
CCOUNTING
(FRS) –
N
EW
A
CCOUNTING
(C
ONNECT
C
AROLINA
)
Think
a
bout
h
ow
y
ou
c
urrently
r
ecord
t
ransactions
.
We
a
llocate
p
ersonnel
a
nd
c
harge
c
osts
t
o
A
ccounts
(
w
here
m
oney
i
s
c
oming
f
rom
)
a
nd
O
bject
c
odes
(
f
or
w
hat
)
Behind
t
he
s
cenes
a
re
m
any
a
ttributes
:
Accounts
b
elong
t
o
a
s
pecific
l
edger
c
orresponding
t
o
a
m
ajor
F
und
t
ype
(
S
tate
,
F
&
A
,
C
ontracts
&
G
rants
,
U
niversity
T
rust
)
.
Accounts
a
re
a
ssigned
t
o
a
D
epartment
.
Accounts
a
re
a
ssigned
a
P
urpose
c
ode
f
or
t
he
m
ajor
t
ype
o
f
a
ctivity
s
upported
b
y
t
he
f
unds
i
n
t
he
a
ccount
.
Account
Object
Fund
Department
Purpose
6
/19
O
LD
A
CCOUNTING
E
NVIRONMENT
An
e
xample
i
s
i
n
t
he
o
ld
H
R
s
ystem
,
E
PAWeb
:
We
p
rimarily
e
nter
t
he
A
ccount
a
nd
O
bject
c
ode
.
Account
Object
Department
Purpose
7
/19
Fund
O
LD
A
CCOUNTING
E
NVIRONMENT
An
e
xample
i
s
i
n
t
he
o
ld
H
R
s
ystem
,
E
PAWeb
:
We
p
rimarily
e
nter
t
he
A
ccount
a
nd
O
bject
c
ode
.
The
a
ccount
n
umerical
s
eries
a
utomatically
i
ndicates
F
und
t
ype
.
Purpose
a
nd
D
epartment
a
re
r
equired
i
nformation
,
b
ut
a
re
p
opulated
a
utomatically
i
n
t
he
o
ld
s
ystems
.
Account
Object
Department
Purpose
8
/19
Fund
N
EW
C
ONNECT
C
AROLINA
E
NVIRONMENT
In
C
onnectCarolina
,
e
xactly
t
he
s
ame
i
nformation
i
s
b
eing
c
aptured
.
The
u
ser
i
s
r
equired
t
o
e
nter
t
he
f
ull
c
hartfield
s
tring
f
or
e
ach
t
ransaction
.
The
c
ore
c
hartfield
s
tring
i
s
m
ade
u
p
o
f
t
he
f
ollowing
f
ive
c
omponents
:
Source
Account
Department
Business Unit
9
/19
Fund
C
ORE
C
HARTFIELDS
– B
USINESS
U
NIT
The
B
B
usiness
usiness
U
U
nit
nit
i
s
t
he
h
ighest
o
rganizational
u
nit
t
o
w
hich
t
ransactions
w
ill
“
r
oll
u
p
”
(
c
onsolidate
)
.
For
S
PH
d
epartments
,
t
he
B
usiness
U
nit
w
ill
b
e
U
NCCH
f
or
A
LL
y
our
t
ransactions
.
T
his
d
enotes
t
he
t
ransaction
b
elongs
t
o
t
he
o
verall
s
tewardship
o
f
t
he
U
niversity
i
n
g
eneral
.
Since
t
he
P
ublic
H
ealth
F
oundation
i
s
a
s
eparate
l
egal
e
ntity
,
d
irect
f
oundation
t
ransactions
w
ill
u
se
a
s
eparate
B
usiness
U
nit
C
HPHF
.
T
hese
t
ransactions
w
ill
o
nly
b
e
i
nitiated
b
y
t
he
S
PH
B
usiness
O
ffice
.
Business
Business
Unit
Unit
10
/19
Source
Account
Department
Fund
C
ORE
C
HARTFIELDS
– D
EPARTMENT
The
D
D
epartment
epartment
h
as
b
een
e
xpanded
f
rom
4
d
igits
t
o
6
d
igits
.
This
c
ode
i
ndicates
t
he
o
wner
o
f
t
he
t
ransaction
.
All
S
PH
d
epartments
s
till
b
egin
w
ith
4
6XXXX
.
Department
11
/19
CEHS
i
s
4
60501
HPM
i
s
4
61001
BIOS
i
s
4
62001
ESE
i
s
4
63001
EPID
i
s
4
63501
HB
i
s
4
64001
MCH
i
s
4
64501
NUTR
i
s
4
66001
NCIPH
a
nd
P
HLP
i
s
4
68501
Central
A
dmin
U
nits
i
s
4
60101
Business Unit
Source
Account
Fund
C
ORE
C
HARTFIELDS
– F
UND
For
e
very
t
ransaction
,
y
ou’ll
n
eed
t
o
a
nswer
t
wo
q
uestions
:
What
m
ajor
f
und
g
roup
w
ill
b
e
s
upporting
t
he
t
ransaction
?
What
i
s
t
he
p
urpose
o
f
t
he
t
ransaction
?
Fund
Fund
c
hartfield
i
s
a
s
ingle
5
-digit
c
ode
c
apturing
b
oth
m
ajor
f
und
g
roup
(
3
d
igits
)
a
nd
p
urpose
(
2
d
igits
)
.
12
/19
Fund
Major Fund
Group supporting
transaction
Purpose of
transaction
2XX XX
Business Unit
Source
Account
Department
C
ORE
C
HARTFIELDS
– F
UND
The
m
ajor
f
und
g
roups
c
orrespond
t
o
o
ur
m
ajor
s
ources
o
f
f
unding
.
State
F
unds
(
H
ealth
A
ffairs
)
:
2
11
Contracts
&
G
rants
:
2
52
F
&
A
:
2
71
Restricted
T
rust
F
unds
:
2
92
13
/19
Purpose
r
esembles
p
urpose
c
odes
e
mbedded
i
n
t
he
o
ld
F
RS
s
ystem
:
Regular
I
nstruction
:
0
1
Distance
E
ducation
:
0
2
Organized
R
esearch
:
1
0
Student
A
id
:
3
0
Student
S
ervices
:
6
0
Major Fund Group
Purpose
Fund
Source
Account
Business Unit
Department
C
ORE
C
HARTFIELDS
– F
UND
When
r
ecording
a
t
ransaction
,
y
our
F
F
und
und
i
s
t
he
c
ombination
o
f
t
he
a
ppropriate
m
ajor
f
und
g
roup
a
nd
p
urpose
o
f
t
he
t
ransaction
.
Example
1
:
T
o
r
ecord
t
he
p
urchase
o
f
l
ab
s
upplies
o
n
a
g
rant
i
n
t
he
c
ourse
o
f
c
onducting
r
esearch
,
t
he
F
F
und
und
i
s
2
5210
.
14
/19
Major Fund Group
Purpose
2XX XX
Fund
C
ORE
C
HARTFIELDS
– F
UND
When
r
ecording
a
t
ransaction
,
y
our
F
F
und
und
i
s
t
he
c
ombination
o
f
t
he
a
ppropriate
m
ajor
f
und
g
roup
a
nd
p
urpose
o
f
t
he
t
ransaction
.
Example
2
:
T
o
r
ecord
p
ersonnel
c
osts
s
upporting
i
nstruction
a
s
p
aid
f
rom
s
tate
f
unds
(
h
ealth
a
ffairs
)
,
t
he
F
F
und
und
i
s
2
1101
.
15
/19
Major Fund Group
Purpose
2XX XX
Fund
C
ORE
C
HARTFIELDS
– S
OURCE
Source
Source
i
s
a
5
-digit
c
ode
t
hat
i
ndicates
t
he
s
pecific
s
ource
t
hat
i
s
s
upporting
y
our
t
ransaction
All
s
tudent
f
ees
a
ccounts
w
ill
h
ave
a
u
nique
S
ource
c
ode
All
r
echarge
c
enters
w
ill
h
ave
a
u
nique
S
ource
c
ode
All
s
tate
r
eceipts
a
ccounts
w
ill
h
ave
a
u
nique
S
ource
c
ode
All
t
rust
a
ccounts
w
ill
h
ave
a
u
nique
S
ource
c
ode
Pooled
U
niversity
s
ources
h
ave
a
c
ommon
S
S
ource
ource
:
State
a
ppropriations
(
a
cademic
a
ffairs
)
:
1
2001
State
a
ppropriations
(
h
ealth
a
ffairs
)
:
1
3001
School-based
t
uition
:
1
3111
F
&
A
:
1
4101
Source
16
/19
Business Unit
Department
Account
Fund
C
ORE
C
HARTFIELDS
- A
CCOUNT
The
A
A
ccount
ccount
i
dentifies
t
he
a
ccounting
c
lassification
o
f
t
he
t
ransaction
b
eing
r
ecorded
.
1XXXXX
=
A
sset
a
ccounts
2XXXXX
=
L
iability
a
ccounts
3XXXXX
=
F
und
B
alance
a
ccounts
4XXXXX
=
R
evenue
a
ccounts
5XXXXX
=
E
xpense
a
ccounts
The
A
A
ccount
ccount
r
epresents
t
he
o
bject
c
ode
i
n
t
he
o
ld
s
ystem
.
Account
17
/19
Source
Fund
Business Unit
Department
C
ORE
C
HARTFIELDS
– S
UMMARY
All five core chartfields are required on all transactions. Here are some
examples of full chartfield strings with explanations:
/19
18
Source
Account
Department
Business Unit
Fund
13001
513120
462001
UNCCH
21101
H0062
569190
464501
UNCCH
29230
This
t
ransaction
r
ecords
B
IOS
u
sing
s
tate
(
h
ealth
a
ffairs
)
a
ppropriations
(
h
ealth
a
ffairs
)
t
o
s
upport
r
egular
t
erm
i
nstruction
w
ith
E
PA
t
eaching
s
alaries
.
This
t
ransaction
r
ecords
M
CH
u
sing
a
r
estricted
t
rust
f
und
f
or
s
tudent
a
id
,
t
he
S
arah
T
aylor
M
orrow
S
cholarship
,
b
y
o
ffering
a
s
tudent
a
ward
.
C
ORE
C
HARTFIELDS
19
/19
Congratulations
!
Y
ou
h
ave
c
ompleted
t
he
f
irst
u
nit
o
f
C
hartfield
F
oundations
.
The
n
ew
c
hartfields
w
ill
r
equire
t
ime
t
o
d
igest
.
D
on’t
w
orry
a
bout
m
emorizing
c
odes
.
R
esources
w
ill
b
e
p
rovided
t
o
f
acilitate
y
our
w
ork
.
Please
c
ontinue
t
his
p
resentation
t
o
c
omplete
t
he
s
ummary
t
est
.
Y
our
a
nswers
w
ill
b
e
k
ept
a
nonymous
a
nd
o
nly
r
eviewed
i
n
a
ggregate
t
o
s
ee
w
hich
a
reas
m
ay
n
eed
a
dditional
t
raining
.
Source
Account
Department
Business Unit
Fund
Explore the 5-unit module focusing on the new ConnectCarolina chartfield structure customized for SPH users. Learn about core chartfields, the transition from old accounting systems to ConnectCarolina, and the attributes associated with different fund types and departments.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
CHARTFIELD FOUNDATIONS This is a 5-unit module that explores the new ConnectCarolina chartfield structure. Note: this presentation is designed for ConnectCarolina users in SPH only as it is customized for SPH-specific chartfields. UNC Gillings School of Global Public Health
#1 CORE CHARTFIELDS After completing this unit, learners will: Understand the components that make up the core chartfields. Understand that these chartfields are a reconfiguration of the same information that is currently captured in old accounting system (FRS) codes and their related attributes. Understand the required core chartfields for all transactions. 2 /19
OLD ACCOUNTING (FRS) NEW ACCOUNTING (CONNECTCAROLINA) Think about how you currently record transactions. Account Object We allocate personnel and charge costs to Accounts (where money is coming from) and Object codes (for what) 3 /19
OLD ACCOUNTING (FRS) NEW ACCOUNTING (CONNECTCAROLINA) Think about how you currently record transactions. Account Object We allocate personnel and charge costs to Accounts (where money is coming from) and Object codes (for what) Behind the scenes are many attributes: Accounts belong to a specific ledger corresponding to a major Fund type (State, F&A, Contracts & Grants, University Trust). Fund 4 /19
OLD ACCOUNTING (FRS) NEW ACCOUNTING (CONNECTCAROLINA) Think about how you currently record transactions. Account Object We allocate personnel and charge costs to Accounts (where money is coming from) and Object codes (for what) Behind the scenes are many attributes: Accounts belong to a specific ledger corresponding to a major Fund type (State, F&A, Contracts & Grants, University Trust). Fund Department Accounts are assigned to a Department. 5 /19
OLD ACCOUNTING (FRS) NEW ACCOUNTING (CONNECTCAROLINA) Think about how you currently record transactions. Account Object We allocate personnel and charge costs to Accounts (where money is coming from) and Object codes (for what) Purpose Behind the scenes are many attributes: Accounts belong to a specific ledger corresponding to a major Fund type (State, F&A, Contracts & Grants, University Trust). Fund Department Accounts are assigned to a Department. Accounts are assigned a Purpose code for the major type of activity supported by the funds in the account. 6 /19
OLD ACCOUNTING ENVIRONMENT An example is in the old HR system, EPAWeb: Account Object We primarily enter the Account and Object code. Purpose Fund Department 7 /19
OLD ACCOUNTING ENVIRONMENT An example is in the old HR system, EPAWeb: Account Object We primarily enter the Account and Object code. The account numerical series automatically indicates Fund type. Purpose Purpose and Department are required information, but are populated automatically in the old systems. Fund Department 8 /19
NEW CONNECTCAROLINA ENVIRONMENT In ConnectCarolina, exactly the same information is being captured. The user is required to enter the full chartfield string for each transaction. The core chartfield string is made up of the following five components: Business Unit Department Fund Source Account 9 /19
CORE CHARTFIELDS BUSINESS UNIT The Business Unit is the highest organizational unit to which transactions will roll up (consolidate). For SPH departments, the Business Unit will be UNCCH for ALL your transactions. This denotes the transaction belongs to the overall stewardship of the University in general. Business Unit Since the Public Health Foundation is a separate legal entity, direct foundation transactions will use a separate Business Unit CHPHF. These transactions will only be initiated by the SPH Business Office. Department Fund Source Account 10 /19
CORE CHARTFIELDS DEPARTMENT The Department has been expanded from 4 digits to 6 digits. This code indicates the owner of the transaction. All SPH departments still begin with 46XXXX. CEHS is 460501 HB is 464001 Department HPM is 461001 MCH is 464501 BIOS is 462001 NUTRis 466001 ESE is 463001 NCIPH and PHLP is 468501 EPID is 463501 Central Admin Units is 460101 Business Unit Fund Source Account 11 /19
CORE CHARTFIELDS FUND For every transaction, you ll need to answer two questions: What major fund group will be supporting the transaction? What is the purpose of the transaction? Fund chartfield is a single 5-digit code capturing both major fund group (3 digits) and purpose (2 digits). Fund 2XX XX Major Fund Group supporting transaction Purpose of transaction Business Unit Department Source Account 12 /19
CORE CHARTFIELDS FUND Fund 2XX XX Major Fund Group Purpose The major fund groups correspond to our major sources of funding. Purpose resembles purpose codes embedded in the old FRS system: State Funds (Health Affairs): 211 Regular Instruction: 01 Contracts & Grants: 252 Distance Education: 02 F&A: 271 Organized Research: 10 Restricted Trust Funds: 292 Student Aid: 30 Student Services: 60 Business Unit Department Source Account 13 /19
CORE CHARTFIELDS FUND Fund 2XX XX Major Fund Group Purpose When recording a transaction, your Fund is the combination of the appropriate major fund group and purpose of the transaction. Example 1: To record the purchase of lab supplies on a grant in the course of conducting research, the Fund is 25210. 252 10 Contracts & Grants Organized Research 14 /19
CORE CHARTFIELDS FUND Fund 2XX XX Major Fund Group Purpose When recording a transaction, your Fund is the combination of the appropriate major fund group and purpose of the transaction. Example 2: To record personnel costs supporting instruction as paid from state funds (health affairs), the Fund is 21101. 211 01 State funds (health affairs) Regular term instruction 15 /19
CORE CHARTFIELDS SOURCE Source is a 5-digit code that indicates the specific source that is supporting your transaction All student fees accounts will have a unique Source code All recharge centers will have a unique Source code All state receipts accounts will have a unique Source code All trust accounts will have a unique Source code Source Pooled University sources have a common Source: State appropriations (academic affairs): 12001 State appropriations (health affairs) : 13001 School-based tuition: 13111 F&A: 14101 Business Unit Department Fund Account 16 /19
CORE CHARTFIELDS - ACCOUNT The Account identifies the accounting classification of the transaction being recorded. 1XXXXX = Asset accounts 2XXXXX = Liability accounts 3XXXXX = Fund Balance accounts 4XXXXX = Revenue accounts Account 5XXXXX = Expense accounts The Account represents the object code in the old system. Business Unit Department Fund Source 17 /19
CORE CHARTFIELDS SUMMARY Business Unit Department Fund Source Account All five core chartfields are required on all transactions. Here are some examples of full chartfield strings with explanations: UNCCH 462001 21101 13001 513120 This transaction records BIOS using state (health affairs) appropriations (health affairs) to support regular term instruction with EPA teaching salaries. UNCCH 464501 29230 H0062 569190 This transaction records MCH using a restricted trust fund for student aid, the Sarah Taylor Morrow Scholarship, by offering a student award. 18 /19
CORE CHARTFIELDS Congratulations! You have completed the first unit of Chartfield Foundations. The new chartfields will require time to digest. Don t worry about memorizing codes. Resources will be provided to facilitate your work. Please continue this presentation to complete the summary test. Your answers will be kept anonymous and only reviewed in aggregate to see which areas may need additional training. Business Unit Department Fund Source Account 19 /19
