• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bank Recon where date and amount is common & Bank provide single entry for bulk transaction & in books we record in each entry individually

H

harman1213

New Member
Dear Excel Experts,

I am also stuck on the same situation. I have to do bank recon, where bank gives combined payment entry for particular Date & in our books we records as individual entry.E.g on Date 12/12/2022 Bank Cr Amount 10,000 with single transaction & in our books we have recorded Dr Amount 10,000 with 10 transaction. I have to matched individually with diff promotion combination adding diff amount. Sample File attached for your reference

If anybody have any solution for this, Pls share. It would be great help.


Regards,
Harmandeep Singh
 

Attachments

  • Sample Recon File.xlsx
    10.7 KB · Views: 7
Hi ,

Expected result is where amount and date matched with combination it should be Marked as Matched Transaction in next to amount column.

Sample file is attached.
 

Attachments

  • Sample Recon File.xlsx
    10.8 KB · Views: 4
harman1213
Please reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
 
You must log in or register to reply here.
Back
Top