General Ledger Submodule

​

Overview

The Accounting → General Ledger submodule provides comprehensive tools for managing the chart of accounts, processing journal entries, and generating financial statements within DASH. The system serves as the central repository for all financial transactions and supports detailed financial analysis and reporting. This submodule is used by accounting personnel, finance managers, controllers, and auditors who need to process journal entries, prepare financial statements, analyze departmental performance, and maintain accurate general ledger records for financial reporting and compliance purposes. The General Ledger submodule provides several tabs for managing GL operations:

• Journal Entry: Record manual journal entries with supporting documentation.
• Ledger Transactions: Review and analyze all general ledger transactions.
• Trial Balance: Generate trial balances to verify account balances.
• Profit/Loss: Produce detailed profit and loss statements.
• Balance Sheet: Generate balance sheet reports.
• Department Breakdown: Analyze financial performance by department.
• eCommerce P/L: Specialized profit and loss reporting for eCommerce operations.
• General Ledger Detail Report: Detailed transaction-level reporting.

​

Journal Entry

The Journal Entry (JE) tab allows you to record manual adjusting entries and other transactions not automatically generated by the system. This process is useful for: Recording month-end accruals, adjusting entries, reclassifications, and other manual accounting entries that require supporting documentation.

​

Creating Journal Entries

1. Click the Journal Entry tab.
2. Set enter the Parameters for the JE:
   • Journal Entry Date: Select the date for the journal entry.
   • JE Category: Choose the appropriate journal entry category for classification.
   • Create Reversal (next month): Check this option if the entry should automatically reverse in the following month.
3. Enter line details in the grid. After choosing a GL Code, the Comment field suggests comments entered manually on journal entries for that account within the past 18 months (system-generated comments are not suggested). Select a suggestion or keep typing to enter a new comment.

4. If importing in bulk, click Template File to download the journal entry template, then use + Upload to import completed entries. 5. Upload supporting documents to the JE.

• Click + Upload Documents under “Files” to open a file browser and select the document you want to attach.
• Click Start upload to begin uploading.
• Click Cancel upload if you need to cancel the upload.

6. Click Save to save the JE or Clear to reset the form and start over.

​

Ledger Transactions

The Ledger Transactions tab provides a comprehensive view of all general ledger activity, including both automatic postings from other modules and manual journal entries. This view is useful for: Auditing account activity, researching transaction details, and verifying the accuracy of account balances.

​

Trial Balance

The Trial Balance tab shows the period ending balance for all accounts and displays profits for the year. Use the Filter button to set the reporting period and adjust how accounts are displayed:

• Show Child Accounts: When set to No (the default), each parent account’s balance is rolled up to include its child accounts. When set to Yes, child accounts are listed on their own rows, and the parent rows of accounts that have children are hidden for that period so their balances are not double-counted in the totals. Accounts without children are always shown. Parenthood is evaluated per period, so an account that only gained child accounts in a later period still shows its own balance in earlier periods.
• Show Differences Only: Nets each account’s debits and credits into a single balance column.
• Show Trend: Adds a month-by-month breakdown for the year, optionally split into separate debit and credit columns.

This report is useful for: Month-end closing procedures, financial statement preparation, and ensuring the general ledger is in balance before generating financial statements.

​

Parent/Child Reconciliation

The Parent/Child Reconciliation tab lists parent accounts whose activity does not equal the combined activity of their child accounts for a given period. When every parent reconciles, the report is empty. For each period in the selected range, the report shows the parent account’s own activity, the summed activity of its child accounts, and the difference between them. Open periods use the current running balance; closed periods use the period’s net change. Only parent accounts that do not reconcile are listed.

​

Generate the report

1. Click the Parent/Child Reconciliation tab. The report defaults to the current period.
2. To review other periods, set the Date Range (or use the Current Period, quarter, YTD, or Closed YTD shortcuts) and click Run.
3. Any parent account whose activity does not match its children appears with the difference highlighted. Click an account number to open its account details.

This report is useful for: Verifying that parent (roll-up) accounts stay in sync with their child accounts, and catching posting errors before running the Trial Balance or financial statements.

​

Profit / Loss

The Profit / Loss tab generates comprehensive income statements showing revenues, expenses, and net income. This report is useful for: Monthly financial reporting, performance analysis, budget variance analysis, and management reporting.

​

Balance Sheet

The Balance Sheet tab generates statements of financial position showing assets, liabilities, and equity. This report is useful for: Financial statement preparation, loan applications, investor reporting, and compliance with accounting standards.

​

Department Breakdown

The Department Breakdown tab provides detailed financial analysis by department or cost center. This report is useful for: Departmental performance analysis, cost center management, budget variance analysis, and operational decision-making.

​

Generate the report

1. Click the Department Breakdown tab.
2. You will get the following pop-up window:
3. Set the desired report parameters:
   • Department(s): Select specific departments or all departments.
   • Dates: Set the reporting period.
   • Rounding: Choose rounding precision for amounts.
   • Report Type: Choose a report type (Full, Period Only, YTD Only, Trend, Trend - Grouped).
   • Show Budget (Yes/No): Include budget comparisons
   • Show Variances (Yes/No): Display budget vs. actual variances
   • Show Var. Percents (Yes/No): Show variance percentages
   • Show % to Sales (Yes/No): Display percentages relative to sales
   • Show Total Year (Yes/No): Include full year projections
   • Show Previous Year (Yes/No): Add prior year comparisons
   • Show All Categories (Yes/No): Include all account categories
   • Group all Departments (Yes/No): Consolidate department data
4. Click Run to generate the department breakdown report.

​

eCommerce P/L

The eCommerce P/L tab specialized profit and loss reporting tailored for eCommerce operations and online sales channels. This report is useful for: eCommerce channel analysis, online sales performance evaluation, and digital marketing ROI assessment.

​

General Ledger Detail Report

The General Ledger Detail Report tab provides transaction-level detail for specific accounts or account ranges. This report is useful for: Account reconciliation, audit support, transaction research, and detailed financial analysis.

​

Generating Detail Reports

1. Click the General Ledger Detail Report tab.
2. Click Filter to access report parameters.
3. Set the desired report filters:
   • Date Range: Select the period for transaction detail.
   • GL Account Filter: Choose between Single account or Range of accounts.
   • GL Account (Required): Specify the account(s) to include in the report.
4. Click Run to generate the detailed transaction report.