Georgia Banking – Approve files End of Day

At the end of the day (after 3PM MST) Georgia Bank will send an email with a spreadsheet of the bank files they have received for the day and are going to process. Prior to processing the files, we have to verify the file amounts we sent match the file amounts they have. 

1. Georgia Bank will email an Excel spreadsheet of the bank files for that day in an email with the subject line: Approve ACH files – Today's Date  
2. Open the spreadsheet from the email  
   1. Review 
   2. Create an AutoSum under the Total Debits and Total Credits Column  
   3. Compare totals to the totals of the Tax Payment Audit Export for all Service Groups  
3. Login to Prime  
4. Navigate to Reports > Service Bureau Reports  
   1. Select the Tax Payment Audit Export  
   2. Check mark Select All Environments  
   3. Continue  
   4. Date range – From date and To date should be today's date  
   5. Format – Excel  
   6. Select Generate Report Batch  
   7. Select Go To My Reports Queue 
5. Open the Batch by selecting the arrow  
6. Under Actions make sure each report has generated by displaying "Download Report"  
   1. There is multiple pages of reports  
   2. Note: The reports will take some time to generate. Check each page to review they are showing as generated. If there is an error on one, PRIME will not allow you to download any others and you'll need to start over.  
7. Once all reports have generated select the Download button in the header to download all reports at once  
8. 
9. On your computer under downloads you will see a zip folder file labeled "Download all Reports" 
10. 

11. On your computer under downloads right click > Select New > Select Folder  

    1. Name the folder today's date  
    2. 

12. 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. 

13. 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. 
    13. Auto Sum the column named ACH Payment Total (column F) 
    14. Auto Sum the column named ACH File Total (column G) 
    15. Compare the totals to the Georgia Banking Excel Spreadsheet that is mailed to pvtax@payrollvault.com (Step 1) 
14. Once you confirm the totals match, reply to the email letting Georgia bank know the totals match and the files are okay to process. 

HELPFUL TIPS:  

1. ACH Payment Total (column F) may show reopened batches. This will throw off the total as this column will show the original file, the reopened file, and the new file (if applicable). 
2. Check for files that are showing as "Not Sent". If there is a file as "Not Sent", go back to the tax processor and let them know the file was not sent. They will need to upload the file to Georgia Bank through FileZilla if it needs to go today. 
3. Check notes of the PRIME spreadsheet 
4. Check notes for any Denver OPT payments. The agency pulls these payments as Debit from our account. However, it has to be set as ACH Credit in iSolved to generate the E-Files.  
5. OH OBG may show on the PRIME spreadsheet and not be sent. The OBG payment files in iSolved have to be generated in iSolved once OBG sends the acknowledgment back.