Matching GL Summary Report to GL Account in Analytics

Hi everyone!  I think I'm missing something silly here, but I can't seem to get my GL amounts in Analytics to match up to what I have in my GL Summary Report. I've matched every parameter on the report to the widget that I'm working in, but I'm off by about $38k, and I can't figure out why.  What am I missing here?  Does anyone else have this built out in Analytics (aka can I see how you did it?).  

EDIT: I'm matching this up with sales from yesterday, so dates are good there. (I just double checked that these numbers are still off).

Here is what I have in Analytics so far:

What I have on my GL Summary Report: 

Parents
  • Hi Jordan,

    A couple of things come to mind.  Analytics is not live data, are you comparing both to the same exact time period?  The second thought is I don't see Fiscal Year in your analytics report but you have it as a criteria in your GL Summary Report.  Could it be a fiscal year other than 2020 data is showing up in your Analytics pivot which is not in your GL Summary?

Reply
  • Hi Jordan,

    A couple of things come to mind.  Analytics is not live data, are you comparing both to the same exact time period?  The second thought is I don't see Fiscal Year in your analytics report but you have it as a criteria in your GL Summary Report.  Could it be a fiscal year other than 2020 data is showing up in your Analytics pivot which is not in your GL Summary?

Children
No Data