Loading...
HomeMy WebLinkAboutCity Sales Tax Reporting Instructions City Sales Tax Reporting City Sales Tax is due each month by the 20th for the prior month. To begin you will need to open Incode V.X. *Select Reporting from the locked tab at the top of the screen *On the right side of the screen under Categories you will need to select Utility Billing. The saved report Monthly Transaction Report should be highlighted. Double Click the blue line to open the report criteria *Click on the down arrow by Options, click on Open and select the report titled City. *Change the dates to the 1st and last day of the previous month and the rest of the information will auto populate. Click on Run Report at the top of the page. *When the report comes up, you will not need to print the whole report, only the last page or two that contains Revenue Code Totals By Bill Cycle. * Take the Grand Total for Period and divide it by 10%. This will give you the total sales for the month. **Note: all figures will be rounded to the nearest dollar. *Pull up GL Code 100-43660 (Golf Vending) and on the far left of the screen under History, select Period Activity. Find the month you are working on and use the number in the Activity column. Do the same for GL Code 100-43640 (Golf Cart Rental). Round these figures to the nearest dollar. These amounts are listed on the Incode report you printed earlier and added to the total monthly sales. These figures will be used when you enter into ATAP. Open atap.arkansas.gov in your internet browser. Should also be saved in other bookmarks on Google Chrome. Enter in the login ID. bville01 Password is City2400. Once you are logged into the ATAP program, you will look for Sales and Use tax. Click on the File a Return. The next page that pops up will be Excise Tax (Import from XML), on this page just click next since you are not uploading anything. Gross Receipts Tax will be the next page. Under #1 State Tax you will enter the State Tax which is the 3 figures you added together on the Incode form. Scroll to the bottom of the page and click next. In box #14 (Short Term Rental) you will enter the amount from Golf Cart Rental. Once entered, click on OK. This will automatically figure the State Tax less the discount and the extra 1% for the short-term rental. Click Next. Local Sales and Use selection, click Yes to preload locals from previous filing and then click next. Now you will enter Local Sales and Use in under Taxable Sales. You will enter the grand total of all three figures in to each the County and City taxable sales boxes. Click Next. Once you have everything entered a box will pop up with all the information. Make sure your totals match (instructions on calculating figures at bottom) and click on Next. This brings you to the Balance Due page. If everything is correct click on Yes to make a payment from your bank account and click next. On the Payment Source page, you will need to confirm the bank account number at the bottom left, and the dollar amount on the right screen, then click next. There are no attachments, so click next on the page. This brings you to a Summary page. Click Submit. Another box will pop up saying “Under penalties or perjury…” Click Ok here. The next screen will be the confirmation screen and you will need to click on Print Return and print two copies. One goes with the rest of the paperwork in the Yellow State Sales Tax Folder and the other goes to Denise to make the journal entries for the payments. **For whatever reason, this page will just keep repeating the process, so once you get to the Submitted page, you can click the >City of Batesville at the top to return home. This page will show the Return as Submitted under Status. All of the confirmations, spreadsheet and Incode printouts will be stapled and filed in the folder until the end of the year. **To check the figures on the return: (1) State tax is figured by multiplying the total by 6.5% and the discount is 2% if paid before the 20th of the month. (2) County tax is figured by multiplying the total by 1.5% and the discount is 2% if paid before the 20th. (3) City tax is figured by multiplying the total by 2% and the discount is 2% if paid before the 20th. At any time, the tax rate should change, these figures would need to be adjusted but the current is State 6.5%, County 1.5% and City 2.0%. Some total boxes will include only the tax amount to be paid and some will show the amount after discount is applied. You may have to figure both ways to get the totals to match the boxes. When everything is finished, a copy of the Arkansas Excise Tax Return needs to go to the Clerk to make the payment entries. Also, for disaster recovery purposes, scan the entire packet to Laserfiche under City Clerk, Sales Tax Forms and the appropriate year. This will make copies easily accessible and add a layer of recovery from the Cloud should the originals ever be destroyed.