Manual Journals Import

Owned by Former user (Deleted)
May 21, 2014
3 min read

The Manual Journals Import is used for the following Workbench batch types:

  • Labour Journal
  • Adjustment Journal
  • Plant Issue
  • Stock Issue
  • Stock Return
  • Docket Accrual


Import to Xero










Labour Journal


Xero Field

Workbench Field

Narration :

"Labour journal"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)




Tracking for recovery lines, same as job being costed

Adjustment Journal


Xero Field

Workbench Field

Narration :

"Job Adjustment Dr"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)




Plant Issue


Xero Field

Workbench Field

Narration :

"Plant Issue"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)



Tracking for recovery lines, same as job being costed

Stock Issue


Xero Field

Workbench Field

Narration :

"Stock Issue"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)




Tracking for stock entry, same as job being costed

Stock Return

Xero Field

Workbench Field

Narration :

"Stock Return"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)




Tracking for stock entry, same as job being costed

Docket Accrual


Xero Field

Workbench Field

Narration :

"Docket"

Date :

Batch Date

Description :

Batch No + Batch Reference

Account :

GL Account from activity code selected (refer to section on setup)

Tax Rate :

GST Type Description (refer to section on setup)

Location :

Example for Tracking Option 1 (refer to section on setup)

Division :

Example for Tracking Option 2 (refer to section on setup)




There is no tracking for docket accrual line.