Importing Journal Entries
Related Documents
Populating the Journal Entry Template
1. Click the XLS document at the top of this help page to download the JE Template
2. Open the Template file, you will see the headings of data you need to key. See the two examples below. This is the format you should use when keying any new Journal Entries into the spreadsheet:
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yNTQzLzM5MjYvY2tmaW5kZXIvaW1hZ2VzL2ltYWdlKDIxMCkucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzQ2ODQ3OTAzfX19XX0_&Signature=SKqcx3FG-2fh2lD34lIB8wcVXqc2jgl5S13mU9slYd7VtNgICAdRx3uIDaA2NcuxzClHyFVsbCC60pcUCoRG~0RPVvepRcWcrnZbEkMftseBWF8Cri3DIg0JSQqXUKAeM2q9xGW5yIIrA1ioP~XH2zc0Mu7NlDamdkfV5GnUEw13yzcySac8g0wqOhD7N9Ju5Nw3e98kkB453EV-38x1yLzM2O8y5ra4ALaNDfFptuhFjz3PcWS~4ZAx6ZTvTv0l17nsho87XLK-Or2-F0C4U8qY4HYzP5jOhNIoNqQUC9ZAnbiLyXZj5O5gb5pifEilODcgvrV8Z3PikEaJnoTLTg__&Key-Pair-Id=K2TK3EG287XSFC)
3. Key your own Journal Entries following the sample format and then delete the two sample lines.
4. Save the file to a location where you remember for the import
Importing Journal Entries
1. Open Accounting/General Ledger/Journal Entries.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yNTQzLzM5MjYvY2tmaW5kZXIvaW1hZ2VzL2ltYWdlKDIwOSkucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzQ2ODQ3OTAzfX19XX0_&Signature=aVoksxtHiKnvbffJjU11Ts-uvgIwI1tuqtKSbyNWrh1XMOmUL4Y~Qi5U4Q-pfhqmMbhesd4VRUuPHBfTuEdPi~dVlyAi4DzhoLD93-CAbpSCJ-tHYX13ehPw6QXnoggxj3CpQflB2zPAvBcfeJRgeeKQYEIG-0uXwog9hxS4ZLjzIZDkhLffkwL9mbPm6JuiK9YT0zXijFSZ0ghjaASC2EX2a3jK26clFETNThkGb0fSvIKMc7DXNLXfSsYeOaoUPHREDIIFjGD2oe09bIF1jcwoAS9bcF5FzbbfeDGShGzQ5yUGu4u8NIxbUaE4nvZlsV8HwFRKDSSyYhJc-cDI1A__&Key-Pair-Id=K2TK3EG287XSFC)
2. Click new to start a new journal entry.
3. Key in the Journal Entry Number. To auto-assign a number, click "#". You may only use numerical characters here.
4. Select the GL Date.
4. Key in a short description
5. Below the grid, select the "Import Journal Entry" button.
6. Browse to the template file you entered your Journal Entries into and click Open.
7. The file will import into the grid.
8. If any fields are invalid, they will show in red. Correct here or on the spreadsheet and re-import.
9. If the debits and credits do not balance, you will receive this message and fields will be highlighted in yellow:
10. Once any errors have been corrected and all lines are white, click Save.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yNTQzLzM5MjYvY2tmaW5kZXIvaW1hZ2VzL2ltcG9ydDkoMSkucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzQ2ODQ3OTAzfX19XX0_&Signature=HLuIGsAy0eiziN7MoozggftwvSnZzinqZY9YiRsiu-yGVyyyKEiidnHEq2FPEzZqHwnG8ppYRIfATfpGakdwXD04W~T2OXmYY0Xx4Cyrqje7Tdzw0KbdzDG6NChHFDjq51h~VWqI1WdVZRfEz8othm54CDIvHI27PWLIuiJ6Ff73aFMnTWXT50BfUPxXb9oicFhn8F14-bhGQRpN7WX~nE3S9acVLQzk1o7des09nWZOb083NINw-BNnVbYfJUEwqKKOyy1NZeWyp7amZHfqMGjVrAGGGOxwuod9-SxBKRaxpr6hnC8BoLtlhc6GRpWGtip6Sec~jzuCW87TJeAh5w__&Key-Pair-Id=K2TK3EG287XSFC)