Troubleshooting: Bank Account not appeared in Bank Reconciliation

From AutoCount Resource Center
Jump to navigation Jump to search

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?

OR,

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?


Possible Reason

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


Bank recon.png


Solution:

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


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