Skip to main content

Journal Import - G/L

Overview

This guide shows users how to import a General Ledger (GL) journal entry when adding a manual journal entry or reversing a manual journal. Users may be required to import and correct a journal entry, for full or half yearly review, or for auditing purposes. 

This guide is intended for commercial or finance team members.

Import Journal

  1. Go to Financials > General Ledger > General Ledger Home > Journals > Import Journals from PC file.
  2. Select Import Journals from PC file from the Journals menu in the General Ledger sub-module.
o8.png
  1. Fill in each field in the Journal Import from PC File window.
mceclip1.png

Journal reference

Currency Mode

  • For Auto, you need to provide columns J (Amount), S (Currency Amount) and T (Currency Rate).
  • For Manual FX Rate you need to provide columns J (Amount), S (Currency Amount) and T (Currency Rate), which will allow you to choose the rate and the rate will not be system generated.
  • For Single currency mode column J (Amount) is the amount and column S (Currency Amount) is the amount and column T (Currency Rate) is zero - this will post a single currency journal and not update the shadow ledgers.
  • For Manual Amount mode, update column J (Amount) and S (Currency Amount) only it will upload the amount only and ignore the rate.
  • For Manual BaseRate mode, update column J (Amount) and T (Currency Rate) only and this will calculate the currency rate multiplied by the amount.
  • Ensure column Q (Currency code) is always updated.

Post Period Date: The period date the journal is to be posted into (This cannot be a future date).

File & Location: Enter where the file can be located

Delimiter: Leave as comma (,)

Transfer Type: Enter PC (your computer) or HOST (the server)

  1. Press F1 or Go.jpg
  2. You will get a message indicating you were successful and showing the new batch number.
Import.png
  1. Press End.jpg or F4 to exit from the screen.
  2. Go to Financials > General Ledger > General Ledger Home > Journals > Journal Entry and Editing
  3. Open Journal Entry and Editing.
o9.png
  1. Select the batch process to post and press Enter. Another screen is displayed with batch details.
o10.png
Batch details screen
  1. Press Enter on any individual line to change

mceclip3.png

  1. When all details are correct, Select Choices.jpg or press F11.
  2. Scroll to option 3 "Post Journal Batch" and press Enter.
  3. You will be able to display the posting report or change delivery method.
mceclip4.png
  1. When posted you will be taken back to the list of all journals and your Journal has successfully been posted.

 

 

Was this article helpful?
0 out of 0 found this helpful

Copyright Notice

This document and the business processes it describes should be treated as COMMERCIAL-IN-CONFIDENCE.

This document is Copyright © 2022 Pulse Mining Systems Pty Ltd. Pulse software products, including this document, are copyrighted and all rights are reserved by Pulse Mining Systems. It may not, in whole or in part, be copied, photocopied, translated, or reproduced to any electronic medium or machine-readable form without prior consent, in writing, from Pulse Mining Systems. This document is designed for internal use of Pulse Mining Systems, and by Pulse clients. It may contain information which is commercially sensitive and/or confidential to Pulse Mining Systems and should be treated as ‘commercial-in-confidence’. All users of this document are reminded that, as part of their role, they are responsible for protecting and maintaining the confidentiality of all commercial- in-confidence material.

Return to top