J + Q is the actual GL revenue for each store

If a statement comes in, it can be placed into 
E, I, T  -- which one it gets reported on

In an "Open Month" all statements hit the current month, unless it is exactly the month previous, in which case it goes to the tab for the month previous. 


A report for April arrives in April, that appears in 'I'.  (Arrives before month is closed)
A report for March comes in April,  then we go into the March tab and put it into the T column (Arrives after the month is closed)
A report for Februrary or previous arrives in April, that goes into E in the April tab. 


The actual revenue that is recognized:  
  eg Accu $100K in march, then in april get a statement of $105. 

T influences the F column of the FUTURE MONTH.  
   F from a current month == V from the previous month
   V in general is T - Q
   


-------

Column I - if the store is reporitng in the month in question, that goes here.  

Accrual_ThisMonth == Accrual_Part1 & Accrual_Part2
-- if customer is less than 5K, accrual will be $0. 
L & M - Accruals if Estimates did not come in.  
Q - sum (L & M) 

Previous Month
T - when we receive reporting.    (eg in March, we get Feb reporting). 

E - Revenue for months we received prior to month before.  ("Actual" being anything for two months or prior)

V := T - Q  (next month's True Up)  '


The ammount of revenue credited to a store in a month is J + Q. 
J := (E) Old revenue that we just got + (F) True Up + (I) Any Statment for Current Month

I == Current Month Statement.   Generally there will be a value either in I or in Q.  (rare evenets where both, is if they did not report properly, skipped a month  etc). 


TrueUps :=  Statement - Accrual 

have a look at Next Music PTY 



    c(  ## NEW                            ## ORIGINAL 
        "DMV"                          = "Dig/Mob"  # (B)
      # , "ID"                           = "Customer ID"  # (C)
      , "storepart"                    = "LABEL"  # (D)
      
      , "Statements_older_ThanMonth"   = "Actuals"  # (E)
      , "TrueUp_LastMonth"             = "TrueUp" # (F)
      , "Statement_ThisMonth"          = "February" # (I)
      , "Subtot_StatementsPlusTrueUps_ThisMonth"              = "Actual Invoiced"  # (J)
      , "Accrual_part1"                = "Cust Prelim"  # (L)
      , "Accrual_part2"                = "Estimate" # (M)
      , "Accrual_ThisMonth"            = "Accrual"  # (Q)
      , "Statement_ThisMonth"          = "Feb 14 -Orchard Actual" # (T)
      , "TrueUp_FutureMonth"           = "No Accr.VS.Actual"  # (V)
      , "Music_Statement"              = "Digital Invoiced" # (AD)
      , "Mobile_Statement"             = "Mobile Invoiced"  # (AE)
      , "Video_Statement"              = "Video Invoiced" # (AF)
      , "Music_Accrual"                = "Digital Accrual"  # (AH)
      , "Mobile_Accrual"               = "Mobile Accrual" # (AI)
      , "Video_Accrual"                = "Video Accrual"  # (AJ)
      , "accounting_month"             = "accounting_month" # ( N/A )
      )