Cash Disbursement Journals

Viviana Yang

One of the basic requests from our Auditor is the Cash Disbursement Report for our audit. When I pulled the “Cash Disbursement Journal” within FE, I noticed that it's only including Checks and Bank Draft transactions. However, all Cash Management Payment Adjustments are being excluded. Unfortunately, we do use Cash Management Payment Adjustments for some expenses. And needs these transactions to be in a Cash Disbursement Report. Anyone has had this issue and what is your fix? I've tried to export the Bank Register Report, but the financial data is massive, and having to filter and sort data of that quantity feels like I'm leaving room for error to occur. Also, a Cash Disbursement Report should capture all expenses, and the fact that FE's Cash Disbursement Journal doesn't and BB is unwilling to add this required improvement to the report is frustrating to me.

Beckie Osterman

I pull this report for our auditors by going into NXT> Register> filter the transaction status for all selections by last fiscal year, then check the boxes for Computer check, Manual check, one time check, EFT, Bank Draft & adjustment payment. You should then be able to export to Excel.

If that file is to large, I would create separate tabs for each method of payment. IE EFT tab, Bank Draft Tab, Adjustment Payment tab.

You could also create a query in database view to pull this information.

Good luck!