Solved

Cash Transactions are not visible in Automatic Transaction Matching Screen

  • 13 July 2023
  • 5 replies
  • 194 views
X
Rank
Userlevel 2
Badge +5

Hi Experts, 

I need your assistance to resolve below issue. 

Cash Transactions are not visible for a cash account in automatic transactions matching window. 

I checked below points. 

  1. Unticked the ‘Exclude matched’ check box to whether transactions are already matched. No transactions were matched before.
  2. Got related GL accounts from PP1 posting control and checked in GL voucher row analysis. Transactions are available for related period.   
  3. Checked the related mix payment transaction and noticed nothing is unusual. 
  4. Then checked in 'Bank statement reconciled transaction analysis' window. No transaction reconciled for related month in related cash account.
  5. I checked ‘Cash Transaction Analysis’ window and transaction were visible. 
  6. Further, I checked from the Back-end also. Transactions are visible in back-end.
  7. Checked in Manual transaction matching window and figured out that related transactions were manually matched. 
  8. Then, unticked the manual transaction check box and saved the record. 
  9. Once unticked manual transaction matching, balance showed in unmatched cash transactions. But cash transaction lines were not visible. 

Thank you !

 

 

icon

Best answer by XitLakshM 18 July 2023, 13:49

View original

5 replies

Zuha Samsudeen
Rank
Userlevel 5
Badge +10

Hi XitLakshM

Have you tried running automatic transactions matching again after rollbacking the manual matching? 

T
Rank
Userlevel 7
Badge +18

Hi, 

 I’m including the following because many who first use Bank rec do not know the following. It looks like you're already familiar. 

The IFS Bank reconciliation process is limited to transactions that occur in IFS payment. This includes a number of different use processes such as mixed payment, customer / supplier payments and other.   It does not consider manual voucher / voucher entry as a transaction source.  In other words, we reconcile the cash accounts noted in the following screen - this is not related to GL accounts. 

 

In your notes, what transactions are missing from the top section of that screen? 

In my sample - I see all the true cash type entries.   

 

Best regards, 

Thomas

X
Rank
Userlevel 2
Badge +5

Hi @Zuha Samsudeen - Yes, I tried that, and automatic matching has not been happened. 

X
Rank
Userlevel 2
Badge +5

Hi @Thomas Peterson

Missing cash transactions in ‘automatic transactions matching’ are created through mixed payment. Not Manual entries. 

 

BR

XitLakshM

X
Rank
Userlevel 2
Badge +5

As further Investigated, final matching has happened for 2 cash accounts, and it has been rolled back later.

Normally once performed a final matching, reconciled ID will be created and once it rolled back, reconciled ID will be removed.

In this case, we noticed that reconciled ID has not been removed from Back-End although the final matching has been cancelled. But in front-end reconciliation ID is not visible since it’s cancelled. (Refer below 2 screenshots)

Suggested below solution and it worked. 

  1. Cancel the mixed payment. (Cancelation should be done for same period)
  1. Go to ‘Automatic transaction matching’ window and create a transaction by selecting related bank transaction line and approve it. (Re-creation should be done for same period)
  2. Then check in automatic transaction matching screen whether cash transaction is visible.

Reply


Terms & ConditionsCookie settings