AJ-12: Streamlining the GL Entry Process

Deirdre Larkin, Etegent Technologies, Ltd

About the Presenter

• Ajera User since 2009• Financial Professional for over 25 years• Past President of the Ajera User Association• Contact Information

– Telephone – 513-807-2170– Email: deirdre.larkin@etegent.com

2

What we will Cover

General Ledger Journal EntriesCreating Schedules using the

Financial Statement DesignerExporting Schedules to ExcelGeneral Ledger Upload Feature in

AjeraWorking with csv filesImporting csv files in Ajera

3

4

Types of Journal Entries

Fringe AllocationsDivision AllocationsFacility or Administration AllocationsYear End Journal Entries

5

Financial Statement DesignerYou can create any number of schedules in the Financial Statement Designer. The schedule we will be using in this session is a Division Allocation schedule. We have an administrative division that is allocated to the other 4 division in our company.

Here is what the design and the Preview look like

6

7

DE

SIG

NM

OD

E

8

PR

EV

IEW

MO

DE

9

CS

VE

XP

OR

T

Working with csv filesI will manipulate this file a bit. I copied the section for import to another sheet and paste special with values. I enter the current period I am working on (here I have added 8/31/18 dates) and I change the format of the dollar amounts to number. These csv file can be tricky, rounding causes the debits and credits to not balance.

10

11

CSV File

SA

VE

DA

SA

CS

VF

ILE

12

SE

TT

ING

UP

JO

UR

NA

LE

NT

RY

IMP

OR

T

GL Upload Feature

I have set up my csv file to match the import

settings

13

Journal Entry Importing

• We will import the csv file via the journal entry import

14

15

Here is an example of an error you might getting while importing. See error below in the import file

16

No errors, file is imported