I'm trying to reconcile the deposits that OR thinks have come in over the last month with my bank statement. To aid this process, I would like to have a way of simply and easily generating an Excel file that contains each lump-sum amount and the date it went to the bank.
But so far the only way I've found of actually getting this data displayed this way is to go to the Deposits screen and filter by last month. Presto! Super easy, and exactly what I'm looking for! Only problem is, although Rezzy is convinced that there's an Export button on this screen, there actually isn't. So there's no way to get this data to Excel.
The only way to get the info into Excel is to export a Payment Details report, and then have Excel summarize by listing site and deposit date. I get there eventually, but it's a lot of extra work. The only deposit-oriented reports currently available in OR center more on tracking big-picture cashflows, not reconciling details. Hopefully upcoming changes to the PM platform and reporting are going to make it a lot easier to run the financial side of things.
