Skip to main content

CM-07 Daily Cash Transactions Detail Report

Purpose

The purpose of this Quick Reference Guide (QRG) is to explain how to navigate to and generate the Daily Cash Transactions Detail Report in the North Carolina Financial System (NCFS).

Introduction and Overview

This Quick Reference Guide covers the navigation to the Daily Cash Transactions Detail Report and how to generate the report output. The Daily Cash Transactions Detail Report provides the detailed transaction information related to all cash transactions posted to a specific cash account by Budget code. This report lists all deposits, disbursements (requisitions), and transfers that have posted to the North Carolina Financial System.

Navigating to the Daily Cash Transactions Detail Report

To navigate to the Daily Cash Transactions Detail Report, please follow the steps below. There are 4 steps to complete this process.

Step 1.    Click Expand in the Cash Management and Treasury Section.

Image

Step 2.    Scroll down and click Expand under the Daily Cash Transaction Detail Report.

Image

Step 3.    Click Open under the FBR Daily Cash Transaction Detail Report.

Image

Step 4.    Select the desired Agency, Budget Code Type, Posted Date From, and Posted Date To. Then click Apply.

Image

Daily Cash Transactions Detail Report Output

To navigate to the Daily Cash Transaction Detail Report output, please follow the steps below. There are 2 steps to complete this process.

Step 1.    In the bottom left-hand corner, click the Microsoft Excel Document.

Image

Step 2.    Review the Daily Cash Transactions Detail Report.

Image

Report Field Name   Report Field Description
Agency   This field displays the agency code assigned to the organization.
Agency Description   This field displays the Agency Name.
Budget Code   This field displays the agency budget code for the transaction displayed.
Budget Code Description   This field displays the budget code title.
Transaction Type   This field displays the transaction type (deposit, disbursement, transfer in, transfer out) entered when the transaction was created.
Journal Category   This field displays the category type of the journal entry. An example is DEP – ACH and PAY.
Budget Code Amount   This field displays the dollar amount of the transaction(s).
Posting Date   This field displays the date the transaction was processed.
Effective Date   This field displays the accounting date that is entered for the transaction.
Journal Source   This field displays the source the initial entry derives from (manual, spreadsheet, interface). 
Journal Batch Name   This field displays the journal batch name that was entered in the initial entry. The journal batch name can be copied and used to search for a specific transaction in the “Manage Journals” screen.

Wrap Up

The Daily Cash Transaction Detail Report lists all transactions affecting cash, by budget code, for a given posting date range. The Daily Cash Transaction Detail Report provides all posted transactional data by budget code and date ranges.

Additional Resources    

First Published

Last Updated