General Ledger Reports

This report provides a month-by-month total of amounts journalized to each GL account for the specified fiscal year. For the current fiscal year, amounts for future months will be blank.

• From the Applications menu, select BackOffice Management > General Ledger > Reports > Fiscal Year Journal Summary.

  This displays the Run Report - Fiscal Year Journal Summary window.

  

• Enter the appropriate information.

  • Year: Drop down to select a specific Year for the Report. (Required field)

    Note

    The years for which General Ledger data is available should be displayed in the drop-down list.

  • Month: Drop down to select a specific Month of the selected Year for the Report. (Required field)

    Note

    All 12 months ‘January’ thru ‘December’ should be displayed in the drop-down list.

  • GL Subcategory Type: Drop down to select a specific GL Subcategory Type for the Report.

    Note

    ‘POS’ & ‘Billing’ should be displayed in the drop-down list.

  • GL Subcode: Use the drop-down list to select a specific GL Subcode for the Report

• Click OK to run the report.

  This displays the report viewer window.

  

This report provides a high level summary of assets & liabilities. It is based upon information posted to the general ledger accounts.

The report can be printed and consists of five sections:

• Accounts Receivable

• Balance Aging

• Accrued A/R

• Deposits

• Accounts Payable

  Each section provides high level details and comparisons to the previous month and previous year ago month.

• From the Applications menu, select BackOffice Management > General Ledger > Reports > Month End Summary – Assets & Liabilities.

  This displays the Run Report - Month End Summary – Assets & Liabilities dialog.

  

• Enter the appropriate information:

  • Year: Drop down to select a specific Year for the Report. (Required field)

    Note

    The years for which General Ledger data is available should be displayed in the drop-down list.

  • Month: Drop down to select a specific Month of the selected Year for the Report. (Required field)

    Note

    All 12 months ‘January’ thru ‘December’ should be displayed in the drop-down list.

  • GL Subcategory Type: Drop down to select a specific GL Subcategory Type for the Report.

    Note

    ‘POS’ & ‘Billing’ should be displayed in the drop-down list.

  • GL Subcode: Use the drop-down list to select a specific GL Subcode for the Report

• Click OK to run the report

  This displays the Summary of Assets and Liabilities report.

  

This report provides a high level summary of revenue, taxes and expenses, and is based upon information posted to the general ledger accounts.

The report is a printable and consists of three sections:

• Revenue

• Expenses

• Taxes

  Each section provides high level details and comparisons to the previous month and previous year ago month.

• To run, from the Application menu, select BackOffice Management > General Ledger > Reports > Month End Summary – Revenue, Expenses, & Taxes.

  

• Enter criteria, then run the report.

  T

This report displays the journal entries whose journal post date is within the specified month.

The report breaks out accruals/reverse journal entries for future months and provides a summary line at the bottom of the grid that totals the Debit column and the Credit column.

• From the Application menu, select BackOffice Management > General Ledger > Reports > Month End General Ledger Journal Entries.

  Verify that the Run Report - Month End GL Journal Entries dialog appears.

  

• Enter the necessary information and click OK. This displays the report viewer window.

  

• Click View Parameters to view the parameters.

  

See also:

Running the Month End GL Journal Entries Report

This grid report provides a list of all journal entries made for the specified criteria and could be used for data entry of raw journal entries into a third party accounting system and auditing the raw journal entries. This report provides a summary line at the bottom of the grid that totals the debit column and the credit column.

For a given post period, total debits should equal credits. This will not be the case if and when other optional report parameters are utilized. Drill down capability to show all the (perhaps millions of) micro transactions that contributed to the given journal entry.

• Go to BackOffice Management > General Ledger > Reports > General Ledger Journal Entries - Details.

  Verify that the Run Report - GL Journal Entries Detail dialog appear.

  (Show Picture)

  

  

• Enter the necessary information and click OK. This displays the report viewer window.

• Click View Parameters to view the parameters.

This report locates the source of a non balanced posted GL transaction.

• From the Application menu, select BackOffice Management > General Ledger > Reports > General Ledger Journal Entry Audit.

  

• Enter the appropriate search criteria and click OK. This displays the Report Viewer window with the search results.

  

This report provides a summary by the ‘transaction type’ of all micro transaction that met the specified criteria.

Drill down capability to show all the (perhaps millions of) micro transactions that contributed to the given summary record.

• From the Application menu, select BackOffice Management > General Ledger > Reports > General Ledger Micro Transactions Summary.

  Verify that the Run Report - GL Micro Transactions Summary dialog appears.

  

• Enter the appropriate search criteria and click OK. This displays the Report Viewer window with the search results.