Page Comparison

Booking date

This is the date when the transaction will be posted in WorkBook.

Yes

Voucher number

Indicate how you want to assign the voucher number for the relevant transaction. There are 4 options:

• Automatic voucher number (New voucher number for each line): WorkBook will assign the next running number based on the system setup, each line will be assigned with a new number.

• New voucher number (same for all lines): WorkBook will assign the next running number based on the system setup, the same number will be used on all lines.

• Fixed voucher number (use provided default value): WorkBook will use the default number you set on this import specification.

• Voucher number from imported file: WorkBook will use the voucher number that have been provided in the uploaded excel/csv file.

Yes

Voucher date

This is the original date of the transaction.

Yes

Account entry type

Specify which type of account the entry comes under.

• F is for Finance

• D is for Debtor

• C is for Creditor

• H is for Holding account

Yes

Account number

This is corresponding to the option you provide in Account entry type above.

• If Finance type, this refers to GL account number

• If Debtor type, this refers to Debtor number

• If Creditor type, this refers to Creditor number

• If Holding account type, this refers to the holding account code that are set up in WorkBook.

Yes

Currency code

Specify the currency of the transaction. E.g. AUD, USD, SGD, etc.

Yes

Currency rate

This field allows specifying the exchange rate between the transactional currency and the company currency (base currency).

This is only required if your transaction is in foreign currency.

No

Currency amount

The amount of the transaction in foreign currency (bearing in mind whether it’s - or +).

This is only required if your transaction is in foreign currency.

No

Amount

The amount of the transaction (bearing in mind whether it’s - or +).

This always be the amount based on company currency (base currency). E.g. AUD

Yes

Offset account entry type

Only required if you’re off-setting account on the same line. Specify the offset account type:

• F is for Finance

• D is for Debtor

• C is for Creditor

• H is for Holding account

No

Offset account

This is corresponding to the option you provide in Offset Account entry type above.

• If Finance type, this refers to GL account number

• If Debtor type, this refers to Debtor number

• If Creditor type, this refers to Creditor number

• If Holding account type, this refers to the holding account code that are set up in WorkBook.

No

Activity GST

If required, this needs to match your Activity GST setup.

No

AR/AP GST

Depending on the type of transaction you are importing (e.g. sales invoice, supplier invoice), this allows you to specify the VAT/GST code that is applied to the transaction.

If required, this needs to match your AR/AP GST setup

No

GST amount

Enter your GST/VAT amount. This always be the amount based on company currency (base currency). E.g. AUD.

No

Comment

The description of your transaction

No

Invoice number

Enter the original number of your transaction. E.g. Receipt number, original invoice number, reference number, etc.

Currency GST amount

Enter your GST amount in foreign currency in corresponding to the currency selected above.

This is only required if your transaction is in foreign currency.

No

Due date

Specifying the due date of the transaction if you are importing invoices

No

Transaction type

Invoice
Credit note
Payment

No