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.
- Then select the option to 'Import'.
- 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.
- Then select the option to 'Import'.
- Now select the Magnifying glass icon to browse for the CSV file on your computer.
Related Articles
How to add a new Bank Account
Guidance on how to create new bank accounts, ready for cashbook processing. (Guide for Pastel Partner 14, but older versions will loosely follow the same method). You will first need to create the bank account as a General Ledger account. Part 1): Go ...When viewing a report, you get the message: Your System Has Unallocated Financial Categories
(Guide for Pastel Partner 14, but older versions will loosely follow the same method). When you view certain reports ( like the Balance Sheet ) you may get this message if any of your General Ledger accounts do not have a financial category ...Starting a new company using existing accounts
Pastel Partner - Creating a new company, but using your existing accounts and set up (Guide for Pastel Partner 14, but older versions will loosely follow the same method) If you are going to be managing another companies accounts and you want to ...How to do a stock take
Guidance on the Inventory Count / Stock Take procedure. (Guide for Pastel Partner 14, but older versions will loosely follow the same method). The inventory count is a process where you would do a physical stock count and compare them to the quantity ...Discrepancies between Inventory Control Account and Inventory Valuation
Discrepancies between Inventory Control Account and Inventory Valuation Differences between the Inventory Control Account and the Inventory Valuation Report will be the result of the following: Inventory being integrated into the General Ledger. ...