Need help in calculating residuals?
We are accounting and MS Excel experts and can make it happen.
Consider us when heavy-duty calcs are needed for submittals to SAG-AFTRA (the Screen
Actors Guild – American Federation of Television and Radio Artists, DGA (the Directors Guild of
America) and WGA (Writers Guild of America).
We just do the calculations; we are not affiliated with any CAM (Collection Account Managers)
or Payroll Houses.
We can calculate residuals based on royalties for:
| AVOD Clips Domestic DVD Domestic Free TV Domestic Licensing Domestic Pay TV Domestic Theatrical Domestic VOD DVD DVD Rental DVD Retail DVD Sales DVD Wholesale Foreign DVD |
Foreign Free TV Foreign Licensing Foreign Pay TV Foreign Theatrical Foreign VOD Free TV Sales Internet Advertising IPVOD / TVOD IPVOD HD IPVOD HD / TVOD IPVOD SD Licensing Masters / Tech Materials Merchandise sales |
Music Royalties Pay TV Sales Product Endorsements Prop Rentals Satellite / Terrestrial Special: Airlines Special: Allowance for Returns Special: Commissions Special: Discounts Special: Integration Fees Special: Trading Cards SVOD Theatrical Exhibition – More |
We can calculate all of these, all at once, with lots of special carve-outs.
We’re also certified Quickbooks experts and can format for import into Intuit Quickbooks
Desktop, Quickbooks Online and many other accounting systems and applications.
Your data is handled with top security throughout, and we are insured.
Los Angeles based.
Residuals can be complicated! –
=IF(OR(]=mapping!$C$103,]=mapping!$C$104,]=mapping!$C$105,]=mapping!$C$107, ]=mapping!$C$109,]=mapping!$C$110, ]=mapping!$C$111,]=mapping!$C$113,]=mapping!$C$114),RATE2*Q10,0)
=CONCATENATE(“From “,TEXT(R243,”ddd”),” “,TEXT(R243,”m/d/yyyy h:mm”),” to “,TEXT(S243,”m/d/yyyy h:mm”),” = “,TEXT(G243,”#,##0.0″),” hrs, by “,K243,” at “,IF(K243=”CODE1″,”IP VOD HD”,Y243),” RATE3: “,IF(W243=”NO”,” (NOT BILLABLE) “,””),AB243)
=IF(W243=”NO”,$M$3,IF(Y243=”FOR DVD”,$E$3,IF(Y243=”C14″,$F$3, IF(Y243=”C15″,$G$3,IF(Y243=”C16″,$H$3,IF(Y243=”C17″,$I$3,IF(Y243=”C18″,$J$3, IF(Y243=”C19″,$K$3,IF(Y243=”TAX”,$L$3,$M$3)))))))))
=IF(V243=INDIRECT(“V”&ROW()-1),INDIRECT(“I”&(ROW()-1))+H243,H243)
=IF(OR(=mapping!$C$120,=mapping!$C$121,=mapping!$C$122, AND(=mapping!$C$123),F15=mapping!$F$129),”yes, 1 of the 4 exc rates”,”no, not 1 of the exc rates 4″)
=IFERROR(VLOOKUP(,’UniqueInv#s’!C$2:C$2866,1,FALSE),”invc# not found earlier”)
=IF(=mapping!$C$138,AB15,IF(AG15=mapping!$C$137,0,GX_DATA!C150))
Need some help? Call or email us now and let’s get going!
Contact Us now for a free written proposal.