If you decide to collect KPS card fees for online transactions and have the school cover the cost for in-person card transactions, please follow the instructions below and use the attached Excel file.


  1. Open the Excel file and start in the "Total Remaining Fees" worksheet. In cell 'B1' enter the total convenience fees that were taken from the bank. This number should be on your bank statement.
  2. Run the Account Activity report for your Webstore Convenience Fees account for the prior month. Take the total and enter this into cell 'B3'


    1. *If you are unsure which account this is, reference your Webstore payment processor




  1. Switch to the "Paste Credit Card GL Summary" worksheet in Excel. Inside ASBWorks, navigate to the Credit Card GL Summary report. Run this report for the prior month, filter by Point of Sale transactions, and run it through Excel format. Copy and paste this report into cell 'A2'. These are the ledger accounts that made money from in person card sales. These ledger accounts will proportionally cover the remainder of card fees that were NOT collected from online sales. 

              
  1. Tab into the "Journal Entry" worksheet in Excel. The file will automatically generate the JE needed to account for all Pace credit card fees for the month you wish to reconcile. Inside ASBWorks, navigate to the Journal Entry module and create the adjustment based off the worksheet's recommendations.