General Ledger acts as a master document for all the financial transactions of the business.
A general ledger, also known as a nominal ledger, is a bookkeeping ledger that serves as a central repository for accounting data transferred from all sub ledgers like accounts payable, accounts receivable, cash management, fixed assets, purchasing and projects.
A company’s general ledger is the basis of its financial reporting and the source of the information used therein. In Accoxi, General ledger is a means for keeping record of a company's total financial accounts. Accounts typically recorded in a general ledger include: assets, liabilities, equity, expenses, and income or revenue.
Key features;
Click on Accounts module and select the option General Ledger
After clicking on the General Ledger, it opens to the form with Trial balance
It shows the Trial balance details of the current financial year and we can use the keyboard throughout the General Ledger form.
Fields |
Description |
Particulars |
This column list all business transactions made during the set period of time, including revenue, liabilities and assets |
Debit |
Amount of assets and expense accounts appear on this column |
Credit |
Amount of liabilities, capital and income accounts appear on this column |
Modify |
Use the right arrow key on the keyboard to open the Modify menu option. While we open the modify option, it includes Detailed view, Period, Group search, Ledger wise view and Export. |
Up |
Use the Up arrow key for on keyboard to upward move |
Down |
Use the down arrow key to move downward move |
Enter |
Use the Enter key to enable drill down option or to open inner forms. |
Esc |
Use the Esc (Escape) key to exit from the current page |
When the user clicks on right arrow key, it opens to more options and it includes detailed view, Period, Group Search, Ledger wise view and Export.
1. Detailed view
When the user click on General ledger form, it shows the details of the trial balance and while click on the modify key, it opens the detailed accounting vouchers list of each and every accounting group in trial balance. In detailed view of account group page, there is an option of Condensed view in modify (right arrow key) to redirect to previous page.
2. Period
Period is the second option in modify menu. It is the option to enter a particular date of period to access the trial balance details of that particular period. By clicking on the period option, new tab will appear on the screen and user need to enter the starting date along with end date to access the data and the details will appear on the basis of the date entered.
3. Group Search
In group search, user can search or can select particular account group and can access the details of ledger from that group. While click on the group search, a new tab will appear with complete list of account groups and if user select any one of the group, it opens to the details of that particular account group and user can access the complete ledger details with monthly transactions under the selected group by clicking enter key.
4. Ledger wise view
Ledger wise view in modify option, enable the user to access complete list of ledger accounts and user can access the monthly detailed information of every ledger account from there. While click on the ledger account, it opens to monthly transaction details, shows debit balance, credit balance, opening and closing balances and also shows bar graph of debit and credit balance of the particular ledger account.
5. Export
User can export the group summary details into excel format by clicking on the export option. A save as window will appear and user can select the save location of the exported data.
For example, if the user select Sales account group from trial balance, it opens to group summary of sales account
Field |
Description |
# |
The serial number of data available in the table shows in here |
Particulars |
Shows the particulars under a ledger |
Closing balance: debit/credit |
The closing debit/credit balance of each ledger shows in this section |
1. Period:
Period is the first option in modify menu. It is the option to enter a particular date of period to access the group summary details of that particular period. By clicking on the period option, new tab will appear on the screen and user need to enter the starting date along with end date to access the data and the details will appear on the basis of the date entered.
2. Group Search:
In group search, user can search or can select particular account group and can access the details of ledger from that group. While click on the group search, a new tab will appear with complete list of account groups and if user select any one of the group, it opens to the details of that particular account group and user can access the complete ledger details with monthly transactions under the selected group by clicking enter key.
3. Export:
User can export the group summary details into excel format by clicking on the export option. A save as window will appear and user can select the save location of the exported data.
Ledger monthly summary: Sales Account.
In this page of general ledger user can view the monthly summary of transactions made in a particular ledger.
User can view the transactions debit and credit balances as well as closing balance for each month.
There is also a graphical representation of data is available. In the bar diagram user can view the debit/credit balances of each month.
Data available in ledger monthly summary:
Field |
Description |
# |
The serial number of data available in the table shows in here |
Month |
Shows the ledger month wise data |
Transactions: debit/credit |
The debit/credit balance of each month shows in this section |
Closing balance |
The closing balance of each month is shown in this column |
When the user clicks on right arrow key, it opens to more options and it includes quarterly, period, ledger search, and export
1. Quarterly:
By clicking on quarterly option user can view the quarterly wise data of the particular ledger. User can switch back to monthly wise view if wanted from the modify option
2. Period
Period is the second option in modify menu. It is the option to enter a particular date of period to access monthly summary details of that particular period. By clicking on the period option, new tab will appear on the screen and user need to enter the starting date along with end date to access the data and the details will appear on the basis of the date entered.
3. Ledger Search
In ledger search, user can search or can select particular ledger and can access the details of ledger. When the user clicks on the group search, a new tab will appear with complete list of ledgers and if user select any one of the ledger, it opens to the details of that particular ledger and user can access the complete ledger details with monthly transactions.
4. Export:
User can export the ledger monthly summary details into excel format by clicking on the export option. A save as window will appear and user can select the save location of the exported data.
In the ledger voucher view user can access all the date wise vouchers from the particular selected month.
All the transaction details made in one particular month is shown her with its date, amount, current total and closing balance.
Data available in ledger vouchers:
Field |
Description |
# |
The serial number of data available in the table shows in here |
Date |
Shows the date of the particular voucher entered in that particular month |
Particulars |
The particulars details of that certain voucher shows here |
Voucher no |
The voucher number of the transaction shows here |
Voucher type |
The voucher type of the transaction shows here |
Debit/credit |
The debit/credit amount of the transaction shows in this column |
When the user clicks on right arrow key, it opens to more options and it includes quarterly, period, ledger search, and export
1. Daily breakup :
The daily breakup of the ledger can be shown with this option. All the transactions entered in each day can be viewed with this option.
2. Export:
User can export the ledger voucher details into excel format by clicking on the export option. A save as window will appear and user can select the save location of the exported data.
User can access to the view option of each transaction by clicking enter key against it. It will directs the user to view window.
And from that window user can edit, print and export the invoice/voucher/transaction.
Yes the general ledger form is fully keyboard enabled and user can access the general ledger data using keyboard only.
A company’s general ledger is the basis of its financial reporting and the source of the information used therein. In Accoxi, General ledger is a means for keeping record of a company's total financial accounts. Accounts typically recorded in a general ledger include: assets, liabilities, equity, expenses, and income or revenue.
Yes user can access the monthly summary details from the general ledger by clicking on the ledger account and user can also switch to quarterly wise details.
Yes user can export the trial balance general ledger data by clicking on modify option and by selecting export option
Yes user can view ledger wise view of trail balance by clicking on modify option and by selecting ledger wise view option