Tax Payment Audit Export 

The Tax Payment Audit Export is a Service Bureau report designed to review tax payment bank files that have been created in iSolved, tax checks and filings associated with the payments. 

1. Prior to creating the report, you'll want to process all your payments for the day. 
2. In iSolved PRIME navigate to Reports > Service Bureau Reports 
3. 
4. Select Report: Tax Payment Audit Export 
   1. Select all Service Groups you pay taxes for
   2. Select Continue 
5. Filter the report
   1. From Date: Today's date 
   2. To Date: Today's Date
   3. Format: Excel 
   4. Select Generate Report Batch
   5. Note: Running multiple reports at once may take a few minutes
6. 
7. Select Go To My Reports Queue
8. Once all reports have generated select the Download button in the header to download all reports at once  
9. 
10. On your computer under downloads, you will see a zip folder file labeled "Download all Reports" 
11. Review each report individually or combine reports together to view as one report
12. Review for files marked as "Not Sent" in column named "ACH File Marked as Sent" meaning the file was created in iSolved and not transmitted to the bank 
13. Review column named "EFile Status Summary" to ensure all efiles have been sent to the agency
    
    

Steps to combine Tax Payment Audit Export Reports into one after downloaded from iSolved PRIME 

1. Once all reports have generated select the Download button in the header to download all reports at once  
2. 
3. On your computer under downloads you will see a zip folder file labeled "Download all Reports" 
4. 
5. On your computer under downloads right click > Select New > Select Folder  
   1. Name the folder today's date  
   2. 
6. On your computer under downloads right click on the zip folder file labeled "Download all Report" 
   1. Select Extract All  
   2. In the pop up window "Extract Compressed (Zipped) Folders" select Browse  
      1. Navigate to Downloads > File named today's date from step 11 
   3. Select Extract 
   4. 
      
      
7. Combine all Excel spreadsheets together into one  
   1. Open a new Excel  
   2. Select Blank Workbook  
   3. Select the Data Ribbon > Get Data > From File > From Folder 
   4. 
   5. In the pop up window Select your mm.dd.yyyy folder  
   6. Select OPEN 
   7. 
   8. In the pop up window select Combine > Combine & Load 
   9. 
   10. In the pop up "Combine Files" window select TaxPaymentAuditExport 
   11. Select OK 
   12.