Importing General Ledger / Cashbook Batches

Guide on the import specifications, to import a Journal Batch or a Cashbook Batch

(Guide for Pastel Partner 14, but older versions will loosely follow the same method)

Attached at the bottom of the page is a template, which you can edit the relevant columns based on the requirements here.

Please note, you must save the file as a 'Comma Separated Value file' (CSV) before importing.

Ref.	Field	Type	Format	Excel Ref.
1	Period	Numeric	1-13	Column A
2	Date	Character	DD/MM/YYYY	Column B
3	GDC	Character	G=General Ledger, D=Customer, C=Supplier	Column C
4	Account Number	Character	7 characters, for example 7000000	Column D
5	Reference	Character	8 characters maximum	Column E
6	Description	Character	36 characters maximum	Column F
7	Amount	Numeric	12.2 maximum Negative=CR, Positive=DR	Column G
8	Tax Type	Numeric	0=No tax	Column H
9	Tax Amount	Numeric	12.2 maximum Negative=CR, Positive=DR	Column I
10	Open Item	Character	A=Allocation, O=Original Invoice For journal debits for customers, and journal credits for suppliers, this is set to "O". For journal entries of the opposite sign and cashbook items, this is set to "A".	Column J
11	Projects Code	Character	5 characters maximum	Column K
12	Contra Account	Character	7 characters, for example 7000000	Column L
13	Exchange Rate	Numeric	7.6 maximum	Column M
14	Bank Exchange Rate	Numeric	7.6 maximum	Column N
15	Batch ID	Numeric	1-99, how many times to repeat	Column O
16	Discount Tax Type	Numeric	0=No tax	Column P
17	Discount Amount	Numeric	12.2 maximum Negative=CR, Positive=DR	Column Q
18	Home Amount	Numeric	12.2 maximum Negative=CR, Positive=DR	Column R

Journal Batch

When the file is populated and ready to be imported, you can import by selecting the Batch button at the bottom of the Journal Batch.

Now select the Magnifying glass icon to browse for the CSV file on your computer.

Cashbook Batch

When the file is populated and ready to be imported, you can import by selecting the Batch button at the bottom of the Cashbook batch.

Now select the Magnifying glass icon to browse for the CSV file on your computer.