Create Accounts File

Owned by Mark Jason Brumpton
Last updated: Jun 05, 2017
3 min read

fig 1

fig 2

This window allows you to export recent invoices into a .csv file that can be imported into your chosen accounts package - this will be set up by Journease staff when you go live with Journease software

fig 1

This window allows you to export recent invoice runs (when an invoice is created in Finance/Sales Invoices ) The most recent run will show at the top of the list and will have the highest Batch Number

  1. Select the invoice runs that you want to export by selecting the first batch number that you wish to export then each subsequent batch number whether they are adjacent or not.
  2. Check the settings at the bottom of the screen in the Options section to make sure that a) the file path is correct for where you wish to store the exported file, and b) the file name is correct. The file number will increment automatically to the next available file number (this is added to the filename to differentiate between files that have been exported.
  3. Click on Create File to export the file. A message should pop up to say that the file has exported correctly, if there is a problem with the export then a warning message will pop up to say what is wrong. The most common cause of a failed export is that the file path is incorrect and Journease is unable to locate the folder.
  4. You can click on Clear sel at any time before creating the file to deselect all the highlighted invoice runs

fig 2

This window allows you to export recent supplier costs related to invoices. N.B. the supplier Must have a Cost Center associated with it before you can export

  1. Select the cost you wish to process by ticking the appropriate tickbox, to select multiple tickboxes put a tick in the Multi select mode tickbox and then select all required by selecting a) the row if, it is just one invoice run to process, b) the first row - hold shift key - select the last row, for multiple adjacent batches or c) the first row - hold ctrl - other rows, if there are multiple that are not adjacent. Once you have selected all the items you require click on Mark Inv to tick the process boxes or Unmark Inv to untick them (these options will only appear when multi select mode is active).
  2. check the settings at the bottom of the screen in the Options section to make sure that a) the file path is correct for where you wish to store the exported file, and b) the file name is correct. The file number will increment automatically to the next available file number (this is added to the filename to differentiate between files that have been exported.
  3. Click on Create File to export the file. A message should pop up to say that the file has exported correctly, if there is a problem with the export then a warning message will pop up to say what is wrong. The most common cause of a failed export is that the file path is incorrect and Journease is unable to locate the folder.
Once you have created your export files you can navigate to the folder that you set and the files should be listed there as .csv files, these can be opened for viewing using excel (or similar) however please note DO NOT make any changes after export as this will cause serious problems when importing the file into your chosen accounts package.