Need help in calculating residuals?

QB-LA are accounting and MS Excel experts and can make it happen.

Our team brings deep understanding and expertise in accounting and advanced Excel work, and we can handle the calculations you need for formal submissions. We are well versed in preparing heavy-duty financial worksheets for SAG-AFTRA, the Directors Guild of America, and the Writers Guild of America. We focus solely on the calculations and reporting requirements; we are not affiliated with any collection account managers or payroll companies.

Need some help? Call or email us now and let’s get going!
Contact Us now for a free written proposal.

We calculate residuals based royalties for all industries!

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.

Residuals can be complicated! – Just take a look at the example below

=IF(OR([@[GX_CODE]]=mapping!$C$103,[@[GX_CODE]]=mapping!$C$104,[@[GX_CODE]]=mapping!$C$105,[@[GX_CODE]]=mapping!$C$107, [@[GX_CODE]]=mapping!$C$109,[@[GX_CODE]]=mapping!$C$110, [@[GX_CODE]]=mapping!$C$111,[@[GX_CODE]]=mapping!$C$113,[@[GX_CODE]]=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([@Name2]=mapping!$C$120,[@Name2]=mapping!$C$121,[@Name2]=mapping!$C$122, AND([@Name2]=mapping!$C$123),F15=mapping!$F$129),”yes, 1 of the 4 exc rates”,”no, not 1 of the exc rates 4″)

=IFERROR(VLOOKUP([@Num],’UniqueInv#s’!C$2:C$2866,1,FALSE),”invc# not found earlier”)

=IF([@TX_PdEarlier]=mapping!$C$138,AB15,IF(AG15=mapping!$C$137,0,GX_DATA!C150))

QB-LA is a Los Angeles based accounting firm.

Need help with Calculating Residuals?

Or, maybe a higher-end QuickBooks Accounting Pro?
QB-LA will engage the person with the right skill sets to get it done fast and save you money.

Contact Us

Service Areas | Low Cost Bookkeeping | Quickbooks Certifications | About QB-LA | Contact Us