The purpose of this worksheet is to show the cost savings from using the EXACTOR ASP solution. This is not purported to replace a comprehensive cost analysis, but to provide a basic order of magnitude evaluation. Results will be displayed according to information that you insert in the unlocked (and shaded) fields, which are intended for you to insert your company specific data.
Scenario Data Input General Bookkeeper, Salary base (please insert for one option only)
Average annual Salary per book-keeper (fully loaded) Accountant, Salary base (please insert for one option only)
Average annual Salary per book-keeper (fully loaded)
$
60,000
Monthly
$
-
Hourly
$
EXACTOR Data
Annual - Please choose one option
Cost
Transactions
$
78,000
0
Annual
$
90,000
0 Tax Calculation, Filing & Reporting
Monthly
$
-
Hourly
$
-
$
117,000
0
Savings
$
504
$
10,797
$
780
$
14,040
$
-
$
-
$
1,284
$
24,837
$
240,000
Account Reconciliation 0
Assumption - 1% of bookeepers time
0 Compliance
Tax Calculation Expenses associated with calculating taxes on transactions
0
Assumption - 1% of bookeeper & accountant time
400
Average number of transactions per month
Total
$
50
Set-up, installation and annual fees paid for tax calculation
$
8.4% -
Revenue
Transaction fees paid for tax calculation
$
0.12
Savings
Hardware required to host tax calculation
$
-
Average size per transaction Average Taxes (@8.4% average tax rate)
Additional software required for tax calculation engine Total Cost of Tax Calculation
$
-
$
576
Tax Liability Savings / Tax Liabiulity ratio
10.3% $
20,160 123.2%
Account Reconciliation Daily / weekly / monthly activities involving reconciliation of transaction and credit card data, prior to uploading clean, aggregate,
1
Number of book-keepers working on reconciliation
16%
Portion of time they dedicate to reconciliation activity
Cost of Book-keeper Number of Accountants working on reconciliation
$
12,480 1
$
2,340
$
14,820
2%
Portion of time they dedicate to reconciliation activity Cost of Accountant Total personnel cost of reconciliation
YOU HAVE ADDITIONAL LIABILITY IN THE FORM OF INTEREST AND PENALTIES FOR THOSE STATES THAT YOU ARE NOT FILING
Tax Filing Periodic activities associated with filing of sales taxes, including generating periodic reports for each filing jurisdiction, completing,
1
Number of book-keepers working on filing
4%
Portion of time they dedicate to filing activity
Cost of Book-keeper
$
3,120 1
$
1,170
Number of Accountants working on filing
1%
Portion of time they dedicate to filing activity Cost of Accountant
2
Number of states you file
5
Number of states you should be filing Total personnel cost of filing
$
10,725 YOU HAVE ADDITIONAL LIABILITY IN THE FORM OF INTEREST AND PENALTIES FOR THOSE STATES THAT YOU ARE NOT FILING
Compliance (Sarbanse Oxley) Periodic activities including auditing and data collection and reconciliation, associated with SOX and other compliance efforts.
-
Number of book-keepers working on compliance
0%
Portion of time they dedicate to compliance activity
$
Cost of Book-keeper
-
Number of Accountants working on compliance
0%
Portion of time they dedicate to compliance activity $
Cost of Accountant
-
Number of FTE technical personnel dedicated to compliance Annual fully loaded cost of FTE technical personnal
$
72,000
Cost of FTE technical personnel dedicated to compliance
$ $
-
Hardware required for compliance related data tracking and auditing
$
-
Total personnel cost of compliance
$
-
Total Cost of Tax Compliance
$
26,121
Software required for compliance related data tracking and auditing
YOU HAVE ADDITIONAL LIABILITY IN THE FORM OF INTEREST AND PENALTIES FOR THOSE STATES THAT YOU ARE NOT FILING