# AvaTax Reconciliation **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [February 26, 2021, 8:59pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031 "2021-02-26T20:59:20Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\ **Post date:** [February 26, 2021, 8:59pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/1 "2021-02-26T20:59:20Z")
For all of you who are using Avalara/AVaTax, my accounting team gives me a Document Summary Reconciliation report from Avatax and has sked me to see if these numbers match up in Epicor and to write the a report they could run from Epicor for them. Has anyone wrote a report doing this? I’ve been trying to a while now and I keep running into issue after issue. ---
**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\ **Post date:** [February 26, 2021, 9:19pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/2 "2021-02-26T21:19:13Z")
I’ve written a few reports to reconcile Avatax and Epicor. I dont remember the report you have. Can you share the column headers? I dont need any of your data. ---
**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\ **Post date:** [February 26, 2021, 9:20pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/3 "2021-02-26T21:20:51Z")
Customer Vendor Code, Document Date, Total Sales, Discount, Exempt/Non Taxable Sales, TAxable Sales, Tax Amount ---
**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\ **Post date:** [February 26, 2021, 9:30pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/4 "2021-02-26T21:30:34Z")
the report is summary of sales and tax data by customer by date? no invoice/document numbers? ---
**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\ **Post date:** [February 26, 2021, 9:31pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/5 "2021-02-26T21:31:35Z")
Sorry, the first column is Document Code. As in Invoice numbers. ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [February 26, 2021, 9:32pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/6 "2021-02-26T21:32:59Z")
Do either of you know if there is some user guide or tech guide on how to set up avalara and epicor? I saw a configuration guide for company maintenance setup but I didn’t see things outlining anything else such as reports or exports, etc… ---
**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\ **Post date:** [February 26, 2021, 9:34pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/7 "2021-02-26T21:34:18Z")
No, when we purchased Avalra we had someone help us set it up and then we tested it. ---
**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\ **Post date:** [February 26, 2021, 9:34pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/8 "2021-02-26T21:34:52Z")
@tmcgrady is the person to reach out for tax setups. best advice I can give you is reach out to professional services. I’ve configured it a bunch of times, and it’s not to hard, but there is a lot to learn. ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [February 26, 2021, 9:43pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/9 "2021-02-26T21:43:51Z")
Thank you both @Will79 and @bderuvo ! Yeah I am trying to get it set up with them, but I like to have literature on it so I can read up on it and get an idea for myself before going into a consulting session. ---
**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\ **Post date:** [February 26, 2021, 9:51pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/10 "2021-02-26T21:51:41Z")
The Alavara education process will get you up to speed quickly. They make you watch some training videos prior to consulting time, that is helpful. ---
**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\ **Post date:** [February 26, 2021, 9:52pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/11 "2021-02-26T21:52:49Z")
@bderuvo Did you happen to write a report that was to reconcile the above AvaTax report with Epicor? ---
**Author:** ![bderuvo](https://www.epiusers.help/user_avatar/www.epiusers.help/bderuvo/32/55706_2.png) [@bderuvo](https://www.epiusers.help/u/bderuvo)\ **Post date:** [February 26, 2021, 10:11pm UTC](https://www.epiusers.help/t/avatax-reconciliation/76031/12 "2021-02-26T22:11:28Z")
@Will79 I wrote this somewhere else and I dont have a copy. looks like you need to write a baq to pull in the invchead table with a few linked subqueries. Summarize the InvcDtl table ExtPrice+TotalMiscCharges and Discount Fields for sales and discounts. Summarize the InvcTax table TaxAmt field. I think you can get taxable sales amount from here too. Breaking out the Exempt sales is tricky because epicor doesnt store that data in invcdtl from avalara, the tax exempt field would need to manually maintained by your team. if you use the tax Exempt field, you could summarize the invcdtl table for only exempt.