Cash Disbursement Report - NEED 2-27-17 for Audit

(0) Share

Report

Posted on by Community Member

We have only been using NAV 2016 for a few weeks and are starting our audit. How do I run a cash disbursement report with date filter? I need to be able to pull a reports of all checks, ACH and wire payments (all payment made) during a time period. I tried the bank account register but it includes deposits and there does not appear to be a way to filter so only withdrawals are shown. I also tried the bank ledger entries but it does not show the payee name. Anyone with help is much appreciated! They are starting the audit work today.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report

RE: Cash Disbursement Report - NEED 2-27-17 for Audit

Thanks! I assumed there would be a canned report so I didn't ask for this report to be created originally. I will go back to our partner to see how much they will charge us to get this report created.

Was this reply helpful? Yes No
Verified answer

Maneesha 5,891 on at

Like (1)

Report

RE: Cash Disbursement Report - NEED 2-27-17 for Audit

Dear Sdb1011 ,

actually yes there are no option to make that report as per the audit requirement (i also face this) problem is every data cannot be capture by one exact report

best thing is to create custom report for our own requirement

If don't have development license just contact your partner and ask them to develop the custom report

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

RE: Cash Disbursement Report - NEED 2-27-17 for Audit

Aa Alexander suggestee you need to work on manual reporting

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Cash Disbursement Report - NEED 2-27-17 for Audit

You can try to work directly with data transactions from General Ledger. Go to Chart of Accounts, drill down to needed bank account Balance field and set needed filters: date, amount (negative), and some others you might find useful to set. Source No. field should show you the payee. You can export this data to Excel and apply additional filters.

Was this reply helpful? Yes No