Skip to main content

Reconcile

Common Bank Reconciliation Issues

In this article we'll review common bank reconciliation issues and how to resolve them. Check these common issues when you can't reconcile your bank and book balances.

Payroll Checks Not Added To Reconciliation

Review the Checks screen to make sure that Payroll checks have been added to Reconciliation. If the checks have not been added to Reconciliation, follow these steps to add your Payroll checks.

  1. In Payroll, select Reports.
  2. Select Bank Reconciliation.
  3. Enter the Beg Date and End Date to the month you are reconciling.
  4. Enter the Bank Code in the Bank Code field (typically 1).
  5. Make sure the Bdgt Path lists the path to the Budget folder.

    This is important! The Budget Bank Reconciliation expects the check file to be saved in the Budget folder. Use the folder icon to choose the Budget folder.

  6. Make sure the Filename lists the name of the checks file. (This should be PRCkFile.dat)
  7. Press Build to create the check file.
  8. In Budget, select Reconcile.
  9. Enter your Bank Code and press Save.
  10. Press Add then select Payroll Checks.
  11. Make sure the Path-Filename lists the PRCkFile.dat file.
  12. Make the Bank Code is correct.
  13. Make sure the Mo-Yr is correct.
  14. Press Add Pyrl Checks.

This will add your payroll checks to Bank Reconciliation and you can continue to reconcile.

 

Missing Cash Accounts

If you've added new funds and accounts, make sure that your cash accounts are listed on the Print Bank Reconciliation Report screen.

  1. In Budget, select Reconcile.
  2. Enter your Bank Code and press Save.
  3. Press Print to open the Bank Reconciliation Report.
  4. Use the Account / Amount section at lower left to review your cash accounts. Make sure all cash accounts are listed.
  5. If a cash account is missing, close Bank Reconciliation and go to Accounts.
  6. On the Accounts screen, search for the cash account that is not listed.
  7. Make sure the Cash Acct checkbox is checked. If the Cash Acct box is not checked the account will not be listed in Bank Reconciliation.

    If you are using the C-ISAM version, the Cash Account is a Yes or No dropdown. Set the dropdown to Yes.


  8. If it is not checked, press Edit then check the Cash Acct Box.
  9. Press Save.

This will add the cash account to Bank Reconciliation and you can continue to reconcile.

 

Related articles