MKMS Help

General Ledger Detail

This Help File Page was last Modified on 03/04/2014

General Ledger Detail

This Help File Page was last Modified on 03/04/2014

Previous topic Next topic  

General Ledger Detail

This Help File Page was last Modified on 03/04/2014

Previous topic Next topic  
The General Ledger Listing with Detail report offers several options.
This report provides a detailed listing of the Transactions that were automatically created by the Accounts Receivable and Accounts Payable modules, as well as manual entries made through the General Journal.
The General Ledger Listing with Detail report may be produced for transactions that occurred for one day, up to one year, only for the most recent Fiscal Year that has not been Closed.
Illustrated below are the General Ledger Detail report's column headings:

HelpFilesGeneralLedgerDetailHeadings

General Ledger Detail - Column Header Names

 

Dept - The Department number assigned to the transaction.  Zero ("0") indicates the default Department.
Journal Source - The name of the transaction's source.
Year - The Year in which this transaction was created.
Period - The Fiscal year reporting period that this transaction was created.  This is particularly important for those Companies whose Fiscal Year does not end in December.
Month - The actual Month in which this transaction was created.
Journal - The abbreviation for the Journal's Source.
Debit - The amounts entered as a Debit.
Credit - The amounts entered as a Credit.
Detail - A succinct description of the transaction generally including the internal account number for the Subscriber or Vendor, their Name, and additional information pertaining to the transaction.
On the Main Menu, Select Reports and Choose the General Ledger sub-menu, then Click General Ledger Detail.

HelpFilesGeneralLedgerDetailInfoBox

Note that this General Ledger Detail Report is only available for the current Fiscal year

 

Click the OK button to view the Date Selection dialog.

 

General Ledger Listing with Detail report tabs - There are three tabs on the General Ledger Listing w/Detail report dialog.
Options - Initially only the Options tab is shown (until you make your Options selections and Select Print).
Date Selection - Specify the Date Range of the transactions that are to be included in the report:

HelpFilesGeneralLedgerDetailDialog

General Ledger Detail Report - Options tab

 

From: By default, the Starting Date will be the first day of the month immediately following the Last Closed Year.
oUse the Drop-Down Date Selection Box to Choose the desired Starting Date for this report.
To: By default, the Ending Date will be Today.
oUse the Drop-Down Date Selection Box to Choose the desired Ending Date for this report.
Account - Optionally, use the Drop-Down Selection List to Choose a specific General Ledger Account to be reported.
Exclude Balance Forward - Check this box to eliminate the Balance Forward Amounts for each account.
Print - Click the Print button HelpFilesPrintButton to Preview and optionally Print (to a File or a Printer) this General Ledger Listing w/Detail.

 

The Preview tab presents the report which resulted from the Options you've selected.
Up Arrow/Down Arrow - hi - Moves the report one line up, or one line line down, respectively.
Page Up/Page Down - Moves the report to the previous or next page, respectively.

HelpFilesGeneralLedgerListingDetailSample

General Ledger Listing with Detail - Preview tab

 

Arrows - The arrows allow you to move back and forth, from page to page.
Number - Indicates the page number you are viewing.
You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately.
If you enter an invalid page number, it will be ignored.
Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen.
Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view).
Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen.
Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage.

 

HelpFilesPercentageOfViewAdjuster

When you Click the Zoom To Percentage button, the Percentage selector will be displayed.
You may then Click the Up  or Down arrows to set the exact amount of Zoom you want.
Print - Click the Print button to Print (to a File or a Printer) HelpFilesPrintIconthe displayed General Ledger Listing w/Detail, and may also be converted to a PDF or various other types of documents, or into an Excel® Spreadsheet file.
Email - Click the Email button HelpFilesEmailButtonto send the Report to an Email Address of your choosing.
Exit the Preview tab by Clicking the Close button x on the right at the top of the Form.

 

Data View - This view provides a tabular (spreadsheet style) presentation of the selected data.

 

HelpFilesGeneralLedgerListingDataView

General Ledger Listing with Detail - Data View tab

 

Arrows - Click the arrows to move through the record.
Export - Exporting the data from this Data View tab (note the "fly-over" help available on these buttons):
Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format.
Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format.
Export To Html - Click the third button after the arrows to export the data to an HTML formatted file.
Exit the Data View tab by Clicking the Close button x on the right at the top of the Form.