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

 

How to

Add a General Journal

Add a Payroll General Journal

Create Similar or Recurring General Journals

Delete/Reverse a General Journal

Edit a General Journal

Enter Payroll Tax