Home > Forum Home > Excel Invoice Template > Calculating Total Sales Tax for Orders Share

Calculating Total Sales Tax for Orders

Excel Help for Calculating Total Sales Tax For Orders in Excel Invoice Template


Forum TopicPost Reply Login

Calculating Total Sales Tax For Orders

Rate this:
(3/5 from 1 vote)
SurprisedSeveral users have asked how a the total sales tax charged can be calculated and aggregated for multiple orders (invoices). This information isn't separated in the 'Reports' nor explicitly stored in the 'Orders' sheet; however it can be derived from the invoice information that is saved in the 'Orders' sheet.

To calculate the Sales Tax attributable to the first order (saved invoice), the following formula must be entered into cell M2 of the 'Orders' sheet.

=LEFT(K2,FIND("|",K2,1)-1)-RIGHT(K2,LEN(K2)-FIND("|",K2,1))-F2*(1-(H2/100))-OFFSET(shipmethods,J2-1,2,1,1)

The formula can then be copied down to subsequent rows and then totaled in order to obtain an aggregate of the sales tax charged.
 Excel Business Forums Administrator
 Posted by on
 
There are currently no replies to the "Calculating Total Sales Tax for Orders" topic of the Excel Help Forum for Excel Invoice Template.

Post Reply

Find relevant Excel templates and add-ins for Calculating Total Sales Tax for Orders in the