Skip to main content

Add GL Cashbook

Go to General Ledger Module > Activity > Cashbooks

image.png

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.

image.png

Your cashbook lines contain the actual data seen 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

image.png

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.


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

image.png

Search  
Import
Delete Template
Name
New Date and Reference Tick
New Date
New Reference
Swap Debit / Credit Tick
Keep Template Date Tick