13
*** [BUSINESS PROCESS] ***
Step1: Create a new Bank Account & Main account and setup as below setup
Step 2: Process payment for Vendor. Post two lines with some amount for above new bank created.
Step 3: Process Bank Account reconciliation
Step4: Notice the issue.
***[REPRO STEPS GROUP] ***
Tested in USMF Legal entity with standard data set.
Step1: Create a new Bank Account & Main account and setup as below setup
Go to General ledger >> chart of accounts >> main accounts.
Click new.
Main account: 241001
Name: Bank account current.
Main account category: Cash
Main account type: Asset
Default currency: USD.
Create a new bank account,
Go to cash and bank management>> Bank accounts >> Bank accounts >>new.
Bank account: BA1
Name: Bank of US
Main Account: 241001 (above created)
Bank groups: BankUSA
Bank account number: Any
Step 2: Process payment for Vendor. Post two lines with some amount for above new bank created.
Go to Accounts payable>> Payments >> Vendor payment journal >> click new
Name: Vendpay, Click lines in the top of the form.
Add two lines with 10000 and 15000 USD amounts.
Account: 1001
Currency: USD
Offset account type: Bank
Offset account: BA1 (Above created bank)
Method of payment: Nil
Post the payments.
Step 3: Process Bank Account reconciliation
Note: 100 USD Correction is made during reconciliation.
Go to cash and bank >> bank accounts >> BA1
In the action pane Reconcile >> Account reconciliation.
Create a new line
Bank statement date: Today, Bank statement: April 30, save and click on Transaction in the action pane.
In the (15000) 2nd line of transactions Edit Bank amount field make it as -15100 so that in correction amount -100 will pop up. Save and close the form.
Update -25100 in ending balance. And again, click on the Transactions.
Now the reconcile button is enabled. Select both the Transactions and click reconcile account.
Click on the Voucher in the action pane after reconciliation.
Observe Voucher entry posted during reconciliation for the correction.
Go to cash and bank management >> Bank accounts>> Bank BA1 >> Click Transactions
Bank transactions.
Issue1:
*** [Actual Results] ***
No vouchers for correction amount 100. The voucher is not route through Bank account.
*** [Expected Results] ***
The voucher entry must be routed through Bank account, instead of direct GL posting.
Expectation is that correction entries (100 Debit and 100 credit) should appear in the bank transactions.
Step 4: Bank to Ledger reconciliation report.
Go to Cash and bank management >> Periodic tasks >> Bank to ledger reconciliation report.
From Date: Today (whenever you have reconciled)
To date: Same
From and To Main account: 241001 (Created in Step1)
Click Ok.
Issue2:
*** [Actual Results] ***
When the correction entries are processed through Reconciliation form, the difference is appearing in the report. Whole amount reconciled is considered as difference amount.
*** [Expected Results] ***
The Bank/ledger reconciliation report must consider the correction entries & there should not be any difference in balance between bank account & ledger account. There should not be any difference between Bank & ledger balance.
Step1: Create a new Bank Account & Main account and setup as below setup
Step 2: Process payment for Vendor. Post two lines with some amount for above new bank created.
Step 3: Process Bank Account reconciliation
Step4: Notice the issue.
***[REPRO STEPS GROUP] ***
Tested in USMF Legal entity with standard data set.
Step1: Create a new Bank Account & Main account and setup as below setup
Go to General ledger >> chart of accounts >> main accounts.
Click new.
Main account: 241001
Name: Bank account current.
Main account category: Cash
Main account type: Asset
Default currency: USD.
Create a new bank account,
Go to cash and bank management>> Bank accounts >> Bank accounts >>new.
Bank account: BA1
Name: Bank of US
Main Account: 241001 (above created)
Bank groups: BankUSA
Bank account number: Any
Step 2: Process payment for Vendor. Post two lines with some amount for above new bank created.
Go to Accounts payable>> Payments >> Vendor payment journal >> click new
Name: Vendpay, Click lines in the top of the form.
Add two lines with 10000 and 15000 USD amounts.
Account: 1001
Currency: USD
Offset account type: Bank
Offset account: BA1 (Above created bank)
Method of payment: Nil
Post the payments.
Step 3: Process Bank Account reconciliation
Note: 100 USD Correction is made during reconciliation.
Go to cash and bank >> bank accounts >> BA1
In the action pane Reconcile >> Account reconciliation.
Create a new line
Bank statement date: Today, Bank statement: April 30, save and click on Transaction in the action pane.
In the (15000) 2nd line of transactions Edit Bank amount field make it as -15100 so that in correction amount -100 will pop up. Save and close the form.
Update -25100 in ending balance. And again, click on the Transactions.
Now the reconcile button is enabled. Select both the Transactions and click reconcile account.
Click on the Voucher in the action pane after reconciliation.
Observe Voucher entry posted during reconciliation for the correction.
Go to cash and bank management >> Bank accounts>> Bank BA1 >> Click Transactions
Bank transactions.
Issue1:
*** [Actual Results] ***
No vouchers for correction amount 100. The voucher is not route through Bank account.
*** [Expected Results] ***
The voucher entry must be routed through Bank account, instead of direct GL posting.
Expectation is that correction entries (100 Debit and 100 credit) should appear in the bank transactions.
Step 4: Bank to Ledger reconciliation report.
Go to Cash and bank management >> Periodic tasks >> Bank to ledger reconciliation report.
From Date: Today (whenever you have reconciled)
To date: Same
From and To Main account: 241001 (Created in Step1)
Click Ok.
Issue2:
*** [Actual Results] ***
When the correction entries are processed through Reconciliation form, the difference is appearing in the report. Whole amount reconciled is considered as difference amount.
*** [Expected Results] ***
The Bank/ledger reconciliation report must consider the correction entries & there should not be any difference in balance between bank account & ledger account. There should not be any difference between Bank & ledger balance.
STATUS DETAILS
Needs Votes
Comments
Without resolution of these issues, we are not able to suggest this feature of correction in the bank reconciliation form to any of our customers. Please consider the same for better implementation of this feature as it helps customer to pass the correction entries without need to create a separate general for it (as this was the original thought process behind the feature).
Category: Cash and bank management