Post a journal entry from a spreadsheet

    1.    Prompts for the file name of the spreadsheet journal entry to be posted

    2.    Copies the file (comma delimited format) into a work table

    3.    Validates that account numbers, etc, are correct

    4.    Displays an error report and terminates when errors are detected

    5.    Previews a posting report for your final review

    6.    Prompts whether to continue:   "Ready to post?"

    7.    Posts the spreadsheet data as a journal entry

A template spreadsheet file, that you may copy for preparing your journal entries, is located at  x:\Data\GeneralLedgerJournalEntryTemplate.xls, where 'x' is the network drive letter used for your Agate III installation.

Your spreadsheet must be saved in comma delimited format, i.e. one with a file suffix of ".csv".

You can press 'F2' from within the File Name field in the above prompt to display the following file chooser dialogue to browse and locate your comma delimited, spreadsheet file.