Dynamic vs. Static reporting in Tess (and general frustration with data integrity and lack of deferred revenue solutions)

Hi - we download  End of Day transaction reports to get our daily sales into the General Ledger (currently using Financial Edge NXT, but prob soon moving to Netsuite.  There seem to always be exceptions on a daily basis of what has hit the credit card processor (windcave) and what has hit Tess, so there is a lot of reconciliation happening on a daily basis and differences being put into a 'short and over' account until the differences clear.  This creates a very manual, high touch process rather than just a simple download and upload and month end reconciliation.  Is recording cash receipts this manual for others?  

Our end of day reports are of course static and feed into the financials, but all other reports in Tess are dynamic and constantly changing and don't agree to the financials which are at a point in time.  You can run 10 different reports and they are all different.  How do others handle this?

Also, has anyone cracked the code of using Tess to account for deferred revenue?  We don't only have ticket sales but also classes with multiple sessions that straddle fiscal years so we have to divide those classes between fiscal years.  Currently it is a manual process and wondering if anyone has figured out anything useful in this regard.

Also, as mentioned will be moving to Netsuite so wondering if anyone out there has any experience with the system, positive or negative, thx!