Import a General Journal

Back Top Previous Next

You can import general journals from a generic spreadsheet.

 

gjspreadsheet

Example of a payroll general journal with the correct column headings in Excel

 

In Add/Edit mode, select the system script Spreadsheet, then click Import.

 

importjournal

 

When you click Import, the lower section of the popup screen will show the required columns and their heading names, then the following screen will pop up.

 

importgj

 

Here you can see which columns the spreadsheet can have, to assist you in matching your spreadsheet columns.

 

Click Load from file to see a preview of what will be imported.

 

loadfromfile1

 

Click Import and here is the resulting general journal.

 

importedgj

 

Further information

General Journal List

General Journal Header

General Journal Footer

General Journal Details Grid

General Journal Reports

Add a General Journal

Add a Payroll General Journal

Enter Payroll Tax

Create Similar or Recurring GJs

Delete/Reverse a General Journal

Edit a General Journal

Provision for Long Service Leave

Record Superannuation Salary Sacrifice