This template allows you to import General Ledger journals.
Overview
Below is a template that can be used to import General Ledger Journals.
General Journal Template
Here is the template that can be used to import journal entries to your General Ledger. This will download an .xlsx spreadsheet that you can use.
Import General Ledger Journal
- Start at General Ledger > Tasks > Create General Ledger Journal.
- Enter the date, reference and description for this journal.
In the Import journal lines from spreadsheet section on the right of the screen:
- Browse for or drag your file to this box.
- Click Import journal lines.
- Then click Create Journal (at the foot of the screen).
| TIP: If you are adding journal lines manually, you can click New item to bring up the fields on the right of the screen, where you can add the details. |
Fields to Import
| GeneralLedgerAccount | The GL code |
| GeneralLedgerAccountantCode | The accountant GL code (optional) |
| Company | Company code |
| Branch | Branch code |
| Department | Department code |
| Currency | Currency code |
| Reference | Reference |
| Amount | Amount |
| Description | Description |
|