Checks missing from the Reconcile Bank Accounts screen
There are a number of reasons why payroll checks may be missing from the Reconcile Bank Accounts screen. Use the following information to determine which is causing the checks not to show and how to display them on the bank reconciliation.
The bank account is not approved for direct deposit
The bank account needs to be approved for direct deposit. When bank accounts are initially set up, the status defaults to Prenote. Use the following steps to verify the bank account is approved.
Select
Setup
and then
Bank accounts
.
Select the
Direct Deposit
tab.
In the
Bank Account Prenote Information
section, change the
Status
field to
Approved
.
note
If payroll checks have already been printed for this bank account, you'll need to delete and re-enter the check.
Checks are eligible for direct deposit, but the ACH file hasn’t been created
If you printed payroll checks that are to be direct deposited, they won't appear on the bank reconciliation until the direct deposit file has been created.
Select
Actions
and then
Process Direct Deposit
.
If you're impounding payroll, select
Funding
and fund the file.
Mark the checkbox for the payroll you're ready to create the ACH file for.
Select
Create Files
.
note
If you are using direct deposit through Kotapay, the file will be automatically transmitted.
Liabilities were generated as historical checks
If you enter payroll checks after the fact, and generate the liabilities as historical checks, those checks are removed from the general ledger and the bank reconciliation. Use the following steps to generate the liabilities as handwritten checks.
Select
Actions
, and then
Enter Transactions
.
If you already generated the liabilities for handwritten payroll checks as historical checks, delete and re-enter the checks.
Select the
Generate Liabilities for Handwritten Payroll Checks
link.
In the dialog, select
Handwritten
from the dropdown.
Select the checks to generate liabilities for and then select the
Generate
button.
The checks should now appear on the bank reconciliation, and there will be open liabilities created on the
Print Checks
screen.
Payroll checks were entered for the wrong bank account
When the payroll checks were created, it is possible an incorrect bank account was selected. Use the following steps to verify the correct bank account was selected on the payroll checks.
Select
Actions
, and then
Enter Transactions
.
Locate one or more of the missing checks in the Transactions list.
In the Transaction detail field, check the Bank Account selection and verify the correct bank account was used.
Checks were converted from Creative Solutions Accounting (CSA)
It is best to convert client data after a given period has been reconciled in CSA as converted checks don’t transfer to the reconciliation screen.
After you complete a reconciliation in CSA, print out a
Bank Reconciliation Worksheet
. This report lists statement summary, bank summary, and book summary information for the reconciliation of a selected checkbook. This information will help you enter any
In Transit
transactions as
initial open items
in the Reconcile Bank Accounts screen of Accounting CS.