Taxcompliant products should appeal to the retailer who wishes to keep the collection and reporting of sales taxes in-house, and thereby rely on his or her local tax, accounting, and e-commerce software experts. With sales taxes collected through Magento, with Taxcompliant extensions, the first major hurdle is achieved. The second hurdle is to report those taxes to the states timely and in accordance with state regulations in effect where ever the sales are made. And the third hurdle, while perhaps not as legally important as the first two, is to integrate the collection and payment of those taxes into the retailer's accounting system.
Taxcompliant offers applications which greatly ease the tasks of preparing tax returns and integrating the payment of those taxes into Quickbooks accounting. These applications use the standard Microsoft Office suite, primarily Excel spreadsheet and Access data base tools. The three applications that we offer utilize the export file generated by the Magento shopping cart, with either the Magento Import Extension, or the Magento Lookup Extension installed.
Before reviewing the applications listed below, it would be helpful to view our sample csv file which is the common input for each application. The sample file shows sales transactions for California, Texas, and Oklahoma. Click here to open this file in your Microsoft Excel. You can also review a demonstration of steps taken to import this file into each of the applications listed below. You may also view this video narrative which will hopefully clarify any issues or questions you may have.
Special Applications Offered for Download:
Microsoft Access Data Base:
This download is a Microsoft Access application which simply summarizes data from the Magento export file by state, zip code, and tax location. Click here for a Word document showing reports from the export sample file. This application is compatible for MS Access 2002 and later. (After downloading, make sure you "enable content", which allows MS Basic macros to operate.) The report for tax location may be sufficient for preparing state returns where only tax location (districts) are required. However, for those states having multiple taxes in each location, i. e. state, county, and local option combined, the Microsoft Excel application may be preferable. The Microsoft Data Base Application is offered at no charge.
Microsoft Excel Tax Preparation:
Microsoft Excel applications display tax data in individual worksheets for each state. The process is similar to that used for the Access Data Base (where the tax csv file is imported into the application) and tax worksheets are generated by visual basic macros included with the application. For those states where tax forms are publicly available, the worksheets are produced as facsimiles of the actual state forms. See the examples here for California, Texas, and Washington. For those states where forms are not publicly available, the tax results are displayed in spreadsheet form. Here the data can be transferred to the actual form provided from the state, when the retailer is properly registered to collect and submit the tax.