General Journal Excel Template - Free Download
4.2, 4443 votes
Please vote for this template if it helps you.
General Journal Excel Template
General Journal Excel Template
D8CFD495E732B61CB61623959C331AC0.xls
Page 1 of 1
GENERAL LEDGER JOURNAL ENTRY TEMPLATE
JE Template.XLS
1. Required data entry fields are indicated as "Y".
2. Enter your data beginning on line 16.
3. Enter the full chartfield combination (columns A to F).
OR
4. Enter the Account and SpeedCode (column F & G).
5. After all the data has been entered, sum colum "K". Column "K" must sum to zero.
6. Delete the cell containing the formula that sums column 'K" before continuing to step 7.
7. Press Ctrl + E to format file and to delete rows 1 to 15.
Save as type:Formatted Text(Space Delimited)(*.prn) and enter file name (<Journal Source Code>gl.prn)
Y Y Y Y/N Y Y N Y N N Y N Y Y N N N N
Fund
Department
Program
Project/Grant
Class
Account
Speedcode
Accounting
Date
(MMDDYYYY)
Business Unit
Business
Unit(GL)
Monetary
Amount
Journal Line
Description
Budget Period
Journal Line
Reference
Statistics
Amount
Statistics
Code
Sponsor
550 328000 0 Y000000029 0 TD0030 11152000 281945.03 Transfer to Fund 550 2001
350 328000 0 Y000000029 0 TC0030 11152000 -281945.03 Transfer from Fund 350 2001
530 100400 0 G599000228 0 502101 11152000 2625.00 Test Data 2001 SFR1866
530 100400 0 G599000228 0 502101 11152000 7.61 Test Data 2001 SFR1866
210 710201 0 0 109021 11152000 -2625.00 Test Data 2001
100 710201 81071 0 109021 11152000 -7.61 Test Data 2001
502324 04460 11152000 91.55 s/c to speedcode 04437 2001
502324 04437 11152000 -91.55 s/c from speedcode 04460 2001
100101 09939 11152000 1235.40 Test Data 2001
402001 00558 11152000 -1235.40 Test Data 2001
0.00
General Journal Excel Template Previous Page
source: policiesonline.ualberta.ca
General Journal Excel Template
Previous

1/1

Next