You may export unposted batch transactions in a selected batch and save it in a spreadsheet "Excel Workbook (*.xlsx) file type.  

You may then import it into a batch, when required. 

To export batch transactions from a Excel Workbook (xlsx) file: 

  1. On the Default ribbon, select Batch entry (F2). 
  2. Select an unposted batch, and click Open. 

 

  1. Click on the Spreadsheet import icon. 
  2. The "Data Import Export" be launched without any data.

  1. On the "Data Import Export" screen, click Export. All the transactions (excluding the balancing transactions, if the batch is already balanced) in the unposted batch will be imported  the "Data Import Export" screen.  

 

If the Batch includes balancing transactions, these will not be included in the "Data Import Export" screen.
  1. Click on Save as... to save the imported transactions to an Excel Workbook.

 

  1. Select the folder and enter a name for the file.
  2. Click on the Save button. 
  3. Click on the Close icon in the titlebar of the "Data Import Export" screen. 

The data of the imported accounts is imported (populated) in the following eleven (11) columns in the spreadsheet and is as follows:  


Field name

Values

Comments


A

SREFERENCE

Alpha-numeric

Reference entered


B

SACCOUNT

Account code - Prefixed by:

G = Ledger account

D = Debtor account

C = Creditor account

B = Bank account 

Selected account - Account lookup


C

SDESCRIPTION

Description

Description entered for the transaction


D

FAMOUNT

Amount

Amount entered - Exclusive of Tax 


E

STAX

Tax account code (should be pre-fixed by T)

Selected tax account - Tax lookup


F

DDATE

Date

Date of the transaction 


G

SCONTRAACCOUNT

Account code - Prefixed by:

G = Ledger account

D = Debtor account

C = Creditor account

B = Bank account 

Account code selected / set in F10:Setup (for balancing entries)


H

BEXCLUSIVE

0 = Inclusive

1 = Exclusive

Tax Amount entered Inclusive of Tax or Exclusive of Tax


I

SJOBCODE

Project code 

Projects (if activated and selected)


J

SCOSTGROUP1

Cost centre 1 name

Cost centre 1 group (if activated and selected) 


K

SCOSTGROUP2

 Cost centre 2 name

Cost centre 2 group (if activated and selected)