Hello, I have a user that is looking to run a report, to provide the breakdown of transactions making up Undeposited funds "as of" a point in time, to tie with the Balance sheet. Does anyone know of a Suite Answer that can help me build this search/report? They are currently looking at the Nolan Bundle to help with this need, but they need something to get them through this Quarter End.

can you tell us what you mean by breakdown? do you mean exact items or buckets like Cash Sale vs Invoice?

Sure, this would be a list of each transaction, that is not deposited as of a specified date. Balance should tie with the Balance Sheet. Document Number, Amount, Customer, Date for example.

this isnt possible via Balance Sheet Detail?

No, that report will show all debits and credits.

been a while since i had to handle cash receipts...I'll go poke around in an account

Thanks!

so i just created a payment to Undeposited Funds and as expected it offsets AR and shows in the BS. I can also drill in and see the BS detail report and it shows all transactions that make up the balance. Bear in mind it contains the inputs and offsets for the period but one can surpise the open balance item by looking at it

Makes sense, however the issue becomes when you have hundreds of transactions that make up the detail (payments and deposits) and the user is looking for transactions that do not have a deposit "As of" the end of a period. Initially I tried a saved search, showing transactions of "Undeposited" status "as of" a date, but the results did not tie out to the account. At the end of the day I want the list of transactions with no deposits yet.

I'll keep thinking about this...i have another idea I'll try out