Cash Journal Templates

Please use these cash receipts templates to record your cash transactions. Please record each type of deposit on a different template and save your templates on your computer. Now that the new system is live, use these templates to connect to the system and upload your cash journal entries.

Please note that as of Monday, November 23, 2020 the posting of credit card (merchant account) deposits to the General Ledger are automated through Cash Management. The automated posting  of these deposits will relieve the units of the need to prepare Cash Receipts journals for credit card deposits. This new process will limit potential errors and ensure that deposits are recorded in a timelier manner. Any Cash Receipts journals for the credit card bank account submitted by a unit on or after Friday, November 20, 2020 will be auto rejected. Cash Receipts journals will be prepared by University Accounting staff for any credit card transactions that are not reflected in the automated posting process upon the Monday, November 23, 2020 implementation. As always, departments will be responsible to reconcile their merchant accounts and ensure that all transactions are recorded properly to the general ledger. To identify the automated transactions on an Account Analysis report, the journal source is “Cash Management."

All other deposits consisting of cash, checks and wires or other electronic deposits will still require Cash Receipts journals to record the deposits for now. The offices of the University Controller and University Treasury will work on automating these deposits as well in the near future.

Also if you have revenue related to Projects, please store them at this time on the template (in Col AA Line Desc Flex Field). Store the contract number project number and task number of your revenue account in this field. Double click on Col AA, which will connect you to the system, open a drop box and prompt you to enter project related information in the drop box.

We would strongly suggest that you view the GL020:Journal Entry Processing video that is posted on Canvas for further clarity on the Cash Journals Process and the Cash Receipts document [PDF] which details the process of Cash receipts entry via a spreadsheet when the credit is to a Project account (Post Go Live). A listing of Permanent Cash Journal Templates can be found in the Forms Repository. If you have any questions, please email