Troubleshooting: Bank Account not appeared in Bank Reconciliation

From AutoCount Resource Center

Question: I have created a bank account (315-0000) and with few months of transaction. When I try to do Bank Reconciliation, the Bank Account is not displayed?


Question: I have created a bank account (315-0000) with transactions, and now I realized that it was wrongly created as Special Cash Account (SCH) instead of Special Bank Account (SBK). How can I make it right?

Version: 1.8 / 1.9 / 2.0

Possible Reason:

Special Bank Account (SBK) was wrongly saved as Special Cash Account (SCH) during account creation.

Bank recon.png


1. If there is no transaction involved, just delete the Bank Account and re-create a new one; and make sure the option button of 'Bank' is selected.

2. If there are only few transactions involved, you may:
(a) Rename the current 'Bank Account' to 'Cash Account' (you must also change the name of related payment method at General Maintenance > Payment Method Maintenance); then
(b) Create a new Bank Account (SBK); and
(c) Edit the related transactions one-by-one and change the Payment Method to the new Bank Account.

3. If there are many transactions involved, follow the following steps:
(a) go to Start > All Programs > AutoCount Accounting > AutoCount Accounting Management Studio... login to the related account book using ADMIN user ID and password.
(b) go to Tools > SQL Query

Bank recon1.png

Please be aware that any mistake made in SQL Query could cause your database to corrupt, thus it is advisable to be cautious and make a backup copy of your database (account book) before this; If you are sure about the risk, click on Yes to continue:

Bank recon2.png

key in the query: UPDATE GLMAST SET SPECIALACCTYPE = 'SBK' WHERE AccNo = '315-0000'

Then click on Execute,

Bank recon3.png

The special account type of 315-0000 is now changed to 'SBK'.

(c) go back to AutoCount Accounting, verify the result by looking into G/L > Bank Reconciliation, the Bank Account (315-0000) should be displayed and with related transaction.

By:Peter@2013, KM 170720; P170801

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations