# CGL Analysis

# GL Account Analysis Menu

# GL Account Analysis

<span class="ts0">Analysis the General Ledger Accounts and the transactions posted.</span>

<span class="ts0">This is a way of analyzing and measuring the cost behaviour of the company.</span>

<span class="ts0">Go to <span style="color: rgb(45, 194, 107);">**General Ledger Module &gt; Analysis &gt; Account Analysis**</span></span>

<span class="ts0">Check that you are running the correct date range, change your date from and date to.</span>

<span class="ts0">search for</span><span class="ts0"> a specific </span><span class="ts0">account:</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/x4Simage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/x4Simage.png)

<span class="ts0">Click on Search button to view the details of the ledger account selected.</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/0fEimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/0fEimage.png)

<span class="ts0">This grid shows you the date of the transaction with Source Reference, line reference, description that was capture on the line of the transaction.</span>

<span class="ts0">View two columns namely Debit and Credit.</span>

<span class="ts0">Who processed the document with actual audit date and time.</span>

<span class="ts0">Buttons at the bottom of screen View – Opens up the window to view original document – cannot amend anything.</span>

<table border="1" id="bkmrk-print-prints-the-gri" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 19.1976%;"></col><col style="width: 80.926%;"></col></colgroup><tbody><tr><td>**<span class="ts0">Print</span>**</td><td><span class="ts0">Prints the grid that you are viewing.</span></td></tr><tr><td>**<span class="ts0">Export</span>**</td><td><span class="ts0">Exports the data into Excel.</span></td></tr><tr><td>**<span class="ts0">Related Transactions</span>**</td><td><span class="ts0">This shows the debit and credits that were done on the document, also gives you a T-Account View.</span></td></tr></tbody></table>

---

<span style="color: rgb(34, 34, 34); font-family: var(--font-heading, var(--font-body)); font-size: 1.4em; font-weight: 400;">Filters defined</span>

<span class="ts0">Basic Search Tab allows the user to search by selecting from the following:</span>

<table border="1" id="bkmrk-account-to-select-th" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 16.5666%;"></col><col style="width: 83.4334%;"></col></colgroup><tbody><tr><td>**<span class="ts0">Account</span>**</td><td><span class="ts0">to select the account</span></td></tr><tr><td>**<span class="ts0">Date From</span>**</td><td><span class="ts0">to select the date from which the analysis will run from</span></td></tr><tr><td>**<span class="ts0">Date To</span>**</td><td><span class="ts0">to select the date To, for limiting account analysis run</span></td></tr><tr><td>**<span class="ts0">Branch</span>**</td><td><span class="ts0">to select the branch from the drop-down arrow</span></td></tr><tr><td>**<span class="ts0">Order By</span>**</td><td><span class="ts0">to select order by, from the drop-down arrow</span></td></tr></tbody></table>

<span class="ts0">Once above fields are selected, after searching, there will be a Total Debit and a Total Credit for a selected account</span>

<span class="ts0">Filter Tab allows the user to search by selecting the filter type from the drop-down arrow and entering the filter value.</span>

---

##### <span style="color: rgb(34, 34, 34);">Buttons Defined</span>  


<table border="1" id="bkmrk-search-button-for-se" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 25.4939%;"></col><col style="width: 74.6297%;"></col></colgroup><tbody><tr><td>**<span class="ts0">Search button</span>**</td><td><span class="ts0">for searching after selecting filter type</span></td></tr><tr><td>**<span class="ts0">Clear Filter button</span>**</td><td><span class="ts0">to clear filter value field</span></td></tr><tr><td>**<span class="ts0">Main View Tab</span>**</td><td><span class="ts0">to view account analysis documents list</span></td></tr><tr><td>**<span class="ts0">View button</span>**</td><td><span class="ts0">to view a selected source document</span></td></tr><tr><td>**<span class="ts0">Print button</span>**</td><td><span class="ts0">to print account analysis transaction history</span></td></tr><tr><td>**<span class="ts0">Export button</span>**</td><td><span class="ts0">to export account analysis to excel spread sheet</span></td></tr><tr><td>**<span class="ts0">Related Transactions button</span>**</td><td><span class="ts0">to view related transactions</span></td></tr></tbody></table>

<div aria-label="Page Section Options" class="pointer-container" id="bkmrk--4" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--5" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--6" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--7" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--8" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--9" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--10" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk--11" refs="pointer@pointer" tabindex="-1"></div>---

<div aria-label="Page Section Options" class="pointer-container" id="bkmrk--14" refs="pointer@pointer" tabindex="-1"></div><div aria-label="Page Section Options" class="pointer-container" id="bkmrk-%C2%A0-2" refs="pointer@pointer" tabindex="-1"><div class="pointer flex-container-row items-center justify-space-between p-s anim is-page-editable"><div class="flex-container-row items-center gap-s" refs="pointer@mode-section"><button class="text-button icon px-xs" title="Permalink mode, Press to show include tag"><svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></button><div class="input-group"> <button class="button outline icon" title="Copy Link" type="button"><svg class="svg-icon" data-icon="copy" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></button></div></div><svg class="svg-icon" data-icon="edit" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></div></div>##### Export button  
  


Click on Print Grid or Export button to Print Transaction History

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/M7oimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/M7oimage.png)

# Detail Of T-Accounts Menu

# Detail of T-Accounts

<span class="ts15">View accounts in a T-account view with Debits on the left and Credits on the right</span>

<span style="color: rgb(45, 194, 107);">**<span class="ts15">General Ledger&gt;</span><span class="ts15">Analysis</span><span class="ts15">&gt;</span><span class="ts15">Detail of T-Accounts</span>**</span>

<span class="ts23"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1222).png)

<span class="ts0">T-account contains detailed elements of the account</span>

<span class="ts0">Search button allows the user to search by selecting the financial year and financial period from the drop down arrow and to select account as well</span>

<span class="ts0">The stem of the 'T' is divided into two columns. The name given to the left column is: Debit and the name given to a right column is: Credit.</span>

<span class="ts0">Each line below the 'T' in a 'T' account is called an 'entry'.</span>

<span class="ts0">An 'entry' includes either a Debit Amount or a Credit Amount. Often additional columns are also used to log the date of the 'entry' and some details about it.</span>

# GL Journal History Menu

# GL Journal History

<span class="ts15"><span class="ts0">The record of all the journal entries in the General ledger will be found under journal history</span></span>

<span style="color: rgb(45, 194, 107);">**<span class="ts15">General Ledger&gt;Analysis&gt;Journal History</span>**</span>

<span class="ts0">These can be viewed, printed and saved as a template if needed.</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2785).png)

# Cash Book History Menu

# Cash Book History

<span class="ts15"><span class="ts0">The record of all the Cashbook entries in the General ledger will be found under Cashbook history</span></span>

<span style="color: rgb(45, 194, 107);">**<span class="ts15">General Ledger&gt;Analysis&gt;</span><span class="ts15">Cash Book</span><span class="ts15"> History</span>**</span>

<span class="ts0">These can be viewed , printed and saved as a template if needed.</span>

<span class="ts15"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2786).png)

# Bank Recon History Menu

# Bank Reconciliation History

<span class="ts15"><span class="ts0">This is a reconciled financial statement which is owned by both the business itself and the bank statement</span></span>

<span style="color: rgb(45, 194, 107);">**<span class="ts15">General Ledger&gt;Analysis&gt;</span><span class="ts15">Bank Recon</span><span class="ts15"> History</span>**</span>

<span class="ts23"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(1225).png)

##### <span class="ts0">Basic Search</span>

<span class="ts0">Bank Account – to search a bank recon by selecting bank account from the drop down arrow</span>

<span class="ts0">Order By – to search a bank recon by sorting the order</span>

<span class="ts0">Date From – to search bank recons by date, select the date from and the date to</span>

<span class="ts0">Print button – to print the selected bank reconciliation</span>

<span class="ts0">View – to view the selected bank reconciliation</span>

---

#### <span class="ts0">Attach Bank Statements</span>

<span class="ts2">Attach bank statements to Bank Recon History</span>

<span class="ts0">Yes, one can attach past bank statements to bank recons.</span>

<span class="ts0">Go to Bank Recon History</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2615).png)

# WIP Journal Menu

# WIP Journal History

WIP journals show automatic correction journals

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/scaled-1680-/v4Jimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/v4Jimage.png)

Search for all WIP journals

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/scaled-1680-/c2Wimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/c2Wimage.png)

# GL Document History Menu

# GL Document History

When accessing the document history in General Ledger module, this will filter by General Ledger documents

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/scaled-1680-/mM0image.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/mM0image.png)

---

##### Document Management Search

Filter and search by General Ledger Module category

Add Bank Statements, Tax Reports, journals to this document management

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/scaled-1680-/LsRimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-11/LsRimage.png)