Skip to main content

Debtors Journal Transactions Import

Print / Import function

This function allows you to print existing debtor/customer journal transactions and import new journals to the system.

Import clone refers to loading an existing debtor from the system. All you need to do is make changes as per current journal.

Debtors Module >Activity > Debtors Transactions > Print /Import

 

 Print option will take you to print the selected debtor's transaction.

 

 Import takes you to the option of bringing in data from a saved csv file

 

See the process of importing a debtor/ customer journal transaction into the system:

  1. Click Select
  2. Upload
  3. After, uploading the CSV file the import button will open allowing you to import the file into the system
  4. Once, complete click close

Important CSV File notes and format tips:

  • The file must be saved as a CSV
  • Don't put commas in your file
  • Fields for values mostly require codes of those fields
  • The date format must be 2020/01/01 YYYY/MM/DD
  • The column headings can be left in the import file.

See the file Layout for CSV file:

1

AccountCode

Required

2

Date

Required

3

Reference

Required

4

Description

Required

5

Amount Inc Vat

Required

6

ExchangeRate

Required (Default 1)

7

Action

Required

8

TaxType

 Enter the applicable VAT type

9

AutoAllocate

1/0

10

CheckZero

1/0

11

Division

 Enter the Division code (if applciable) 

12

Region

enetyr the Region code (if applciable) 

13

GL Account

Required


Import Clone

To import a cloned journal, one will need to create the clone form an existing journal transaction.

To create a journal clone go to:

Debtor module> Analysis> Debtors Transaction history

Search the required Journal

Click the Clone Journal button

Continue

image.png

image.png

This will create a clone that can be used anytime in the future

to import the cloned journal go to:

Debtors > Activity > Debtors Journal transactions

Click the Print / import Drop down

Select Import clone

image.png

Search the required clone

Click Import

image.png

This creates a clone of the initial journal.

You can then make any necessary edits and process the journal as normal

image.png