Add GL Cashbook

Go to General Ledger Module > Activity > Cashbooks 

 Click on the Search button to check for any open cashbooks 

 

 Creating a new cashbook, click on the Add button. 

 Select the bank account which is going to affect this batch. 

 

 

 

 Enter a Cashbook Name 

 As per your company preference 

 

 

 Enter Reference field 

 As per your company preference 

 

 

 

 Click on Save-to-save changes to your header batch details. These details filled in are only relevant to search and find the actual cashbook. 

 

 Your cashbook lines contain the actual data see n  on documents. 

 After saving one will notice the Insert, Amend and Delete buttons become available. 

 Click on the  Add button to, Add cashbook transaction line. 

 

 There are three ways to enter a line – General Ledger is the default. 

 

 

 

 General Ledger 

 This searches ledger accounts and affects the bank and ledger account selected. 

 

 

 Debtors 

 This searches customer accounts and affects the bank and the customer account selected. 

 

 

 Creditors 

 This searches supplier accounts and affects the bank and the supplier account selected. 

 

 

 

 Cashbook Type: General Ledger type selected 

 Select the date of the transaction that is per the bank statement date. 

 One will notice the reference is copied from your batch header, you can change it if you want. 

 (to increment reference put a tick on Increment Reference on the Batch header). 

 Select the account. 

 There are three ways to search for an account: 

 

 

 

 a. 

 Short Search 

 just type in part of the code or name and hit enter on the keyboard and select the account. 

 

 

 b. 

 Tree Search 

 Clicking on the square with three dots allows you to find the account via the Tree view. 

 

 

 c. 

 Long Search 

 Clicking on the Arrow button opens a new window where you can search on the code or name. 

 

 

 

 Select the entry type: 

 a. Payment / Credit 

 

 This is when one is paying money out of the bank account 

 Debit – Bank and Credit – Ledger account 

 

 b. Deposit / Debit 

 This is when one is depositing money into the bank account 

 Credit – Bank and Debit – Ledger account 

 

 

 

 Entry Amount 

 enter the amount including VAT that affects the bank. 

 

 

 Tax Account 

 you will notice that if one selects the Payment entry type the VAT control ledger account comes up with the Tax Type being 4 Cashbook VAT. If one selects the Deposit entry type the VAT control ledger comes up with No Tax, therefore not allocating to the VAT control account. 

 

 

 Description 

 Enter the name of the company you are paying or deposited from. 

 

 

 Additional Comments 

 Enter comments for later information needed. 

 

 

 Job 

 assign this cost to a Job 

 

 

 Projects 

 assign this cost to a Project 

 

 

 

 Click on Save and Close 

 OR Click on Save and New to enter another entry. 

 

 

 Allocate 

 

 

 

 

 Debtor Allocations 

   

 

 

 Creditor Allocations 

 

 

 

 Match Payments 

 

 

 

 Allocate Oldest 

 

 

 

 

 

   

 Template tab 

 Templates are good to use when one has the same transactions every month eg. Monthly debit orders or monthly salary payments. 

 There are two options 

 

 

 

 a. 

 Insert Template 

 

 

 b. 

 Save as Template 

 

 

 

 Insert Template 

 Once you have saved a template from a previously captured cashbook, you can insert this into the cashbook. 

 Save as Template 

 Allows you to save this cashbook lines as a template for further use. 

 

 

 Insert Template 

 

 

 

 

 Search 

   

 

 

 Import 

 

 

 

 Delete Template 

 

 

 

 Name 

 

 

 

 New Date and Reference Tick 

 

 

 

 New Date 

 

 

 

 New Reference 

 

 

 

 Swap Debit / Credit Tick 

 

 

 

 Keep Template Date Tick 

 

 

 

 

 

 

 Save As Template 

 

 

 

 

 Template Name