Before you can upload a journal you need to create a spreadsheet that has the required format in terms of columns to enable the routine to import your journal in to Pastel.
An example will have been installed in to your PaXcel folder named, journalimp.xls.
In this example we have first create an area that includes the column headers that we wish to capture and then import in to Pastel. The column header and data rows entered will form the Select part of the Select-n-Load operation.
The routine expects the column headers to match the pre-defined headings as shown below, but the order can be set by yourself. This means that as long as you use the correct headings, you can define the spreadsheet to match your input requirements.
Headings
Line |
the line number is not imported in to Pastel, but can be used to ensure all lines have been captured
|
Date |
the date of the transaction to import - if blank then you will be given a chance to set the post date before importing
|
Period |
Enter the period number to post to - if blank the import routine will set the period that matches the transaction date
|
Type |
Indicates the ledger the specified account belongs to this can be
G - General Ledger D - Debtors Ledger (Customers) C - Creditors Ledger (Suppliers)
|
Account |
The account number that you wish to post the transaction to
|
Reference |
The reference number for the transaction, this can be up to 8 characters in size
|
Description |
A description or narrative that should appear in the ledgers once the batch has been posted
|
Amount |
The value that you wish to post to the account + for Debit, - for credit. (Exclusive Amount)
|
Tax-Code |
Specify the tax/vat code that you wish to attach to the transaction
|
Cost Code |
Enter the cost code that the transaction should be attached to
|
Contra |
Enter the contra or balancing GL account that you wish to post the transaction to
|
Tax Amount |
Enter the Tax/VAT amount that is applicable to the transaction, if left zero and a tax code has been specified then the system will calculate the Tax based on the supplied tax code
|
Exchange Rate |
If the transaction is subject to an exchange rate then capture the value here
|
Bank Rate |
If the transaction is a cash book transaction and the cash book is in foreign currency then enter the bank rate to use here
|
Discount Tax |
If the transaction is a payment and requires a discount tax code to be assigned then capture that here
|
Discount Amount |
If a discount amount has been given or taken on the transaction then capture the value here
|
Home Amount |
If you the transaction is a foreign currency transaction and you require a different home value than the one the system will calculate enter the value here |