Check Reconciliation Import from Bank File
- In the web, go to Financial Management\Accounts Payable\Check Reconcilation.
- Click the Auto Rec from Bank File button.
- Select the appropriate bank format to reflect your AP, payroll, food services, or other account to be reconciled. Next, click the Choose File button to navigate to the file location on your computer. Input the statement date as shown on your bank statement. Click the Import button to begin the import.
- Skyward will begin the import and then provide a preview screen.
- Before seeing all the checks to be reconciled, Skyward will provide you with a summary. Make sure to note any exceptions.
- Review the checks and note any errors or messages. Click Reconcile after review.
Confirm that you want to continue.
- Skyward may send a couple of mixed messages, the reconciliation process is complete. Click the Continue button.
The update has been run, click Yes to continue. This is definitely a little confusing.
- You are still in the Auto Check Reconciliation screen. You can search for checks to verify Skyward has the message, “Reconciled as of MM/DD/YYYY”. From here click the Back button. Skyward will give a pop-up message, click OK.
- You are now back at the main Check Reconciliation screen. Click the Refresh button to have the statement dates load into your view. If desired, search for a reconciled check in the lower right corner. The reconciliation from that bank file is complete and ready for the next.
