• 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


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

Receipt Register


Dear Sir,
Column A has customer name
Column K is the Cheque number
Column C is the Invoice number being allocated.
I wanted to make a summary customer wise
Like Column
A ) customer name,
B) Cheque number
C) Reference number from Column G
D Date of Entry from column B
E ) Debit amount from Column M
F) Deposit in from Column D
G) Remark as “on account” if Colum C doesn’t show Invoice number like M1819 or M1920
As show in Sheet1
Columns are only for example it can be rearranged if needed.