# Cash Book Transaction

##### <span style="color: rgb(0, 0, 0);">The **Cash Book** main function is to keep track of all the cash and bank transactions that occur daily. The GC can be found in the Finance tab under Cash book Section. A cash book transaction refers to the recording of all cash inflows (receipts) and outflows (payments) made by an organization. These transactions are entered and categorized as either receipts (e.g., cash sales, customer payments) or payments (e.g., cash purchases, payroll). It automates the process, ensuring real-time updates and accurate financial tracking through double-entry accounting. Cash book transactions are seamlessly integrated with other modules like Accounts Receivable and Payable, providing a comprehensive view of cash flow and facilitating tasks such as bank reconciliation and the generation of detailed financial reports.</span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/LgJimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/LgJimage.png)</span>

##### <span style="color: rgb(0, 0, 0);">After clicking the cash/bank book button, you will see the GC transactions, wherein you can add new transactions, search existing GC transactions, and edit them if needed.</span>

##### **<span style="color: rgb(0, 0, 0);">HOW TO ADD NEW GC TRANSACTIONS?</span>**

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/5r7image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/5r7image.png)</span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/tmzimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/tmzimage.png)</span>

1. <span style="color: rgb(0, 0, 0);">Click to select chosen bank</span>
2. <span style="color: rgb(0, 0, 0);">Click to select chosen currency</span>
3. <span style="color: rgb(0, 0, 0);">Click to add new details</span>
4. <span style="color: rgb(0, 0, 0);">Click to select new account</span>
5. <span style="color: rgb(0, 0, 0);">Click to “**check**” to save the new details</span>
6. <span style="color: rgb(0, 0, 0);">Click ‘’**save**’’ to save the transaction</span>
7. <span style="color: rgb(0, 0, 0);">Click “**exit**” to exit the transaction</span>

##### **<span style="color: rgb(0, 0, 0);">HOW TO CLONE GC TRANSACTIONS?</span>**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/lb4image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/lb4image.png)

1. <span style="color: rgb(0, 0, 0);">Click the "**clone**" button</span>
2. Select the date when to clone the GC transaction.
3. <span style="color: rgb(0, 0, 0);">Select the type of Recipient/Payee and Fill in the name</span>
4. <span style="color: rgb(0, 0, 0);">Verify the **bank**, **currency**, and **exchange rate**.</span>
5. <span style="color: rgb(0, 0, 0);">Once finalized, hit "**OK**".</span>

<span style="color: rgb(0, 0, 0);">After all these steps, you can see a new GC transaction with the same information.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/yuSimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/yuSimage.png)

##### **<span style="color: rgb(0, 0, 0);">HOW TO IMPORT GC TRANSACTION USING EXCEL?</span>**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/lqWimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/lqWimage.png)

1. <span style="color: rgb(0, 0, 0);">Click the "**Excel Template**" button to download the template in your local file.</span> [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/s9oimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/s9oimage.png)
    
    [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/zIWimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/zIWimage.png)
    
    [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/vOPimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/vOPimage.png)
    
    [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/oeximage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/oeximage.png)
    
    [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/6rIimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/6rIimage.png)
2. Fill in the necessary information in the template.

- - - <span style="color: rgb(0, 0, 0);">**Account** - Encode the account number for the line detail you need to add. The account number can be found in the Chart of Accounts.</span>
        - <span style="color: rgb(0, 0, 0);">**Debit/Credit amount** - Enter the amount choose one column only either debit or credit.</span>
        - <span style="color: rgb(0, 0, 0);">**GST Applicable** - Type **TRUE** if GST is **applicable**, **FALSE** if **not applicable**.</span>
        - <span style="color: rgb(0, 0, 0);">**GST Type** - Fill this in **only if** you choose **TRUE** in the **GST Applicable**. Codes for this can be found in the GST master. </span>
        - <span style="color: rgb(0, 0, 0);">**Detail Narration** - In this column you can type the detail narration for the specific transaction.</span>

<span style="color: rgb(0, 0, 0);"> 3. Click "**Load Excel**" to load the line details thru excel.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/s3uimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/s3uimage.png)

##### **<span style="color: rgb(0, 0, 0);">HOW TO ADD ATTACHMENT IN GC TRANSACTION?</span>**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/ukuimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/ukuimage.png)

1. Select the "**attachment**" tab.
2. Click "**Add Files**" [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/a3wimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/a3wimage.png)
    
     3. Fill in the attachment name and hit "**Start**". [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/saXimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/saXimage.png)
    
    Finally, the receipt attachment can be previewed.

<details id="bkmrk-cash-bank-contra"><summary>Cash Bank Contra</summary>

##### **<span style="color: rgb(0, 0, 0);">HOW TO CREATE CASH BANK CONTRA TRANSACTIONS?</span>**

##### <span style="color: rgb(0, 0, 0);">A **contra transaction** in the cash book of UNIQ365 refers to a transaction that involves the movement of money between two cash or bank accounts within the organization, without affecting the overall cash balance. For example, when cash is transferred from the petty cash account to the main cash account, or when funds are moved between different bank accounts, it is recorded as a contra transaction. These transactions are typically non-revenue or non-expense related but still need to be documented for accurate financial tracking. The ERP system records the debit and credit entries for both accounts, ensuring proper internal cash flow management and accurate accounting, while the overall cash position remains unchanged.</span>

##### <span style="color: rgb(0, 0, 0);">Go to **Finance&gt; Cash Book&gt; Cash book operations &gt; Cash Book Contra**</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/60oimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/60oimage.png)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/cVQimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/cVQimage.png)

1. <span style="color: rgb(0, 0, 0);">Click to select chosen bank</span>
2. <span style="color: rgb(0, 0, 0);">Click to select chosen currency</span>
3. <span style="color: rgb(0, 0, 0);">Click to add new details</span>
4. <span style="color: rgb(0, 0, 0);">Click the select new account</span>
5. <span style="color: rgb(0, 0, 0);">Click to “check” to save the new details</span>
6. <span style="color: rgb(0, 0, 0);">Click ‘’save’’ to save the transaction</span>
7. <span style="color: rgb(0, 0, 0);">Click “exit” to exit the transaction</span>


</details><details id="bkmrk-petty-cash-transacti"><summary>Petty Cash Transaction</summary>

##### **<span style="color: rgb(0, 0, 0);">HOW TO CREATE PETTY CASH TRANSACTIONS?</span>**

##### <span style="color: rgb(0, 0, 0);">**Petty Cash Transaction** involves recording small, day-to-day cash expenditures that are made for minor expenses, such as office supplies, employee reimbursements, or incidental costs. These transactions are typically managed through a dedicated petty cash account. When a petty cash transaction occurs, the ERP system records the expenditure, adjusting the petty cash balance and categorizing the expense under the appropriate account (e.g., office supplies, travel expenses). As petty cash is replenished, the ERP updates the balance and ensures proper documentation for reconciliation with the general ledger. This helps maintain accurate financial records for small cash outflows while ensuring control and accountability over the use of petty cash.</span>

##### <span style="color: rgb(0, 0, 0);">Go to **Finance&gt; Cash Book&gt; Petty Cash Transaction.**</span>

##### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/7Z3image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/7Z3image.png)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/DW7image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/DW7image.png)

1. <span style="color: rgb(0, 0, 0);">Click to select chosen bank</span>
2. <span style="color: rgb(0, 0, 0);">Click to select chosen currency</span>
3. <span style="color: rgb(0, 0, 0);">Click to add new details</span>
4. <span style="color: rgb(0, 0, 0);">Click the select new account</span>
5. <span style="color: rgb(0, 0, 0);">Click to “check” to save the new details</span>
6. <span style="color: rgb(0, 0, 0);">Click ‘’save’’ to save the transaction</span>
7. <span style="color: rgb(0, 0, 0);">Click “exit” to exit the transaction</span>

</details><details id="bkmrk-recurring-cash-bank-"><summary>Recurring Cash Bank Template</summary>

##### **<span style="color: rgb(0, 0, 0);">HOW TO CREATE RECURRING CASH BANK TEMPLATE?</span>**

##### <span style="color: rgb(0, 0, 0);">**Recurring Cash Bank Template** in a web ERP system is a feature that automates and manages repetitive cash or bank transactions that occur on a regular basis, such as monthly rent payments, loan installments, or subscription fees. The template allows users to set up these transactions once, specifying the frequency (e.g., weekly, monthly, quarterly) and the relevant amounts, accounts, and categories. The ERP system then automatically generates and records these transactions on the specified dates without manual intervention. This automation streamlines cash flow management, ensures timely payments or receipts, and reduces the risk of errors or missed entries, all while maintaining consistency and improving the accuracy of financial reporting. This can also be done with petty cash transactions. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/uNmimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/uNmimage.png)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/GU5image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/GU5image.png)

1. <span style="color: rgb(0, 0, 0);">Click to select chosen bank.</span>
2. <span style="color: rgb(0, 0, 0);">Click to select chosen currency.</span>
3. <span style="color: rgb(0, 0, 0);">Choose how frequent the transaction will reoccur.</span>
4. <span style="color: rgb(0, 0, 0);">Click "add new" to add line details.</span>
5. <span style="color: rgb(0, 0, 0);"> Select new account.</span>
6. <span style="color: rgb(0, 0, 0);">Click to “check” to save the new details.</span>
7. <span style="color: rgb(0, 0, 0);">Click ‘’save’’ to save the transaction.</span>
8. <span style="color: rgb(0, 0, 0);">Click “exit” to exit the transaction.</span>

</details><details id="bkmrk-post-recurring-cash-"><summary>Post Recurring Cash Bank Template</summary>

##### **<span style="color: rgb(0, 0, 0);">HOW TO POST RECURRING CASH BANK TEMPLATE?</span>**

##### <span style="color: rgb(0, 0, 0);">To **Post Recurring Cash Bank Template** in a web ERP system, you first set up a template for a transaction that occurs regularly, such as monthly rent or utility payments, by specifying details like the transaction amount, frequency, involved bank accounts, and associated categories. </span>

##### <span style="color: rgb(0, 0, 0);">Once the template is configured, the system automatically posts the transaction on the scheduled date, generating the necessary journal entries to debit and credit the relevant accounts, such as cash or bank and the expense accounts. This automation ensures timely, accurate recording of recurring transactions without the need for manual entry each time, streamlining cash flow management and maintaining consistent financial records.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/A0Ximage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/A0Ximage.png)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/uRrimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/uRrimage.png)

1. Select the frequency of the recurring transaction.
2. Select the category recurring.
3. Select Bank Account No.
4. Tick the recurring transaction that you want to post.
5. Click "Okay" once finalized.
6. Prompt will occur confirming the transaction to posted. Click ok to post [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/O1Nimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/O1Nimage.png)
    
    After posting the recurring GC transaction, it will be visible in the Cash Bank Book screen.

</details>